[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