Job Description

We are looking for a Senior Database Administrator (DBA) to join our remote team at Promologistics.\nLocation: CDMX\nModality: Full time / Remote\nRequired experience: 5+ years\nDescription of the job:\nWe are looking for a high-impact Database Administrator to manage, optimize and guarantee the availability of critical databases for the business. The ideal person has solid experience in Microsoft SQL Server as the main engine, with management of MySQL, MariaDB and PostgreSQL, and verifiable experience in cloud infrastructure with AWS.\nMain responsibilities\nAdministrate, monitor and optimize the performance of production databases (MS SQL Server, MySQL, MariaDB, PostgreSQL).\nDesign and implement high-performance strategies availability (HA) and disaster recovery (DR): Always On Availability Groups, Failover Clustering, replication (master-slave, master-master, logical replication), log shipping.\nDefine and implement backup and restoration policies (full, differential, log), and periodically validate recovery plans.\nPerform query tuning, execution plan analysis, indexing and optimizing storage engines.\nManage database security: managing roles and permissions, encrypted in transit and at rest (TDE), auditing and regulatory compliance.\nDesign and implement database architectures in AWS (RDS, Aurora, EC2 self-managed, RDS for SQL Server/PostgreSQL/MySQL/MariaDB), including Multi-AZ, reading replicas and scaling strategies.\nAutomate operational tasks through scripting (T-SQL, PL/pgSQL, Bash, PowerShell, Python).\nCollaborate with development teams in schema design, data modeling and good integration practices with applications.\nParticipate in database engine migrations (on-prem to cloud, cross-engine) and major version updates.\nProvide support and safeguards for critical incidents (on-call), ensuring compliance with defined SLA/RPO/RTO.\nDocument architectures, operating procedures and runbooks.\nRequirements\n5+ years of experience as DBA in critical production environments.\nSolid and verifiable knowledge in Microsoft SQL Server (installation, configuration, tuning, HA/DR, security).\nExperience with MySQL, MariaDB and PostgreSQL in production.\nPractical experience with AWS: RDS, Aurora, EC2, VPC, IAM, CloudWatch, backups in S3.\nMastery of T-SQL and SQL standard; Knowledge of PL/pgSQL desirable.\nExperience in clustering, replication and data partitioning.\nMonitoring and observability knowledge (CloudWatch, Zabbix, Prometheus/Grafana, SolarWinds, Redgate, or similar).\nFamily with automation and infrastructure as code (Terraform, CloudFormation) desirable.\nExperience working with agile methodologies and version control (Git).\nIntermediate-advanced technical English (documentation reading, collaboration with international teams).\nDeseable / plus\nCertifications: Microsoft Certified: Azure Database Administrator Associate, AWS Certified Database - Specialty, AWS Solutions Architect.\nPrevious experience in sectors with critical data 24/7 (logistics, finance, e-commerce, health).\nCI/CD knowledge applied to database changes (Flyway, Liquibase).\n\nSoft skills\nAbility to work under pressure in critical incidents.\nClear communication with technical and non-technical teams.\nAutonomity, proactivity and focus on continuous improvement.\nSecurity-oriented mentality regulatory compliance.",