Site Reliability Engineer – Oracle DB

Role Summary

As an Oracle Database Site Reliability Engineer at Lilly, you will enable reliable, secure, and high-performing Oracle Database platforms by driving automation, modernizing hybrid and cloud data services, and enforcing SRE principles to ensure enterprise-grade availability, observability, compliance, and operational excellence. The Tech@Lilly team seeks 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 reliability challenges, automating operational toil, strengthening governance, and enabling application teams—this role is for you.

• 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.
• 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.
• Support Oracle Database deployments on‑prem and in cloud platforms (OCI, Azure, AWS).
• Assist with Oracle database migrations and upgrades using 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.
• 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.
• 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.
• Forecast Oracle database growth and manage compute, storage, and licensing utilization.
• Ensure Oracle platforms scale efficiently to support high‑volume enterprise workloads.
• 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.
• Design and automate RMAN backup and recovery strategies.
• Validate RTO/RPO objectives through regular restore and DR testing.
• Manage backup storage and retention policies.
• Optimize Oracle workloads across on‑prem and cloud environments.
• Ensure cost‑efficient sizing, licensing alignment, and resource utilization.
• Define and maintain SLIs, SLOs, and SLAs for Oracle database services.
• Apply SRE best practices to reduce operational toil and increase platform reliability.
• Partner with DR teams to execute Oracle DR drills, validate failover, and maintain readiness.
• Maintain detailed documentation of Oracle environments, configurations, and troubleshooting procedures.
• Share knowledge to reduce operational silos and strengthen team capabilities.

• Deep expertise in Oracle Database internals, including architecture, memory structures, background processes, and enterprise-scale 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,…