SQL Database Administrator

We are seeking an experienced SQL DBA with strong expertise in Microsoft SQL Server and Azure cloud services
, including CI/CD pipeline implementation using Azure Devops
, Visual Studio and Octopus Deploy
. The successful candidate will be responsible for database administration, performance optimization, automation, and supporting Dev Ops practices to ensure secure, highly available, and scalable database environments.

• Install, configure, upgrade, and maintain Microsoft SQL Server (On‑Prem & Azure)
  THROUGH Azure Pipelines (Azure Devops and Octopus Deploy).
• AUTOMATE
  backup, restore, disaster recovery
  , and high availability (Always On, Failover Groups, Log Shipping).
• Monitor database health, capacity, and performance.

• Identify and resolve performance bottlenecks using execution plans, indexing strategies, and query tuning.
• Optimize database schemas, stored procedures, and SQL queries.
• Implement proactive monitoring and alerting.
• Ensure security best practices using Azure AD authentication
  , TDE
  , Key Vault
  , and firewall rules.
• Support scalability, cost optimization
  , and resource governance in Azure.

• Design and maintain CI/CD pipelines for database deployments using:
• Octopus Deploy
• DBA Tools
• Power Shell
• Automate schema changes, version control, and deployment approvals.
• Work closely with development teams to enable Database Dev Ops (DBOps).
• Implement AUTOMATIC rollback, validation, and release strategies for database changes.

• Manage user access, roles, and permissions.
• Implement auditing, encryption, and compliance standards.
• Support vulnerability assessments and security reviews.
• Partner with application, infrastructure, and Dev Ops teams.
• Provide L3 support for production issues and root‑cause analysis.
• Create and maintain documentation, runbooks, and SOPs.

• Strong experience with Microsoft SQL Server (2016+)
• Hands‑on experience with Azure SQL services
• Strong knowledge of:
• Backup & Recovery
• HA/DR solutions (
  Always On Availability Groups
  , Log Shipping
  )
• Indexing & performance tuning
• Strong experience with CI/CD tools (
  Azure Dev Op and Octopus Deploy
  )
• Scripting skills:
  Power Shell and T‑SQL
• Experience with version control systems (Git)
• Azure Key Vault & Security features
• ARM/Bicep or Terraform (good to have)