Database Administrator

Compunnel, Inc.; New Jersey; On-site; USD 110,000 - 145,000; Full time

Job summary

A technology services firm in New Jersey is seeking a DB2 Administrator to support and optimize enterprise DB2 environments. This role involves maintaining performance, integrity, and scalability, while collaborating with development and infrastructure teams. Ideal candidates have 7–10+ years of experience in DB2 and a strong knowledge of performance tuning and monitoring tools. This position requires excellent communication skills and experience working in hybrid environments.

Qualifications

• 7–10+ years of experience as a DBA/Database Engineer supporting DB2.
• Strong knowledge of JCL, COBOL/DB2 packages, and indexing strategies.
• Proficiency with performance tuning and backup/restore concepts.

Responsibilities

• Support and maintain enterprise DB2 environments.
• Conduct structured program walk-throughs prior to code releases.
• Analyze performance traces and execute query tuning.

Skills

DB2 Administration

Performance Tuning

SQL Optimization

Stakeholder Management

Collaboration

Tools

SolarWinds

Dynatrace

Splunk

ServiceNow

Job description

The DB2 Administrator is responsible for supporting, optimizing, and maintaining enterprise DB2 environments across pre‑production and production systems. This role focuses on ensuring database performance, integrity, and scalability while proactively identifying and resolving performance bottlenecks. The DB2 Administrator will collaborate with development and infrastructure teams to ensure SDLC readiness, maintain environment stability, and establish governance for support and monitoring processes within a hybrid delivery model (onshore/offshore/nearshore).

Key Responsibilities

• Program Walk-Throughs & SDLC Readiness
• Conduct structured program walk-throughs prior to code releases, scanning COBOL/DB2 components and SQL for efficiency and performance optimization.
• Validate binds to the correct schemas, review data integrity impacts, and provide actionable feedback to development teams.
• Serve as a pre-production gatekeeper to streamline SDLC processes and minimize regression risk.
• Maintain the integrity of multi‑environment development landscapes (multiple schemas/environments).
• Manage storage, volume, and data refreshes, including flash copies of production data for development environments.
• Monitor and manage database utilities, archiving, and quarterly data purges in line with enterprise policies.
• Establish and manage a formal ticketing process (e.g., ServiceNow), L2 triage, and documentation (runbooks/playbooks).
• Participate in Agile stand-ups and ensure timely incident response and root cause analysis.
• SQL Performance Monitoring & Tuning
• Analyze performance traces and metrics to identify workloads exceeding CPU or utilization thresholds.
• Execute query, index, and parameter tuning to optimize performance.
• Enhance monitoring solutions (e.g., SolarWinds, Dynatrace, Splunk) to streamline alerting and improve capacity management.
• Collaborate with infrastructure and security teams to ensure resilient, compliant operations.
• Define and enforce L2 SLAs/OLAs, escalation paths, and incident/problem/change management best practices (ITIL).
• Develop and maintain operational dashboards, performance reports, and improvement backlogs.
• Coordinate across global (onshore/offshore/nearshore) teams to ensure consistent, 24x7 hybrid support coverage.
• Drive continuous improvement initiatives and communicate technical recommendations to leadership.

Required Qualifications

• 7–10+ years of experience as a DBA/Database Engineer supporting DB2 (Mainframe/z/OS) in enterprise environments.
• Strong knowledge of JCL, COBOL/DB2 packages, BIND/REBIND, RUNSTATS, REORG, indexing strategies, and query optimization.
• Proven experience with performance tuning, patch management, backup/restore, and high‑availability concepts.
• Experience establishing support governance — including ticketing workflows (e.g., ServiceNow), L2 triage, SLAs, and documentation.
• Proficiency with monitoring tools such as SolarWinds, Dynatrace, or Splunk.
• Excellent communication and stakeholder management skills, with experience working across global delivery teams.
• Willingness to participate in maintenance windows and on‑call rotations.

Preferred Qualifications (if any)

• Exposure to Oracle or other mainframe database systems.
• Scripting experience in Shell, PowerShell, or Python.
• ITIL v4 Certification or equivalent.
• IBM DB2 and/or Microsoft SQL Server certifications.
• Experience working in retail, consumer goods (CPG), or other high‑throughput environments.

Certifications (if any)

• IBM Certified Database Administrator – DB2 (preferred).
• ITIL v4 Foundation Certification (preferred).
• Microsoft SQL Server DBA Certification (optional).