Job Summary :
Looking for an experienced MySQL DBA & Developer to design, maintain, and optimize MySQL databases for high-volume applications. Must be capable of managing large-scale data operations (in TBs), cloud / on-prem deployments, ETL pipelines, and ensuring high availability, performance, and security.
Key Responsibilities :
Database Administration :
- Install, configure, upgrade MySQL (v5.5-v8.0) on VM, systems, and Azure Cloud.
- Manage backup, recovery, DRDP, auto-recovery, and replication setups
- Tune performance (queries, indexes, server settings); ensure database security and access control.
- Monitor systems using tools like Percona Toolkit, Nagios, or Prometheus.
- Maintain architecture documentation, cronjobs, and archiving strategies
MySQL Development :
Write complex SQL queries, views, triggers, procedures; design schemas.Create & optimize ETL pipelines for data loading / extraction (including staged loads).Handle large-volume data migration, cleaning, normalization, and modeling.Support analytics and report development (Superset, Power BI, Tableau preferred).Implement schema changes, assist DR planning, and support app integration.Technical Skills Required :
MySQL (v5.5 / 8.0), SQL, indexing, encryption, query tuning.ETL tools, SSIS, scripting (Python, Bash), Linux / Unix.Cloud (Azure preferred, AWS / GCP a plus), job schedulers (Autosys, cron).Familiar with high availability, clustering, sharding, failover systems.Experience with ServiceNow, JIRA, DevOps, and BI tools is a plus.Soft Skills :
Strong problem-solving, communication, stakeholder handling.Ability to work under pressure and support distributed teams.Detail-oriented with a focus on performance, reliability, and security.ref : hirist.tech)