Mainframe DB2 DBA
PROLIM Corporation
ob Description
Key Responsibilities
• Manage DB2 objects (databases, tablespaces, tables, indexes)
• Execute DB2 commands (STOP/START, DISPLAY, thread cancel/termination)
• Run DB2 utilities (REORG, RUNSTATS, COPY/RECOVER, LOAD/UNLOAD, REPAIR)
• Perform BSDS updates using DSNJU003/DSNJU004
• Support DB2 upgrades, migrations, SMP/E maintenance
• Use ISV tools (BMC, CA, IBM utilities)
• Monitor and tune performance using DB2 catalog and tools
• Troubleshoot DB2 and application issues
• Manage grants, privileges, and security
• Follow ITIL processes (Incident, Problem, Change, Configuration)
• Support DR planning and execution
Required Skills
• 4-6 years of Mainframe DB2 DBA or System Programmer experience
• Strong Mainframe & DB2 architecture knowledge
• Proficiency in JCL and z/OS operations
• Hands-on experience with DB2 utilities and SMP/E
• Experience with BMC/CA tools
• Strong SQL and catalog analysis skills
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Mainframe DB2 DBA in Detroit, MI vacancy
- ...MQ integration, Parallel Sysplex, high availability environments Programming Languages JCL, COBOL, Assembler, REXX, CLIST, PL/I, SQL (DB2 integration), scripting for automation Database Definition Activities Backup & Recovery / Reorganization Disaster recovery, Image...Mainframe
- Stefanini is seeking a Mainframe Engineer in Dearborn, MI for an onsite role. The candidate will design, develop, test, and maintain mainframe... ...building high‑level architecture, writing JCL/COBOL/SQL on IBM DB2, and implementing test strategies and security practices. 6+...Mainframe
- ...Senior Vice President, Mainframe DB2 or IMS Systems Programmer About the Company Large enterprise needing expert DB2 mainframe systems support and 24x7 coverage. Industry Financial Services Type Privately Held About the Role The Company is seeking...MainframeWork experience placementWeekend work
- ...candidates will possess skills in various technologies, programming languages, and software development methodologies. Experience with JCL and COBOL is essential, as well as a strong understanding of databases including IBM DB2 and PostgreSQL. #J-18808-Ljbffr Stefanini, IncMainframeLong term contract
- Stefanini North America and APAC is seeking a Mainframe Engineer to design, develop, and maintain software applications in Dearborn, MI. This role involves engaging with customers to understand their needs, handling complex problem-solving, and working with a cross-functional...Mainframe
- PDSSOFT INC. is looking for a skilled database professional in Dearborn, Michigan, with expertise in HDAM, HIDAM and IMS utilities. The role requires proficiency in various programming languages, including JCL and COBOL. The candidate will perform critical database definition...Mainframe
- ...located in Detroit, Michigan. The role focuses on testing over 1600 mainframe jobs in an automated test setup. Ideal candidates will have 7+ years of mainframe experience, strong skills in COBOL, JCL, and DB2, as well as excellent analytical problem solving abilities. This...Mainframe
- ...2E) Testing Team, where the primary focus is testing over 1600+ mainframe jobs in an automated test that approximates production job schedules... ...3 Skills/Experience 1. Strong mainframe skillset: COBOL, JCL, DB2, IMS (7 years minimum experience). 2. Strong analytical/problem...Mainframe
- ...Senior Mainframe Software EngineerWe are seeking a Senior Mainframe Software Engineer to design, develop, test, maintain, and support enterprise... ...will have extensive experience in Mainframe development (COBOL, DB2, CICS, JCL, z/OS) while also embracing modern development...Mainframe
Apex Systems
Dearborn, MI5 days ago - Job-ID32426226Reference26-01925 Job Title: (Mainframe Cobol, CICS Developer)About Kyyba:Founded in 1998 and headquartered in Farmington Hills... ...) for critical operational tasks.Write complex SQL queries for DB2 and perform database design and optimization. Ensure data...MainframeRemote work
$186k - $257k
...accelerate large scale technology transformation by turning decades-old mainframe code into agile, cloud-native systems. This role blends deep... ..., PL/I, HLASM, JCL, etc.* Knowledge of z/OS fundamentals: CICS, DB2, VSAM, batch scheduling, system utilities.* Experience...MainframeTemporary workLocal area- ...performance through SLA-driven support. Hybrid environment combining modern Java applications with legacy Mainframe. Key Technologies Angular & React COBOL, JCL, DB2 GCP, Red Hat Container Platform Tekton, GitHub Actions Splunk, Dynatrace BigQuery and DB2 databases...Mainframe
- ...Analysis, Software Testing, Batch Processing, Requirements Analysis, IBM DB2, SQL, TSO/ISPF, REST APIs, Customer Information Control System (CICS), Application Support, COBOL, Program Analysis, Mainframe Systems, JSON, ApplicationTesting Experience: 10+ years of hands-on...Mainframe
RIT Solutions
Dearborn, MI2 days ago - ...this job) Because the req explicitly mentions host-based , candidates often work with: Mainframe environments (z/OS concepts), COBOL/JCL , CICS/IMS , DB2 Batch scheduling tools (CA-7 / Control-M, etc.) File-based integrations (VSAM / flat files...MainframeRemote work
3B Staffing LLC
Detroit, MI1 day ago $115.5k - $218.1k
...teams of Architects or Senior Engineers in an enterprise setting.Mainframe Familiarity: Strong conceptual and integration experience with... ...modern microservices and legacy Mainframe systems (e.g., IBM z/OS, DB2, CICS). Architect secure API enablement layers and event-driven...MainframeImmediate startFlexible hoursShift work$65 - $70 per hour
...to write structured jobs. Debug JCL errors. Understand Schedule IDs. Mainframe DB - Understand relational databases. Understand, code and debug SQL statements. Understand keys and indexes. IBM DB2 - Understand relational databases. Understand, code and debug SQL statements...MainframeContract workFlexible hours- ...Senior Discovery Database Administrator (DBA)Employment Type: Full-Time, Executive-LevelCGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced and hard-working team to assist with any legal accounts. As a Senior Discovery Database Administrator...Full timeFor contractors
Contact Government Services LLC
Detroit, MI2 days ago - ...current industry standard PC applications and systems (e.g., Excel, Word, etc.).Working knowledge of PeopleSoft general ledger and mainframe systems.General knowledge of Generally Accepted Accounting Principles (GAAP).Other related skills and/or abilities may be required...Mainframe
- A government services company based in Detroit is looking for a dedicated Discovery Database Administrator to join their team. You will be responsible for providing comprehensive database administration support, particularly for Microsoft SQL Server, optimizing database...Full time
- ..., analytical experience, ability to produce statistical information from conceptual needs, and working with PC application and/or mainframe systems preferred. Effective verbal and written communication skills. Ability to lead and contribute to process improvement programs...Mainframe
Strategic Staffing Solutions
Detroit, MI1 day ago $110.7k - $218.3k
Position Summary Our Deloitte Strategy & Transactions team helps guide clients through their most critical moments and transformational initiatives. From strategy to execution, this team delivers integrated, end-to-end support and advisory services covering valuation...Local areaVisa sponsorship- ...Testing, Z/OS, AIPGEE, Batch Processing, Requirements Analysis, SQL, IBM DB2, GitHub, TSO/ISPF, REST APIs, Customer Information Control System (CICS), Application Support, Program Analysis, COBOL, Mainframe Systems, JSON, Application Testing, Agile Software Development,...MainframeImmediate startFlexible hours
- ...for data center migration strategy and key components of a data center migration Ability to discover application characteristics of mainframe, midrange, and Wintel applications that will help define migration groups. Experience assessing applications and application...MainframeFull time
SonSoft
Dearborn, MI5 days ago - ...work primarily onsite in Dearborn, MI. This role involves application design and development support activities for B2Bi, Web, and Mainframe applications. The ideal candidate has over 5 years of experience in supply chain management and integration solutions, and...Mainframe
- ...environment including experience with scheduling appointments and schedule maintenance. Analytical ability required preparing physicians' schedules is preferred. Familiarity with computer applications in a PC and mainframe environment is preferred. Henry Ford HospitalMainframeFull timeWork at officeShift workWeekend workDay shift
- ...Applicants must be able to work directly for Artech on W2 Preferred Skills & Qualifications Familiarity with web and mainframe applications Mainframe Systems experience Experience with GCP, Unix, Network Protocols & Standards, Session Initiation Protocols...MainframeWork experience placementImmediate start
Artech
Dearborn, MI5 days ago - Senior Manager - Client Services | Delivering High-Impact Professional Services for Strategic Clients Hiring: Teamcenter DBA/Admin or implementation (Contract) Location: Michigan, USA Type: Contract - 12 Months + Ext Experience: 5-10 years Security Clearance: Must clear...Contract work
- ...containerization, and DevOps. Ability to describe data center service framework design. Ability to discover application characteristics of mainframe, midrange, and Wintel applications that will help define migration groups. Experience assessing applications and application...MainframePermanent employmentContract workFor contractorsImmediate start
Procom Consultants Group
Dearborn, MI5 days ago - ...managing database schemas (e.g., SQL Server, Postgres), and integrating with complex, potentially legacy, DoD systems including mainframes and cloud environments (MS Azure, WS GovCloud, Azure SQL). Mastery level experience in software testing and documentation to include...MainframeFull timeRemote work
Phoenix Cyber
Detroit, MI1 day ago $19 per hour
...instructions. For this position, employees will be responsible for banding steel coils, banding small steel cuts skids, operating a basic mainframe computer to access instructions, and read and follow these instructions on a job-to-job basis. Let’s go to work! Apply online...MainframeWeekly payWorkbox Staffing
Taylor, MI18 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Mainframe DB2 DBA. Be the first to apply!
