- Company Name
- Certes Computing Ltd
- Job Title
- Senior SQL DBA
- Job Description
-
**Job title:**
Senior SQL DBA
**Role Summary:**
Lead the design, deployment, maintenance and performance optimization of the organization’s enterprise database environment, primarily Microsoft SQL Server, while also overseeing PostgreSQL and MySQL platforms. Collaborate with application, infrastructure, and business teams to deliver secure, high‑availability, and scalable data solutions.
**Expectations:**
* 5+ years of hands‑on production DBA experience with Microsoft SQL Server and additional expertise in PostgreSQL and MySQL.
* Deep knowledge of T‑SQL, query optimization, and database internals across the three platforms.
* Proven ability to implement high‑availability, disaster‑recovery, backup/restore, security, and compliance controls in secure production settings.
**Key Responsibilities:**
1. Install, configure, patch, and update SQL Server, PostgreSQL, and MySQL environments.
2. Monitor performance, tune queries, indexes, server settings, and execute regular health checks.
3. Design and maintain HA/DR solutions (AlwaysOn, log shipping, replication, clustering).
4. Manage full‑cycle backup, recovery strategies, and restoration testing.
5. Analyze execution plans, use profiling tools to resolve slow queries, and implement indexing/partitioning strategies.
6. Conduct capacity planning, forecasting, and scalability assessments.
7. Enforce database security: authentication, encryption, auditing, role‑based access, and compliance with governance frameworks.
8. Oversee user account creation, role assignment, and privilege management.
9. Assist developers with schema design, stored procedures, functions, triggers, and data modeling.
10. Support ETL, data migration, and integration projects; manage cross‑platform replication and synchronization.
11. Automate routine tasks via PowerShell, Bash, Python, or SQL scripts.
**Required Skills:**
* Microsoft SQL Server (2008/2012/2016/2019+) administration
* PostgreSQL and MySQL database administration
* T‑SQL, query optimization, execution plan analysis
* Indexing, partitioning, and performance tuning techniques
* High‑availability and disaster‑recovery implementation (AlwaysOn, clustering, replication)
* Backup/restore and disaster‑recovery testing
* Database security (authentication, encryption, auditing, role management)
* Scripting: PowerShell, Bash, Python, SQL
* Monitoring and alerting tools (SQL Server Profiler, DMVs, custom dashboards)
* Capacity planning and scalability assessment
**Required Education & Certifications:**
* Bachelor’s degree in Computer Science, Information Technology, or related field, or equivalent professional experience.
* Relevant certifications preferred: Microsoft Certified: Azure Database Administrator Associate or MCSA/MCSE (SQL Server), PostgreSQL or MySQL certification, or equivalent DBA credentials.
Milton keynes, United kingdom
On site
Senior
18-02-2026