What are the responsibilities and job description for the MySQL DBA position at Centraprise?
Job title: MySQL DBA
Job Location: Englewood Cliffs, NJ - Onsite
Job Type: Fulltime
Interview: In-Person (Face to Face)
Job Description:
Must Have Technical/Functional Skills
- MySQL
- Linux
- AWS RDS
- PostgreSQL
- Redis
- Mongo dB
- CICD
- We are hiring an experienced MySQL Database Administrator with a minimum of 5 years of hands-on experience in managing, tuning, and supporting MySQL environments. The ideal candidate must have strong expertise in Linux, AWS cloud services, and production-grade MySQL administration.
Roles & Responsibilities
- Install, configure, and maintain MySQL 5.7 / 8.0 on Linux-based systems.
- Perform database performance tuning, slow query analysis, and index optimization.
- Manage backup and recovery using tools like mysqldump and Percona XtraBackup.
- Configure and support MySQL replication (Master–Slave, GTID replication).
- Work on high availability setups (MySQL Cluster, InnoDB Cluster, Galera).
- Maintain and optimize AWS-hosted databases: EC2 MySQL instances, AWS RDS / Aurora MySQL.
- Troubleshoot database performance, latency, and system resource issues.
- Perform regular patching, upgrades, and engine maintenance.
- Implement and manage user access, privileges, and security best practices.
- Work closely with DevOps and application teams for schema changes and deployments.
- Participate in on-call rotation for production support.
Generic Managerial Skills:
- Exposure to Percona MySQL or MariaDB.
- Experience with Shell/Python scripting for automation.
- CI/CD tools (Jenkins, GitLab CI) knowledge.
- Experience in monitoring tools: PMM, Grafana, Prometheus, datadog.