Client: Our client is a leading general travel agency network specializing in luxury and experiential journeys. They are seeking a highly skilled Senior Database Administrator (DBA) to support and advance their SQL Server and Snowflake environments.
Position overview: 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.
- 10+ years as a Database Administrator with deep expertise in SQL Server /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.
- 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.
- Experience with Snowflake administration: warehouse management, RBAC implementation, monitoring and credit optimization, supporting data sharing and secure cleanroom use cases

📌 Senior Database Administrator (Dba) (Monterrey)
🏢 DataArt
📍 Monterrey