Database Administrator - Oracle DBA, Oracle DBMS, PostgreSQL, Python, IBM IIDR
Toronto ON – Hybrid
Long Term Contract
• Minimum 8 years of DBA working experience building| deploying and administering distributed Oracle DBMS| Oracle Exadata appliance| Oracle OEM| and Oracle Cloud.
• Undergrad Degree or Diploma in Computer Science. 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 review 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
• Provides sound advice and/or acts 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
• Works independently and/or autonomously on a diverse range of tasks / operational support of solutions and is relied upon to coach/ educate others
• Expert level knowledge of database auditing| audit logging| creating benchmark for audit points.
• Sound knowledge of Finance industries 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
• Sound experience with the building| configuring| monitoring| and implementation of Oracle Data Guard technology along with Oracle Goldengate Replication tool
• Sound knowledge about RMAN backup/recovery experience on very large databases.
• Sound knowledge is required with Oracle performance analysis using several tools Stats pack| SQL tracing| AWR| ASH report etc
• Solid hands-on experience with experience in troubleshooting and resolving urgent/critical incidents on production systems.
• Experience is required with Python| Perl| and UNIX shell scripting.
• Solid experience with IBM IIDR data Replication is required
• Experience with database utilities and backup tools (Tivoli Storage Manager)
• Experience with performing backup and recovery for both application table spaces and catalogue tablespaces
• Able to provide expert knowledge in the development of an enhance database service.
• Influence product direction| foresee issues and gaps| identify solutions| and work comfortably with leading edge products that are untested/ unproven in the market
Job Type: Fixed term contract
Pay: $50.00-$55.00 per hour
