DB2 Database Administrator Job at William Everett, Chicago, IL

b3g4ZG1RYTA2WGZLYmlaMHpjUmFWNGllQWc9PQ==
  • William Everett
  • Chicago, IL

Job Description

Position Overview:

Seeking an experienced DB2 DBA for on-demand, project-based engagements (typically 3–4 months) to support critical database operations, including migrations, upgrades, and integrations across multiple DB2 databases on IBM Power9/Power10 systems (including Rep, WP, ABE, and Misc) on IBM Power9 systems, with potential migration to Power10. The role focuses on performance tuning, maintenance, upgrades, and troubleshooting to ensure system reliability, efficiency, and scalability.

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.

Collaboration & Documentation

  • 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.

Job Tags

Hourly pay,

Similar Jobs

Brian Cover - State Farm Agent

Life/Health Insurance Position - State Farm Agent Team Member Job at Brian Cover - State Farm Agent

 ...)~ Bonus based on performance ~ Competitive salary ~ Health insurance ~ Opportunity for advancement ~ Paid time off ~ Training & development ROLE DESCRIPTION: Brian Cover - State Farm Agent is seeking a dedicated, compassionate professional for the role... 

Devereux Advanced Behavioral Health- Pennsylvania Children's...

Education Program Coordinator Job at Devereux Advanced Behavioral Health- Pennsylvania Children's...

 ...Are you interested in making a difference in the lives of children and adolescents? Are you a Special Education Teacher looking for a change? Are you looking for an opportunity to grow outside of classroom instruction and provide supervision in a school setting? If you... 

Amazon Conservation Team

Digital Marketing and Communications Manager Job at Amazon Conservation Team

 ...Join the Amazon Conservation Team as our Digital Marketing and Communications Manager Are you a strategic, entrepreneurial digital marketing...  ...and at least one other major language ACT works in (e.g., Spanish, Portuguese, Dutch). Conversational ability in Spanish, minimum... 

Diverse Lynx

Dell Boomi Developer Job at Diverse Lynx

 ...Role Description: BOOMI Competencies: Digital : Dell Boomi Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on... 

gold man team

Community Energy Sales Advocate (Hiring Immediately) Job at gold man team

 ...customer satisfaction through door-to-door and retail channels. Join us and make a positive impact on the environment while helping your community. Responsibilities # Manage Client Relationships: Develop and maintain strong relationships with clients to ensure...