MySQL Database Administrator

As an experienced MySQL DBA & Developer, your role will involve designing, maintaining, and optimizing MySQL databases for high-volume applications. You must be capable of managing large-scale data operations, cloud/on-prem deployments, ETL pipelines, and ensuring high availability, performance, and security. Key Responsibilities: - Database Administration - Install, configure, upgrade MySQL (v5.5/8.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. Qualifications Required: - Technical Skills - Proficiency in MySQL (v5.5/8.0), SQL, indexing, encryption, and query tuning. - Experience with ETL tools, SSIS, scripting (Python, Bash), and Linux/Unix. - Familiarity with Cloud platforms like Azure (AWS/GCP a plus), job schedulers (Autosys, cron). - Knowledge of high availability, clustering, sharding, and failover systems. - Experience with ServiceNow, JIRA, DevOps, and BI tools is a plus. Soft Skills: - Strong problem-solving and communication skills. - Ability to handle stakeholders and work under pressure. - Detail-oriented with a focus on performance, reliability, and security.,