Database Reliability Engineer – Oracle at Lilly

Hyderabad, Andhra Pradesh, India -

Full Time

Start Date

Immediate

Expiry Date

23 Jan, 26

Salary

0.0

Posted On

25 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle Database Administration, Automation, Performance Tuning, Disaster Recovery, Cloud Platforms, Scripting, Database Migration, Security Management, Monitoring, Collaboration, AI-Driven Solutions, High Availability, Backup and Recovery, Continuous Improvement, Problem Solving, Documentation

Industry

Pharmaceutical Manufacturing

Description

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. Lilly’s Purpose: 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. Come help us unlock the power of Oracle Database Reliability Operations through AI & Automation! The Cloud and Connectivity organization is actively looking for an Oracle Database Site Reliability Engineer to join our team. For solving complex challenges and driving large-scale impact here is the opportunity to shape the future of global Oracle database operations across on-prem, ExaCC, and multi-cloud environments (AWS, Azure, GCP) through automation and AI-driven solutions. Job Summary: Oracle Database Reliability Engineer will be supporting mission-critical Oracle database environments across on-prem, Exadata Cloud@Customer, and multicloud platforms (AWS, Azure, GCP). Also responsible for driving automation of day-to-day DBA tasks, enabling multi-cloud database operations and migrations, and ensuring cost-effective and secure environments. The role provides opportunities to work with Oracle PaaS/IaaS services, qualify and adopt new database technologies, and implement CI/CD pipelines to automate deployments. As part of this role, you will Collaborate with SMEs, Cloud Infrastructure, and Self-Service Enabling teams to bring enhancements and automation to database operations. Roles & Responsibilities: Database Reliability Operations: Provide day-to-day administration, monitoring, and support for Oracle databases (19c/21c and above). Improve service qualification and database lifecycle management through automation at an enterprise scale. Ensure compliance with Lilly security standards by performing vulnerability scanning, timely patching, and upgrades. Work on AI-driven insights to improve observability, reliability, and proactive incident prevention. Manage database performance tuning, backup/recovery (RMAN, Data Guard), patching, and upgrades. Ensure database availability, resiliency, and security compliance 24/7/365. Automation & Innovation Develop scripts/tools (Python, Shell, Ansible, Terraform, or similar) to automate repetitive DBA tasks (patching, health checks, provisioning, monitoring). Implement AIOps practices for proactive issue detection, anomaly detection, and predictive alerting. Multicloud & Database Modernization Support and administer Oracle workloads across on-premises, Exadata Cloud at Customer (ExaCC), and public cloud platforms (OCI, AWS RDS/Aurora, Azure, GCP Cloud). Participate in database migrations to cloud (lift-and-shift, re-platforming, or modernization to PDBs/multitenant). Assist with database replication, DR solutions, and cross-cloud failover planning. Collaboration & Continuous Improvement Work closely with operations, application, and cloud engineering teams to deliver reliable database services. Drive innovation through automation, monitoring, and AI-driven solutions to reduce manual efforts. Document best practices, runbooks, and operational procedures. Required Skills & Experience: Database Installation & Configuration Install, configure, and maintain Oracle Database (12c, 19c, 21c). Configure Oracle Grid Infrastructure and ASM (Automatic Storage Management). Manage multitenant architecture (CDB/PDB creation, cloning, unplug/plug, consolidation). User & Security Management Create and manage database users, roles, and privileges. Implement fine-grained access control, VPD, and Database Vault. Knowledge of auditing, TDE (Transparent Data Encryption), and database security best practices. Backup & Recovery Proficient with RMAN for backups, restores, and recovery. Implement incremental, full, and image backups. Perform point-in-time recovery, tablespace recovery, and cross-platform backups. Knowledge of Flashback technologies. Performance Tuning & Optimization Diagnose performance issues using AWR, ASH, ADDM, and SQL Tuning Advisor. SQL query tuning and optimizer statistics management. Memory management (SGA, PGA tuning). Troubleshooting, locking, latching, and wait events. High Availability (HA) Oracle RAC (Real Application Clusters) administration. Clusterware installation, configuration, and troubleshooting. Oracle ASM disk groups management for RAC and standalone environments. Disaster Recovery (DR) Oracle Data Guard (Physical, Logical, Snapshot standby) configuration and management. Active Data Guard for read-only workload offloading. Switchover, failover, and role transition testing. DR strategy planning and execution in hybrid/multicloud environments. Patching & Upgrades Apply PSU/RU patches, DB upgrades, and patchset installation. Experience with Database Migration Assistant (DBUA) and manual upgrade processes. Exposure to Exadata patching cycles. Storage & Space Management Tablespace and datafile management. Partitioning strategies for large tables. Monitoring growth trends and capacity planning. Monitoring & Troubleshooting Proficiency with Oracle Enterprise Manager (OEM/24ai) for monitoring and alerting. Troubleshoot ORA- errors, deadlocks, performance bottlenecks, and job failures. Develop health check scripts for proactive monitoring. Automation Skills Proficiency in scripting languages (Shell, Python, Perl). Experience with automation/orchestration tools (Ansible, Terraform, Jenkins). Exposure to OEM (Oracle Enterprise Manager), 24ai, or other monitoring/automation frameworks. Cloud & Multicloud Knowledge Hands-on with Oracle Cloud (OCI DBaaS, ExaCC, Autonomous DB). Working knowledge of AWS RDS/Aurora, Azure SQL/Managed Instances, GCP Cloud. Experience in database migration strategies (GoldenGate, Data Pump, DMS, RMAN cross-platform). Soft Skills: Strong problem-solving, troubleshooting, and analytical mindset with a focus on reliability and continuous improvement. Excellent communication and collaboration abilities to work effectively with cross-functional and global teams. Adaptability to dynamic environments and ability to manage multiple priorities in fast-paced operations. Commitment to accountability, ownership, and driving results through innovation and automation. Willingness to Work in 24×7 Reliability Operations Your Qualification: Bachelor’s degree in computer science, Information Technology, MCA, or a related technical field. 3-9 years of experience as an Oracle Platform Engineer in an enterprise environment with relevant experience in Oracle database administration plus supporting mission-critical production environments. Additional Skills/Requirements: Strong hands-on experience in Oracle Database Administration (Core DBA, RAC, Data Guard, RMAN, Performance Tuning). Knowledge of Oracle Multitenant architecture (CDB/PDB) and Autonomous Database. Experience with automation frameworks such as Ansible, Terraform for database provisioning and patching. Familiarity with CI/CD tools (Jenkins, GitHub Actions, or equivalent) for database deployment automation. Exposure to Kubernetes / Docker for database containerization. Proficiency with scripting languages (Shell, Python, PL/SQL) to automate DBA tasks. Hands-on experience with ServiceNow or equivalent ticketing tools for incident/change management. The ability to maintain detailed documentation aligned with Security, Compliance, and CSQA standards. Desirable Skills: Exposure to AI/ML-driven monitoring or AIOps tools for predictive insights and automated remediation. Experience with cross-platform database migrations (Linux ↔ Windows, On-Prem ↔ Cloud, Multicloud). Familiarity with multicloud environments (Oracle Cloud, AWS, Azure, GCP) for database deployment and operations. Knowledge of project management methodologies (Agile/Scrum) to collaborate effectively in global teams. Experience with cloud-native databases and hybrid deployment models is an added advantage. 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 does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status. #WeAreLilly At Lilly we strive to ensure our employees are part of a team that cares about them and our shared purpose of making life better for those around the world. How do we do this? We continue to look for ways to include, innovate, accelerate and deliver while maintaining integrity, excellence and respect for people. We hope that you seek to join us on our journey as we create medicine and deliver improved outcomes for patients across the globe! #WeAreLilly

Responsibilities

The Oracle Database Reliability Engineer will support mission-critical Oracle database environments and drive automation of day-to-day DBA tasks. This role involves collaborating with various teams to enhance database operations and ensure compliance with security standards.