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

Short Description: Senior Oracle DBA - ETL Specialist with Data Warehousing Experience of at least 5 years.
Complete Description: The Senior Oracle DBA - ETL Specialist will work on the Citywide Data Warehouse (CityDW) team developing databases that comprise the CityDW infrastructure environment. This infrastructure provides the foundation for business intelligence services and data transparency initiatives via reports creation, data integration, and application development. The resource will initially be part of an effort to develop a Citywide IT Spend Dashboard, as well as, making enhancements to the existing CityDW environment via performance tuning. Their role will expand, however, to include other CityDW development projects. In addition to these responsibilities, the Senior Oracle DBA - ETL Specialist will also possess experience in developing ETL processes using Informatica. These responsibilities will be secondary in nature, but are still crucial to have for any successful candidate. ETL development responsibilities will entail supporting existing load processes and assisting the ETL lead with developing and installing new data sources to the existing Informatica architecture. The candidate will work closely with the Data Architect, other DBAs, the ETL Lead, and data owners to bring new data sources online.
Behavior Characteristics: Excellent written, oral communications, interpersonal skills; the ability to work as a team player; must be well versed in communicating to both technical and non-technical persons.

Required / Desired Skills

JavaScript Requires Sorry this site will not function properly without the use of scripts. The scripts are safe and will not harm your computer in anyway. Adjust your settings to allow scripts for this site and reload the site.

Skill	Required / Desired	Amount of Experience	Expertise Rating
Experience as an Oracle DBA	Required	8 Years	3 - Expert
Experience working with Oracle RAC clustering.	Highly desired	2 Years	2 - Proficient
Experience working Data Guard failover and Grid Control	Required	2 Years	3 - Expert
Experience working with Oracle in a Microsoft Environment	Highly desired	2 Years	2 - Proficient
Experience working within a Data Warehousing environment	Required	3 Years	3 - Expert
Experience writing and debugging complex PL/SQL procedures and packages.	Required	3 Years	3 - Expert
Experience with Oracle backup and recovery.	Required	3 Years	3 - Expert
Experience installing Oracle bug fixes and patching.	Required	3 Years	3 - Expert
Experience with table space space, installing new databases.	Required	2 Years	2 - Proficient
Experience designing backup solutions using RMAN.	Required	2 Years	3 - Expert
Experience writing backup scripts using export/data pump	Required	2 Years	2 - Proficient
Experience using RMAN to do database cloning to create test environments.	Required	2 Years	2 - Proficient
Writing and reviewing technical specifications, test plans, requirements	Required	1 Years	2 - Proficient
Experience performance tuning of the database

Senior Oracle DBA- ETL Specialist

Client Services

Job Seekers

Visa Sponsorship