1 year contract
Position closes 3/29
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.
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 Experience:
Experience as an Oracle DBA (Required 8 Years)
Experience working with Oracle RAC clustering. (Highly desired)
Experience working Data Guard failover and Grid Control (Required 2 Years)
Experience working with Oracle in a Microsoft Environment (Highly desired)
Experience working within a Data Warehousing environment (Required 3 Years)
Experience writing and debugging complex PL/SQL procedures and packages. (Required 3 Years)
Experience with Oracle backup and recovery. (Required 3 Years)
Experience installing Oracle bug fixes and patching. (Required 3 Years)
Experience with table space space, installing new databases. (Required 2 Years)
Experience designing backup solutions using RMAN. (Required 2 Years)
Experience writing backup scripts using export/data pump (Required 2 Years)
Experience using RMAN to do database cloning to create test environments. (Required 2 Years)
Writing and reviewing technical specifications, test plans, requirements (Required 1 Year)
Experience performance tuning of the database (Required 1 Year)
Experience in full life cycle development of applications. (Highly desired)
Experience designing databases, data modeling and working as a DB developer (Required 1 Year)
Experience developing Visual Basic Scripts (Required 1 Year)
Experience with Informatica in a data warehousing environment. (Required 1 Year)
Oracle 10 g Certified professional. (Required 2 Years)
Developing and supporting Informatica ETL real-time and batch processes. (Required 2 Years)
Implementing Informatica ETL solutions to Oracle databases. (Required 2 Years)
Informatica Mapping design, development and implementation. (Required 2 Years)
This position goes to the end of this fiscal year. Based on funding and performance this resource will be extended into FY13.
Work Location: Citywide Data Warehouse: 1100 15th St NW, 9th Floor