DB2 LUW Architect & Developer — Performance & Automation

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

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.