What are the responsibilities and job description for the Oracle DBA position at Bahwan CyberTek?
Role description
Work Location - Birmingham, Alabama
1. Backup & Recovery
Design, implement, and manage backup and recovery strategies using RMAN.
Perform database restores and point-in-time recovery when required.
Regularly test backup integrity and disaster recovery procedures.
Maintain and monitor backup jobs to ensure successful completion.
2. High Availability – RAC
Install, configure, and administer Oracle Real Application Clusters environments.
Monitor RAC cluster performance and troubleshoot node-related issues.
Perform patching, upgrades, and cluster maintenance activities.
Ensure high availability and load balancing across RAC nodes.
3. Standby / Data Guard
Configure and maintain Oracle Data Guard environments (Physical & Logical Standby).
Monitor Data Guard replication and resolve synchronization issues.
Perform role transitions (Switchover/Failover).
Conduct regular DR drills and ensure readiness.
4. Database Performance & SQL Tuning
Monitor database performance and proactively resolve bottlenecks.
Perform SQL tuning, execution plan analysis, and query optimization.
Implement indexing strategies and performance enhancements.
Use AWR, ASH, ADDM reports for performance diagnostics.
Optimize memory structures (SGA, PGA) and storage configurations.
5. General DBA Activities
Install, upgrade, and patch Oracle databases.
Manage users, roles, and database security.
Implement database monitoring and automation scripts.
Support development teams in database design and code optimization.
Maintain documentation of configurations and procedures.