Job Description

Role: Oracle EBS 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, and 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
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

Job Tags

Similar Jobs