Lead IBM DB2 Database Administrator

Title: Senior IBM DB2 Database Administrator Tech Lead/Management (W2 ROLE)

Location: Rensselaer NY (100% Remote)

Duration: Long term contract

Database Administrator Technical Lead

Deliver insights to help our clients turn data into action as a 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.

At GDIT, people are our differentiator. You will join our team in partnership with New York State of Health (NYSoH) to provide comprehensive health coverage to more than 6.7 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

Must Have Experience:

• Ten (10) years or more of related technical experience DB2
• Within the last Five (5) years or more of database administration with DB2
• Three to five years managing/leading technical staff
• 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

Must Have Skills:

• Must have excellent communication and presentation skills
• Expert in SQL coding and performance tuning
• Backup and recovery strategies, performance tuning and installation
• JDBC, JBOSS, WebSphere, and Apache environment skills
• 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