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.

The Tech@Lilly team is actively looking for an experienced Oracle Database Site Reliability Engineer who is passionate about advancing enterprise‑scale Oracle platforms, modernizing database operations, and delivering cloud‑ready Oracle services. If you thrive in solving complex reliability challenges, automating operational toil, strengthening governance, and enabling application teams—this role is for you. Your expertise will accelerate innovation, improve platform resilience, and support our 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 Oracle Database across on‑premise, hybrid, and cloud environments. In this role, you will ensure availability, resiliency, automation, observability, and lifecycle management of mission‑critical Oracle services. You will partner closely with Cloud Infrastructure, Security, SMEs, and Application Engineering teams to modernize, optimize, and secure enterprise Oracle database operations.

How You’ll Succeed:

Operational Support

• Provide day‑to‑day administration and operational support for Oracle Database (19c, and above).
• Perform performance tuning, patching (RU/RUR), upgrades, backup/recovery, and capacity management.
• Ensure Oracle platform reliability, availability, and compliance with enterprise security standards.
• Handle database incidents, requests, changes, and problem management through ITSM workflows.

Oracle Database Administration

• Install, configure, upgrade, and patch Oracle Database across single‑instance and RAC environments.
• Troubleshoot Oracle database issues including wait events, locking, contention, I/O bottlenecks, and memory pressure.
• Optimize SQL performance using execution plans, indexing strategies, partitioning, and statistics management.
• Support new database provisioning, schema management, maintenance jobs, and platform integrations

Hybrid & Cloud Oracle Modernization

• Support Oracle Database deployments on‑prem and in cloud platforms (OCI, Azure, AWS).
• Assist with Oracle database migrations and upgrades using tools such as Data Pump, and RMAN.
• Design and support HA/DR architectures including Oracle RAC, Data Guard, and Active Data Guard.
• Enable cross‑region and cross‑platform disaster recovery strategies.

Automation & AIOps

• Build automation using Python, Shell scripting, Ansible, Terraform, OCI Resource Manager, and other IaC tools.
• Implement Infrastructure‑as‑Code for Oracle database provisioning, configuration, and patching.
• Apply AIOps practices for proactive monitoring, anomaly detection, and predictive alerting.

Collaboration & Continuous Improvement

• Partner with Cloud Engineering, Operations, Security, and Application teams to deliver reliable Oracle database services.
• Drive modernization initiatives through automation, observability, and AI‑driven insights.
• Create and maintain runbooks, SOPs, and Oracle best‑practice documentation.

Capacity Planning & Scalability

• Forecast Oracle database growth and manage compute, storage, and licensing utilization.
• Ensure Oracle platforms scale efficiently to support high‑volume enterprise workloads.

Database Security & Compliance

• Enforce enterprise security standards including RBAC, least‑privilege access, encryption, and auditing.
• Implement Oracle security features such as TDE, Database Vault, auditing, and vulnerability remediation.
• Support compliance and audit activities.

Backup & Recovery Management

• Design and automate RMAN backup and recovery strategies.
• Validate RTO/RPO objectives through regular restore and DR testing.
• Manage backup storage and retention policies.

Cost Optimization

• Optimize Oracle workloads across on‑prem and cloud environments.
• Ensure cost‑efficient sizing, licensing alignment, and resource utilization.

SRE Principles & SLA Enforcement

• Define and maintain SLIs, SLOs, and SLAs for Oracle database services.
• Apply SRE best practices to reduce operational toil and increase platform reliability.

DR Drills & Business Continuity

• Partner with DR teams to execute Oracle DR drills, validate failover, and maintain readiness.

Documentation & Knowledge Sharing

• Maintain detailed documentation of Oracle environments, configurations, and troubleshooting procedures.
• Share knowledge to reduce operational silos and strengthen team capabilities.

What You Should Bring :

• Deep expertise in Oracle Database internals, including architecture, memory structures, background processes, and enterprise-scale Oracle database patterns.
• Strong experience with Oracle HA/DR technologies, such as Oracle RAC, Data Guard, Active Data Guard, and Exadata (ExaCC and Oracle Database on cloud platforms).
• Proven ability to diagnose and resolve Oracle performance issues, including wait events, execution plans, indexing strategies, partitioning, statistics management, and high‑volume workloads.
• Hands-on automation experience using Python, Shell scripting, Ansible, Terraform, or equivalent tools to reduce operational toil and standardize Oracle database operations.
• Experience supporting Oracle databases across on‑prem, hybrid, and cloud environments (e.g., Oracle Database on Azure/AWS, Exadata Cloud@Customer).
• Strong knowledge of Oracle security and compliance controls, including TDE, RBAC, auditing, vulnerability remediation, and least‑privilege access models.
• Familiarity with DevOps and DBOps practices for Oracle platforms, including Git-based workflows, schema versioning, and CI/CD for database changes.
• Experience with observability and monitoring tools for Oracle environments (e.g., OEM, Splunk, Grafana, custom telemetry).
• Working knowledge of ITSM processes and tools (ServiceNow or similar) for incident, problem, and change management.
• Exposure to containerized and Kubernetes-adjacent workloads supporting Oracle databases (a plus).
• Experience with Oracle backup, recovery, and data movement technologies, including RMAN, Data Pump, and CDC configuration and management.
• Strong background in capacity planning, scalability, and cost optimization for Oracle database platforms.
• Experience with SQL Server and Cloud Databases a plus

Basic Requirements:

·  High School Diploma/GED with 5+ years administering Oracle Database.

·  Experience supporting Oracle databases in both on‑prem and ODB@AWS cloud environments

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:30pm EDT (Mar–Nov)
• Less than 5% travel.

Organization Overview:

Lilly IT builds and maintains capabilities using cutting-edge technologies to advance our purpose—creating medicines that make life better for people around the world. We hire the best technology professionals from a variety of backgrounds who bring diverse skills, perspectives, and innovative thinking to every part of our business.

The Global Information and Services Tech team is at the forefront of digitalization to enable and advance the entire company, delivering increased productivity and best‑in‑class customer experiences. This team provides a robust and sustainable infrastructure and services landscape that powers Lilly’s global workforce and business operations.

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 (https://careers.lilly.com/us/en/workplace-accommodation) 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

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