Senior Database Administrator (DBA)

Client

Our client is a leading global travel agency network specializing in luxury and experiential journeys.

This role requires a hands-on technical leader with deep experience in SQL Server administration, automation, and Azure-native migrations. The DBA will provide operational support while driving key strategic initiatives for 2026.

Responsibilities

• Oversee the health, performance, and availability of all SQL Server and Snowflake databases.
• Implement proactive monitoring for warehouse performance, resource consumption, and credit usage (Snowflake).
• Configure, tune, and troubleshoot SQL Server Agent jobs, indexes, and partitions.
• Manage and monitor backup integrity, recovery jobs, and log shipping.
• Manage user accounts, roles, and permissions across SQL Server and Snowflake.
• Ensure role-based access control (RBAC) is enforced consistently.
• Audit and maintain compliance for handling of sensitive/PII data.
• Align database access policies with organizational security standards and ISO 27001 practices.
• Manage and troubleshoot FiveTran connections and integrations.
• Work closely with Data Engineering teams to optimize ingestion pipelines into SQL and Snowflake.
• Support cross-platform connectivity and reporting tools (Grafana, DataDog, Power BI).
• Conduct in-depth query performance analysis using execution plans and dynamic management views (DMVs).
• Optimize indexing strategies, partition schemes, and statistics maintenance.
• Identify and resolve blocking, deadlocks, and high-cost queries.
• Develop automation scripts (PowerShell, T-SQL, Python) to reduce manual intervention.
• Standardize deployment of database schema, objects, and configurations using Infrastructure-as-Code (IaC) principles.
• Document repeatable processes and maintain runbooks for operational continuity.

Requirements

• 10+ years as a Database Administrator with deep expertise in SQL Server 2012–2019/2022.
• Proven experience migrating large-scale databases from IaaS SQL to Azure SQL Managed Instances / Azure SQL Database.
• Hands-on knowledge of high-availability SQL configurations (AlwaysOn Availability Groups, Failover Clusters, Log Shipping, Replication).
• Strong performance tuning skills: indexing strategies, query plan analysis & optimization, tempDB and transaction log management, deadlock detection/resolution
• Deep understanding of backup and disaster recovery strategies (full/differential/log backups, point-in-time recovery, geo-redundant backups).
• Scripting and automation expertise with T-SQL, PowerShell, and IaC tooling (Bicep, ARM, Terraform preferred).
• Familiarity with data pipeline tools (FiveTran, ETL/ELT platforms) and integration troubleshooting.
• Excellent documentation skills for runbooks, migration plans, and incident reviews.
• Experience with Snowflake administration: warehouse management, RBAC implementation, monitoring and credit optimization, supporting data sharing and secure cleanroom use cases.

Nice to have

• Experience with Azure Database Migration Service (DMS) and Azure-native monitoring (Log Analytics, DataDog).
• Background in BCDR planning and ISO 27001/SOC2 compliance alignment.
• Prior experience in cloud-native modernization efforts (legacy to PaaS migrations).
• Strong collaboration skills to partner with Data Engineering, SRE, and Security teams.