DB2 Database Administrator

Wakefern Food Corp.; Edison (NJ); Hybrid; USD 125.000 - 175.000; Vollzeit

Benefits dieser Stelle

Medical, dental, vision

401(k) with company match

Paid time off

Parental leave

Wellness programs

Zusammenfassung

Wakefern Food Corp. is seeking a highly skilled DB2 Administrator to provide technical leadership and operational support across IBM DB2 for z/OS, DB2 LUW, SQL Server, PostgreSQL, and cloud-based platforms.

The role focuses on mission-critical, high-volume transactional systems and guiding modernization toward cloud-native analytics. The ideal candidate will optimize performance, manage backups and DR, and collaborate with development, infrastructure, and data engineering teams on migration and

Qualifikationen

• Bachelor's degree in computer science, information technology, or related field, or equivalent experience.
• 10+ years of enterprise database administration experience.
• Strong hands-on experience administering IBM DB2 for z/OS.
• IBM DB2 for z/OS architecture and administration.
• Experience with DB2 utilities including REORG, RUNSTATS, COPY, RECOVER, LOAD, and UNLOAD.
• SQL performance tuning and access path analysis.
• Working knowledge of z/OS, JCL, TSO/ISPF, and COBOL application environments.
• Extensive experience with DB2 LUW including database configuration, performance tuning, backup and recovery, and troubleshooting.
• Experience administering Microsoft SQL Server including installation and configuration, performance tuning, backup and restore, security and access management, production support, and troubleshooting.
• Advanced SQL skills with the ability to analyze complex workloads and optimize performance.
• Experience supporting highly available, mission-critical transactional systems.

Aufgaben

• Provide senior-level administration and operational support for IBM DB2 for z/OS, IBM DB2 LUW, Microsoft SQL Server, PostgreSQL, and cloud-based database platforms.
• Install, configure, upgrade, patch, monitor, and maintain enterprise database environments.
• Ensure database availability, reliability, security, and performance across supported platforms.
• Support backup, recovery, disaster recovery, and high-availability solutions.
• Analyze and tune database performance across large-scale production environments.
• Optimize SQL statements and application database interactions.
• Perform execution plan analysis and access path reviews.
• Develop and maintain effective indexing strategies.
• Manage statistics collection, database maintenance activities, capacity planning, and resource optimization.
• Design and implement database solutions supporting enterprise applications.
• Manage and maintain database objects including tables, indexes, views, stored procedures, packages, constraints, and security controls.
• Troubleshoot complex production issues and conduct root cause analysis.
• Partner with application development, integration, infrastructure, and data engineering teams.
• Support enterprise modernization efforts involving migration and integration of legacy database platforms into cloud environments.
• Provide guidance on database architecture, governance, standards, and best practices.
• Evaluate emerging database technologies and recommend modernization strategies.
• PostgreSQL administration and support.
• Google Cloud Platform (GCP), BigQuery, Cloud Storage, and cloud-native data services.
• Hybrid cloud and on-premises data architectures.
• Database migration, replication, and modernization programs.
• Enterprise ETL, data integration, and data pipeline technologies.
• Data warehousing and analytical processing environments.
• Database replication technologies.
• Database automation and monitoring tools.
• Infrastructure-as-Code (IaC) and cloud operations concepts.
• API-driven and event-driven data architectures.
• Collaboration with development teams on database design and application optimization.

Kenntnisse

DB2 for z/OS

SQL tuning

IBM DB2 LUW

SQL Server admin

JCL/ISPF/COBOL

Ausbildung

Bachelor's degree in CS/IT

Tools

DB2 REORG

DB2 RUNSTATS

DB2 LOAD/UNLOAD

SQL Server

JCL

Jobbeschreibung

Wakefern Food Corp. is the largest retailer-owned cooperative in the United States and supports its co-operative members' retail operations, trading under the ShopRite, Price Rite Marketplace, The Fresh Grocer, Dearborn Market, Gourmet Garage, Fairway Market, and Di Bruno Bros.

Employing an innovative approach to wholesale business services, Wakefern focuses on helping the independent retailer compete in a big business world. Providing the tools entrepreneurs need to stay a step ahead of the competition, Wakefern’s co-operative members benefit from the company’s extensive portfolio of services, including innovative technology, private label development, and best-in-class procurement practices.

Summary

We are seeking a highly skilled DB2 Administrator (DBA) to provide technical leadership and operational support across enterprise database platforms spanning both legacy and modern technology environments. This role requires deep expertise in IBM DB2 for z/OS, DB2 LUW, and Microsoft SQL Server, with exposure to modern cloud-based data platforms and data modernization initiatives.

