DB2 Database Developer/Architect

JSM Consulting Inc.; City of Albany (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

JSM Consulting Inc. seeks an experienced DB2 LUW DBA to design enterprise DB2 LUW database structures and implement stored procedures and sequence objects.

You will optimize SQL performance, perform physical database design, and automate tasks with AIX shell scripts. Responsibilities include managing upgrades and establishing database standards, while implementing real-time replication with IBM Data Replication/CDC.

Qualifications

• 84 months experience designing DB2 LUW database structures and stored procedures.
• 84 months experience with SQL performance analysis and tuning.
• 84 months experience with physical database design.
• 84 months experience writing AIX shell scripts to automate tasks.
• 84 months experience performing DB2 LUW database upgrades.
• 84 months experience creating database standards and procedures.
• 84 months experience installing, configuring and developing real time replication using IBM Data Replication/CDC.

Skills

DB2 LUW design

Stored procedures & sequence objects

SQL performance analysis

Physical database design

AIX shell scripting

DB2 LUW upgrades

Database standards & procedures

IBM Data Replication / CDC

Job description

Job Description

84 months experience in designing DB2 LUW database structures, stored procedures, and sequence objects for enterprise systems.

• 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)