Senior Database Administrator

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Design, manage, and ensure the reliability, performance, and security of SQL Server environments hosted on Azure.

• Oversee around 30 SQL Server IaaS virtual machines across both production and non-production environments.

• Handle two high-availability SQL Server clusters and roughly 20 Azure SQL PaaS logical servers with elastic pools, along with seven Azure SQL Managed Instances.

• Execute performance tuning, query optimization, index and statistics maintenance, capacity planning, cost optimization, backup and restore processes, disaster recovery testing, security configurations, access management, and compliance activities.

• Develop, maintain, and verify high-availability and disaster recovery strategies.

• Assist in production and non-production replication utilizing Attunity Replicate (Qlik).

• Work collaboratively with application, reporting, and analytics teams to ensure data availability SLAs are met.

• Create and sustain monitoring and alerting systems using SQL Server Agent, Foglight, Azure Monitor, Azure Alerts, PowerShell, PagerDuty, and email notifications.

• Participate in on-call rotations, incident response, root cause analysis, and post-incident remediation efforts.

• Utilize Terraform for deploying and maintaining Azure SQL resources, alerting configurations, monitoring baselines, and data platform infrastructure.

• Manage Azure DevOps YAML pipelines for build, test, and deployment workflows.

• Oversee repository governance practices, including pull-request templates, pre-commit hooks, linting, validation, and documentation.

• Own enterprise data platform repositories and assets that encompass Azure Data Factory, Databricks Python jobs, configuration, and deployment artifacts.

• Develop and maintain modular data pipelines, Python-based transformations, business-rule logic, and automated unit, component, and integration tests.

• Assist in data quality validation, reconciliation, technical documentation, data governance, database consolidation, redesign, migration planning, and modernization initiatives.

⛳️ Requirements

• 8+ years of practical experience as a Database Administrator with Microsoft SQL Server.

• 5+ years of experience in T-SQL development and performance optimization.

• 3+ years of experience in database schema design, refactoring, and modernization.

• 2+ years of experience with Azure cloud services.

• Demonstrated capability in optimizing databases that support high-transaction OLTP systems.

• Proven history of tuning databases and queries that are performing poorly.

• Experience with code review processes and mentoring development teams.

• Eagerness to expand expertise in modern data platforms.

• Strong proficiency in SQL Server administration (both IaaS and PaaS).

• Hands-on experience with Azure SQL Database, Azure SQL Business Critical and General Purpose tiers, SQL Server Failover Clustering, and/or Always On technologies, along with Azure infrastructure and services.

• Proficiency in PowerShell scripting for automation and monitoring tasks.

• Experience with monitoring and alerting systems using Foglight, Azure Monitor, and custom solutions.

• Preferred: 2+ years of experience in data engineering or ETL/ELT development.

• Familiarity with Terraform and Infrastructure as Code practices.

• Experience in implementing medallion architecture or lakehouse patterns.

• Hands-on experience with Databricks and Azure Data Factory.

• Familiarity with Microsoft Fabric in production settings.

• Experience in migrating on-premises databases to cloud platforms.

• Knowledge of DevOps practices for database deployments.

• Experience in regulated industries with compliance requirements.

• Familiarity with real-time data streaming using Event Hubs or Kafka.

• Experience with data governance tools and frameworks.

• Experience with Azure DevOps CI/CD using YAML pipelines.

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related technical field is required.

• An equivalent combination of education and experience will also be considered.

• Highly desirable certifications include: Microsoft Certified: Azure Database Administrator Associate; Microsoft Certified: Azure Data Engineer Associate; Databricks Certified Data Engineer Associate or Professional.

• Additional valuable certifications: Microsoft Certified: Azure Solutions Architect Expert; Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics; ITIL Foundation.

🏝️ Benefits

• Competitive compensation and benefits package.

• Equal Opportunity Employer.