Senior Sql Database Administrator

PowerSchool; Región Centro; On-site; MXN 609,000 - 730,000; Full time

Job summary

PowerSchool in Mexico is seeking a Sr Database Administrator with strong MySQL experience to support production database environments. The role focuses on administration, monitoring, troubleshooting, performance tuning, backups, recovery, and continuous improvement of critical databases.

The ideal candidate has 7+ years of hands-on MySQL production experience, expertise in performance tuning, replication/high availability, and scripting.

Qualifications

• 7+ years of production database administration experience.
• Strong SQL troubleshooting and query optimization skills.
• Experience with MySQL and high availability concepts.
• Proficient scripting skills and cross‑platform OS knowledge.
• Professional English communication.

Responsibilities

• Administer and support production MySQL database environments.
• Monitor availability, performance, capacity, security and resources.
• Troubleshoot slow queries, indexing, locking, and performance issues.
• Analyze queries and execution plans for improvements.
• Manage upgrades, patches, maintenance, and config changes.
• Support backup, restore, DR, replication, and HA procedures.
• Investigate incidents and perform root cause analysis.
• Collaborate with engineering and cloud teams to optimize performance.
• Develop automation scripts for routine DBA tasks.
• Maintain documentation and operational standards.

Skills

SQL troubleshooting

Query optimization

MySQL

High availability

Scripting

Linux/Windows

English communication

Tools

MySQL

SQL Server

Oracle

MongoDB

AWS RDS

Job description

Employment Type: Full-time

Location: Mexico

Salary: MXN $60,000 gross per month, depending on the candidate’s experience and position level.

About the Role

We are seeking a Sr Database Administrator with strong MySQL experience to support our company.

This position focuses on the administration, monitoring, troubleshooting, performance, availability, backup, recovery, and continuous improvement of production database environments.

The ideal candidate has hands‑on experience supporting MySQL databases in production and understands database performance, SQL troubleshooting, indexing, replication, high availability, backup and restore procedures, and incident resolution.

Key Responsibilities

• Administer and support production MySQL database environments.
• Monitor database availability, performance, capacity, security, and resource utilization.
• Troubleshoot slow queries, locking, connections, indexing, memory, CPU, storage, and database performance issues.
• Analyze SQL queries and execution plans and recommend performance improvements.
• Manage database upgrades, patching, maintenance, and configuration changes.
• Support backup, restore, disaster recovery, replication, and high-availability procedures.
• Investigate database incidents and participate in root cause analysis.
• Work with Software Engineering and Cloud Operations teams to improve application/database performance.
• Develop scripts and automation for recurring database administration activities.
• Maintain database documentation, procedures, and operational standards.
• Participate in production support and scheduled on-call rotations when required.
• Senior candidates may mentor other DBAs and contribute to architecture, standards, capacity planning, and technical decision‑making.

Required Qualifications

• 7+ years of professional database administration experience.
• Experience supporting databases in production environments.
• Strong SQL troubleshooting and query optimization skills.
• Knowledge of indexing, execution plans, transactions, locking, constraints, and database performance.
• Experience with backup, restore, replication, high availability, and disaster recovery concepts.
• Knowledge of database monitoring and performance troubleshooting.
• Experience with Linux, Windows, Ubuntu, or similar operating systems.
• Scripting experience with Bash, Shell, Python, PowerShell, Perl, or similar technologies.
• Strong troubleshooting and root cause analysis skills.
• Professional English communication skills.

Preferred Qualifications

• MySQL 8.x
• Microsoft SQL Server
• Oracle
• MongoDB
• AWS RDS or other managed database platforms
• ETL and data warehouse environments
• Database modeling
• Stored procedures, functions, views, and triggers
• CI/CD or SRE environments

Preferred Candidate Background

This opportunity may be a strong fit for professionals currently working as:

• Database Administrator
• MySQL Database Administrator
• SQL Database Administrator
• Production DBA
• Senior Database Administrator
• Application Database Administrator
• Database Operations Engineer

Candidates whose primary background is Oracle, PostgreSQL, or SQL Server are welcome to apply provided they also have meaningful hands‑on MySQL experience.

We are committed to building a workforce that represents the users and communities we serve, creating a culture of belonging, and providing equal employment opportunities regardless of race, creed, color, religion, gender, sexual orientation, gender identity or expression, national origin, disability, age, genetic information, marital status, veteran status, or any other characteristic protected by applicable la