Job Title: Jr. Oracle Database Administrator (DBA)
Location: Atlanta, GA - 2 days per week (Hybrid)
Contract to Hire
Job Description :
Key Responsibilities:
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.
Qualifications & Requirements:
• 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.