Oracle Database Administrator

2 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 Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Senior** **Database Administrator **for one of our clients. **Position: Senior Database Administrator** **Location: Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must Have** - More than 10 yrs. Oracle DBA experience - Approved experience with Oracle 12c & 19c...


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


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


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


  • 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, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Position: Database Administrator - Senior** **Location: Toronto, Ontario (Hybrid)** **Must haves**: - Support data migration activities from external data sources into source Oracle/Siebel database - Maintain and...


  • Toronto, Canada Dawn InfoTek Inc. Full time

    **Dawn InfoTek Inc.** is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of **Oracle...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Position: Database Administrator - Senior** **Location: 40 St. Clair Ave. W, Toronto, Ontario (Hybrid)** **Duration: Long Term** **Employment: Contract** **Must haves**: - Support data migration activities from...


  • 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 ydc pro Inc Full time

    Hi All, We are Hiring for Sr. Oracle Database Administrator Position for Toronto Location Work type: Contract and Hybrid Must haves: - More than 10 yrs. Oracle DBA experience - Approved experience with Oracle 12c & 19c using multi-tenant architecture - Oracle 19c RAC - Grid infrastructure/ASM - RMAN backup and Restore - Data Encryption using ASO/TDE -...


  • Toronto, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Position: Database Administrator - Senior** **Location: Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must haves**: - 10+ years of demonstrated experience supporting/managing Oracle DB, including...


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


  • Toronto, Canada CCI Full time

    **Experience and Skill Set Requirements** **Deliverables**: - Creation of technical specifications for Azure, SQL and Oracle database systems development - Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards - Undertake special assignments/sub-projects as assigned - Conduct,...