Oracle Database Administrator / Warehouse Architect
Hunter Green Associates - Albany, NY

This job posting is no longer available on Dice. Find similar jobs: Oracle Database Administrator jobs - Hunter Green Associates jobs

A major New York State Government agency is currently looking for a Oracle Database Administrator Warehouse Architect Five years experience working with oracle with a thorough understanding of the architecture and processes of the oracle server including Oracle 9i andor Oracle 10g or higher Three years experience as an oracle database administrator in a production database environment Three years experience in monitoring and tuning the general performance of the oracle database Three years experience writing SQLPLSQL stored procedures and triggers Three years experience in identifying business rules and database design One year experience in the transition of systems including the transfer of knowledge and mentoring Three years experience in the design and implementation of data warehousing and data mart activities in multiple large scale database environment Three years experience in designing strategies for migrating data from hierarchical to relational database structures and integrating these strategies on multiple platforms PREFERRED EXPERIENCE Excellent communication and interpersonal skills Superior knowledge of the English language and elevated ability to understand and be understood Four or more years demonstrated experience working In a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts Using advanced ExtractTransformLoad techniques including bulk select bulk insert arrays dynamic SQL and developing detailed incremental ETL processes Building maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting Three or more years demonstrated experience In an Oracle Data Warehouse as a developer performing development work Using PLSQL Developing and testing maps in Oracle Warehouse Builder (OWB) data versioning techniques Exceptional problem solving skills and superior ability to think and resolve technical issues under pressure
Dice - 19 months ago - save job - block