Back to Jobs list

Post Date 11/4/2013 
Title Lead Oracle DBA 
Pay Rate Market 
Length 6-9 Months 
Location Bensonville, IL 
Description 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) and guides others in the resolution of the most complex incidents and problems. Develops processes, procedures and defines metrics to review for capacity management. Leads additional research into technology that provides improved resiliency and recovery for databases.

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
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
Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities and capacity planning
Manage the on-site backup and recovery process and / or support of the off-site backup and recovery teams
Plan for and execute any required database upgrades and migration (patches, etc.)
Communicate database requirements to the development team for the design and implementation of database-related code
Perform model walk-through to educate the technical and business communities, as needed
Help define back-up & recovery strategy
Help define archiving strategy
Help define disaster recovery strategy
Develop and implement standards for data object naming and database design
Participate in project estimating activities
Produce technical documentation related to the databases under management according to technology standards
Provide off hours support as required
Strong understanding of ETL principals
Business Partnership
Establish strong working relationships with Information / Data, Application and Technical Architects, other team members; all functions within technology area; and across the business as appropriate
Drive discussion around database direction and new technology applications to the environment
People Management
Drive Operation Excellence and Continuous Improvement at enterprise infrastructure.
Coach / mentor other team members as appropriate
Demonstrate ability to work in team environment and help resolve issues
Communicate status / risks to manager regarding delivering solution on time


Qualifications
College degree in related technical / business areas or equivalent work experience
10 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
CRM experience is plus (e.g. Amdocs) 
Recruiter Amy Kilcoyne 
Apply Here
Apply Now

Back to Jobs list