Job Description
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 range of protection and wealth products and services to individuals, businesses, and institutions. Your Role & Responsibilitiescandidate 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). Responsibilitiessupport 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 SucceedYears 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.