IBM Db2 Database Administrator (Onsite) || Albany NY
Posted 7 days ago by 1765516860
Negotiable
Outside
Undetermined
USA
Summary: The role of IBM Db2 Database Administrator involves maintaining and troubleshooting IBM Db2 databases, ensuring optimal performance, and managing user access and security. The position is based in Albany, NY, and requires expertise in database monitoring, data management, and recovery strategies. The candidate should be prepared for an onsite role with a duration of over six months. Relocation is acceptable for the right candidate.
Key Responsibilities:
- Perform maintenance and troubleshooting for multiple IBM Db2 databases (LUW or z/OS).
- Regularly monitor Db2 databases using tools like Db2 Monitoring Console, db2pd, db2top, and system views.
- Oversee Db2 tablespaces, containers, storage groups, and transaction logs.
- Manage Db2 logins, roles, and privileges.
- Optimize Db2 performance through index design, buffer pool tuning, and configuration parameter adjustments.
- Implement and manage Db2 backup and recovery strategies.
- Maintain detailed documentation of Db2 configurations and compliance procedures.
Key Skills:
- Experience with IBM Db2 databases (LUW or z/OS).
- Proficiency in database monitoring tools and performance tuning.
- Knowledge of user access management and security configurations.
- Ability to implement backup and recovery strategies.
- Strong documentation and compliance skills.
Salary (Rate): undetermined
City: Albany
Country: USA
Working Arrangements: undetermined
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Hi
Hope you are doing well !!
I have an urgent position. Kindly go through the Job description and let me know if this would be of interest to you.
Title : IBM Db2 Database Administrator (Onsite)
Duration : 6+ Months
Location : Albany NY (Relocation is fine)
About the job
IBM Db2 Database Administrator Job Details
Troubleshooting & Maintenance:
- Perform maintenance and troubleshooting for multiple IBM Db2 databases (LUW or z/OS). Diagnose and resolve Db2-specific issues such as utility failures, locking conflicts, buffer pool problems, and catalog inconsistencies.
Database Monitoring:
- Regularly monitor Db2 databases using tools like Db2 Monitoring Console, db2pd, db2top, and system views. Check for lock escalations, deadlocks, long-running applications, failed updates, and tablespace utilization.
Data & Log File Management:
- Oversee Db2 tablespaces, containers, storage groups, and transaction logs. Manage log file growth, log archiving, and recovery configurations (LOGARCHMETH1/2).
User Access & Security:
- Manage Db2 logins, roles, and privileges. Configure authentication and authorization using Db2 s built-in security model or external systems (LDAP, Kerberos).
Performance Tuning:
- Optimize Db2 performance through index design, buffer pool tuning, RUNSTATS, REORG, package/application tuning, and configuration parameter adjustments.
Recovery:
- Implement and manage Db2 backup and recovery strategies using online/backups, rollforward recovery, or HADR environments.
Documentation & Compliance:
- Maintain detailed documentation of Db2 configurations, maintenance routines, troubleshooting history, and compliance procedures."
If you are interested, please share your updated resume and suggest the best number & time to connect with you
Thanks & Regards
| Himanshu Gupta | |||
|