IBM DB2 Database Administrator

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

Work Location: Albany, NY
Duration of assignment (in Months): 12 months

JD

Role Descriptions: Mandatory: IBM DB2 Administration| Data Modeling| LinuxDesired: IBM InfoSphere DataStage| GCP

IBM DB2 Database Administrator, Linux

Work Location: Albany, NY
Duration of assignment (in Months): 12 months

JD

Role Descriptions: Mandatory: IBM DB2 Administration| Data Modeling| LinuxDesired: IBM InfoSphere DataStage| GCP

Essential Skills: DB2 LUW Database server installation| configuration and upgrade on Linux servers. Database disaster recovery setup (HADR). Database server encryption using DB2 native encryption and IBM Guardium. Manage database authentication and authorization. Database monitoring and performance optimization; db2expln| db2advis| db2top| db2diag| db2pd etc. Database backup and log management; database restoration from incremental/full backup image. Database storage space (tablespaces) and memory (bufferpools) management; database capacity planning. Design and implement database changes according to business requirement; roll-out changes to various database environments with releases. Data movement across various database environments. Triggers/Stored procedure/Functions/indexes creation based on application requirement. Logical data modelling and ERD generation using Erwin. Data loading and error resolution using load and import utilities. Data Profiling and cleansing using SQL statements. Perform database maintenance activities such as runstats| reorg| snapshots| prun logs etc. Knowledge of bash/shell scripting and cron scheduling. Basic knowledge of ETL and associated processes.

Keyword

Desirable Skills:
Skills: Database Administration (DBMS)~Unix / Linux Basics and Commands
Experience Required: 6-8