[Remote] Mainframe DB2 Database Administrator

Note: The job is a remote job and is open to candidates in USA. Northramp is seeking a Mainframe DB2 Database Administrator and Application Architect to support complex enterprise systems. This role involves managing DB2 for z/OS databases, optimizing system performance, and collaborating with technical teams to ensure alignment with organizational standards.

Responsibilities

• Manage, configure, and maintain DB2 for z/OS databases across Development, Test, and Production
• Refresh datasets and environments to support testing cycles
• Develop database conversion routines to support new projects or modernization efforts
• Optimize system and application performance by tuning SQL queries, identifying bottlenecks, and monitoring resource consumption
• Plan and execute DB2 utilities such as REORG, RUNSTATS, LOAD, UNLOAD, COPY, and REBUILD INDEX
• Implement structural database changes (DDL), stored procedure modifications, and bind plans/packages
• Research and resolve abends, performance issues, and production defects
• Develop and execute SQL as needed to correct data issues
• Define and maintain backup and recovery strategies, perform DR drills, and ensure the integrity of data assets
• Define enterprise application architecture inclusive of systems, web services, integration patterns, and data models
• Provide development support and mentorship to technical teams, conducting code and architecture reviews as needed
• Produce technical documentation including data models, process flows, and specifications for system changes
• Ensure solutions align with architectural standards, security requirements, and system performance goals
• Collaborate closely with analysts, developers, technical leads, and stakeholders on system design, task execution, quality, and delivery timelines
• Communicate technical concepts clearly to both technical and non-technical audiences
• Support cross-functional teams by providing subject matter expertise during planning, development, and troubleshooting

Skills

• Experience performing IT engineering tasks of moderate complexity under minimal supervision
• Strong DB2 database skills with hands-on database administration experience
• 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 work collaboratively across teams and maintain professional client-facing interactions
• Experience with banking, financial, or loan processing systems
• Experience with Java, ASP, Cobol, JCL, and related legacy technologies
• Experience with web service design and development (SOAP/REST)
• Familiarity with batch, asynchronous, and event-driven integrations
• Experience supporting system modernization or cloud-integration efforts

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Family Leave (Maternity, Paternity)
• Short Term & Long Term Disability
• Training & Development
• Work From Home
• Wellness Resources
• Employee Bonus Programs

Company Overview