!!!VERY URGENT REQUIREMENT!!!
Position: IBM DB2 Database Administrator
Location: MI (REMOTE)
Duration: 6 Mo
Job Description
Key Responsibilities
1. Database Installation & Configuration
· Install, configure, and upgrade IBM DB2 LUW or DB2 z/OS environments.
· Create and manage DB2 instances, databases, buffer pools, and tablespaces.
· Apply fix packs, patches, and firmware updates.
· Configure high-availability environments (HADR, TSA, Pacemaker, Q-replication).
2. Database Administration & Maintenance
· Perform routine maintenance tasks such as REORG, RUNSTATS, and backup management.
· Monitor storage usage, tablespace health, and database growth.
· Ensure proper log management and archival strategies.
· Automate operational tasks using scripts and tools.
3. Performance Monitoring & Tuning
· Monitor database performance, identify bottlenecks, and resolve slow-running queries.
· Optimize SQL statements and access paths.
· Tune database parameters, buffer pools, memory, and I/O configurations.
· Perform workload analysis and recommend improvements.
4. Troubleshooting & Incident Management
· Diagnose and resolve DB2 errors, lock issues, performance problems, and failures.
· Review db2diag logs, snapshots, and system performance metrics.
· Work with IBM Support to resolve critical incidents (PMRs).
---
Required Qualifications
· Bachelor's degree in Computer Science, Information Systems, or related field.
· 5+ years of hands-on DB2 database administration (LUW or z/OS).
· Strong knowledge of SQL, DB2 architecture, and database internals.
· Experience with HADR, Q-replication, TSA, or clustering technologies.
· Proficiency in performance tuning, capacity planning, and monitoring tools.
· Strong analytical and troubleshooting skills.
Thanks & Regards,
Steve
Manager Recruitment’s
___________________
Parmesoft, Inc
2626 Cole Ave, Ste: 300
Dallas, TX 75204
Never miss an opportunity! Create an alert based on the job you applied for.
