Overview
On Site
$$78/hr
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 30 Month(s)
Skills
SQL
procedures
stored procedures
tuning
Change Data Capture
DB2 LUW
physical database design
sequence objects
AIX shell scripts
database upgrades
database standards
IBM Data Replication
performance analysis
Job Details
Greetings from Sligo Software Solutions, Inc. !!
This is Yashwanth from SLIGO. We have an urgent requirement for DB2 Database Architect position with our client.
This is Yashwanth from SLIGO. We have an urgent requirement for DB2 Database Architect position with our client.
Title : DB2 Database Architect
Location : Albany, New York
Duration : 30 Months
Client : NY State - Information Technology Services
Job ID: SLG - 19 - 11280
Respond by: 11/05/25 5:00 PM
Greetings from Sligo Software Solutions, Inc. !!
SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government.
We have an urgent requirement for DB2 Database Architect position with our client.
SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government.
We have an urgent requirement for DB2 Database Architect position with our client.
Role: DB2 Database Architect
Location: Albany, New York
Duration: 30 Months
Job ID: SLG - 19 - 11280
Client: NY State - Information Technology Services
Description
This project is to modernize aging Tax systems into new technologies including CARTS, Correspondence.
Duties
- Responsible for analysis, support, development, reengineering, and maintenance of all agency databases. Support is required for specific database management systems (DB2 LUW, DB2 LUW, IDMS, SQL Server), and using specific technologies (Unix scripting, DBI performance tools, ERwin, z/OS, AIX, IBM Data Replication).
- Provide performance analysis and tuning, troubleshooting, capacity planning, benchmark design.
- Develop a streamlined process for database migrations.
- Design methodologies for data synchronization from operational data stores to a data warehouse across multiple database platforms and varied DBMS'.
- Planning, and interfacing between application databases, data warehouse, Cognos, Identity Insight, and DataStage.
- Act as liaison between Data Management, business customers, and application development staff to ensure that recommended performance considerations are included in reviews, designs, development, and implementation of applications.
- Create cost effective and timely solutions to strategic business requirements utilizing database structures, application methodologies, and coding techniques.
Mandatory Requirements
- Experience (14+ Years)
- Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Requirements
- This is an 100% Onsite.
- 84 months experience in designing DB2 LUW database structures, stored procedures, and sequence objects for enterprise systems.
- 84 months experience with application and SQL performance analysis and tuning.
- 84 months experience with physical database design.
- 84 months experience writing AIX shell scripts to automate redundant tasks.
- 84 months experience performing database upgrades for DB2 LUW.
- 84 months experience creating database standards and procedures.
- 84 months experience installing, configuring and developing real time replication utilizing IBM Data Replication/Change Data Capture (CDC).
- R sum
- Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable)
- Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Thanks & Regards
Deepika Pagalla
Senior Talent Acquisition Specialist
Sligo Software Solutions Inc.
IMPORTANT NOTICE: This e-mail and any attachments may contain confidential or sensitive information which is, or may be, legally privileged or otherwise protected by law from further disclosure. It is intended only for the addressee. If you received this in error or from someone who was not authorized to send it to you, please do not distribute, copy or use it or any attachments. Please notify the sender immediately by reply e-mail and delete this from your system. Thank you for your cooperation.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.