Mainframe DB2 Database Administrator

3 weeks ago
Full-time
Senior
Software Development
Northramp

Northramp

Northramp is a leading IT consulting company that offers FEDPASS™ for enhanced visibility and control over IT services. With SPARCH technology, they combine custom MS .NET code and MS SQL Server for reliable solutions. Their services focus on managing ...

IT Services
51-250
Founded 2012

Description

  • Manage, configure, and maintain DB2 for z/OS databases across development, test, and production environments.
  • Refresh datasets and environments to support testing cycles and project work.
  • Develop database conversion routines to support new projects and modernization efforts.
  • Tune SQL queries, identify bottlenecks, and monitor resource consumption to improve performance.
  • Plan and execute DB2 utilities such as REORG, RUNSTATS, LOAD, UNLOAD, COPY, and REBUILD INDEX.
  • Implement structural database changes, stored procedure modifications, and bind plans/packages.
  • Research and resolve abends, performance issues, and production defects.
  • Develop and execute SQL to correct data issues as needed.
  • Define and maintain backup and recovery strategies, perform DR drills, and protect data integrity.
  • Define enterprise application architecture, provide development support, and conduct code and architecture reviews.

Requirements

  • Experience performing IT engineering tasks of moderate complexity under minimal supervision.
  • Strong hands-on DB2 database administration experience with DB2 for z/OS.
  • Experience in system architecture and application design.
  • Experience with both mainframe and distributed computing platforms.
  • Ability to troubleshoot and resolve complex technical problems.
  • Excellent verbal and written communication skills.
  • Ability to collaborate across teams and maintain professional client-facing interactions.
  • Experience with banking, financial, or loan processing systems is preferred.
  • Experience with Java, ASP, Cobol, JCL, and related legacy technologies is preferred.
  • Experience with web service design and development (SOAP/REST) is preferred.
  • Familiarity with batch, asynchronous, and event-driven integrations is preferred.
  • Experience supporting system modernization or cloud-integration efforts is preferred.
  • Successful completion of a client-required background investigation and suitability determination is required.
  • Ability to obtain and maintain a federal security clearance may be required.

Benefits

  • Health care coverage including medical, dental, and vision.
  • Retirement plan options including 401(k) and IRA.
  • Life insurance coverage including basic, voluntary, and AD&D.
  • Paid time off for vacation, sick time, and public holidays.
  • Family leave, including maternity and paternity leave.
  • Short-term and long-term disability coverage.
  • Training and development opportunities.
  • Work-from-home flexibility.
  • Wellness resources.
  • Employee bonus programs.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

AI Web Designer & Architect | Vibe Coding (Lovable & Higgsfield)

Puulse Marketing 11-50 Professional Services

Remote full-time independent contractor role at an AI-first web design team, responsible for building, animating, and launching client websites end to end using Lovable and Higgsfield.

14 hours, 16 minutes ago

Senior PHP Engineer with strong DB experience

Intetics 1K-5K Internet Software & Services

Intetics Inc. is seeking a Senior PHP Engineer to develop, maintain, and enhance web applications for a cybersecurity-focused client and its risk-based vulnerability management platform.

Agile AWS Cybersecurity Linux PHP Scrum SQL
14 hours, 31 minutes ago

MDM Data Specialist (L2)

Twilio 5K-10K Diversified Telecommunication Services

Twilio is hiring a remote MDM Data Specialist (L2) in India to steward enterprise master data, strengthen data quality, and support governance across core business domains.

Databricks GCP Snowflake SQL Twilio
1 day, 13 hours ago

Product Data Engineer

Anduril Industries 1K-5K Aerospace & Defense

Anduril Industries is hiring a Product Data Engineer to support configuration management across complex defense programs, maintaining accurate product data from requirements through manufacturing and sustainment.

Confluence JIRA
1 day, 14 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers