Tata Consultancy Services-posted 8 months ago
$100,000 - $130,000/Yr
Full-time • Mid Level
Cincinnati, OH
Professional, Scientific, and Technical Services

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.

  • 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
  • 5 - 19 years of experience in Oracle database management
  • Bachelor's degree in Computer Science or related field
  • Experience with Oracle Real Application Clusters (RAC)
  • Familiarity with Data Guard and RMAN
  • Base Salary Range: $100,000 - $130,000 per annum
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service