Oracle Functional Consul...

Tata Consultancy Services • Cincinnati, OH

310d • $100,000 - $130,000

About The Position

The Oracle Functional Consultant will be responsible for installing, configuring, and maintaining Oracle database instances across various versions including 11g, 12c, and 19c. The role involves routine database monitoring, performance tuning, and query optimization. The consultant will also configure and manage Oracle Real Application Clusters (RAC), Data Guard, and RMAN, as well as implement and manage backup, restore, and disaster recovery strategies using RMAN. Troubleshooting and resolving database issues, managing database security, performing migrations, upgrades, and patching with minimal downtime are key responsibilities. Additionally, the consultant will automate administrative tasks using Oracle scripts and monitor capacity planning, storage, and system resources. Collaboration with application developers to enhance database performance and scalability is also expected.

Requirements

• 5 - 19 years of experience in Oracle database management
• Bachelor's degree in Computer Science or related field

Nice To Haves

• Experience with Oracle Real Application Clusters (RAC)
• Familiarity with Data Guard and RMAN

Responsibilities

• Install, configure, and maintain Oracle database instances (All Versions/11g, 12c, 19c)
• Perform routine database monitoring, including performance tuning and query optimization
• Configure and manage Oracle Real Application Clusters (RAC), Data Guard, and RMAN
• Implement and manage backup, restore, and disaster recovery strategies using RMAN
• Troubleshoot and resolve database issues, including performance degradation, corruption, and outages
• Manage Oracle database security (user roles, privileges, encryption, auditing)
• Perform database migrations, upgrades, and patching with minimal downtime
• Automate administrative tasks using Oracle scripts (PL/SQL, Bash, Perl)
• Monitor capacity planning, storage, and system resources
• Collaborate with application developers to enhance database performance and scalability

Benefits

• Base Salary Range: $100,000 - $130,000 per annum

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree