Senior Database Administrator

Role & responsibilities

• Administer, monitor, and maintain production Azure SQL and SQL Server databases, ensuring availability, performance, and data integrity
• Perform query optimization, execution plan analysis, index tuning, and performance troubleshooting
• Partner with engineering teams to implement CI/CD pipelines for database migrations and schema changes, and review database changes for quality and risk
• Build and maintain real-time database monitoring in Datadog with actionable alerting in PagerDuty
• Implement and test backup, restore, high-availability, and disaster recovery strategies
• Support capacity planning, cost optimization, and database scaling initiatives
• Automate routine operations using scripting and infrastructure as code (Terraform, PowerShell, Python)
• Manage database security, access controls, auditing, and compliance requirements (HIPAA, HITRUST, and PCI DSS), including evidence collection to support audits
• Design, implement, and maintain static and dynamic data masking to protect sensitive data (PHI, PII, and cardholder data) across production and non-production environments

Preferred candidate profile

• Administer, monitor, and maintain production Azure SQL and SQL Server databases, ensuring availability, performance, and data integrity
• Perform query optimization, execution plan analysis, index tuning, and performance troubleshooting
• Partner with engineering teams to implement CI/CD pipelines for database migrations and schema changes, and review database changes for quality and risk
• Build and maintain real-time database monitoring in Datadog with actionable alerting in PagerDuty
• Implement and test backup, restore, high-availability, and disaster recovery strategies
• Support capacity planning, cost optimization, and database scaling initiatives
• Automate routine operations using scripting and infrastructure as code (Terraform, PowerShell, Python)
• Manage database security, access controls, auditing, and compliance requirements (HIPAA, HITRUST, and PCI DSS), including evidence collection to support audits
• Design, implement, and maintain static and dynamic data masking to protect sensitive data (PHI, PII, and cardholder data) across production and non-production environments