Logo of Huzzle

Oracle DBA with RAC / Golden Gate-Hyderabad, Chennai & Bangalore

image

Cognizant

Oct 10

Applications are closed

  • Job
    Full-time
    Mid & Senior Level
  • Data
    IT & Cybersecurity
  • Chennai

Requirements

  • Experience:4 to 8 Years
  • Location: Hyderabad, Chennai & Bangalore
  • Notice period:45 days
  • Experience with Oracle enterprise manager 13c
  • Experience in RAC and Multi-tenant (CDB-PDB) environments and performance tuning as well.
  • Perform and develop the PL/SQL code for automation process.
  • Manage /support Oracle Golden gate
  • Working knowledge of Exadata
  • MySQL database administration is required
  • Working knowledge of percona/Proxy clustering with MySQL
  • Familiars with Cloud platform (preferred Azure)
  • PostgreSQL and Cassandra will be added advantage
  • Operating System: HP Unix, Red Hat Linux, AIX
  • Oracle Database solutions (ASM and Recovery Manager).
  • Oracle tools (13cOEM, SQL Loader, Quest TOAD, AWR and ADDM).
  • Oracle PL/SQL stored procedures and Unix Shell Scripting.
  • Managing Oracle databases on HP-UX and Linux environments.
  • Production Support of Large (VLDB) and Complex Databases.
  • Upgrade/Migration/conversion from non CDB o PDB of the databases from Oracle 12c/19c
  • MySQL Working Knowledge of MySQL is required
  • Cassandra will be added advantage
  • Good to have: Oracle Certified DBA, Oracle 19c, Experience on Exadata Machines

Responsibilities

  • Responsible for designing, implementing and maintaining all functions of database systems according to business needs;
  • Managing Oracle 11g and 12c, 19c databases on HP UNIX and LINUX environments.
  • Performing all forms of database maintenance and administrative activities; installing, configuring, patching and upgrading Oracle server software, applications and related products.
  • Design and implement database backups using Oracle Recovery Manager.
  • Automating routine maintenance tasks as appropriate utilizing OEM, Shell scripting and PL/SQL batch processing;
  • Support the production environment on 11g,12c, 19c databases on HP UNIX and Linux.
  • Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.
  • Manage, troubleshoot and resolve oracle database and applications issues.
  • Perform database and application tuning through the use of AWR and ADDM
  • Assist the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance.
  • Perform and develop the PL/SQL code for automation process.
  • Manage /support Oracle Golden gate
  • Manager and troubleshoot and resolve Oracle database and Performance its issues.
  • MySQL database administration is required
  • Manager and troubleshoot and resolve MySQL Issues
  • Support the production environment on 12c, 19c databases on HP UNIX and Linux.
  • Experience in RAC environments, patching and performance tuning as well.
  • Automating routine maintenance tasks as appropriate utilizing OEM, SQL Loader, Shell scripting and PL/SQL batch processing;
  • Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.
  • Manage, troubleshoot and resolve oracle database and applications issues.
  • Cassandra will be added advantage

FAQs

What is the required experience for the Oracle DBA position?

The required experience for the Oracle DBA position is 4 to 8 years.

What are the preferred locations for this job?

The preferred locations for this job are Hyderabad, Chennai, and Bangalore.

What is the notice period required for this position?

The notice period required for this position is 45 days.

Which Oracle database versions should the candidate be familiar with?

Candidates should be familiar with Oracle database versions 11g, 12c, and 19c.

Is experience with Oracle RAC a requirement for this job?

Yes, experience in RAC environments is a requirement.

What kind of database management systems will the candidate be responsible for?

The candidate will be responsible for managing Oracle databases as well as MySQL databases.

Will the candidate be involved in automating maintenance tasks?

Yes, the candidate is expected to automate routine maintenance tasks using OEM, Shell scripting, and PL/SQL batch processing.

Is knowledge of Oracle GoldenGate required for the position?

Yes, managing and supporting Oracle GoldenGate is required.

What kind of performance tuning experience should the candidate have?

The candidate should have experience in database and application tuning using AWR and ADDM.

Is Cloud platform experience necessary?

Familiarity with Cloud platforms, preferably Azure, is preferred.

Are there any additional database technologies that would be beneficial?

Yes, knowledge of PostgreSQL and Cassandra would be an added advantage.

Does the job require working on Exadata machines?

Yes, experience with Exadata machines is considered a good to have.

What tools and utilities should the candidate be proficient in?

The candidate should be proficient with Oracle tools such as 13c OEM, SQL Loader, Quest TOAD, AWR, and ADDM.

What is considered a good to have certification for this role?

An Oracle Certified DBA certification, particularly for Oracle 19c, is considered a good to have.

Consulting
Industry
10,001+
Employees

Mission & Purpose

Cognizant is a multinational technology company that provides a wide range of IT services and solutions to organisations worldwide. Their primary focus is on helping businesses transform and thrive in the digital age. Cognizant's mission and purpose are centred around delivering innovative and cutting-edge technology solutions that drive client success. They offer services such as digital strategy, consulting, technology implementation, and IT outsourcing, enabling companies to adapt to evolving market dynamics, enhance operational efficiency, and deliver exceptional customer experiences. Cognizant's ultimate goal is to empower their clients with the tools, insights, and capabilities needed to navigate complex technological landscapes and achieve their business objectives in an increasingly digital world.