• Perform advanced day-to-day Oracle DBA tasks, including installation, configuration, patching (e.g., Critical Patch Updates/CPUs), upgrades, and performance tuning (SQL optimization, index management, memory/CPU utilization) for EBS databases and concurrent processing/workflows.
• Lead proactive monitoring (24x7 via automated tools like Oracle Enterprise Manager) and alerting for system performance, availability, and interfaces; conduct root cause analysis (RCA) for incidents and implement corrective/preventive actions (CAPA).
• Manage high availability and disaster recovery (DR) readiness, including backups, restores, and participation in DR testing per clients plan (e.g., failover to secondary site within 24 hours for critical apps).
• Handle integrated L1/L2 support: Triage and resolve Oracle-related tickets (e.g., data integrity issues, journal errors) during business hours (1:00 AM CT Sun – 7:00 PM CT Fri); provide on-call support for P1 critical incidents.
• Support integrations with third-party systems (e.g., Concur, GHX, Salesforce) and middleware (SOA/D2R PIP), ensuring data synchronization and resolving gaps proactively.
• Enforce security and compliance: Implement role-based access controls (RBAC), user administration (onboarding/offboarding), encryption, and audit support aligned with ISO 27001, HIPAA, GDPR, and FDA guidelines for medical device data.
• Drive automations and AIOPS: Identify opportunities for AI-driven predictive maintenance like anomaly detection in query performance and process optimizations to support yearly cost reductions.
• Mentor Junior DBA, collaborate with Infrastructure Engineers and contribute to QBRs with insights on trends (ticket volumes, SLA compliance in MedTech).
• Maintain documentation for configurations, procedures, and change management; participate in Change Advisory Board (CAB) reviews.

Success Metrics

• Achieve 99.9% database uptime for critical Oracle systems, measured monthly via monitoring tools, aligning with SLAs and reducing supply chain disruptions.
• Reduce Mean Time to Resolve (MTTR) for Oracle-related incidents by 20% YoY through RCAs and AIOPS implementations, tracked in ITSM tools.
• Complete 100% of quarterly patching and DR tests on schedule, ensuring compliance with ISO 27001 and HIPAA (zero audit findings related to DB security).
• Contribute to 15% automation of routine tasks (scripting backups/alerts), supporting overall Y2/Y3 cost reductions.
• Mentor Junior DBA to independently handle 70% of L1/L2 tickets within 6 months, with CSAT scores >4.5/5 from client feedback in QBRs.