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