Oracle Database Administrator DBA

Letitbex AI Tech Solutions LLC

United States

19 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Batch Processing Cloud Engineering Computer Networks Databases Continuous Integration Data Migration Database Security Oracle Data Guard DevOps Disaster Recovery Middleware Oracle Exadata

+24 more

JD Edwards EnterpriseOne Oracle Databases Oracle (Applications) Oracle Rac Performance Tuning Ansible Recovery Manager (RMAN) Shell Script Backup and Restore Scripting Data Storage Management Google Cloud Enterprise Software Applications DB2UDB Oracle Enterprise Manager System Availability Database Performance Database Migration Performance Monitor Patch Management Database Replication Oracle Cloud Infrastructure Servicenow Microservices

Job description

We are seeking an experienced Oracle Database Administrator DBA with deep expertise in Oracle GoldenGate to support missioncritical enterprise applications and largescale database environments The role will be responsible for Oracle database administration GoldenGate replication architecture performance optimization disaster recovery planning database migrations and ensuring high availability of businesscritical systems, The ideal candidate should have strong experience managing Oracle databases in complex enterprise environments including Oracle RAC Data Guard Exadata and GoldenGate implementations supporting realtime data replication and migration initiatives, * Oracle Database Administration

Administer monitor and maintain Oracle Database environments 12c 19c and above
Install configure patch upgrade and maintain Oracle databases across Production DR UAT and Development environments
Manage Oracle RAC ASM Data Guard and Exadata platforms
Perform capacity planning storage management and database health assessments
Implement and manage RMAN backup restore and recovery strategies
Ensure database security compliance and governance standards are maintained
Oracle GoldenGate Administration
Design implement configure and support Oracle GoldenGate replication solutions
Manage Extract Pump and Replicat processes across heterogeneous environments
Monitor replication performance and resolve latency synchronization and data consistency issues
Configure bidirectional and unidirectional replication architectures
Support zerodowntime database migration and cutover activities using GoldenGate
Perform GoldenGate patching upgrades performance tuning and troubleshooting
Lead replication testing validation and disaster recovery exercises
High Availability Disaster Recovery
Design and support High Availability HA and Disaster Recovery DR solutions
Plan and execute Data Guard switchovers failovers and role transitions
Ensure replication integrity and business continuity across primary and DR environments
Conduct periodic DR drills and validate recovery processes
Performance Incident Management
Troubleshoot complex database and replication issues
Perform Root Cause Analysis RCA and implement permanent corrective actions
Analyze AWR ASH OEM and GoldenGate reports to optimize database performance
Participate in critical incident Major Incident Review MIR and Post Incident Review PIR calls
Provide proactive monitoring and preventive maintenance recommendations
Migration Transformation Initiatives
Support database migration projects involving Oracle DB2 Exadata cloud and hybrid environments
Participate in application modernization and cloud migration programs
Develop migration runbooks cutover plans and rollback strategies
Ensure successful execution of database and replication migration activities with minimal downtime
Stakeholder Management
Act as the primary onsite DBA liaison for customer teams architects infrastructure teams and application owners
Coordinate with offshore database and middleware teams
Provide technical guidance mentoring and operational oversight
Participate in governance architecture and operational review meetings

Required Technical Skills

Oracle Database
Oracle Database Administration 12c19c21c
Oracle RAC
Oracle Data Guard
Oracle ASM
Oracle Enterprise Manager OEM
RMAN Backup Recovery
Performance Tuning
Database Security Auditing
Database Upgrades and Patch Management
Oracle GoldenGate
Oracle GoldenGate Administration
GoldenGate Microservices Architecture
Replication Design Implementation
ActiveActive and ActivePassive Replication
Data Migration and Synchronization
Replication Monitoring Troubleshooting
Heterogeneous Database Replication
Infrastructure Cloud
Oracle Exadata
LinuxUnix Administration
Shell Scripting
Oracle Cloud Infrastructure OCI
Google Cloud Platform Google Cloud Platform knowledge preferred
Networking concepts related to database replication
Tools Automation
OEM Monitoring
Ansible
Automation Scripting
ITSM Tools ServiceNow preferred
DevOps and CICD awareness

Requirements

Experience supporting large healthcare pharmaceutical supply chain or ERP environments
Experience with JD Edwards JDE environments
Experience with OracletoOracle and DB2toOracle migration projects
Experience supporting Exadata and cloudhosted Oracle workloads
Knowledge of ControlM and enterprise batch processing environments

Soft Skills