Back to Jobs list

Post Date 11/4/2013 
Title Oracle DBA 
Pay Rate Market 
Length 6-9 Months 
Location Chicago, IL 
Description We are currently working with our direct end client in Bensenville, IL who is looking for a contract to hire senior DBA. If you are interested in this position, please forward your resume to:

Administer and maintain the security and integrity of the databases. Design database maintenance and upgrade processes and provide incident/problem management support. Resolve database performance issues, database capacity issues, replication, and other distributed data issues. Serves as an expert (SME) in the resolution of the most complex incidents and problems. Develops processes, procedures and defines metrics to review for capacity management.

Responsibilities

Role Specific Responsibilities
Work with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model for the development and / or production environments for Data Warehouse Systems and OLTP Systems.
Help develop and validate the Data Warehouse and OLTP implementation plan
Support the data loads into the databases, expert level experience using Oracle Goldengate Change Data Capture tool.
Create database objects and maintain their physical organization / relationships
Provide input, as needed, to the development of business cases when enterprise-wide database solutions are proposed
Ensure that the application, and any enhancements, interact efficiently with the database



Qualifications
College degree in related technical / business areas or equivalent work experience
8 years or more of relevant work experience
Experience / advanced knowledge of logical and physical database modeling concepts and techniques
Knowledge of database performance factors, monitoring tools and tuning procedures
Knowledge of productivity factors and ability to understand impact of issues on overall database performance
Knowledge of fault detection and resolution processes
Knowledge of maintenance tools and procedures
Backups/recovery; Experience in backup/recovery of 10+ TB systems, Use of FRA
Database Loading; Bulk loading techniques (sql*ldr, datapump, etc), Change Data Capture processes Golden Gate
Oracle RAC experience with DW systems
Oracle RAC experience with OLPT systems
Oracle Data Guard experience
Database Security; PCI, CPNI, SOX controls, TDE / Oracle encryption. Oracle Advanced Security
Data Warehouse; Materialized views (building, designing, query rewrite), OLAP, Data Mining , Use of hybrid 3NF and dimensional data models in same database


Thank you,
Barb Connelly
Manager, Consulting Services
York Solutions
 
Recruiter Barb Connelly 
Apply Here
Apply Now

Back to Jobs list