DB2 Database Administrator Job at William Everett in chicago

Key Responsibilities: Database Management & Maintenance Perform regular index cleanup, re-indexing, and database optimization. Oversee upgrades of DB2 databases, operating systems, and associated tools. Ensure database health across production, test, and development environments. Execute database upgrades (DB2, OS), migrations (legacy to Power9/Power10), and re-indexing/cleanup during defined project windows. Support disaster recovery (DR) testing, failovers, and performance tuning for time-sensitive initiatives. Migrations & Hardware Upgrades Execute migrations from legacy hardware to modern Power9/Power10 systems (occasional). Plan and validate disaster recovery (DR) failovers, migrations, and runtime testing. Performance & Troubleshooting Diagnose and resolve SQL query issues (e.g., slowness, incomplete returns) from Deloitte IES code. Troubleshoot system/technical issues, including database connectivity and performance bottlenecks. Partner with developers and infrastructure teams to optimize SQL and system configurations. Maintain documentation for migrations, upgrades, and DR procedures.

Qualifications: 5+ years as a DB2 DBA, with expertise on IBM Power Systems (Power9/Power10). Proven experience managing large-scale DB2 environments (50+ databases). Strong SQL tuning, indexing strategies, and performance optimization skills. Familiarity with scripting (Shell, Python, etc.) for automation of maintenance tasks. Knowledge of DR planning, replication, and HA configurations.

Preferred Qualifications: Certifications in DB2 or IBM Power Systems. Experience with Power9-to-Power10 migrations.

Pay Scale: $80-$90 on an hourly basis. Seniority level Mid-Senior level