IBM DB2 Database Administrator
Listed on 2026-08-09
-
IT/Tech
Database Administrator, Data Engineering, Information Security & Data Protection, Data Warehousing
Work Location:
Albany, NY
Duration of assignment (in Months): 12 months
Mandatory: IBM DB2 Administration| Data Modeling| Linux Desired: IBM Info Sphere Data Stage| GCP
IBM DB2 Database Administrator, Linux
Work Location:
Albany, NY
Duration of assignment (in Months): 12 months
Mandatory: IBM DB2 Administration| Data Modeling| Linux Desired: IBM Info Sphere Data Stage| 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 (table spaces) and memory (buffer pools) 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.
Desirable
Skills:
Skills:
Database Administration (DBMS)~Unix / Linux Basics and Commands
Experience
Required:
6-8
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).