LOCATION: Remote | SHIFT: Day: Monday thru Friday |
DUTIES AND RESPONSIBILITIES
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.
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.
REQUIREMENTS & EXPERIENCE
WHAT YOU’LL NEED TO SUCCEED:
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
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
15 + years of related experience
US Citizenship Required: