Job Description

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

Graduate or post graduate in Technology with Computers or IT stream

OR

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

Preferred Qualifications/ Skills

Knowledgeable about the Oracle; Sybase and SQL Database architecture

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

Knowledge of EBS is must.

Worked on multiple Oracle Databases releases

Perform DB refreshes

Perform DB installs and refreshes

Knowledge of shell scripts

UNIX Solaris/Linux all current releases

Database user creation

Hands on with RMAN backup recovery

Adding of datafiles and space management

Well versed with Index and Reorganization of database objects

Change management and apply datafixes

Well versed with audit concepts

Analysis and implementation of CPU patching on production system independently

Understanding of database concept as a SME and ability to provide solutions

Good Understanding of OPatch concepts

Well versed with performance & tuning of databases

Exposure of database recovery scenarios

Experience of database upgrades

Good understanding of RMAN, ADDM and ASH reports

Sound experience of Database export/import functions

Experience of database character set conversion

Knowledge of Database monitoring tools

Must have very good trouble shooting and analytical skills

Excellent communication skills (verbal and written)

High energy, results driven person with strong interpersonal skills

Ability to work under minimal supervision

Capital Markets Domain knowledge is preferred

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

Sound knowledge of Oracle v12 Database (PDB & CDB)

Knowledge of Oracle Apps R12.2will be a plus

Job Tags

Similar Jobs