Senior SQL DBA
Share
Job Location:
Milton Keynes - UK
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Job Description
Senior SQL DBA
Duration: 6 Months
Location: Milton Keynes & remote (hybrid)
Rate: 400 per day
IR35 Status: Inside
Start: ASAP
A Senior SQL DBA is required for our Government Client who will be responsible for the design implementation maintenance and optimisation of their enterprise database systems Microsoft SQL Server.
This role also supports and administers additional database platforms including PostgreSQL and MySQL to ensure reliability security performance and availability across the data environment.
As the Senior SQL DBA you will collaborate closely with their application teams infrastructure engineers and business stakeholders to deliver efficient and scalable data solutions.
Essential Skills & Experience required
As the Senior SQL DBA you will possess the following:
5 years experience administering Microsoft SQL Server in production/secure environments
Hands-on expertise with PostgreSQL and MySQL database administration
A strong understanding of T-SQL SQL query optimisation and database internals.
Duties include:
Install configure patch and maintain Microsoft SQL Server PostgreSQL and MySQL database environments.
Monitor database performance and proactively tune queries indexes and server configurations.
Perform routine health checks and ensure high availability and disaster recovery solutions (AlwaysOn log shipping replication clustering).
Manage database backups recovery strategies and restore testing across all platforms.
Analyze slow-running queries and optimize performance using execution plans and profiling tools.
Implement indexing strategies data archiving and partitioning where appropriate.
Conduct capacity planning and forecasting for growth.
Implement and maintain database security controls including authentication encryption auditing and role-based access.
Ensure compliance with company policies data governance frameworks and regulatory standards.
Manage user accounts roles privileges and security auditing.
Database Design & Development
Support developers with database design schema improvements stored procedures functions and triggers.
Collaborate on data modeling efforts (logical and physical models) for new applications and enhancements.
Assist with ETL processes data migrations and integration projects across heterogeneous systems.
Resolve database related incidents performance issues and service disruptions
Automate routine tasks using PowerShell Bash Python or SQL based scripts.
Support cross platform replication data synchronisation and migration activities between MS SQL PostgreSQL and MySQL.
If this role is of interest please email your CV to:
Required Experience:
Senior IC
Key Skills
- Databases
- SQL Server Management Studio
- SQL
- .NET
- Microsoft SQL Server
- ssrs
- TFS
- Database Design
- Performance Tuning
- SSIS
- T Sql
- Data Warehouse
About Company
Certes IT Service Solutions provides security solutions for high performance networks for government agencies and federal organizations.
