This position involves managing mission-critical workloads, ensuring data security and compliance, and implementing scalable solutions for both OLTP and analytical environments.
The Senior DBA will play a key role in database upgrades, migrations, disaster recovery, automation, performance tuning, and incident/change management, aligning with ITIL best practices and enterprise governance standards.
This role requires strong hands-on experience in hybrid infrastructure, including on-premises SQL Server environments and cloud-native services, with a focus on reliability, automation, and cost optimization.
Will work closely with application teams, cloud engineers, data engineers, security teams, and business stakeholders to support database operations across development, non production, and production environments.
Key Responsibilities
Administer and support SQL Server databases across on premises and Azure IaaS (VM) environments, including installation, configuration, patching, and upgrades (2017–2022).
Manage Azure SQL PaaS offerings, including Azure SQL Database and Azure SQL Managed Instance, ensuring high availability, security, and performance.
Design, implement, and maintain High Availability and Disaster Recovery (HA/DR) solutions such as: Always On Availability Groups, Failover Clustering, Log Shipping, Azure SQL Failover Groups.
Perform database upgrades and migrations, including: SQL Server version upgrades, Azure SQL (IaaS & PaaS) migrations, Cross platform data migrations as required.
Monitor database performance and proactively identify and resolve bottlenecks (CPU, memory, I/O).
Implement and enforce security best practices, including role based access control, encryption (TDE).
Execute and validate backup, restore, point in time recovery, and disaster recovery drills across platforms.
Monitor and tune database performance using execution plans, indexing strategies, statistics management, and platform metrics.
Collaborate with developers, architects, and infrastructure teams for database design and integration.
Automate routine DBA tasks using scripts (PowerShell, T-SQL, Python, etc.).
Support cloud database platforms (Azure SQL, AWS RDS, Snowflake, etc.).
Participate in incident, problem, change, and release management processes, ensuring SLA adherence and proper documentation.
Maintain accurate database documentation, runbooks, and operational standards.
Administer Snowflake data warehouse environments, including user management, performance optimization, data loading, and cost monitoring.
Support Azure Cosmos DB, including account configuration, throughput management, monitoring, and availability.
Job requirements
The ideal candidate will have deep expertise in database architecture, performance tuning, and high availability across distributed systems.
7–10+ years of experience as a Database Administrator.
Strong experience with SQL Server (2017–2022+) and Azure SQL Database and Azure SQL Managed Instance
Expertise in performance tuning, indexing, and query optimization.
Experience with HA/DR solutions (Always On, clustering, log shipping, replication).
Knowledge of backup/recovery strategies and disaster recovery planning.
Experience with cloud platforms (Azure, AWS, or GCP).
Strong understanding of database security and encryption techniques.
Proficiency in scripting and automation.
Working knowledge of Snowflake architecture, administration, and cost management.
Experience managing or supporting Azure Cosmos DB (Core SQL API preferred).
Experience operating in ITIL aligned environments for incident, change, and problem management.
Exposure to DevOps / CI CD practices for database deployments is a plus.