Oracle Database Administrator

3 weeks ago


Toronto, Canada Hays Full time

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

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

  • support of Oracle 12c and 19c and PostgreSQL, and AWS RDS database instances including many of the sub-components.
  • performance tuning expertise, including specifics related to partitioning, indexing , storage optimization, and memory management.

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).

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.
  • analysis, monitoring, troubleshooting and resolution of issues.
  • project development following documented standards, policies, and procedures (Change Management Process).
  • regular reviews of database vulnerability scan and remediation of open vulnerabilities.
  • 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.
  • document, and implement consistent standards and procedures.
  • ideas for best practice improvements, process improvement, and innovative solutions.


What You’ll Need to Succeed

  • Years of Technical experience working with Oracle 12c and 19c hosted on Unix and Linux platforms.
  • years of Technical experience working with PostgreSQL version 9+ and above hosted on Linux or AWS cloud-based platforms.
  • PLSQL skills that including a strong understanding of system tables, stored procedures, functions, triggers, and SQL tuning.

in database upgrade, cloning, platform migration, installations, and patching.

  • Experience with Oracle database monitoring and tuning using native Oracle or other third-party tools.

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.
  • of Oracle Enterprise Manager or GRID Control, RMAN backup and recovery strategies, Oracle replication, mirroring, log shipping, maintenance plans and DR recovery strategies.

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.



  • Toronto, Canada Procom Full time

    Oracle Database Administrator On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Administrator. Oracle Database Administrator - Job DescriptionEnhanced performance due to Database Offload in ExadataReduced size of database without compromising performance by leveraging compression technologyProvided trustworthy data from...


  • Toronto, Canada Raise Full time

    Database Administrator Location: Toronto, ON - Hybrid - (Currently remote but may be required to go in for department meetings) Contract Length: 6 Months. We at Raise are hiring a Database Administrator for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand. We’re...


  • Toronto, Canada Raise Full time

    Database Administrator Location:Toronto, ON - Hybrid - (Currently remote but may be required to go in for department meetings) Contract Length:6 Months.We at Raise are hiring a Database Administrator for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand.We’re hiring right...


  • Toronto, Canada Hays Full time

    Client: Insurance sector Role: Oracle DBAJob Type: 6 monthsRate: Open *depending on experienceLocation: One York, Waterloo King, Atria locations and even 2 two Quebec locations Your new CompanyOur 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...


  • Toronto, Canada GalaxE.Solutions Full time

    What You Will Do Oracle DBA to be part of DBA team supporting a large OSFAA-FCCM application project. The Database Administrator (DBA) is required to perform Oracle database changes related to a large OCAC environment – "personalizing" it to meet the application's needs. Net new DB server build re


  • Toronto, Canada iPartner Staffing Full time

    Role: Database Administrator - Senior Location: Toronto, ON Contract Description **Senior Database Administrator**: 1. Perform day-to-day operations, maintenance, and support, including: 1.1 Database Error/Alert Monitoring & Troubleshooting 1.2 Database Logs Review and Troubleshooting 1.3 Database Backup/Recovery jobs/tasks review 1.4 Performance...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Toronto, ON, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day. • We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on. • The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Toronto, ON, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024Number of Positions: 1Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Toronto, Canada IBI Group Full time

    Company Description We are a global team of dedicated and experienced architects, engineers, planners, designers and technology professionals who share a common desire - to help our clients create liveable, sustainable, and advanced urban environments. Arcadis has officially purchased IBI Group and with this transaction now complete, IBI will now be known...


  • Toronto, Canada iPartner Staffing Full time

    3 days per week in the office Expert Oracle and Microsoft SQL Database administration experience Demonstrated experience with DACPAC Experience with Azure build automation using Ansible, Terraform, Packer and VSTS Description The Services and Deliverables to be provided by the Vendor will include the following: - Participate in the review of...


  • Toronto, Canada YouthCare Full time

    Most Important - At least 10 years of experience - Experience in database replication / Real-Time data delivery with either MSSQL or Oracle - products (5+ years)RequirementsGeneral Skills - Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL - Create, test and implement safeguards to maintain data integrity and protect...

  • Database Administrator

    12 hours ago


    Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ HybridCandidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...


  • Old Toronto, Canada S I Systems Full time

    Senior Oracle Database Administrator to provide on-going support for a database upgrade and migration project for one of our major banking clients - BNSJP00033962Senior Oracle Database Administrator to provide on-going support for a database upgrade and migration project for one of our major banking clients - BNSJP00033962Hiring Manager: Senior Manager, GTS...


  • Toronto, ON, Canada S I Systems Full time

    Senior Oracle Database Administrator to provide on-going support for a database upgrade and migration project for one of our major banking clients - BNSJP00033962 Senior Oracle Database Administrator to provide on-going support for a database upgrade and migration project for one of our major banking clients - BNSJP00033962 Hiring Manager: Senior Manager,...