What are the responsibilities and job description for the MySQL Database Administrator (DBA) (Full Time) position at ResolveTech Solutions Inc.?
Job Details
Company: RTS
Location: Addison TX
Job Type: Full-time
Experience Level: Mid-Senior Level
RTS is seeking a skilled MySQL Database Administrator (DBA) to join our team on a full-time basis. The ideal candidate will be responsible for managing, optimizing, and securing MySQL databases, ensuring high availability, performance, and reliability. The role requires deep expertise in database administration, backup strategies, replication, and query optimization.
<>Key Responsibilities:- Install, configure, and maintain MySQL databases in production, development, and test environments.
- Ensure database performance, scalability, and security by monitoring and optimizing database performance.
- Design and implement backup, recovery, and disaster recovery strategies.
- Set up and maintain database replication, clustering, and high availability solutions.
- Perform regular performance tuning, indexing, and query optimization.
- Automate routine database maintenance tasks using scripts and tools.
- Ensure database security and compliance with industry best practices.
- Work closely with development teams to optimize SQL queries and improve application performance.
- Manage database migrations, upgrades, and patches.
- Develop and maintain documentation for database architecture, procedures, and policies.
- 5 years of experience as a MySQL DBA in a high-availability production environment.
- Strong experience with MySQL performance tuning, replication (Master-Slave, Master-Master), and clustering.
- Expertise in writing and optimizing complex SQL queries, stored procedures, and triggers.
- Hands-on experience with MySQL backup and recovery tools such as Percona Xtrabackup or MySQL Enterprise Backup.
- Proficiency in Linux-based MySQL environments, including shell scripting for automation.
- Experience with monitoring tools like Prometheus, Grafana, or Percona Monitoring & Management (PMM).
- Knowledge of NoSQL databases (MongoDB, Redis, etc.) is a plus.
- Strong understanding of database security best practices.
- Familiarity with cloud-based MySQL solutions (AWS RDS, Azure MySQL, Google Cloud SQL) is preferred.
- Excellent troubleshooting skills and ability to work under pressure.
- MySQL DBA certification (e.g., Oracle MySQL Certified DBA).
- Experience with containerized databases using Docker/Kubernetes.
- Familiarity with CI/CD pipelines and DevOps practices.
- Knowledge of database migrations and version control systems (Liquibase, Flyway).
- Competitive salary and benefits package.
- Work with cutting-edge database technologies and cloud environments.
- Career growth and learning opportunities.
- Comprehensive health, dental, and vision insurance.
- Paid time off (PTO) and holiday benefits.