Job ID :
3748
Company :
State of Iowa
Location :
des moines, IA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

 

Complete Description:

The Database Administrator (DBA) is responsible for administrating Oracle databases. This position will be responsible to:

 

The background and experience most critical is in query writing and decision support.  The types of queries/stored procedures that this resource will be helping with have to do with getting data out of the database for ad-hoc reporting and decision support activities.

 

We DO NOT want someone who has spent their time as a system DBA (e.g. doing back-ups, performance monitoring, etc.).

 

This position will work on various projects related to ELIAS.

1.         Providing training to data warehouse and other staff on Oracle query language, building automated processes, building stored procedures, and creating data extracts using multiple tables from a highly normalized database.

2.         Develop complex data extracts from the ELIAS system.  We have several systems that will need ELIAS data and this person will work with various groups to define, design, and develop flattened data extracts that will, via automated processes, move from the ELIAS environment to the mainframe on a daily basis.

 

•          Experience with both traditional  application database design and dimensional database modeling for design support structures.

•          Experience developing automated data extract packages from source transactional systems to decision-support databases (normalized and dimensionalized)

•          Experience with Oracle decision support tools.

•          Experience working with team members and providing training on Oracle SQL query language.

•          Experience with SQL Server (2005, 2008, 2012) and key differences between SQL Server T-SQL and Oracle SQL query languages.

 

Skills:

Skill

Required / Desired

Amount

of Experience

 

Strong SQL Programming, preferably Oracle with the ability to write complex SQL queries

Required

7

Years

Oracle Performance Tuning Experience

Required

7

Years

Experience working in secure enterprise database environments

Required

7

Years

Experience with RMAN

Required

7

Years

Experience with Oracle Database in Windows

Required

7

Years

Experience with Oracle Application Server (10g) and Oracle Weblogic (11g) and SSO

Required

7

Years

Experience with SQL Server (2005, 2008, 2012) and key differences between SQL Server T-SQL and Oracle SQL query languages

Required

7

Years

Good understanding of the Software development lifecycle

Required

 

 

Ability to diagnose and resolve technical problems independently as well as in collaboration with a team

Required

 

 

Ability to take initiative and work without supervision

Required