Logo
agreeya

Database Administrator II

agreeya, Atlanta, Georgia, United States, 30383

Save Job

Job Title: Oracle Database Administrator - Junior level Location: Atlanta GA - Hybrid Onsite Job type: Contract

Job Description: We are seeking a skilled Oracle Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the design, implementation, administration, and maintenance of Oracle databases. This role requires expertise in database performance tuning, high availability, security, and disaster recovery. The Oracle DBA will work closely with developers, system administrators, and business stakeholders to ensure database systems are optimized, secure, and aligned with business needs.

Key Responsibilities:

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. Qualifications & Requirements:

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. Preferred Skills:

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

About AgreeYa:

AgreeYa is a global systems integrator delivering a competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,800+ professionals across offices. AgreeYa works with 550+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public Sector, Pharma & Biotech, Retail, Client, and others. Please visit us at www.agreeya.com for more information.

Equal Opportunity:

AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website at www.agreeya.com/career-culture to learn about our Career & Culture.