Job Summary
We are seeking a skilled and experienced (10+ years) Database Administrator (DBA) to join our team with strong expertise in MS Azure & Oracle EBS. The candidate should have thorough knowledge of installation, configuration, management & optimization in enterprise scope of Oracle E-Business Suite (EBS) across multiple environments. Expected to play a pivotal part in ensuring high availability, security, scalability and performance of critical applications with relational & non-relational data assets. Must have a clear and concise understanding of database architecture while being able to design and implement robust Azure cloud solutions for troubleshooting complex issues.
Roles and Responsibilities
Database Management & Administration:
Install, configure & upgrade database models in Enterprise scope.
Install, configure, patch & upgrade various aspects of Oracle EBS with AD (Application DBA) scripts & tools (adop, adconfig, adstart, adcmctl etc) Concurrent Processing, workflows, Sysadmin capability, Responsibility & Menu Management, Application Object Layer integration.
Design & manage robust clustering (RAC), replication, mirroring & failover solutions with Dataguard strategies to safeguard data replication and integrity.
Planning & Testing Disaster Recovery, Switchover & Failovers.
Provide 24/7 production support, shift rostering, on-call rotation, SLA adherence and RCA guidance.
Performance Monitoring via Azure Monitor, Log Analytics workspace, Application Insights and Tuning to resolve bottlenecks.
Designing & maintaining Zero-Downtime paradigm.
Azure Cloud Expertise:
Deploy and administer Azure resources like Azure SQL, backup vaults & security groups.
Enforcing Azure Site Recovery, Always-On availability groups, Geo-replication to maintain database high availability.
Automating database management and provisioning via Azure automation, ARM templates, Azure CLI & PowerShell modules.
Oracle EBS Administration:
HA(High Availabilities) & DR (Disaster Recovery):
Verification and validation of Recovery Point Objectives (RPO) & Recovery Time Objectives (RTO).
Database development & Lifecycle Management:
Managing database migrations, schema versioning, cloning & recycling.
Create and maintain support SOPs, database configurations, policies.
Support Agile and CI/CD pipelines by integrating database changes into automated deployments.
Troubleshooting:
Utilizing recommendation models and reinforcement learnings to proactively detect and resolve database issues.
Ensuring compliance with data governance and data privacy regulations and industry standards while staying updated on emerging technologies & industry trends.