Database Architect - Gonzer Associates, L. J.
Albany, NY
About the Job
L.J. Gonzer Associates is looking for individuals to join our pool of qualified candidates for potential assignment as a Database Architect. This position will provide design, coding, and performance tuning services at the database level in support of multiple large scale, high visibility applications. Tasks will include:
- 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.
- 7 years of experience in designing DB2 or IDMS database structures for enterprise systems.
- 7 years of experience with application and SQL performance analysis and tuning.
- 7 years of experience with CICS Design.
- 7 years of experience with physical database design.
- 7 years of experience writing shell scripts.
- 7 years of experience maintaining logical and physical database designs with Erwin.
- 7 years of experience creating database standards and procedures.
- 7 years of experience performing database upgrades for DB2 or Oracle.
Source : Gonzer Associates, L. J.