This is for a US Citizen Only who would be eligible for a Q Clearance at sensitive location in Schnectady, NY.
Oracle DBA- Q Clearance-Schenectady, NY
The candidate will be the DBA for a highly visible and critical application.
The candidate should be well versed with oracle database administration fundamentals, application performance tuning, SQL performance tuning, thorough knowledge of Entity-Relationship diagrams, create/manage/tune materialized views, create/tune stored procedures, create/manage/tune LOBS.
The candidate should be capable to write PL/SQL packages, triggers, procedures, functions
The candidate should be able to understand application SQL logic and provide input for any performance improvement.
The candidate should be able to work with middleware team in new deployments to the application
The candidate should be able to give recommendations on the new deployments for the application, test new deployments.
The candidate should have experience working with VLDB (minimum of 10 TB) hosting large tables.
Install, configure and support OEM
Database creation, upgrades and migrations
Setup RMAN configuration and monitor periodic RMAN backups
Implementation, troubleshooting and documentation of application, database and security patches
Designing, modeling, developing and supporting of Oracle Database Management Systems (RDBMS).
Develop an overall data architecture that supports the information needs of the business in a flexible but secure environment.
Analyze, recommend and perform database and application tuning and cloning
Demonstrates past experience interfacing with a wide range of corporate personnel from junior-level engineers up to director-level executives in support of project initiatives.
Excellent written and verbal communication
24 x 7 database administration support for Oracle 11g and Application
Perform database verifications during server maintenances
Provide ORACLE database engineering, design and administration services for several mission-critical application/systems.
Plan for database growth and changes (capacity planning)
Other duties and functions as required
Working knowledge of Oracle 11g oracle database administration
11g RAC, ASM on Linux systems
Oracle datapump, export/import
Oracle database migration
Oracle database backup and recovery
Writing shell scripts
Managing databases using Oracle Enterprise Manager
Good communication skills
Rate: all inc, Job Type: Contract, Start Date: ASAP, Duration: 1 Yr++, Number Of Openings: 1, Location: Schenectady, NY
Respond to this requirement.
Please respond with Resume, Rate and Phone numbers of the Consultant. Make sure the Consultant's skills match the requirement.