
Mid-Level Oracle DBA
- Atlanta, GA
- $45.00-50.00 per hour
- Contract
- Full-time
- Note: Candidate needs to local to Atlanta area to be considered
- Contract to hire/perm for right candidate
- Responsible for maintaining, upgrading and administering Oracle EBS instances on Oracle Cloud Infrastructure using automation tools like Ansible, Jenkins etc
- Optimize database performance, ensuring high availability and reliability.
- Perform backup, recovery, and disaster recovery planning using RMAN and other tools.
- Troubleshoot database-related issues, working closely with application and infrastructure teams.
- Performance Tuning & Optimization:
- Identify and resolve performance bottlenecks using tools like AWR, ADDM, and SQL Tuning Advisor.
- Optimize SQL queries and database indexing strategies for improved performance
- Implement partitioning, compression, and other techniques to enhance efficiency.
- Security & Compliance:
- Implement database security policies, user access controls, and encryption techniques
- Conduct regular security audits and vulnerability assessments.
- High Availability & Disaster Recovery:
- Configure and manage Oracle RAC, Data Guard, and Goldengate for HA and replication.
- Develop and test disaster recovery plans, ensuring minimal downtime in case of failures.
- Automation & Scripting:
- Develop scripts using Shell, PL/SQL, or Python for database automation and monitoring.
- Collaboration & Documentation:
- Work with developers to optimize database schemas and queries.
- Document database architecture, configurations, and standard operating procedures.
- Key Skills; Oracle Apps DBA, Oracle Core DBA, Ansible, Tuning & Oracle Cloud
- Note: Manager is looking for Oracle DBA with 2-5 years of max experience.
- Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
- 2-5 years of experience as an Oracle DBA in enterprise environments
- Strong knowledge of SQL, PL/SQL, and performance tuning techniques.
- Experience with Oracle Enterprise Manager (OEM) for monitoring and administration.
- Hands-on experience with Unix/Linux environments and shell scripting.
- Strong troubleshooting and problem-solving skills.
- Certifications such as Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) are a plus.
- Experience in Ansible or Terraform for database automation.
- Exposure to NoSQL or other RDBMS (PostgreSQL, MySQL) is an advantage.
- Exposure to Python is a plus