SQL Database Administrator

Experience: 4 - 12 Years

Venue: Gitanjali Park, International Finalcial Hub(CBD), Newtown, Kolkata, Chakpachuria, West Bengal 700156.

Candidate must be available for face-to-face interview on 10/05/2025 Saturday.

Job description

Database Administration – Install, configure, and manage MySQL/MariaDB instances across production, staging, and development environments.

• Backup & Recovery – Implement and monitor mysqldump, Percona XtraBackup, and binary log backups for disaster recovery.

• Performance Tuning & Optimization – Analyze slow queries using EXPLAIN, Performance Schema, and Query Profiling; optimize indexes and configurations.

• High Availability (HA) & Replication – Configure and manage Master-Slave, Master-Master, Group Replication.

• Security & Compliance – Enforce user access controls, SSL encryption, auditing, and GDPR compliance.

• Troubleshooting & Issue Resolution – Identify and resolve deadlocks, replication lag, MySQL crashes, and performance bottlenecks.

• Automation & Scripting – Develop scripts for automation of backup, monitoring, and maintenance tasks.

• Database Design & Capacity Planning – Support schema design, data partitioning, and resource scaling based on workload patterns.

• Patch Management & Version Upgrades – Apply MySQL patches, version upgrades, and security fixes with minimal downtime.

• Cloud & Hybrid Database Management – Administer MySQL databases in all environments.