DB2 Admin

KTek Resourcing LLC; Malvern (Chester County); On-site; USD 110,000 - 160,000; Full time

Job summary

KTek Resourcing LLC is seeking an experienced Db2 DBA to administer and tune enterprise Db2 LUW databases in a high-availability environment. You will analyze workload behavior, optimize SQL, and design efficient data layouts to ensure peak performance.

You will collaborate with developers and architects to optimize application-to-database interactions, perform capacity planning, and lead root-cause analyses of incidents while implementing durable fixes and best practices.

Qualifications

• Strong hands-on experience administering and tuning IBM Db2 LUW/UDB in enterprise environments.
• Advanced SQL tuning, query-plan analysis, indexing, statistics, and workload-management experience.
• Expertise in physical database design, table spaces, partitioning, buffer pools, locking, concurrency, and utilities.
• Experience with monitoring, diagnostics, backup/recovery, high availability, and production incident resolution.
• Ability to translate business workload characteristics into database configuration and optimization decisions.
• Strong collaboration skills with application, infrastructure, architecture, and production-support teams.

Responsibilities

• Administer distributed Db2 databases and ensure performance, availability, stability, and recoverability.
• Analyze workload behavior and tune SQL, access paths, indexes, statistics, memory, configuration parameters, and database objects.
• Design and review physical schemas, partitioning approaches, indexing strategies, table spaces, and data placement.
• Use explain plans, monitoring data, and diagnostic tools to identify bottlenecks and recommend corrective actions.
• Partner with Java developers and solution architects to optimize application-to-database interactions.
• Lead root-cause analysis for database incidents and implement sustainable remediation and preventive controls.
• Perform capacity planning, database health reviews, maintenance planning, and standards definition.
• Provide technical guidance, peer reviews, and operational documentation for database support teams.

Skills

Db2 DBA administration

SQL tuning

Physical database design

Backup & recovery

High availability

Performance monitoring

Team collaboration

Tools

IBM Data Studio

db2pd

MON_GET interfaces

Job description

• Administer distributed Db2 databases and ensure performance, availability, stability, and recoverability.
• Analyze workload behavior and tune SQL, access paths, indexes, statistics, memory, configuration parameters, and database objects.
• Design and review physical schemas, partitioning approaches, indexing strategies, table spaces, and data placement.
• Use explain plans, monitoring data, and diagnostic tools to identify bottlenecks and recommend corrective actions.
• Partner with Java developers and solution architects to optimize application-to-database interactions.
• Lead root-cause analysis for database incidents and implement sustainable remediation and preventive controls.
• Perform capacity planning, database health reviews, maintenance planning, and standards definition.
• Provide technical guidance, peer reviews, and operational documentation for database support teams.

Mandatory Skills

• Strong hands-on experience administering and tuning IBM Db2 LUW/UDB in enterprise environments.
• Advanced SQL tuning, query-plan analysis, indexing, statistics, and workload-management experience.
• Expertise in physical database design, table spaces, partitioning, buffer pools, locking, concurrency, and utilities.
• Experience with monitoring, diagnostics, backup/recovery, high availability, and production incident resolution.
• Ability to translate business workload characteristics into database configuration and optimization decisions.
• Strong collaboration skills with application, infrastructure, architecture, and production-support teams.

Preferred Skills

• Experience supporting high-volume Java applications and distributed services.
• IBM Data Studio, db2pd, MON_GET interfaces, or comparable Db2 monitoring and diagnostic tooling.
• AWS or cloud-migration exposure.
• Automation or scripting using shell, Python, or similar tools.