Data Warehouse Architect / Db2 Administrator Job in Nyc 10019, New York US
Role: Data Warehouse Architect / Db2 Administrator
Duration: 6 months +
Location: NYC, NY
RESPONSIBILITIES:
· Design, create and maintain structural integrity of all DB2 database objects.
· Responsible for monitoring and optimizing the performance of the database and performing query optimizations.
· Enhancement and support of database maintenance streams (archive, purge, partition maintenance, reorgs, etc).
· Work with Data and Business Analysts to ensure requirements and source feeds will support the reporting use cases and database design.
· Development and support of db2 stored procedures utilized by the ETL batch stream.
Skills Required
· Proven experience with large multi-terabyte db2 installations on the DB2 DPF platform.
· Highly skilled at database programming in SQL for DB2, query optimization, and schema design with DDL.
· Proven experience with database dimensional modeling techniques and complexities including a solid understanding of the Kimball bus architecture for Data Warehousing.
· Expertise in shell scripting or programming in a UNIX/Linux environment.
· Experience with scripting languages such as Perl or Python.
· Strong analytical and design skills.
· Understanding of adhoc dynamic reporting tools like Business Objects or Cognos and tuning of queries generated from those tools.
· Experience with the Erwin data modeling tool for physical modeling and forward engineering of DDL. Some experience with Erwin Macros would be a plus.
· Excellent organizational skills and ability to Multi-task.
· Excellent oral and written communication skills.
Skills Desired
· Some knowledge of XML.
· Some knowledge of Autosys for job scheduling
· Some knowledge of Informatica
Thanks,
Shivendra Singh
Direct-412-267-3067