02 Nov
|
Olive Crypto Systems
|
Gurugram
02 Nov
Olive Crypto Systems
Gurugram
Job Summary We are looking for an experienced MySQL Database Administrator (DBA) with 5+ years of hands-on experience in MySQL database administration, performance tuning, database patching, backup and recovery, high availability, and production database support. The candidate will be responsible for ensuring database availability, performance, security, reliability, and business continuity across production and non-production environments.
Key Responsibilities
Install, configure, upgrade, patch, and maintain MySQL databases across production and non-production environments. Perform database administration, monitoring, troubleshooting, and performance tuning. Manage MySQL backup and recovery strategies, including logical and physical backups, and conduct periodic recovery testing. Administer MySQL replication, InnoDB Cluster, Group Replication, and high-availability/disaster-recovery environments, as applicable. Troubleshoot database performance issues using execution plans, slow query logs, Performance Schema, and other MySQL diagnostic tools. Perform database migrations, refreshes, cloning, and version upgrades. Execute periodic database patching and apply bug fixes and security updates to address vulnerabilities and incidents. Manage database security, user accounts, roles, privileges, access controls, and auditing.
Handle production incidents, perform root-cause analysis, and implement preventive measures. Automate routine DBA activities using shell scripting, SQL, and other appropriate tools. Collaborate with application, infrastructure, and development teams to ensure database stability, performance, and reliability. Maintain database documentation, operational procedures, backup and recovery procedures, and disaster recovery plans. Required Skills 5+ years of hands-on experience in MySQL Database Administration. Strong knowledge of MySQL architecture, storage engines (particularly InnoDB), indexing, transactions, and database administration. Experience with MySQL replication, InnoDB Cluster, Group Replication, and high-availability solutions. Strong expertise in SQL tuning, query optimization, indexing strategies, and performance troubleshooting. Experience in database backup, recovery, patching, upgrades, and migrations. Experience in production support and critical incident management. Good knowledge of Linux/Unix operating systems and shell scripting. Experience with database monitoring, capacity planning, and troubleshooting replication lag. Solid analytical, troubleshooting, and communication skills.
📌 DBA II (Gurugram)
🏢 Olive Crypto Systems
📍 Gurugram