Mainframe DB2 Database Administrator
N
Northramp LLCFinancial Systems
Texas, United States. Kansas, United States. Missouri, United States. Virginia, United States. Maryland, United States. Washington, District of Columbia, United StatesFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- SQLRESTful APIs
Requirements
- 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.
- Experience with banking, financial, or loan processing systems (Desired).
- Experience with Java, ASP, Cobol, JCL, and legacy technologies (Desired).
- Experience with web service design and development (SOAP/REST) (Desired).
- Familiarity with batch, asynchronous, and event-driven integrations (Desired).
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 and monitoring resources.
- 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.
- Define and maintain backup and recovery strategies and perform DR drills.
- Define enterprise application architecture inclusive of systems, web services, integration patterns, and data models.
View Full Description & ApplyYou'll be redirected to the employer's site
