Oracle Database Administrator (jr to intermediate)

Job ID
1030
Location
Montreal downtown
Role and Responsibilities
IT Unlock’s mission is to improve our client's current IT condition. We are looking for a talented Oracle Database Administrator. This is a permanent position. The work is done remotely until new instruction from the government and the candidate must live in Montreal. Beautiful technologies and nice challenge are waiting for you.

Department Summary:

Global Technical Services (GTS) is the infrastructure organization supporting all entities in the Americas for all infrastructure technology requirements including:

  • Workstations including computers, telephones and email
  • Data centers hosting
  • Networks/telecommunications
  • End user computing services
  • Market Data administration infrastructure
  • Data services

GTS various fields of expertize enable the organization to:

  • Work as part of the team responsible for the Group's Digital Transition,
  • Ensure the 24/7 quality and continuity of our infrastructures and their resilience to incidents,
  • Advise/accompany business lines and functional divisions through their own transformation,
  • Provide diversified/innovative service offer that is customized to the requirements of our internal/external partners

Our goal is to deliver quality/cost-effective IT infrastructure services aligned to our customer needs while effectively managing operational risks and providing value added/innovative solutions.

 

Day-to-Day Responsibilities:

 

  • Installation, configuration, management and maintenance of databases
  • Responsible for database health, resiliency, performance tuning and optimization, operational control procedures, support and inventory.
  • Work closely with developers and application production support to provide technical help
  • Participate in On-call, handle alerts and escalations during business hours and off-hours, including weekends and Holidays on rotational basis.
  • Setup and maintain Database backup and recovery procedures
  • Provide technical documentation.
  • Support and implement database changes, ensure quality of the changes.
  • Perform capacity planning for the databases
  • Implement and help other team members with group/team strategy
  • Participate in Feature teams to build tools and develop APIs to automate daily tasks
  • Adopt the DevOps way of working to provide support for the automation
  • Participate in Agile ceremonies to promote teamwork
 
 
 

Profile

 

Technical Skills:         

 

Oracle:

 

  • Oracle 11g, 12C, 19C
  • RAC, ASM, DataGuard, RMAN, Oracle Enterprise Manager
  • Linux Operating system
  • Windows server operating systems basics
  • EMC-SAN technologies.  

 

Development :

 

  • Advanced Python Knowledge
  • Unix shell scripting
  • Knowledge in Agile Methodology

 

Desired / Plus:

 

  • Oracle EXADATA management
  • Golden Gate
  • Knowledge in other RDBMS (PostgreSQL, MSSQL, Sybase, Cassandra)
  • UC4/Autosys scheduling tool

 

Competencies:

 

  • Experience working in a large, 24x7, Investment Bank.
  • Must be organized, detail-oriented, self-motivated, disciplined, professional, and a team player to multiple tasks at one time, in a fast paced environment handling multiple demands
  • Excellent written and verbal communications skills, ability to present and explain technical information
  • Database management experience, including installation, maintenance and migration/upgrades and database refreshes.
  • Database architectural knowledge

 

Experience Needed:

 

  • 4+ years hands-on experience On Oracle (12c, 11g, 10g) databases on Sun Unix or Linux
  • PL/SQL development experience, using Oracle Packages, Stored Procedure, and Functions
  • Experience handling large databases
  • Experience with the Oracle Optimizer plans and hints.
  • Experience with optimizing physical data models (table definition, indexes, range and hash partitioning)
  • Experience with building automation tools or APIs using Python
  • Experience with shell scripting and Linux scripts development

 

Educational Requirements:

 

  • Bachelor's Degree in Computer Science or equivalent work experience

 

Desired / Plus:

 

  • Certification in Database adminstration

 

Languages: English, French



Skillset
Required:
- 1-5 years as an Oracle DBA (12C, 19C) on Sun Unix or Linux
- Application Cluster Oracle
- PL/SQL using Oracle Packages, Stored Procedure, and Functions
- Experience handling large databases
- Optimizing physical data models (table definition, indexes, range and hash partitioning)
- Oracle Optimizer
- RAC, ASM, DataGuard, RMAN, Oracle Enterprise Manager
- Linux Operating system
- Windows server
- EMC-SAN  
- Building automation tools or APIs using Python
- Unix shell scripting
- Agile
- Ready to do support including weekend
- English
- Live in Montreal
- Permanent

Assets:
- Oracle 10g, 11g
- Oracle EXADATA management
- Golden Gate
- PostgreSQL, MSSQL, Sybase, Cassandra
- UC4/Autosys scheduling tool
- Working in a large, 24x7, Investment Bank.
- Certification in Database administration
Number of positions
1
Work Experience
At least 1 year
Salary
null
Apply on Job