Job Title or Location
RECENT SEARCHES

CONSULTANT DBA SQL ORACLE (H/F)

Genpact
Quebec, QC
Contract
Experienced
Posted 25 days ago This job may expire soon!

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.