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. We're looking for people who are determined to make life better for people around the world.
Enable reliable, secure, high-performing SQL Server and cloud database environments by driving automation, modernizing multi-cloud data platforms, and ensuring enterprise-grade observability, compliance, and operational excellence.
The Tech@Lilly team is actively looking for an experienced SQL Server Site Reliability Engineer who is passionate about advancing enterprise-scale data platforms, modernizing database operations, and enabling Cloud-ready SQL servers. If you thrive in solving complex reliability challenges, automating repetitive tasks, strengthening governance, and empowering application teams-this 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 You'll Be Doing:You will serve as a core engineering and operational expert for SQL Server across on-premise and multi-cloud environments. In this role, you will ensure availability, resiliency, automation, observability, and lifecycle management of mission-critical 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 You'll Succeed:Operational Support
- Provide day-to-day 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.
Multi-Cloud Database Modernization
- Support SQL Server migrations to Azure, AWS, and other cloud platforms.
- Assist in designing DR, replication strategies, and cross-cloud failover.
Automation & AIOps
- Build automation using PowerShell, Python, Ansible, Terraform, Bicep/ARM, and Shell scripting.
- Implement Infrastructure-as-Code (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 AI-driven insights.
- Create runbooks, SOPs, and best practice guides.
Capacity Planning & Scalability
- Forecast database growth and manage resource utilization.
- Ensure systems scale efficiently to support high-volume enterprise workloads.
Database Security & Compliance
- Enforce enterprise security standards, RBAC, encryption, auditing, and least-privilege 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 on-prem, Azure SQL DB, Azure Managed Instance, and IaaS.
- Ensure cost-efficient 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 enterprise-scale 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 hybrid-cloud 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 database-adjacent 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 on-prem and Azure-based deployments.
- High Availability & DR experience: Always On AGs, FCI, Log Shipping, Replication, Geo-replication.
- Experience in performance-tuning 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 - 8:30pm EST (Nov-Mar)
- 12:30pm - 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 what's possible through tech to advance our purpose - 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), Women's Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups.
Actual compensation will depend on a candidate's 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 Lilly's compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees.
#WeAreLilly
Never miss an opportunity! Create an alert based on the job you applied for.
