W2 Only (No C2C) :: Remote :: IBM Db2 DBA LDAP, ISVG/ISIM & ISVA/ISAM Exp. || G.C / U.S.C
Bitsoft International, Inc.
United States
4 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source
Tech stack
Databases
IBM DB2
Linux
File Systems
Identity and Access Management
Indexed Sequential Access Method (ISAM)
Java Database Connectivity
Python (Programming Language)
Korn Shell
Lightweight Directory Access Protocols (LDAP)
Linux System Administration
Open Database Connectivity
+10 more
Performance Tuning
Red Hat Enterprise Linux
Ansible
Shell Script
Data Logging
Scripting
Git
Splunk
Software Version Control
Dynatrace
Job description
Seeking a senior Db2 DBA to plan and execute multi-environment upgrades of IBM Db2 on RHEL for enterprise IAM platforms. The databases support IBM Security Verify Governance (ISVG, formerly ISIM) and IBM Security Verify Access (ISVA, formerly ISAM). The role spans upgrade strategy, hands-on execution, performance/stability validation, and comprehensive documentation/runbooks.
Core Responsibilities:
- Plan, lead, and execute Db2 upgrades across DEV/TEST/UAT/PROD on RHEL, including pre-checks, backup/restore strategy, change windows, and rollback plans.
- Run prerequisite and compatibility checks (db2ckupgrade, db2prereqcheck), rebind packages, RUNSTATS/REORG, and license management (db2licm).
- Coordinate closely with ISVG/ISVA engineering to validate application connectivity, driver/client updates (JDBC/ODBC), and post-upgrade functional testing.
- Tune and validate database/instance parameters (DBM/DB CFG, bufferpools, logging, filesystem layout), and rebaseline performance.
- Harden and validate secure connectivity (SSL/TLS, certificates/GSKit/keystores), and LDAP directory integrations as applicable.
- Ensure HA/DR readiness (HADR/TSA or equivalent), log archiving/roll-forward, and DR tests post-upgrade.
- Automate repeatable steps with shell/Ansible; maintain execution logs, as-built docs, and SOPs.
- Troubleshoot post-upgrade issues (locking, package invalidation, query regressions) and drive remediation.
- Adhere to ITIL change/release processes and coordinate across infra, security, and application teams.
Requirements
7+ years as a Db2 for LUW DBA on Linux (RHEL) with recent hands-on upgrade/migration experience across multiple environments.
- Proven delivery of Db2 upgrades from 11.x to target LUW release in enterprise settings, including complex rollback and zero/low-downtime strategies.
- Strong skills in backup/restore, log management, HADR/TSA, performance tuning, and security hardening.
- Proficiency with shell scripting (bash/ksh) and automation tooling (e.g., Ansible).
- Experience collaborating with application teams to update Db2 clients/drivers and validate end-to-end connectivity.
- Solid understanding of Linux administration relevant to Db2 (filesystems, ulimits, kernel params).
Preferred Qualifications:
- Experience supporting IAM stacks: ISVG/ISIM and ISVA/ISAM, and IBM Directory/LDAP.
- Familiarity with SSL/TLS for Db2 connectivity, certificate lifecycle, and GSKit.
- Experience with monitoring and log tooling (e.g., IBM Data Server Manager/DSM, Splunk, Dynatrace).
- ITIL Foundation or equivalent change management discipline.
Deliverables:
- Approved upgrade strategy, runbooks, rollback plans, and cutover schedules for each environment.
- Successful completion of Db2 upgrades in all in-scope environments with documented validation results and performance baselines.
- Updated as-built documentation, configuration inventories, and operational SOPs.
- Knowledge transfer to operations, including on-call procedures and troubleshooting guides.
Environment/Notes:
- Platform: RHEL, Db2 for LUW; databases back ISVG/ISVA workloads.
- Travel/On-call: Occasional after-hours/weekend change windows; on-call during stabilization period.
- Tools: Db2 CLP, db2MOVE/db2LOOK, DSM, Git for runbook/version control, Ansible for automation.
Nice to Have:
- Experience with capacity planning and licensing optimization (AESE/ESE).
- Exposure to containerized or cloud-hosted Linux environments.
- Scripting in Python for advanced automation/reporting.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