SQL Database Administrator

About the role

The SQL Database Administrator will join a technical team responsible for the administration, performance tuning, integrity, availability and security of SQL Server databases. The role requires deep expertise across multiple SQL Server versions and a strong focus on high‑availability and disaster‑recovery solutions.

Key responsibilities

• Administer SQL Server 2012‑2022 environments, including installation, configuration and patching.
• Implement and maintain high‑availability features such as Always On, Mirroring, Replication and Log Shipping.
• Design, configure and monitor active‑passive and active‑active clustering solutions.
• Plan and execute database upgrades, migrations and version consolidations.
• Perform performance tuning, index optimization and query tuning using tools like SQL Profiler and Database Tuning Advisor.
• Manage security features including Dynamic Data Masking and role‑based access.
• Develop and maintain T‑SQL scripts for automated maintenance tasks.
• Integrate SQL Server with BI tools (SSRS, SSAS, SSIS, Power BI) and monitoring platforms (SCOM).
• Support capacity planning, auditing and cost‑saving initiatives.

Required profile

• 8+ years of hands‑on experience in SQL Server administration.
• Strong knowledge of Windows operating system performance monitoring.
• Experience with SAN‑based replication and disaster‑recovery design.
• Proven ability to manage incidents, upgrades and deployments in large, mixed‑environment infrastructures.

Required skills

• SQL Server 2012‑2022
• Always On, Mirroring, Replication, Log Shipping
• SQL Server clustering (active‑passive, active‑active)
• SQL Profiler, Database Tuning Advisor
• SSRS, SSAS, SSIS
• Dynamic Data Masking
• Management Data Warehouse & Performance Dashboard
• T‑SQL scripting
• Power BI, SCOM integration
• Azure (certification preferred)
• Linked Servers, Oracle gateway, Open‑source RDBMS connectivity