Oracle DBA

Role

Description:

· 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, management, documentation and tuning Postgre

SQL 11 and above database with Red Hat Linux.

· Support Postgre

SQL databases through the development and production lifecycles with related operational teams.

· Provide Postgre

SQL database solutions, reviews and advises within company policies;
Troubleshoot and resolve Postgre

SQL 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 and 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 Statspack, SQL tracing, AWR, ASH report and 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.