Job Description :
Role :                   Database Administrator - DB2 LUW
Location :           Renssealer, NY

Duration:           12+ months plus

Moi:                     Phone and WebEx



Database Administrator – DB2 LUW Renssealer, NY Upstate NY



Must have lead experience.



Position 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.

Position Requirements


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.
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


Bachelor''s degree in computer sciences or related field preferred
Fifteen 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)
Database Performance engineering experience in high volume, OLTP applications
Experience in a high-volume a mission critical environment with strict performance Service Levels
IBM InfoSphere Optim Archive product suite desirable
Eligibility and Enrollment applications highly desirable & Healthcare data / databases highly desirable
SQL Server database administration desirable




Thanks and Regards,

Sangeeta Deopa | IT Recruiter | KPG99, INC
Direct| |  

3240 E State St EXT, Hamilton, NJ 08619