Mainframe DB2 Database Administrator

5 hours, 51 minutes 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

Senior Clinical Data Manager (Mexico)

Precision Medicine Group 251-1K Pharmaceuticals

Precision Medicine Group is hiring a Senior Clinical Data Manager in Mexico to establish and oversee clinical trial data operations across assigned studies from startup through database lock.

54 minutes ago

Data Quality Professional

Harbor (YC P26) 1-10 information technology & services

Harbor is hiring remote Data Quality Professionals to support its Managed Services team by maintaining accurate client data that helps law firms and other clients with business development and relationship management.

2 hours, 19 minutes ago

Senior Clinical Data Manager (Mexico)

Precision For Medicine 1K-5K Pharmaceuticals

Precision Medicine Group is hiring a Senior Clinical Data Manager in Mexico to establish and oversee clinical data operations for assigned clinical trial projects across Latin America.

3 hours, 23 minutes ago

Clinical Data Manager II/Senior Clinical Data Manager

Precision Medicine Group 251-1K Pharmaceuticals

Precision Medicine Group is hiring a Clinical Data Manager II or Senior Clinical Data Manager to manage clinical trial data activities for assigned global projects from study start-up through database lock.

4 hours, 1 minute 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