"Senior Oracle DBA - Golden Gate, Exadata, OEM, Cloud *PostgresSQL" at AstraNorth

Toronto, ON, Canada -

Full Time

Start Date

Immediate

Expiry Date

14 Nov, 25

Salary

0.0

Posted On

15 Aug, 25

Experience

8 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Good communication skills

Industry

Information Technology/IT

Description

Responsibilities

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 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
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 DataGuard 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 Statspack, 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 tablespaces 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
Competencies: Digital : EAS : Oracle Cloud Infrastructure, Oracle DBA
Experience (Years): 8-10
Job Types: Full-time, Fixed term contract
Work Location: Hybrid remote in Toronto, O