Remote – DB2/LUW Administrator Technical Lead- Contract to Hire – Experienced Recruiting Partners – Albany, NY – work from home job
Company: Experienced Recruiting Partners
Job description: Remote role
Apply Job!Contract to Hire – possible 6 month conversion
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
- This position will be on the Enterprise Architecture Team
- The project is built on a multi-tier architecture including Service Oriented architecture, multi-tier web applications using Java and various other COTS products.
- Important – Familiar with PII, PHI, FTI – sensitive data security practices
IMPORTANT- Client runs 7 days on two shifts – this person will work 1 weekend out of every 5 — Expected to take weekend shift – this person would be Friday/Monday off the weekend shift they work
Responsibilities:
- 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 Client 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:
- 12+ years of related technical experience
- 8+ years of more of DB2 LUW database administration
- 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
- Bachelor’s degree in Computer Science, Management Information Systems, or related technical field, OR equivalent combination of education and 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
Remote – DB2/LUW Administrator Technical Lead- Contract to Hire – Experienced Recruiting Partners – Albany, NY – work from home job
Expected salary:
Location: Albany, NY
Remote – DB2/LUW Administrator Technical Lead- Contract to Hire – Experienced Recruiting Partners – Albany, NY – work from home job
Job date: Fri, 11 Aug 2023 22:08:24 GMT
Remote – DB2/LUW Administrator Technical Lead- Contract to Hire – Experienced Recruiting Partners – Albany, NY – work from home job
Apply Job!