SQL Server DBA

8 10 years

Role Summary

We are seeking an experienced SQL Server DBA to own the reliability performance security and availability of our data platforms. The ideal candidate has deep handson expertise across Microsoft SQL Server (onprem and/or cloud) strong performance tuning skills and productiongrade experience with HA/DR. Knowledge of PostgreSQL and familiarity with DevOps CI/CD practices for database change management will be a strong plus.

Shape

Key Responsibilities

Database Administration

Install configure and maintain Microsoft SQL Server instances (2016; onprem VMs and/or Azure SQL).

Design and manage backup/restore strategies; regularly test recovery procedures and RPO/RTO adherence.

Implement and support HA/DR (Always On Availability Groups Log Shipping Replication Failover Clustering).

Manage security & compliance (RBAC encryption at rest/in transit auditing vulnerability remediation).

Oversee capacity planning storage optimization and licensing considerations.

Performance & Optimization

Diagnose and resolve performance issues (wait stats query plans I/O memory CPU).

Index strategy statistics maintenance partitioning and query tuning (TSQL).

Baseline and monitor performance using native tools (DMVs XE) and thirdparty APM.

Database Development & Change ManagementSupport development teams with schema design stored procedures and TSQL best practices.

Implement source control and DevOps CI/CD for database changes (e.g. Azure DevOps/GitHub Actions DACPAC SQL Compare/Flyway).

Enforce release management standards migration scripts and automated validations.

Operations & Monitoring Set up and maintain monitoring/alerting (SQL Server Agent Extended Events custom dashboards).

Participate in oncall rotations and incident response; execute rootcause analysis and postmortems.

Maintain documentation (runbooks architecture diagrams inventory standards).CrossPlatform (Added Advantage)

Administer and optimize PostgreSQL (configuration performance tuning backups replication).

Contribute to modernization/migration initiatives between SQL Server PostgreSQL where applicable.

Shape

Required Qualifications

8 10 years of handson DBA experience with Microsoft SQL Server in production environments.

Strong expertise in:

TSQL indexing strategies query plan analysis wait statistics.

HA/DR: Always On Log Shipping Replication Failover Clusters.

Backup/restore disaster recovery testing and business continuity planning.

Security hardening: authentication authorization encryption auditing.

Performance monitoring and tuning at engine query and storage layers.

Experience with automation (PowerShell TSQL jobs) and scripting for operational efficiency.

Proven track record of incident management and oncall support for missioncritical systems.

Excellent communication documentation and stakeholder collaboration skills.