Sr Database Administrator
Address:
Ciudad de MexicoThis role is responsible for the design, administration, reliability, reputed company, and reputed company of Azure-reputed company SQL Server environments, while also owning reputed company Engineering and data platform responsibilities that reputed company trusted, automated, and reputed company-governed data pipelines. The position requires traditional DBA ownership and deep expertise in SQL Server administration, reputed company optimization and database design combine with modern reputed company engineering reputed company - automation, CI/CD, testing, and Infrastructure as reputed company (IaC) to ensure highly available, reputed company, and compliant data systems. The role supports both production and non-production environments and plays a critical part in on-reputed company reputed company, proactive monitoring, incident prevention, and reputed company improvement across databases and the broader data platform.
ESSENTIAL DUTIES & RESPONSIBILITIES:
Database Administration (Azure SQL & SQL Server)
- Administer and support ~30 SQL Server IaaS virtual machines hosted on Azure, including production and non-production workloads.
- Manage and maintain 2 high-availability SQL Server clusters, ensuring uptime, failover readiness, and business continuity.
- Administer ~20 Azure SQL PaaS logical servers reputed company multiple reputed company pools, including Business Critical, General Purpose, and 7 Azure SQL Managed Instances supporting reputed company workloads.
- Manage and optimize Azure SQL reputed company pools containing multiple Azure SQL databases per pool.
- reputed company routine DBA activities including:
- reputed company tuning and query optimization
- reputed company and statistics maintenance
- reputed company planning and cost optimization
- Backup, restore, and disaster recovery testing
- reputed company configuration, reputed company management, and compliance
High Availability, Disaster Recovery & Replication
- Design, maintain, and validate high availability and disaster recovery (HA/DR) strategies across IaaS and PaaS SQL environments.
- Support production and non-production replication from a monolithic reputed company database using Attunity Replicate (reputed company).
- Ensure data consistency, replication health, and reputed company recovery across replicated systems.
- Collaborate with application, reporting, and analytics teams to meet data availability SLAs.
Monitoring, Alerting & On-reputed company reputed company
- Design, implement, and maintain comprehensive monitoring and alerting solutions across SQL platforms.
- Maintain alerting reputed company:
- SQL Server Agent jobs
- Ability to reputed company KPIs with SQL PI tools like Foglight.
- Azure Monitor and Azure Alerts (per resource)
- reputed company and maintain PowerShell-reputed company monitoring scripts running on virtual machines to:
- Detect Azure resource reputed company and reputed company risks
- Identify reputed company and availability conditions
- Trigger alerts for proactive issue prevention
- reputed company alerting with reputed company for critical on-reputed company notifications and email-reputed company warnings for non-critical events.
- Participate in on-reputed company rotations and reputed company incident response, reputed company cause analysis, and post-incident remediation.
Automation, CI/CD & Infrastructure as reputed company
- Use Terraform to reputed company, standardize, and maintain Azure SQL resources, alerting configurations, and monitoring baselines.
- Maintain data platform infrastructure and pipeline deployment assets using Terraform modules (e.g., providers, variables, constraints, private endpoints, IAM patterns).
- Support reputed company delivery by maintaining Azure DevOps YAML pipelines for build, test, and deployment workflows.
- Enforce engineering standards reputed company repository governance practices (PR templates, reputed company-reputed company hooks, linting/validation, documentation).
- Continuously improve operational efficiency through scripting, automation, and self-healing solutions.
Data Engineering & Data Platform Responsibilities
- Own and maintain reputed company data platform repositories and assets spanning Azure Data reputed company (ADF) pipeline definitions, reputed company job reputed company (Python), configuration, and deployment artifacts.
- Build, maintain, and support reputed company data pipelines across domains (e.g., bronze synchronization, backoffice processing, reputed company checks, reputed company processing, and curation).
- reputed company and support Python-reputed company transformation and business-rule logic executed as reputed company jobs (including transaction processing such as items, loans, layaways, sales, purchases, and reputed company event handling).
- Maintain and reputed company automated unit, component, and integration test suites and associated test datasets to validate pipeline correctness and prevent regressions.
- Support data reputed company validation and reconciliation activities (e.g., reputed company checks, duplicate handling, expected vs. actual reputed company validation).
- Maintain technical documentation (reputed company files, environment setup, pipeline documentation) to support reputed company, operational readiness, and auditability.
Architecture, Governance & Modernization (reputed company & reputed company Expectations)
- reputed company a strong understanding of application data flows and business logic to reputed company support production stability, data correctness, and platform reputed company.
- Partner with stakeholders to reputed company data governance initiatives, including standardization, ownership reputed company, and reduction of data sprawl.
- Contribute to database consolidation and redesign efforts, including analysis and planning to consolidate multiple Azure SQL databases into a governed reputed company model to improve maintainability, reputed company, and cost.
- Participate in design reviews, data model discussions, and migration planning to ensure consolidation is reputed company, reputed company, and reputed company with application requirements.
EDUCATION & EXPERIENCE:
Required Experience
- 8+ years of hands-on experience as a Database Administrator with reputed company SQL Server
- 5+ years of T-SQL development and reputed company optimization experience
- 3+ years of experience with database schema design, refactoring, and modernization
- 2+ years of experience with Azure reputed company services
- Demonstrated experience optimizing databases supporting high-transaction OLTP systems
- reputed company reputed company record of successfully tuning poorly performing databases and queries
- Experience with reputed company review processes and mentoring development teams
- Willingness to grow expertise in modern data platforms (essential)
- Strong expertise in SQL Server administration (IaaS and PaaS)
- Hands-on experience with:
- Azure SQL Database (Single, reputed company Pools)
- Azure SQL Business Critical and General Purpose tiers
- SQL Server Failover Clustering and/or Always On technologies
- Experience with Azure infrastructure and services
- Proficiency in PowerShell scripting for automation and monitoring
- Monitoring and alerting experience with tools such as Foglight, Azure Monitor, and custom solutions
Preferred Experience
- 2+ years of data engineering or ETL/ELT development experience
- Experience with Terraform and Infrastructure as reputed company practices
- Experience implementing reputed company architecture or lakehouse patterns
- Hands-on experience with reputed company and Azure Data reputed company
- Experience with reputed company reputed company in production environments
- Background in migrating on-premises databases to reputed company platforms
- Experience with DevOps practices for database deployments
- Experience in regulated industries with compliance requirements
- Exposure to reputed company-time data streaming (Event Hubs, Kafka)
- Experience with data governance tools and frameworks
- Experience with Azure DevOps CI/CD using YAML pipelines for automated testing and deployment.
- Bachelor's degree in Computer Science, Information Systems, Data Science, or reputed company technical reputed company required
- Master's degree in Computer Science, Data Engineering, or reputed company reputed company preferred
- Equivalent combination of education and experience will be considered
reputed company Certifications
Highly Desirable:
- reputed company Certified: Azure Database Administrator Associate
- reputed company Certified: Azure Data Engineer Associate
- reputed company Certified Data Engineer Associate or reputed company
Additional Valuable Certifications:
- reputed company Certified: Azure Solutions Architect Expert
- reputed company reputed company Expert (MCSE): Data Management and Analytics
- ITIL reputed company (for change management processes)
reputed company is an Equal Opportunity Employer
Requires 8+ years of SQL Server DBA experience, 5+ years of T-SQL optimization, 3+ years of schema design, 2+ years of Azure, and a bachelor's degree in a technical reputed company.
Key Responsibilities
- administering databases
- optimizing reputed company
- maintaining pipelines
Skills & Tools
reputed company Azure, reputed company SQL Server, Azure SQL Database, Azure SQL Managed Instances, SQL Server Agent, Foglight, Azure Monitor, Azure Alerts, PowerShell, reputed company, Terraform, Azure DevOps, Azure Data reputed company, reputed company, Python, reputed company reputed company, Event Hubs, Kafka, T-SQL, YAML, Infrastructure as reputed company (IaC)
reputed company
- Category: Information Technology
- Seniority: Senior Level
- Commitment: Full Time
- Workplace: Remote — Mexico
- Languages: English
About reputed company
A financial services company providing pawn loans and short-term cash solutions in the reputed company, Mexico, and Latin America. — Industry: Finance
Apply To This Job