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        SkillRequired / DesiredAmount of ExperienceExpertise RatingExperience as an Oracle DBARequired8  Years3 - ExpertExperience working with Oracle RAC clustering.Highly desired2  Years2 - ProficientExperience working Data Guard failover and Grid ControlRequired2  Years3 - ExpertExperience working with Oracle in a Microsoft EnvironmentHighly desired2  Years2 - ProficientExperience working within a Data Warehousing environmentRequired3  Years3 - ExpertExperience writing and debugging complex PL/SQL procedures and packages.Required3  Years3 - ExpertExperience with Oracle backup and recovery.Required3  Years3 - ExpertExperience installing Oracle bug fixes and patching.Required3  Years3 - ExpertExperience with table space space, installing new databases.Required2  Years2 - ProficientExperience designing backup solutions using RMAN.Required2  Years3 - ExpertExperience writing backup scripts using export/data pumpRequired2  Years2 - ProficientExperience using RMAN to do database cloning to create test environments.Required2  Years2 - ProficientWriting and reviewing technical specifications, test plans, requirementsRequired1  Years2 - ProficientExperience performance tuning of the databaseRequired1  Years2 - ProficientExperience in full life cycle development of applications.Highly desired2  Years2 - ProficientExperience designing databases, data modeling and working as a DB developerRequired1  Years2 - ProficientExperience developing Visual Basic ScriptsRequired1  Years2 - ProficientExperience with Informatica in a data warehousing environment.Required1  Years2 - ProficientOracle 10 g Certified professional.Required2  Years3 - ExpertDeveloping and supporting Informatica ETL real-time and batch processes.Required2  Years2 - ProficientImplementing Informatica ETL solutions to Oracle databases.Required2  Years2 - ProficientInformatica Mapping design, development and implementation.Required2  Years2 - Proficient