19 Nov
|
Clock Edge Technologies Pvt Lt
|
India
19 Nov
Clock Edge Technologies Pvt Lt
India
MySQL Database Administrator (DBA)
**Experience:** 7+ Years
**Location:** Remote
**Work Mode:** Remote
**Shift Timings:** General Shift
**Budget:** ₹25–26 LPA
**Open Positions:** 1
### Mandatory Skills
**MySQL Database Administration**
* Minimum 5+ years of hands-on experience as a MySQL DBA in production environments.
* Strong experience in MySQL installation, configuration, upgrades, and patching.
* Hands-on experience with MySQL replication, GTID replication, Group Replication, and InnoDB Cluster.
* Experience managing high availability, failover, backup, recovery, and disaster recovery.
* Knowledge of point-in-time recovery using binary logs.
**Performance Tuning & SQL**
* Robust SQL query optimization and indexing skills.
* Experience with EXPLAIN plans, slow-query log analysis, and InnoDB tuning.
* Proficiency in SQL queries, stored procedures, functions, and triggers.
* Ability to independently troubleshoot locking, deadlocks, and database performance issues.
**Monitoring, Security & Production Support**
* Experience with database monitoring tools such as Percona Monitoring and Management, MySQL Enterprise Monitor, or Prometheus/Grafana.
* Knowledge of database security, user and privilege management, encryption, and auditing.
* Experience in production support, incident management, root cause analysis, and preventive maintenance.
* Experience with schema changes, data migrations, and database deployments.
### Roles & Responsibilities
* Install, configure, upgrade, and maintain MySQL database servers.
* Manage database availability, replication, performance, and capacity.
* Design and test backup, restore, and disaster recovery strategies.
* Monitor database health and resolve production incidents.
* Optimize queries, indexes, and database configurations.
* Automate routine DBA tasks and support database operations.
* Collaborate with application development, DevOps, infrastructure, and reporting teams.
* Maintain operational documentation, runbooks, and standard operating procedures.
### Good-to-Have Skills
* Linux administration and shell scripting.
* Python or Perl scripting for automation.
* Kubernetes and Docker, including StatefulSets, persistent volumes, and MySQL Operators.
* Cloud-managed databases such as Azure Database for MySQL, Amazon RDS, Aurora MySQL, or Oracle Cloud MySQL HeatWave.
* Exposure to SQL Server, Azure SQL, PostgreSQL, or Oracle.
* Working knowledge of Azure Data Factory (ADF) and Power BI datasets.
* CI/CD pipelines and database change management tools such as Liquibase and Flyway.
* MySQL or Oracle DBA certification..
Pay: Up to ₹2,600,000.00 per year
Work Location: Remote
📌 MySQL Database Administrator (DBA) (India)
🏢 Clock Edge Technologies Pvt Lt
📍 India