Mainframe DB2 systems programmer jobs in United States
cer-icon
Apply on Employer Site
company-logo

BridgeFlair LLC · 1 day ago

Mainframe DB2 systems programmer

positionUnited States
timeContract
remoteRemote
senioritySenior Level, Lead/Staff
date10+ years exp

BridgeFlair LLC is seeking a Mainframe DB2 Systems Programmer with extensive experience in managing and upgrading DB2 systems. The role involves responsibilities such as database administration, performance tuning, and ensuring security compliance for DB2 environments.

AnalyticsCloud Data ServicesInformation TechnologyRecruiting
check
H1B Sponsor Likelynote

Responsibilities

Upgrade/Migrate DB2 Versions to newer versions
Regularly applying PTFS/APARS if required
Manage DB2 IVS Products and upgrade to supported versions if required
Managing system catalogs
Manage application data and database environments, performing reorganizations when required to optimize performance
Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc
Database and related object security – manage user ids, rights and privileges
DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning
Physical database definition (DDL) and understanding of logical database design
Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades
Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades
Implement DBDC (CICS, DB2, or IMS) security compliance corrections
Monitoring – threads, table space and index spaces
Monitoring instances for events and resolution/escalations
Performance tuning – Database and SQL tuning
DB2 recycle
DB2 Image copy (full/incremental)
Database creation
Grant/revoke of authorities
DB2 archive logs
Having experience of DR setup through various synch methods
Build and maintenance of database and related objects like table space, tables, indexes, views, triggers etc

Qualification

DB2 administration on z/OSDB2 performance tuningDatabase security managementUpgrade/Migrate DB2 VersionsPhysical database definition (DDL)DBDC software installsUpgradesMonitoring instancesDatabase creationGrant/revoke authoritiesDB2 archive logs

Required

Minimum 10 to 20 Years of Experience
Functional experience is required with the following technologies:
Upgrade/Migrate DB2 Versions to newer versions
Regularly applying PTFS/APARS if required
Manage DB2 IVS Products and upgrade to supported versions if required
Managing system catalogs
Manage application data and database environments, performing reorganizations when required to optimize performance
Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc
Database and related object security – manage user ids, rights and privileges
DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning
Physical database definition (DDL) and understanding of logical database design
Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades
Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades
Implement DBDC (CICS, DB2, or IMS) security compliance corrections
Monitoring – threads, table space and index spaces
Monitoring instances for events and resolution/escalations
Performance tuning – Database and SQL tuning
DB2 recycle
DB2 Image copy (full/incremental)
Database creation
Grant/revoke of authorities
DB2 archive logs
Having experience of DR setup through various synch methods
Build and maintenance of database and related objects like table space, tables, indexes, views, triggers etc

Company

BridgeFlair LLC

twittertwitter
company-logo
BridgeFlair LLC is a leading provider of technology and staffing solutions for IT, Security, Engineering, and Interactive Design disciplines servicing startups to enterprise clients, nationally.
dateFounded in 2015
location
Irving, Texas, USA
people-size51-200 employees
web-link
https://bridgeflair.com

H1B Sponsorship

BridgeFlair LLC 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 (22)
2024 (8)

Funding

Current Stage
Growth Stage
Company data provided by crunchbase