Mainframe Programmer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Acro Service Corp · 10 hours ago

Mainframe Programmer

Acro Service Corp is seeking a Mainframe Systems Programmer to support an integrated system with both client server and web applications. The role involves administering DB2 databases, managing application environments, and coordinating upgrades while ensuring data privacy and security.

ConsultingInformation TechnologyStaffing Agency
check
H1B Sponsor Likelynote
Hiring Manager
Saurabh Dixit
linkedin

Responsibilities

Administer DB2 database and subsystems
Monitor storage, support capacity planning, support securing ZOS resources, perform routine maintenance tasks, assist with data migration tasks, troubleshoot and resolve issues
Provide status reports as required by personnel
Log activity and time using time tracking software (Jira) daily
Document changes and follow protocols established. The consultant will work with IT teams and complete the assigned tasks in the scope of work in accordance with the IT standards and procedures
Manage, monitor, and tune DB2 subsystems and application environments
Clone databases and establish additional application environments
DB2 database and dataset backup and recovery
Refresh data, as needed
Clone and establish additional application environments, as needed
Aid in data conversion projects and extract data to staging environments, as needed
Maintain privacy and security of data
Support Application Lifecycle, application development tools, as needed
Migrate database changes
Document and update procedures and check list
Coordinate upgrades to ZOS, CICS, DB2, Administration tools, and application development tools
Coordinate DR testing and support data conversion and migration
Help IT teams with SQL review and tuning
Discuss business requirements and help with application and database design
Support CICS environments
Complete work and project tasks assigned
Consultant must provide daily / weekly status reports of the project with details on tasks and hours spent on each task, as well as: Overall completion status of the project in terms of the approved project plan and schedule
Document problems that were encountered and proposed/actual resolution
Document issues that need to be addressed
Document accomplishments during the period
Document activities to be accomplished during the next reporting period

Qualification

DB2 DBA experienceZOS platform experienceDB2 backupRecoverySQL tuningCOBOL/CICS programmingDB2 tools proficiencyDatabase designCommunication skillsDocumentation skillsTeam player

Required

Have the capability to perform the functions described in Scope of Work section
Have a bachelor's degree in computer science, or any other equivalent degree or equivalent years of relevant experience, with a minimum of seven (7) years of DB2 DBA experience in ZOS platform
Have experience administering complex DB2 environments with multiple subsystems
Be experienced working on ZOS tools and utilities - TSO, ISPF, SDSF, JCL, DFSORT, ICETOOL, DFDSS, DFSMS, DFHSM, OMVS, RACF, REXX/CLIST
Be experienced with using DB2 tools - SPUFI, QMF, DB2 Admin Tool or equivalent, DB2 Object Compare or equivalent, IBM Data Studio, OMEGAMON or equivalent, Query Monitor or equivalent
Be proficient with DB2 utilities and DB2 backup and recovery
Be able to work with the IT teams to understand the requirements and design databases
Be able to implement and migrate database changes
Have experience securing database objects
Have expertise in evaluating and tuning SQL and experience tuning DB2 subsystem
Have knowledge of DB2 Attachment facilities
Have good knowledge of COBOL/CICS/DB2 application programming environment
Have good communication, documentation and user requirement gathering skills
Be proficient in analyzing, debugging, and troubleshooting issues and ABENDs
Be a team player who can work with other contractors/consultants and permanent employees under a complex team structure

Preferred

Experience installing and configuring DB2 Connect
Experience working with Application Lifecycle Management tools like LCM, CHANGEMAN, ENDEVOR, SCLM, RTC, or similar
Experience working with data modeler tools like ERWIN or similar

Company

Acro Service Corp

twittertwittertwitter
company-logo
With singular global reach and agility, Acro Service Corporation offers you a unique integrated approach to staffing and consulting solutions.

H1B Sponsorship

Acro Service Corp has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (13)
2024 (24)
2023 (11)
2022 (11)
2021 (12)
2020 (19)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Chris Ehrhart, CCWP
VP - Global Supplier Partnerships
linkedin
leader-logo
Staci Dodson Beurer SPHR, SHRM-SCP, CSP
Chief People Officer (VP, HR)
linkedin
Company data provided by crunchbase