Senior DB2 & Cloud Data Platform Admin (Hybrid)

Wakefern Food Corp.

Edison (NJ)

Hybrid

USD 125,000 - 175,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, dental, vision

401(k) with company match

Paid time off

Parental leave

Wellness programs

Job summary

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

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

Responsibilities

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.