Job Title

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 #J-18808-Ljbffr