&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 (MSSQL) is responsible for architecting, managing, optimizing, and securing Microsoft SQL Server environments across on premises and cloud platforms. This role leads complex database and cloud migration initiatives, oversees technical escalations, ensures regulatory and security compliance, and provides advanced engineering leadership. The position requires deep technical expertise across MSSQL, cloud ecosystems, Python automation, Terraform IaC, AI driven optimization, and enterprise-grade operational excellence including PLM, on-call readiness, and handling security vulnerabilities.Primary Responsibilities:• Lead the end to end design, implementation, optimization, and modernization of MSSQL databases across on premises, hybrid, and multi cloud environments (Azure/AWS/GCP), ensuring high performance, scalability, and reliability• Architect and execute large-scale migration initiatives including cloud DB migrations, cross platform migrations, legacy modernization, and consolidation of complex database ecosystems• Implement, manage, and optimize HA/DR architectures such as Always On Availability Groups, clustering, log shipping, replication, and geo-distributed failover strategies• Drive advanced performance engineering, query tuning, indexing strategies, memory/IO optimization, and proactive capacity planning to support mission-critical workloads• Provide technical leadership by mentoring and upskilling DBA and Data Engineering teams, guiding best practices, and delivering performance evaluations that support continuous professional growth• Lead high-severity incident management, coordinate technical war rooms, resolve escalations related to performance degradation, outages, security breaches, cloud deployment failures, and data integrity issues• Own and execute remediation of security vulnerabilities, including patch management, security hardening, auditing, encryption enforcement, access reviews, and continuous compliance tracking• Conduct periodic security assessments, threat analysis, and vulnerability scans, ensuring adherence to regulatory and organizational data protection standards• Develop and maintain automation frameworks using Python, PowerShell, and T SQL to streamline operations, reduce manual effort, and improve reliability• Design and implement Terraform-based Infrastructure as Code (IaC) for consistent, scalable deployment of SQL infrastructure in cloud environments• Integrate AI/ML-driven capabilities for proactive anomaly detection, predictive performance insights, and automated optimization recommendations• Collaborate with SRE, DevOps, Cloud, and Application teams to enable CI/CD for database objects, schema deployments, and data pipelines• Drive PLM (Product Lifecycle Management) activities including platform upgrades, patch cycles, deprecation, modernization, and lifecycle governance• Participate in and prepare for 24/7 on-call rotation, ensuring rapid response to production issues and minimizing downtime• Maintain comprehensive documentation including architectures, SOPs, runbooks, playbooks, migration plans, and knowledge base articles• Partner with engineering and application teams to support deployments, troubleshoot performance issues, and design scalable, resilient database solutions aligned with business needs• Deliver a customer-first approach and demonstrate high ownership during real-time incident handling.• Support cross-functional data integration, cloud adoption, and migration projects end-to-end• Execute routine maintenance-backups, integrity checks, index optimization, stats updates• Manage least-privilege database security, RBAC, access reviews, and privileged operations• Implement database synchronization and replication strategies for distributed/global architecture• Monitor and optimize resource utilization, cost efficiency, and scalability across cloud platforms• Professional Developmento Stay up to date with the latest trends and advancements in MSSQL technologies and best practiceso Attend relevant conferences, workshops, and training sessions to enhance technical knowledge and leadership skillso Pursue certifications related to Microsoft SQL Server and database managemento Continuously track and adopt the latest advancements in MSSQL, cloud databases, automation, AI/ML capabilities, and cybersecurityo Participate in technical conferences, cloud workshops, and certification programso Pursue advanced certifications in SQL Server, 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 regard 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 degree in computer science, IT, or related discipline• 10+ years of hands-on experience as an MSSQL DBA/Data Engineer managing enterprise-scale systems• Proven experience delivering cloud migrations, modernizations, and complex database transformations• Solid leadership experience in managing DBA teams and handling high-severity escalations• Expertise in troubleshooting advanced database issues and optimizing high-performance workloads• Experience documenting and standardizing procedures, playbooks, and operational frameworks• Technical Skills:o Certifications in Azure / AWS Cloud, Terraform, Python, or AI Engineeringo Microsoft SQL certifications (MCSA, MCSE, MCITP)o Experience with MySQL, PostgreSQL, Oracle, or NoSQL systemso Hands-on experience with cloud-native databases (Azure SQL, AWS RDS/Aurora, GCP Cloud SQL)o Demonstrated commitment to continuous learning and technology adoption• Knowledge & Skills:o Solid leadership and team management abilitieso Proven excellent problem-solving and troubleshooting skillso Proven effective communication and interpersonal skills to collaborate with cross-functional teamso Proven detail-oriented and able to work with a high level of accuracyo Ability to handle multiple priorities and meet deadlines in a dynamic environmento Solid analytical and decision-making skillsPreferred Qualifications:• Master’s degree in Computer Science or a related field• Microsoft SQL Server certifications (e.g., MCSA, MCSE, MCITP)• Experience with other database management systems like MySQL, Oracle, or PostgreSQL• Familiarity with cloud database services (e.g., Azure SQL Database, AWS RDS)• Demonstrated commitment to continual learning

Job Details

Skills Required

More Details

Apply