Oracle Database Administrator Atlanta, GA USC,GC,EAD-GC,

 

Hy

I hope you are doing well.

 

I am hiring a consultant for one of my client's requirements. I've written the Job Description for the same below. If you find yourself comfortable with the requirement please reply back with your updated resume

 

 Position: Oracle Database Administrator 

 

Location:   Atlanta, GA

Duration: 6+ Months

 

Visa: USC,GC,EAD-GC,

The role involves delivering operational support for Oracle 19c databases within an environment encompassing Oracle RAC, Oracle Restart, ASM, Multitenancy, Data Guard, Goldengate, and Oracle Enterprise Manager.

This position will play a critical role in ensuring our Oracle database systems' availability, reliability, and performance. This Oracle DBA will work closely with cross-functional teams to troubleshoot and resolve database-related issues, implement changes, and optimize database performance to support the organization's operational needs.


Responsibilities:
 

• Administration and Maintenance

• Install, upgrade, and patch Oracle Grid Infrastructure, Oracle database enterprise and standard editions, and related components
• Perform database backups, restores, and recoveries using RMAN and Commvault Data Protection for Oracle.
• Manage database space using ASM, ACFS, and filesystems.
• Migrate databases using Data Pump, RMAN duplicate, transportable tablespaces, and PDB clone.
  Implement development changes to Oracle schema objects.
• Participate in on-call rotation to provide 24/7 operational support.
• Ensure compliance with database policies and procedures.
• Perform routine maintenance tasks, including reorgs and index rebuilds.

 

• Security and Vulnerability Management:

•  Manage database security and access controls.
• Regularly access security vulnerability reports and apply patches or mitigations in accordance with vendor recommendations.
• Apply Oracle quarterly release updates
   

• Resiliency

• Participate in DR testing and execution.

• Configure and maintain standby database with Data Guard.
• Configure and maintain logical standby using Golden Gate.
• Utilize flashback technology to return a database and/or database objects to previous state or run queries that return past data.
• Ensure database availability, reliability, and resiliency in accordance with MAA guidelines.
   

• Capacity Planning:
  •     Monitor database resource usage.
  •     Perform capacity planning at the instance, operating system, and storage levels.

 

• Performance Tuning:

• Monitor database performance using OEM and SQL scripts.
• Proactively identify and address database performance bottlenecks and inefficiencies by implementing SQL, database, and OS tuning techniques.
• Implement best practices to enhance database efficiency.
   

• Troubleshooting and Issue Resolution:

• Troubleshoot service problems.
• Root cause analysis.
• Provide solutions and definitive corrective measures.
   

• Automation:
  •     Maintain and enhance existing UNIX shell scripts and SQL scripts.
  •     Continuously explore opportunities for process improvement and automation.
   
• Documentation:

• Create and maintain database documentation, including database standards, best practices, procedures, and implementation plans.
   

 

 

Required Skills and Experience:

• 7 plus years plus years with hands-on experience as an Oracle DBA.
• Strong experience with Oracle RAC Databases on ASM in an enterprise environment.
• Experience configuring and managing standby databases using Data Guard and Active Data Guard.
• Proficient in Oracle management tools, such as OEM, Data Guard Broker, RMAN, Data Pump, AWR, and SQL Tuning Advisor.
• Practical experience working with Multitenant databases.
• Strong UNIX scripting.
• Competence with AIX and/or Linux operating systems.
• Strong work ethic and self -motivator.
   

Preferred Skills and Experience:

• A strong understanding of Maximum Availability Architecture (MAA) with expertise in Gold and Platinum architectures.
• Practical experience in configuring and overseeing replication using GoldenGate.
• Experience with Commvault Data Protection.
• Experience with RMAN catalog in an HA environment.
• Experience supporting Oracle databases in AWS or OCI.

 

 

Kind Regards,

Gaurav Pandey| Absolute IT | Recruitment Manager

116 • Village Blvd • Suite 200 • Princeton • New Jersey • 08540

AbsoluteIT Email- gaurav@absoluting.com