*Database Administrator Technical Lead*
*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
Job Types: Full-time, Contract
Pay: $190,000.
00 per year
Experience:
* MySQL: 5 years (Required)
* Database administration: 5 years (Required)
* DB2: 5 years (Required)
Work Location: Remote
Whatsapp
