Job Details

Skills Required: MySQL

Educational Requirements:

• Master Degree, Bachelor Degree

Experience:

• 3 Years

Job Description:

JOB SUMMARY

 We are seeking a skilled and motivated MySQL Database Administrator with at least 8 years of experience to join our growing technology team. In this role, you will be responsible for ensuring the performance, availability, reliability, and security of our MySQL database systems. You will work closely with our Solution Architect, development, DevOps, and infrastructure teams to design, implement, and maintain efficient database solutions that power our critical applications. The ideal candidate is passionate about data, thrives in a collaborative environment, and is adept at both proactive maintenance and rapid problem-solving.

         KEY ACCOUNTABILITIES

-                 Analyse and assess the business needs of the client to find the best solution for the client. Overall strong analytical and problem-solving skills are highly important for this role.

-                 Database Management & Administration: Install, configure, upgrade, and maintain MySQL database instances (self-managed/On-Premises).

-                 Performance Tuning: Proactively monitor, analyze, and optimize database performance using tools like `EXPLAIN`, Performance Schema, and slow query logs. Identify and resolve bottlenecks in queries, indexes, and configurations.

-                 High Availability & Disaster Recovery: Implement and manage robust replication (master-slave, master-master) and clustering solutions (InnoDB Cluster or Galera Cluster or Similar High Availability solutions).

-                 Design, test, and execute backup, recovery, and failover strategies to ensure business continuity.

-                 Security & Compliance: Enforce database security best practices, manage user access and privileges, and ensure compliance with data protection regulations (e.g., GDPR, PCI DSS). Perform regular security audits and patching.

-                 Monitoring & Alerting: Set up comprehensive monitoring and alerting (using tools like Prometheus/Grafana, Datadog, Nagios, or Zabbix) for database health, performance metrics, and capacity thresholds.

-                 Automation & Scripting: Automate routine DBA tasks (backups, health checks, deployments) using scripting languages like Bash, Python, or Ansible.

-                 Collaboration & Support: Work closely with software engineers to review SQL code, advise on schema design, and optimize application queries. Provide 24/7 on-call support for production database incidents on a rotating basis.

-                 Capacity Planning: Forecast future database growth and performance needs. Plan and execute scaling strategies, both vertical and horizontal.

-                 Schema Migration Management: Plan and execute safe schema changes and data migrations using industry-standard tools (e.g., Percona Toolkit, gh-ost, flyway)

     JOB REQUIREMENTS

    (Education, Qualification/Skills/Behaviors, and Related Experiences.)

-          Bachelor’s degree in computer science, Information Technology, or a related field, or equivalent practical experience.

-          8+ years of hands-on experience as a MySQL Database Administrator in a production environment.

-          Deep understanding of MySQL architecture, InnoDB storage engine, and locking mechanisms.

-          Proven experience with MySQL performance tuning and optimization.

-          Strong practical knowledge of MySQL replication, backup, and recovery methodologies (e.g., using mysqldump, XtraBackup, mysqlshell).

-          Proficiency in writing and optimizing complex SQL queries.

-          Experience in the installation and knowledge of database connection proxying and load balancing (ProxySQL, HAProxy)

-          Knowledge of Orchestrator tools that monitor and handles master promotion

-          Experience with Linux/Unix operating systems and command-line tools.

-          Familiarity with scripting for automation (Bash, Python, etc.).

-          Excellent problem-solving skills and the ability to work under pressure.

-          Establish and enforce database security policies, including encryption at rest and in transit (TLS), auditing, and access control.

-          Knowledge of other database technologies (e.g., PostgreSQL, Redis, Elasticsearch, MongoDB).

-          Relevant certifications (e.g., Oracle MySQL Database Administrator Certified Professional).

-          Strong communication and collaboration skills.

-          Familiarity with DevOps practices and CI/CD pipelines.