Database Admin - Oracle, Postgressql

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A technology solutions provider in Toronto is seeking a seasoned DBA to manage Oracle and PostgreSQL databases. The ideal candidate will have over 8 years of experience and be proficient in database security, auditing, and maintenance. This full-time role requires collaboration with operational teams to ensure optimal database performance and compliance with industry standards.

Qualifications

• Minimum 8 years of DBA working experience with Oracle DBMS.
• Solid hands-on experience with Oracle Exadata Appliance management.
• Expert level knowledge of database security and user access management.

Responsibilities

• Build and manage PostgreSQL databases with Redhat Linux.
• Provide solutions and troubleshoot PostgreSQL database items.
• Develop technical strategies to maintain service levels.

Skills

PostgreSQL

Oracle DBMS

Database Security

Database Encryption

Python

Perl

UNIX Shell Scripting

Statspack

Oracle GoldenGate

RMAN Backup/Recovery

Tools

Oracle Exadata

Oracle OEM

IBM IIDR

Tivoli Storage Manager

Job description

Overview

Onsite, Toronto

Responsibilities

• Minimum 8 years of DBA working experience building, deploying and administering distributed Oracle DBMS, Oracle Exadata appliance, Oracle OEM, and Oracle Cloud.
• Responsible for building, implementation, configuration, managing, documenting, and tuning PostgreSQL 11 and above database with Redhat Linux.
• Support PostgreSQL databases through the development and production lifecycles with related operational teams.
• Provide PostgreSQL database solutions reviews and advises within company policies; troubleshoot and resolve PostgreSQL database related items.
• Sound knowledge of Oracle Cloud at customer on Exadata platform with hands on experience with design, development, and implementation in a large enterprise.
• Solid hands-on experience with Oracle Exadata Appliance management and support.
• Hands on experience with database security and database encryption.
• Provide sound advice and/or act in a lead capacity on operational system / applications planning, performance, availability, integration, operations support and release / deployment management.
• Develop and recommend technical strategies and solutions to maintain and/or expand service levels.
• Work independently and/or autonomously on a diverse range of tasks / operational support of solutions and be relied upon to coach/educate others.
• Expert level knowledge of database auditing, audit logging, and creating benchmarks for audit points.
• Knowledge of finance industry compliance requirements such as SOX, PCI DSS, FISMA, Gramm-Leach-Bliley Act, and FATCA.
• Expert level knowledge of user access management and database privileges.
• Hands on experience with deploying database security patches and remediation of database vulnerabilities.
• Hands on experience with installation, configuration and maintenance for Oracle 12c/19c RAC and 12c/19c ASM.
• Experience with Oracle DataGuard technology and Oracle GoldenGate replication.
• Knowledge of RMAN backup/recovery for very large databases.
• Experience with Oracle performance analysis using tools such as Statspack, SQL tracing, AWR, and ASH.
• Experience troubleshooting and resolving urgent/critical incidents on production systems.
• Experience with Python, Perl, and UNIX shell scripting.
• Experience with IBM IIDR data replication.
• Experience with database utilities and backup tools (Tivoli Storage Manager).
• Experience with performing backup and recovery for both application tablespaces and catalogue tablespaces.
• Ability to provide expert knowledge in the development of an enhanced database service.
• Influence product direction, foresee issues and gaps, identify solutions, and work with leading-edge products that may be untested/unproven in the market.

Seniority level

• Associate

Employment type

• Full-time

Job function

• Information Technology

Industries

• IT Services and IT Consulting