Database Administrator Technical Lead

About the position

Deliver insights to help our clients turn data into action as a Database Administrator Technical Lead at GDIT. 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 7.3 million New Yorkers through its Health Benefit Exchange (HBE).

Responsibilities

• Responsible for the maintenance and support of multiple high volume multi-terabyte DB2 LUW databases.
• Work with the development team to understand requirements and create structures to accommodate them.
• Troubleshoot, database and SQL performance tuning.
• Support the Database Manager with design, planning and scheduling activities.
• Assist project managers in the development of project plans including detailed project estimates and tasks required for database activities.
• Utilize 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.
• Provide 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; resolve conflicts between databases and of the shelf software, operating systems, and open source applications.

Requirements

• Bachelor's degree in Computer Science, Management Information Systems, or related technical field, OR equivalent combination of education and 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.
• 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.

Nice-to-haves

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

Benefits

• Variety of medical plan options, some with Health Savings Accounts.
• Dental plan options.
• Vision plan.
• 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match.
• Full flex work weeks where possible.
• Paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
• Short and long-term disability benefits.
• Life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance.