Job Seekers, Please send resumes to resumes@hireitpeople.com

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: