Job Summary
Advert Start Date:
16/08/2024
Advert End Date:
Closed for applications on 30/08/2024 23:59
Salary:
£40,221 - £44,428
Further Information
Senior Database Analyst:
Reporting to the Data Team Leader, the Senior Database Analyst role is to support and manage the configuration, capacity, security and availability of the database environments supported by ITDS across Peterborough City council. Ensuring that they operate reliably, securely, efficiently and meet the requirements of the business needs.
Your responsibilities will include:
• Specify, plan and implement deployments and amendments to ensure that the ITDS supported database environments continue to meet changing business and legislative requirements.
• Monitor the production usage of the ITDS supported database environments, recommending
enhancements to ensure effective and efficient use of computer resources.
• Manage and control the test and production Oracle and MS SQL Server environments, including where applicable, user administration, library management, data-dictionary, program migrations and security profiles, to ensure a responsive but secure service is maintained.
• Investigate, diagnose and resolve complex technical problems, working with users and third-party suppliers as appropriate to ensure that agreed levels of service, quality and security are
always maintained.
• Implement and monitor quality assurance procedures and standards for database environments and other technical aspects of database administration to ensure the quality and reliability of the delivered product.
• Manage small projects, and work packages within larger projects, to ensure successful delivery to the agreed scope, timescale and budget.
• Provide advice, consultancy and support to members of ITDS, retained organisations and 3rd
parties on technical aspects of Oracle and MS SQL Server to ensure that the best design decisions are made.
• Aggregate and clean data for key or specialised analytics projects. This involves gathering
relevant data from various sources and ensuring its quality and consistency
About you:
In depth knowledge of one or more of the following technical areas:
• Microsoft SQL Server
• Oracle RDBMS
• SQL, T-SQL and PL/SQL
• Microsoft SQL Server Analysis Services
• PowerBI
• SQL Reporting Services.
• Understanding of policies concerning data security, data protection, and confidentiality.
• Excellent interpersonal skills and a friendly and confident manner. Ability to communicate clearly and effectively, both verbally and in writing.
• Excellent customer care skills with substantial experience of client/user contact in a variety of
situations.
• Ability to work with other staff.
• Ability to take responsibility in a support situation.
• Ability to handle pressure, prioritise conflicting demands and meet deadlines
• Self-reliant and able to use initiative with a flexible attitude and approach to work
• Ability and motivation to gain useful experience in new technical areas.
• Ability to analyse complex issues and quickly identify possible solutions based on a sound analysis of the information available
We are proud to server the diverse communities of Peterborough and want our workforce to reflect this diversity which we believe is beneficial for our employees and the communities we serve.
Please note
This job is closed for applications.