Site Reliability Engineer - SQL Server

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. Weu2019re looking for people who are determined to make life better for people around the world. Enable reliable, secure, highu2011performing SQL Server and cloud database environments by driving automation, modernizing multiu2011cloud data platforms, and ensuring enterpriseu2011grade observability, compliance, and operational excellence. The is actively looking for an experienced SQL Server Site Reliability Engineer who is passionate about advancing enterpriseu2011scale data platforms, modernizing database operations, and enabling Cloudu2011ready SQL servers. If you thrive in solving complex reliability challenges, automating repetitive tasks, strengthening governance, and empowering application teamsu2014this role is for you. Your expertise accelerates innovation, improves system resilience, and supports the mission of delivering medicines that make life better for people around the world. What Youu2019ll Be Doing: You will serve as a core engineering and operational expert for SQL Server across onu2011premise and multiu2011cloud environments. In this role, you will ensure availability, resiliency, automation, observability, and lifecycle management of missionu2011critical SQL server services. You will work closely with Cloud Infrastructure, SMEs, Security, and Application Engineering teams to modernize, optimize, and secure enterprise database operations. How Youu2019ll Succeed: Operational Support + Provide dayu2011tou2011day administration and operational support for SQL Server (2014, 2016, and above). + Perform performance tuning, patching, upgrades, backup/recovery, and capacity management. + Ensure database reliability, availability, and compliance with enterprise security standards. + Handle database incidents, requests, and changes. Database Administration + Install, configure, upgrade, and patch SQL Server across all editions and environments. + Troubleshoot database issues, errors, blocking, deadlocks, memory/storage performance, and bottlenecks. + Optimize queries, indexes, and execution plans. + Support new server/database creation, maintenance job design, CDC configuration, and platform integration. Multiu2011Cloud Database Modernization + Support SQL Server migrations to Azure, AWS, and other cloud platforms. + Assist in designing DR, replication strategies, and crossu2011cloud failover. Automation & AIOps + Build automation using PowerShell, Python, Ansible, Terraform, Bicep/ARM, and Shell scripting. + Implement Infrastructureu2011asu2011Code (IaC) for database provisioning, patching, and configuration. + Apply AIOps practices for anomaly detection, predictive alerting, and proactive incident prevention. Collaboration & Continuous Improvement + Partner with Cloud Engineering, Operations, and Application teams to deliver reliable database services. + Drive modernization through automation, observability, and AIu2011driven insights. + Create runbooks, SOPs, and best practice guides. Capacity Planning & Scalability + Forecast database growth and manage resource utilization. + Ensure systems scale efficiently to support highu2011volume enterprise workloads. Database Security & Compliance + Enforce enterprise security standards, RBAC, encryption, auditing, and leastu2011privilege access. + Conduct vulnerability scans, patching, and upgrade planning. Backup & Recovery Management + Design and automate full, differential, and transaction log backup strategies. + Store and manage backups using PPDM (DELL storage). + Validate RTO/RPO through regular restore testing. Cost Optimization + Optimize SQL workloads across onu2011prem, Azure SQL DB, Azure Managed Instance, and IaaS. + Ensure costu2011efficient sizing and utilization. SRE Principles & SLA Enforcement + Define and maintain SLIs, SLOs, and SLAs for SQL services. + Apply SRE best practices to reduce toil and increase reliability. DR Drills & Business Continuity + Partner with DR teams to execute DR drills, validate failover, and maintain readiness. Documentation & Knowledge Sharing + Maintain detailed documentation of environments, configurations, and troubleshooting guides. + Share knowledge to reduce operational silos and strengthen team capabilities. What You Should Bring: + Deep expertise in SQL Server internals, HA/DR architectures (Always On AGs, FCI), and enterpriseu2011scale database patterns. + Proven ability to diagnose and optimize performance issues, indexing strategies, and heavy workloads. + Strong automation experience with PowerShell, Python, Ansible, Terraform, or equivalent tools. + Knowledge of Azure/AWS SQL services and hybridu2011cloud integration patterns. + Experience with identity/security frameworks (AD, Azure AD, SSO). + Familiarity with DevOps workflows, Git, schema versioning, and CI/CD for data platforms. + Strong communication, analytical thinking, and stakeholder management skills. + Ability to translate business requirements into scalable platform enhancements. + Exposure to containers/Kubernetes for databaseu2011adjacent workloads (a plus). + Backup & Recovery experience including restore drill validation. + Experience with observability tooling (e.g., Splunk, Grafana, AppInsights). + Familiarity with ITSM tools (ServiceNow or similar). + Security & compliance experience with TDE, Always Encrypted, RBAC, auditing, vulnerability remediation. + Automation experience with PowerShell, Python, Terraform, Ansible, Bicep/ARM. + Experience with DBOps, Git workflows, and automated database deployments. + Experience with CDC configuration and management. + Cloud knowledge across Azure SQL DB, Managed Instance, SQL on VM; AWS experience is a plus. + Strong root cause analysis skills. Basic Requirements: + High School Diploma/GED with 5+ years administering SQL Server. + Experience with SQL Server in both onu2011prem and Azureu2011based deployments. + High Availability & DR experience: Always On AGs, FCI, Log Shipping, Replication, Geou2011replication. + Experience in performanceu2011tuning background: indexing, partitioning, statistics, query tuning, log management. _Qualified applicants must be authorized to work in the United States on a full-time basis. Lilly will not provide support for or sponsor work authorization or visas for this role, including but not limited to F-1 CPT, F-1 OPT, F-1 STEM OPT, J-1, H-1B, TN, O-1, E-3, H-1B1, or L-1._ Additional Information: + Onsite role located in Indianapolis, Indiana (relocation required). + Work Schedule (Monday-Friday) with rotating weekends: + 11:30am u2013 8:30pm EST (Nov-Mar) + 12:30pm u2013 9:30 pm EDT (Mar-Nov) + Less than 5% travel Organization Overview Lilly IT builds and maintains capabilities using cutting edge technologies like most prominent tech companies. What differentiates Lilly IT is that we redefine whatu2019s possible through tech to advance our purpose u2013 creating medicines that make life better for people around the world, like data driven drug discovery and connected clinical trials. We hire the best technology professionals from a variety of backgrounds, so they can bring an assortment of knowledge, skills, and diverse thinking to deliver innovative solutions in every area of our business. The Global Information and Services Tech team is at the forefront of digitalization to enable and advance the entire company, with increased productivity and best-in-class Customer experiences. This team provides a robust and sustainable infrastructure of hardware, software and services that are critical to enable our global workforce and business to operate and transform. As leaders in technology and understanding business requirements and challenges, this team defines and leads the overall company technology strategy. Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form ( ) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response. Lilly is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status. Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia Network, Black Employees at Lilly, Chinese Culture Network, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinx at Lilly (OLA), PRIDE (LGBTQ+ Allies), Veterans Leadership Network (VLN), Womenu2019s Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups. Actual compensation will depend on a candidateu2019s education, experience, skills, and geographic location. The anticipated wage for this position is $64,500 - $184,800 Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance). In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent day care flexible spending accounts); life insurance and death benefits; certain time off and leave of absence benefits; and well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities).Lilly reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion and Lillyu2019s compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees. #WeAreLilly

Created: 2026-03-07