Oracle DBA

Job Title : Oracle DBA

Location : Montreal QC

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 and 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 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 with multiple 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 postgraduate in Technology with Computers or Information Technology (IT) stream.

Or

A degree in Computer Science IT Systems Engineering or a related qualification.

Preferred Qualifications / Skills

Knowledgeable about the Oracle; Sybase and SQL Database architecture

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

Oracle E-business suite R12.2.x

ADOP Patching Ad-utilities EBS CPU Patching

EBS Cloning Product Patching

EBS Workflow mailer configurations Having good knowledge of GL.

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

Key Skills

Administration & Operation,DBA,Design Management,Drafting,Administrative Services,Corrosion

Employment Type : Full Time

Experience : years

Vacancy : 1