DB2 DBA – Linux, Data Modeling & HADR

VOLTO Consulting; City of Albany (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

VOLTO Consulting seeks an IBM DB2 Database Administrator to join a 12-month assignment in Albany, NY. The role focuses on IBM DB2 administration, data modeling, and Linux-based deployment.

Mandatory tasks include DB2 administration, data modeling, and Linux expertise with additional credit for IBM InfoSphere DataStage and GCP in the_desired list. Essential skills cover DB2 LUW installation, upgrades, HADR disaster recovery, encryption with Guardium, user authentication, monitoring, and

Qualifications

• Essential DB2 administration on Linux servers.
• Disaster recovery setup with HADR.
• Encryption with DB2 native encryption and IBM Guardium.
• Manage authentication and authorization for databases.
• Monitoring and performance optimization of DB2 environments.
• Backup and restore from incremental/full backups.
• Tablespaces and memory (bufferpools) management; capacity planning.
• Implement database changes per business requirements across environments.
• Data movement between database environments.
• Create triggers/stored procedures/functions/indexes as needed.
• ER model and ERD generation with Erwin.
• Data loading and error resolution with load/import utilities.
• Data profiling and cleansing using SQL.
• Runstats, reorg, snapshots, and log pruning maintenance.
• Bash scripting and cron scheduling knowledge.
• Basic ETL knowledge.

Responsibilities

• Maintain IBM DB2 databases on Linux servers.
• Ensure high availability and disaster recovery readiness.
• Implement security and encryption for data at rest and in transit.
• Perform performance tuning and capacity planning across environments.
• Develop data movement and transformation routines as required.

Skills

DB2 Administration

Linux

HADR

Guardium

Performance Tuning

Backups & Restore

Scripting

Erwin (ERD)

ETL

Data Modeling

Tools

db2expln

db2advis

db2top

db2diag

db2pd

bash/shell

Job description

VOLTO Consulting seeks an IBM DB2 Database Administrator to join a 12-month assignment in Albany, NY. The role focuses on IBM DB2 administration, data modeling, and Linux-based deployment.

Mandatory tasks include DB2 administration, data modeling, and Linux expertise with additional credit for IBM InfoSphere DataStage and GCP in the_desired list. Essential skills cover DB2 LUW installation, upgrades, HADR disaster recovery, encryption with Guardium, user authentication, monitoring, and