Job Description :
Position: DB2 LUW DBA
Location: Albany NY
Duration:6+ Months(CTH)

Role Description
Will be a part of the DBA team supporting the New York Health Exchange. Responsible for the maintenance and support of multiple high volume multi-terabyte DB2 LUW databases. Will work with the development team to understand requirements and create structures to accommodate them. Responsible for trouble shooting and database and SQL performance tuning.
Essential Job Functions
Anticipate and resolve database integration issues for complex, high volume transaction processing systems
Provide thought leadership for database management systems (DBMS) use, design and implementation.
Lead SQL and Database performance tuning efforts with the development teams
Build database schema, tables, procedures and permissions
Oversee backup, clustering, mirroring, replication and failover
Install and test upgrades and patches
Coordinate and manage activities of multiple database management systems (DBMS) resources on a large project
Provides work guidance and mentoring to less experienced personnel. Provide database related technical expertise to application development and global infrastructure efforts.
Provide input to development of vision, specify key performance requirements and define technical critical success factors.
Proficient with Erwin tool for data modeling and configuration management
Assists project managers in the development of project plans including detailed project estimates and tasks required for database activities. Utilizes standard corporate tools to record change and problem activities for tracking purposes.
Integrate databases and commercial of the shelf software; resolves conflicts between databases and of the shelf software, operating systems, and open source applications.
qualifications

Basic Qualifications
Bachelor''s degree in computer sciences or related field preferred
Nine or more years of experience in database administration (5 years DB2)
Expert in SQL coding and performance tuning
Experience in implementing replication, backup and recovery strategies, performance tuning and installing DB2 LUW required
Experience with JDBC, WebSphere, and Apache environments
Experience working with differences between database structures (e.g., transaction based vs. data warehouse)