DB2 LUW DBA Technical Lead

Deliver insights to help our clients turn data into action as a DB2 (LUW) Database Administrator Technical Lead. Your work will provide transformative solutions to our clients' big-data obstacles and help advance the mission. Here, you can make a meaningful impact on our clients' mission and on your career.

You will join our team in partnership with New York State of Health (NYSoH) to provide comprehensive health coverage to more than 7.2 million New Yorkers through its Health Benefit Exchange (HBE)

HOW YOU'LL MAKE AN IMPACT:

• You'll join our talented Enterprise Architecture Team. Our project is built on a multi-tier architecture including Service Oriented architecture, multi-tier web applications using Java and various other COTS products.
• 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 troubleshooting, database and SQL performance tuning.
• Technical Lead who will support the Database Manager with design, planning and scheduling activities.
• 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.
• 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 team resources on a large project
• Provides work guidance and mentoring to less experienced personnel. Provide database related technical expertise to application development and NYSOH program infrastructure efforts.
• Integrate databases and commercial of the shelf software; resolves conflicts between databases and of the shelf software, operating systems, and open source applications.

WHAT YOU'LL NEED TO SUCCEED:

Education:

• Bachelor's degree in Computer Science, Management Information Systems, or related technical field, OR equivalent combination of education and experience

Experience:

• Twelve (12) years or more of related technical experience
• Eight (8) years of more of DB2 LUW database administration
• Five (5) years of more managing/leading database team
• Experience working with differences between database structures (e.g., transaction based vs. data warehouse)
• High-volume, mission critical environment with strict performance Service Levels experience

Skills:

• Expert in SQL coding and performance tuning
• Backup and recovery experience
• DB2 installation experience
• Fail over/Fail back experience using HADR
• Replication experience using CDC
• Database Performance engineering experience in high volume, OLTP applications
• Strong communication and presentation skills
• Willingness to provide evening and weekend support as required

Preferred Experience/Skills:

• Eligibility and Enrollment applications
• IBM InfoSphere Optim Archive product suite
• Healthcare data / databases
• SQL Server database administration
• Proficiency with ER Studio tool for data modeling and configuration management

IBM DB2,Database Administration,LUW,SQL,Performance Tuning,InfoSphere,Healthcare Analytics