Responsibilities (how we will measure success)
- Install, configure, and maintain Microsoft SQL Server databases for high availability and optimal performance.
- Implement and manage robust database backup and disaster recovery solutions.
- Monitor and tune databases to ensure peak performance and scalability, including optimizing SQL queries and indexing strategies.
- Maintain data integrity and accuracy through continuous monitoring and regular audits.
- Diagnose and resolve database-related issues quickly and effectively.
- Perform database migrations, upgrades, and patches with minimal downtime.
- Capacity planning and forecasting system growth for additional resource requirement
- Support SQL server estate across Prod/UAT/Dev environments.
Tasks (what does the role do on a day-to-day basis)
- Use tools like SQL Sentry or SSMS to ensure databases are running to optimal standards.
- Index maintenance to speed up query execution and reduce system load.
- Reorganizing indexes and updating statistics
- Assist in queries for new or existing applications, ensuring optimal structure and performance.
- Document detail changes to databases structure including configurations and performance.
- Assist in the generation of SQL reports that may be required for the business.
- Resolve audit findings through change management process.
- Provide support in application upgrades and releases.
- Performing routing data updates, patches etc
- Assist in the support of disaster recovery procedures.
- Ensuring SQL server workloads are distributed evenly across the infrastructure.
Key competencies for position and level (see Group Competency model)
In addition to demonstrating our Global Values (Authentic, Bold, and Collaborative), the role holder
will be expected to demonstrate the following:
- Be a strong team player.
- Proactive mindset to always look to make improvements.
- Confident communication skills with the ability to speak to business stakeholders / application owners / technical individuals to elicit requirements.
- Willing to continually learn new skills and technologies.
- Work well under pressure.