&nbsp;
At Optum, we value the distinctive talents and perspectives each employee brings to our workplace. We foster an inclusive work environment through various initiatives like our Employee Resource Groups, which are connected internal communities that focus on sharing our diverse experiences and backgrounds, creating a greater sense of belonging.
<a id="m_3228872436145793904m_-3991317240390317092OWA89bc3dac-771b-a754-7ba5-5bcced69cc5f" title="https://www.optum.in/about/diversity-equity-inclusion.html" href="https://www.optum.in/about/diversity-equity-inclusion.html" target="_blank" rel="noopener noreferrer" data-saferedirecturl="https://www.google.com/url?q=https://www.unitedhealthgroup.com/careers/in/culture/diversity-equity-inclusion.html&amp;source=gmail&amp;ust=1762842463320000&amp;usg=AOvVaw2nibKunvLIEeyJkda5QUpG">Learn more</a>

Optum

The Senior Data Engineering Consultant (MySQL) is responsible for architecting, operating, optimizing, and securing MySQL platforms across on premises and cloud (AWS/Azure/GCP). The role leads complex cloud and cross platform migrations, manages technical escalations, ensures regulatory/security compliance, and drives engineering excellence via Python automation, Terraform IaC, and AI assisted observability. It includes end to end PLM, 24/7 on call readiness, and proactive vulnerability management.Primary Responsibilities:• Lead end to end design, implementation, optimization, and modernization of MySQL 5.7/8.0 (primarily InnoDB) across on prem, hybrid, and multi cloud (AWS RDS/Aurora MySQL, Azure DB for MySQL, GCP Cloud SQL) with high performance and reliability• Architect and execute large scale cloud DB and cross platform migrations, consolidations, and legacy modernization using DMS, MySQL Shell Dump & Load, mysqldump/myloader-mydumper, and Percona Toolkit• Implement and optimize HA/DR via Group Replication / InnoDB Cluster, semi sync replication, read replicas, Orchestrator, ProxySQL/HAProxy, and geo distributed failover• Drive performance engineering using Performance Schema, slow query log, EXPLAIN, pt query digest, indexing strategies, buffer pool tuning, and proactive capacity planning• Provide senior escalation leadership: run war rooms, resolve outages, replication breakage, data drift, and performance regressions; partner with app/SRE teams for rapid recovery• Own security hardening and vulnerability remediation (patching/versions, SSL/TLS, at rest encryption via keyring, auditing, least privilege, secrets management, and continuous compliance)• Build automation and operations tooling using Python, Bash, and SQL; enable CI/CD for schema changes; provision via Terraform with parameterized modules• Integrate AI/ML for anomaly detection, workload prediction, and automated tuning recommendations• Drive PLM (patching, minor/major upgrades e.g., 5.7 → 8.0), deprecation, and modernization roadmaps; maintain detailed runbooks, SOPs, and architecture docs• Participate in 24/7 on call, ensuring SLAs, RTO/RPO; collaborate closely with DevOps, Cloud, and Application teams• Job Dutieso Customer first ownership in real time incidents; lead technical triage and post mortemso Execute backups and recovery using Percona XtraBackup, MySQL Enterprise Backup, and cloud native snapshots; perform recovery drillso Perform routine maintenance: analyze, optimize, repair (when appropriate), index management, and statistics updateso Manage RBAC, users/roles, secrets rotation; enforce network and TLS policieso Implement and monitor replication topologies (GTID, multi source, cascading); manage orchestrator failoverso Track and optimize resource usage and cloud cost efficiency (instance sizing, storage/IO, backups, cross AZ traffic)• Professional Developmento Maintain expertise in MySQL 8.0, replication/cluster tech, observability, and securityo Pursue MySQL/Percona certifications and major cloud certifications (AWS/Azure/GCP)o Upskill in Terraform, Python, and AI for Opso Pursue advanced certifications in MySQL, Azure/AWS cloud, Terraform, and AI technologies• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do soRequired Qualifications:• Master’s in CS/IT or related; 10+ years as MySQL DBA/Data Engineer at enterprise scale• Proven delivery of cloud migrations, modernizations, and complex transformations• Leadership in handling P1 escalations, on call, and mentoring engineering teams• Deep performance tuning and troubleshooting experience; solid documentation disciplinePreferred Qualifications:• Certifications: MySQL 8.0, Percona, AWS/Azure/GCP, Terraform, Python• Experience with adjacent databases (PostgreSQL, MSSQL, NoSQL)• Exposure to MySQL and ProxySQL at scale• Technical Skills:o MySQL internals (InnoDB, redo/undo, buffer pool, locks/transactions), replication (GTID, semi sync), Group Replication/InnoDB Cluster, Orchestratoro Tooling: MySQL Shell, Percona Toolkit, XtraBackup, Performance Schema, pt query digest, ProxySQL/HAProxyo Cloud: RDS/Aurora MySQL, Azure DB for MySQL, Cloud SQL; VPC/netsec fundamentalso Automation: Python, Bash, Terraform, GitOps/CI CDo Security: TLS, keyring at rest encryption, auditing, least privilege• Knowledge & Skills:o Demonstrated incident management, root cause analysis, and continuous improvemento Proven leadership, stakeholder communication (technical to executive), decision makingo Proven solid prioritization and delivery in dynamic, high stakes environments

Job Details

Skills Required

More Details

Apply