Sr Oracle, Infrastructure DBA

1113103
View Saved Jobs
Save

  • Job type

    Contract

  • Location

    Toronto

  • Profession

    Data & Advanced Analytics

  • Industry

    Banking & Financial Services

  • Pay

    Negotiable
Share Job

Oracle DBA - 6 months contract - Waterloo - Toronto - Quebec


Client: Insurance sector
Role: Oracle DBA
Job Type: 6 months
Rate: Open *depending on experience
Location: One York, Waterloo King, Atria locations and even 2 two Quebec locations

Your new Company
Our client is a leading insurance, investment, and asset management companies in Canada. They cater to millions of customers across the world by providing a broad range of protection and wealth products and services to individuals, businesses, and institutions.

Your Role & Responsibilities

The candidate will be a member of the Oracle practice within Data Management Services (DMS). The primary role for this position will be as an Oracle Database Administrator supporting Canadian and US requirements with current versions of Oracle Database. A minimum of 5+ years of experience in Information Technology is required as well as experience in relational and non-relational database technologies such as PostgreSQL, Redshift, Microsoft SQL Server, and MongoDB to be able to support various teams within DMS. The DMS group has members in Canada, the US and India supporting a wide range of distributed and mainframe applications. Note: This role may require Canadian Enhanced Reliability Security clearance [a minimum of 5 years of consecutive residency in Canada].

Responsibilities
  • Administrative support of Oracle 12c and 19c and PostgreSQL, and AWS RDS database instances including many of the sub-components.
  • Advanced performance tuning expertise, including specifics related to partitioning, indexing , storage optimization, and memory management.
  • Maintain up-to-date documentation and procedures for all supported database related platforms.
    Infrastructure support of Oracle including server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research, and development (as needed by Infrastructure manager).
  • Work with other Database Administrators or Developers in defining requirements.
    Working on ways to automate and improve infrastructure as code release processes.
    Support Oracle Advanced Security features such as TDE.
  • Performance analysis, monitoring, troubleshooting and resolution of issues.
  • Support project development following documented standards, policies, and procedures (Change Management Process).
  • Manage regular reviews of database vulnerability scan and remediation of open vulnerabilities.
  • Working closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services.
  • Define, document, and implement consistent standards and procedures.
  • Contribute ideas for best practice improvements, process improvement, and innovative solutions.
What You’ll Need to Succeed

  • 10+ Years of Technical experience working with Oracle 12c and 19c hosted on Unix and Linux platforms.
  • 5+ years of Technical experience working with PostgreSQL version 9+ and above hosted on Linux or AWS cloud-based platforms.
  • Strong PLSQL skills that including a strong understanding of system tables, stored procedures, functions, triggers, and SQL tuning.
  • Participation in database upgrade, cloning, platform migration, installations, and patching.
    Experience with Oracle database monitoring and tuning using native Oracle or other third-party tools.
  • Involvement with Embarcadero DBArtisan and native Oracle as well as other third-party tools.
    Knowledge with Oracle Key Vault, Veritas clustering software and AIX and Linux operating systems.
  • Knowledge of Oracle Enterprise Manager or GRID Control, RMAN backup and recovery strategies, Oracle replication, mirroring, log shipping, maintenance plans and DR recovery strategies.
  • Excellent interpersonal and communication skills and the ability to handle several tasks efficiently.
    Willingness to partake in ideas, contribute solutions and take initiative.
Interested?

Joining an organization that the industry calls one of the best places to work. · Being part of our journey in developing the next greatest digital experience. · Flexible work schedule, within core business working hours, to meet the needs of you and your family. You can send an email along with your resume at sakina.suterwala@hays.com


#LI-DNI

Apply for this job

Apply through LinkedIn

JOBS YOU MIGHT LIKE