DB2 Database Architect
DB2 Database Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Location: Albany New York
Duration: 30 Months
Description
This position will support the EIM / Database Administration Team of NYSDTF. This position will provide design coding and performance tuning services at the database level in support of multiple large scale high visibility applications.
Duties
Responsible for expert analysis support development reengineering and implementation of multiple business applications. Support is required for specific programming languages (COBOL SQL and Java) for specific database management systems (DB2 z/OS DB2 LUW IDMS SQL Server) and using specific technologies (MQ Series CICS Sort JCL VSAM Unix scripting DBI performance tools Erwin TSO/ISPF Data Studio 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 interfacing and usage 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 or IDMS database structures for enterprise systems
- 84 months experience with application and SQL performance analysis and tuning
- 84 months experience with CICS Design
- 84 months experience with physical database design
- 84 months experience writing shell scripts
- 84 months experience maintaining logical and physical database designs with Erwin
- 84 months experience creating database standards and procedures
- 84 months experience performing database upgrades for DB2 or Oracle
Employment Type
Full Time
