Job Description :
Duties:
* Provide production support, solutions and expertise for Oracle,
Exadata & Golden Gate.
* Ability to troubleshoot difficult production issues quickly.
* Work closely with various development teams across the firm to
ensure proper use of Oracle
* Train and mentor developers in Oracle development methodology and
best practices.
* Participate in the DBA team on call rotation.
* Tune complex Oracle SQL proactively & reactively as required. Be
able to rewrite SQL queries where necessary.
* Design, implement, and maintain capacity planning for database
systems.
* Perform Database Upgrades as required.
* Apply Database/CRS patches, PSU''''s, Bundle Patches, etc as
required.
* Help design, maintain, improve and implement monitoring tools.
* Handle DBA tickets, user requests, routine support and
maintenance.
* Ability to work off hours / weekends as required.
Skills/Qualifications:
* 10 years of experience as a DBA/DBE/DMA.
* 10 years of database development support, and Oracle SQL tuning.
* 3 years of production experience with Oracle Exadata is required.
* Understands Exadata specific concepts and has proven track record
of implementing Exadata specific features.
* 3 years of experience with Oracle Golden Gate is required.
* Expertise with Oracle 12c, Oracle RAC, ASM, Flashback, and
Dataguard are required.
* Expertise implementing Oracle Data Guard and the different
features around Data Guard. (Active Data Guard, Snapshot Standby''''s, etc)
* Expertise with RMAN, cloning, backup & recovery.
* Well versed in PL/SQL coding and stored procedures development,
shell scripting, and SQL.
* Experience in architecting multi-terabyte systems, including a
proven track record of physical optimization, query optimization and
capacity planning.
* Linux expertise including but not limited to volume management,
kernel parameter analysis, shell scripting, understanding of networking
concepts.
* Proven track record of SQL and database tuning on VLDBs.
* Outstanding problem solving and analytical skills.
* Good communication skills.
* Good interpersonal skills; able to build consensus and work
closely with fellow DBA''''s.