Principal Consultant Oracle DBA

Inviting applications for the role of [Principal Consultant], [Oracle EBS DBA]!

The purpose of this job is to provide all aspects of database administration provide technical guidance and support to junior (L1) database administrators (when applicable) and vulnerability remediation would be the primary task.

This position will also handle escalated incidents and perform root cause analysis of any problems that may arise out of IRs and/or proactive needs for business.

Responsibilities

The main responsibilities include: vulnerability remediation which would be the primary task

Should work on configuration, implementation, support of Oracle Database Production servers and technical guidance of junior team members

Understand business requirements and design solutions accordingly

Ensure quality standards in release implementation especially in DML/DCL/DDL & Data Fixes of any form

Resolve incidents, escalate to CACIB management and Oracle Vendor as necessary

Create SOPs

Perform root cause analysis for P1/P2/P3 and P4 incidents and/or proactively based on business needs

Work with the Genpact, CACIB or 3rd party teams for the implementation of changes

Follow the required policies and procedures for the incident, problem and change management

Ensure service performance expectations are met with service levels and quality

Raise/escalate any service related issues and risks to track lead and/or ITS lead

Technical guidance of junior team members (when applicable)

Qualifications we seek in you!

Minimum Qualifications

or post graduate in Technology with Computers or IT stream

or post graduate in any stream with course in Computers or IT stream

Preferred Qualifications/ Skills

about the Oracle; Sybase and SQL Database architecture

experience with Oracle 12c installation, configuration and disaster recovery procedures

of EBS is must.

on multiple Oracle Databases releases

DB refreshes

DB installs and refreshes

of shell scripts

– Solaris/Linux – all current releases

user creation

on with RMAN backup recovery

of datafiles and space management

versed with Index and Reorganization of database objects

management and apply datafixes

versed with audit concepts

and implementation of CPU patching on production system independently

of database concept as a SME and ability to provide solutions

Understanding of OPatch concepts

versed with performance & tuning of databases

of database recovery scenarios

of database upgrades

understanding of RMAN, ADDM and ASH reports

experience of Database export/import functions

of database character set conversion

of Database monitoring tools

have very good trouble shooting and analytical skills

communication skills (verbal and written)

energy, results driven person with strong interpersonal skills

to work under minimal supervision

Capital Markets Domain knowledge is preferred

of ITIL, integration across IPC (Incident, Problem & Change Management)

knowledge of Oracle v12 Database (PDB & CDB)

of Oracle Apps R12.2will be a plus

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. Get to know us at genpact.com and on LinkedIn, X, YouTube, and Facebook.

Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,' paying to apply, or purchasing equipment or training.