*Job Title: Application DBA
Location: New York, NY
Duration: 12 Months+
** 5+ Years of strong database architecture experience.
* Experience in Linux UDB version 10.x and up;
* Strong experience in Linux db2 utilities
* Strong experience in Linux db2 monitoring utilities and features
* This is an application dba role, not an operational DBA role or System DBA role.
* Strong Skills in Relational Database (preferably DB2) including modelling, database design, performance tuning, writing complex DB programs etc.
* Experience in closely working with application teams (ETL, Tableau etc.) and managing all the DB related activities such as DB modeling, design, development, maintenance and support
* Demonstrate proficient skills in analysis and resolution of application performance problems.
* Experience with UNIX, Autosys, Perl is a plus.
* DB2 on Linux; Query Building and Optimization
* Data Architecture and Design
* Strong Database Development experience ( Stored Procedures, Ability to write and tune complex SQL's, Good scripting experience, Shell/Perl etc.)
* Expertise on DB2
* Data Modeling
* Enterprise (OLTP) and Dimensional Modeling using Power Designer or CA Erwin
** Knowledge and some experience on Big Data technologies
* Python or Perl
Job Type: Contract