Database Architect

Desired Requirements:

• 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

Responsibilities:

• 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