DIRECT CLIENT Requirement for Oracle DBA in NY

6:37 AM |

Hello,

Hope you are doing well
Please go through the following requirement and please let me know on recruiter@tcagroupmail.com if you have any available candidates
DIRECT CLIENT

Role : Oracle DBA
Location : Brooklyn NY
Duration : 1920 hours

Tasks & Duties

Infrastructure Engineer–Unix/Linux Oracle DBA

· • Install, configure, customize, create, implement, and support the Oracle databases, software and related tools/products for the HRA database systems;

· Implement Grid Infrastructure release 12c on a Unix/Linux; Implement ASM cluster Filesystem and maintain it;

· Add new disks to an ASM disk group; Patching grid infrastructure software;

· Implement instance caging; Setup/administer Oracle database security environment;

· carry out DB Performance Tuning;

· Troubleshoot DB problems, working with ORACLE support on problems and questions;

· Schedule RMAN (backup/recovery);

· Configure/Support Active Dataguard and Golden Gate for Oracle Replication;

· Install and configure, customize ORACLE server and clients; Schedule, install and configure ORACLE upgrades;

· install, configure, customize ORACLE related system level software;

· design, development, and create all database file systems layouts and Oracle databases;

· monitor software notifications and updates; managing distributed databases and configuring client/server and Web-based environments;

· provide technical assistance and troubleshooting support to developers; review database design specifications and application coding routines to ensure adherence to best practice methods for database usage;

· ensure database performance is maintained at optimal levels and is able to support defined business requirements;

· create/maintain referential integrity relationships/constraints;

· provide problem diagnosis and resolution;

· schedule database backups;

· diagnose and resolve backup failures;

· configure, analyze application SQL to do SQL Tuning for performance improvement opportunities;

· utilize Solaris Administration skills;

· develop UNIX shell scripts;

· work with the Database team and teams of SUN engineers

MANDATORY SKILLS/EXPERIENCE

Infrastructure Engineer–Unix/Linux Oracle DBA (Spec II)

· 4 years as an Oracle DBA;

· experience implementing/managing Oracle Databases in a RAC environment;

· experience Implementing Grid Infrastructure release 11.2 on a Unix/Linux environment; experience implementing ASM cluster Filesystem with knowledge of how to maintain it;

· knowledge of Best Practices for adding a new disk to an ASM disk group; experience patching grid infrastructure software;

· experience implementing instance caging ;

· familiar with Oracle database resource manager;

· familiar with huge pages on Linux;

· experience supporting a high-availability production database;

· experience with Oracle Active Data Guard

DESIRABLE SKILLS/EXPERIENCE : -

Infrastructure Engineer–Unix/Linux Oracle DBA

· experience in a Solaris environment a plus;

· experience in Veritas Cluster Server for Oracle a plus;

· experience in database architecture and design highly desirable;

· Oracle Advanced Security Option is highly desirable;