Please send resume to: anant.k@ames-it-solutions.com
Please include the below Required Details .
Name:
Email Id:
Phone # :
Location :
Visa Status:
Rate:
Job Title Oracle DBA
Project Location Nyc, NY
Duration 6 months /Contract
Skills Required and Job Description:
Interview mode: Telephonic
MANDATORY SKILLS/EXPERIENCE
As an Oracle DBA; experience supporting a high-availability production database;
In Veritas Cluster Server for Oracle;
In database architecture and design
DESIRABLE SKILLS/EXPERIENCE :
Note: candidates who do not have the mandatory skills will not be considered
Experience in a Solaris environment;
Experience with Oracle Active Data Guard, RAC, Oracle Advanced Security Option is highly desirable;
SCOPE OF SERVICES
Install, configure, customize, create, implement, and support the Oracle databases, software and related tools/products for the DSNY SMART project;
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); Schedule, install and configure ORACLE upgrades; install, configure, customize ORACLE related system level software;
Work with Quest Management tools (Spotlight, LiveReORG, etc.); Configure/Support Active Dataguard and Golden Gate for Oracle Replication;
Install and configure, customize ORACLE server and clients;
Design, development, and creation of all database file systems layouts and Oracle databases, Develop UNIX shell scripts; Develop/maintain Oracle database operational procedures;
Monitor software notifications and updates;
Manage 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 Linux and Solaris Administration skills;
Work with the Database team and teams of HP engineers and administrators to design, build, upgrade and support the necessary Oracle infrastructure to meet the needs of DSNY and DoITT.