Specialist - System Management
Job Description
Role description
Oracle Database Patch Management
Impact Job SummaryWhy this Role Matters
The Database Patch Engineer plans, coordinates, tests, and applies patches and updates to database engineered systems to support security, stability, and compliance with cyber security standards. This role demands strong technical expertise in database patching best practices and advanced troubleshooting capabilities.
Key Deliverables Duties and Responsibilities
Manage and execute the Exadata ExaCC patching lifecycle for compute nodes, DomU VMs, Grid Infrastructure, and databases.
Perform Exadata Infrastructure maintenance, including Quarterly Maintenance Release (QMR) and Security Monthly Maintenance (SMR).
Create infrastructure maintenance policies and define maintenance windows.
Support and perform preparatory work prior to infrastructure maintenance activities.
Plan, schedule, and execute OCI patching cycles across ExaCC infrastructure and DomU OS images, including compute OS instances.
Use the OCI console, CLI, and REST APIs to apply rollbacks and monitor patches.
Automate patching workflows using Terraform and Ansible.
Manage Oracle RAC (Real Application Clusters) patching, including GRID, RDBMS, and ASM.
Integrate and manage patching operations using LCM Fleet with OEM, including gold image creation and deployment for GI and RDBMS.
Demonstrate knowledge of Data Guard enabled patching procedures.
Plan, schedule, and execute quarterly PSU, CPU, third-party, and one-off patches with minimal downtime.
Conduct patch impact assessments, risk evaluations, and rollback strategies.
Maintain documentation of patching procedures, schedules, and standards.
Troubleshoot patch-related issues, database failures, and post-patch anomalies; provide RCA and remediation.
Understand investigation and remediation techniques for vulnerabilities that are not patch-related.
Skills and Qualification Functional and Technical Skills
Bachelors degree in computer science, Information Technology, or a related field, or equivalent experience.
7 years of handson experience with ExadataExaCC environments and Oracle Database patching.
Knowledge of Linux OS patching in ExadataOCI environments.
Hands-on experience with Oracle RAC patching, including GRID Infrastructure patching.
Solid understanding of Oracle Exadata ExaCC patching and administration.
Exadata Infrastructure maintenance experience, including Quarterly Maintenance Release (QMR) and Security Monthly Maintenance (SMR).
Experience creating infrastructure maintenance policies and defining maintenance windows.
Experience with backup and rollback strategies for ExaCC Infrastructure and DB patching.
Strong troubleshooting and problem-solving skills in complex Oracle environments.
Familiarity with ITIL processes for Change, Incident, and Problem Management for ITSM compliance.
Excellent documentation and communication skills.
Strong expertise in OCI patching automation, including OCI CLIAPI, OS image updates, DomU patching, Grid, and Database patching.
Experience working with multiple operating system environments, RHEL.
Strong communication and collaboration skills.
Preferred Qualifications
Oracle Certified Professional (OCP) or Oracle Exadata Management OCI Architect equivalent certification.
Experience with cloud-based database Oracle Cloud OCI.
Experience with LCM Fleet maintenance with OEM.
Patch management for OMS and OEM agents.
Experience in large-scale, high-availability, mission-critical environments.
Strong security awareness in patching and vulnerability compliance.
Familiarity with vulnerability scanning and reporting tools Qualys and Brinqa.
Relationships Collaboration
Ensure strong partnership with IT counterparts in India as well as US associates.
Be available for team connects if any.
Flexible to adjust work schedule, including evenings and weekends, as per organizational needs.
Collaborate with Business wherever necessary.
