Database Architect - i-Link Solutions Inc
Albany, NY 12227
About the Job
Job Title: Database Architect - Expert
Task ID: HBITS-06-13706
Position Duration: 30 Months
Client: State of NY
Agency: Information Technology Services
Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or ema il at nysreqs@ilinksolutions.com
Description
Daily Tasks will include but are not limited to the following:
Mandatory Qualifications
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
Task ID: HBITS-06-13706
Position Duration: 30 Months
Client: State of NY
Agency: Information Technology Services
Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or ema il at nysreqs@ilinksolutions.com
Description
Daily Tasks will include but are not limited to the following:
- 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 Qualifications
| 1 | 84 months experience in designing DB2 or IDMS database structures for enterprise systems |
| 2 | 84 months experience with application and SQL performance analysis and tuning |
| 3 | 84 months experience with CICS Design |
| 4 | 84 months experience with physical database design |
| 5 | 84 months experience writing shell scripts |
| 6 | 84 months experience maintaining logical and physical database designs with Erwin |
| 7 | 84 months experience creating database standards and procedures |
| 8 | 84 months experience performing database upgrades for DB2 or Oracle |
| Required Documentation | • Résumé • Copy of Candidate Identification (i.e., driver's license and/or passport and Visa if applicable) • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) |
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
Source : i-Link Solutions Inc