Description
Oracle Data Specialist/Applications DBA
Our large government client in Raleigh, NC is seeking a short term (6 month) Oracle Data Specialist and Applications DBA to work on the implementation of a new State Budget and Performance Management system. The new system will replace the current Mainframe and Oracle systems as well as numerous OSBM and state agency spreadsheet tools, agency-developed and commercial software database tools, and manual processes. This position will work with the IBIS technical implementation team, working primarily on data modelling, database development, ETL processes, and data loading in Oracle. Tasks include migrating data from Legacy systems into a new data model and providing database assistance for forms and reports development
Required Skills:
- Bachelor's degree with (3) three years of professional experience in Oracle database development; or equivalent combination of training and experience.
- Proven accomplishments using data loading and ETL tools.
- Understanding of relational data modelling and experience writing complex SQL queries.
- Working knowledge of web-based Java technology, including basic programming skills and building/deploying web applications.
- Oracle SQL Loader and PL/SQL
- Applications DBA
- Creating and managing schemas, tables, constraints, indexes, and materialized views.
- Managing database access for developers and end users.
- UNIX (Solaris)
Preferred Experience:
- Experience with the design and development of data warehouses and cubes.
- Extensive knowledge of Java application development, including Spring, Hibernate, GWT.