Senior DB2 Database Administrator

3 days ago


Edison, New Jersey, United States Cloudingest Inc Full time

Mainframe DB2 DBA

Onsite – Edison, NJ (Hybrid)

Job Description ::

  1. Execute routine program walk-throughs before all code change releases
  2. Provide support to development teams, including handling error codes, binding programs to specific schemas, and addressing data integrity issues in the development environment. Additional activities may include, physical modeling, logical modeling, and supporting performance issues.
  3. Enhance SQL performance monitoring and tuning

    .

Activity Details

1. Execute Program Walk-throughs

i. Analyze and scan program code changes (e.g., COBOL, DB2 components, etc.) and SQL statemetns for efficiency, accuracy, and cost optimization

ii. Provide feedback to development team before deploying to production

iii. Streamline the SDLC process for code releases

  1. Support Development team

    i. Maintain integrity of development and production environments (approximately 10 environments, 10 schemas)

    ii. Manage space constraints/volume concerns

    iii. Populate development environment from the provided flash copies

    iv. Monitor utilities and control of database objects

  2. Utilize ticketing process and the L2 support foundation to handle development issues

    i. Participate in regular team stand-up meetings

  3. Utilize Wakefern formalized defect and issue tracking system

  4. Perform data archiving and quarterly purges

  5. SQL performance monitoring and tuning

    i. Analyze traces and identify programs that have exceeded percentage thresholds for average CPU utilization

    ii. Optimize monitoring of DB2 using Mainview and other tools

    iii. Streamline alert messaging

    iv. Reduce log fatigue

    v. Proactive measurement of scalability and data volume

    vi. Support the documentation of all net new processes and tools developed during the program and establish a centralized knowledge repository to ensure continuity and broader team enablement.

Job Type: Contract

Pay: $ $80.00 per hour

Expected hours: 40 per week

Work Location: In person


  • Mainframe DB2 DBA

    4 days ago


    Edison, New Jersey, United States Bluegrass Tek, LLC Full time

    Mainframe DB2 DBAOnsite – Edison, NJ (Hybrid)Job Description ::Execute routine program walk-throughs prior to all code change releasesProvide support to development teams, including handling error codes, binding programs to specific schemas, and addressing data integrity issues in the development environment. Additional acitivites may include, physical...


  • Edison, New Jersey, United States JFK Johnson Rehabilitation Institute Full time

    IT Database Administrator IV - Digital Technology ServicesHMH HOSPITALS CORPORATION Edison, New JerseyApplyRequisition # ShiftDayStatusFull Time with BenefitsOverviewOur team members are the heart of what makes us better.AtHackensack MeridianHealthwe help our patients live better, healthier lives — and we help one another to succeed. With a culture rooted...


  • Edison, New Jersey, United States MindTechHub Full time

    Position Title: Administrative Clerk Location: Edison, NJ 08817Job SummaryThe Administrative Clerk will provide administrative and operational support through data entry, document management, and customer service. The role involves handling correspondence, maintaining accurate records, and ensuring efficient processing of incoming information and...


  • Edison, New Jersey, United States Brillio Full time $147,840 per year

    About Brillio: Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their...


  • Edison, New Jersey, United States CDM Smith Full time

    Why CDM Smith?Check out this video and find out why our team loves to work hereJoin Us CDM Smith – where amazing career journeys unfold.Imagine a place committed to offering an unmatched employee experience. Where you work on projects that are meaningful to you. Where you play an active part in shaping your career journey. Where your co-workers are...


  • Edison, New Jersey, United States Hackensack Meridian Health Full time $60,000 - $80,000 per year

    Overview:Our team members are the heart of what makes us better.At Hackensack Meridian Health we help our patients live better, healthier lives — and we help one another to succeed. With a culture rooted in connection and collaboration, our employees are team members. Here, competitive benefits are just the beginning. It's also about how we support one...


  • Edison, New Jersey, United States Modivcare Full time

    Are you passionate about making a difference in people's lives? Do you enjoy working in a service-oriented industry? If so, this opportunity may be the right fit for youModivcare is looking for an Administrative Assistant to partner with the General Manager on clerical and technical support for the office. You will offer a variety of office and...


  • Edison, New Jersey, United States Sunrise Senior Living Full time $80,000 - $120,000 per year

    :When you join Sunrise Senior Living, you will be able to use your unique skills to empower residents to live longer, healthier, and happier lives. Not only will you build meaningful relationships with residents, their families, and team members alike, you will also gain joy in serving others and deep fulfillment in your work. Explore how you can follow your...


  • Edison, New Jersey, United States Sunrise Senior Living Full time $80,000 - $120,000 per year

     When you join Sunrise Senior Living, you will be able to use your unique skills to empower residents to live longer, healthier, and happier lives. Not only will you build meaningful relationships with residents, their families, and team members alike, you will also gain joy in serving others and deep fulfillment in your work. Explore how you can follow...


  • Edison, New Jersey, United States JFK Johnson Rehabilitation Institute Full time

    Administrative Fellowship ProgramHMH HOSPITALS CORPORATION Edison, New JerseyApplyRequisition # ShiftDayStatusFull Time with BenefitsOverviewOur team members are the heart of what makes us better.AtHackensack MeridianHealthwe help our patients live better, healthier lives — and we help one another to succeed. With a culture rooted in connection and...