Database Administrator

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

• 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., Service Now), 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., Solar Winds, 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.

• 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., Service Now), L2 triage, SLAs, and documentation.
• Proficiency with monitoring tools such as Solar Winds, 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.

• Exposure to Oracle or other mainframe database systems.
• Scripting experience in Shell, Power Shell, 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.

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