The ideal candidate will possess strong experience supporting mission-critical, high-volume transactional systems while helping guide the evolution of enterprise data platforms toward cloud-native and analytics-driven architectures, including PostgreSQL, Google Cloud Platform (GCP), and BigQuery.

Essential Functions

Database Administration & Operations

• Provide senior-level administration and operational support for IBM DB2 for z/OS, IBM DB2 LUW, Microsoft SQL Server, PostgreSQL, and cloud-based database platforms.
• Install, configure, upgrade, patch, monitor, and maintain enterprise database environments.
• Ensure database availability, reliability, security, and performance across supported platforms.
• Support backup, recovery, disaster recovery, and high-availability solutions.

Performance Optimization

• Analyze and tune database performance across large-scale production environments.
• Optimize SQL statements and application database interactions.
• Perform execution plan analysis and access path reviews.
• Develop and maintain effective indexing strategies.
• Manage statistics collection, database maintenance activities, capacity planning, and resource optimization.

Database Engineering & Support

• Design and implement database solutions supporting enterprise applications.
• Manage and maintain database objects including tables, indexes, views, stored procedures, packages, constraints, and security controls.
• Troubleshoot complex production issues and conduct root cause analysis.

Collaboration & Modernization

• Partner with application development, integration, infrastructure, and data engineering teams.
• Support enterprise modernization efforts involving migration and integration of legacy database platforms into cloud environments.
• Provide guidance on database architecture, governance, standards, and best practices.
• Evaluate emerging database technologies and recommend modernization strategies.

Additional Functions

• PostgreSQL administration and support.
• Google Cloud Platform (GCP), BigQuery, Cloud Storage, and cloud-native data services.
• Hybrid cloud and on-premises data architectures.
• Database migration, replication, and modernization programs.
• Enterprise ETL, data integration, and data pipeline technologies.
• Data warehousing and analytical processing environments.
• Database replication technologies.
• Database automation and monitoring tools.
• Infrastructure-as-Code (IaC) and cloud operations concepts.
• API-driven and event-driven data architectures.
• Collaboration with development teams on database design and application optimization.

Qualifications

• Bachelor's degree in computer science, Information Technology, or related field, or equivalent experience.
• 10+ years of enterprise database administration experience.
• Strong hands-on experience administering IBM DB2 for z/OS.
• IBM DB2 for z/OS architecture and administration.
• Experience with DB2 utilities including REORG, RUNSTATS, COPY, RECOVER, LOAD, and UNLOAD.
• SQL performance tuning and access path analysis.
• Working knowledge of z/OS, JCL, TSO/ISPF, and COBOL application environments.
• Extensive experience with DB2 LUW include database configuration, performance tuning, backup and recovery, and troubleshooting.
• Experience administering Microsoft SQL Server including installation and configuration, performance tuning, backup and restore, security and access management, production support, and troubleshooting.
• Advanced SQL skills with the ability to analyze complex workloads and optimize performance.
• Experience supporting highly available, mission-critical transactional systems.

Working Conditions & Physical Demands

• Availability to work a varied, flexible schedule to meet business demands
• Ability to monitor computer screens for long periods of time
• Ability to work a hybrid schedule as established by the division (4 days on-site, 1 day remote)

Core Competencies

• Communicate Effectively: Communicates thoughts and ideas in a well-organized manner, encouraging two-way communication.
• Build Relationships: Creates cross-functional partnerships through the development and maintenance of constructive and cooperative relationships.
• Stay Competitive: Demonstrates a mindset of continuous improvement while exhibiting passion and enthusiasm for their work.
• Embrace Change: Looks for new ways of working by supporting advancements in processes and technology.
• Develop You: Identifies and capitalizes on opportunities for personal and professional career growth.
• Drive for Results: Supports divisional and strategic objectives through achievement of work goals.

Compensation and Benefits

The salary range for this position is $125,000-175,000. Placement in the range depends on several factors, including experience, skills, education, geography, and budget considerations.

Wakefern is proud to offer a comprehensive benefits package designed to support the health, well-being, and professional development of our Associates. Benefits include medical, dental, and vision coverage, life and disability insurance, a 401(k) retirement plan with company match & annual company contribution, paid time off, holidays, and parental leave. Associates also enjoy access to wellness and family support programs, fitness reimbursement, educational and training opportunities through our corporate university, and a collaborative, team-oriented work