Mainframe DB2 DBA Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

The Dignify Solutions, LLC · 4 weeks ago

Mainframe DB2 DBA Developer

positionCleveland, OH
timeFull-time
remoteOnsite
seniorityMid Level

The Dignify Solutions, LLC is a company focused on providing innovative solutions, and they are seeking a Mainframe DB2 DBA Developer. The role involves performing DB2 upgrades, managing database systems, and ensuring integrity, availability, and performance of DB2 databases.

Bookkeeping and PayrollHuman ResourcesRecruitingStaffing AgencyTraining

Responsibilities

Perform DB2 upgrades, migrate from older version to newer version DB2, reviewing the enhancements and activating the function level, make online and offline system parameter (DSNZPARMs) changes
Should have good knowledge on SMP/E RSU maintenance process (Receive/Apply/Accept/Restore), applying maintenance through SMP/E
Installation and management of DB2 and associated third party products
Configure and manage DB2 in a parallel sysplex environment
Develop innovation, strategies, processes and best practices in software management
Creating Database objects, Tablespaces, Tables, Views, Indexes etc
Coordinating with application team for design related issues, object changes
Experience with DR (Disaster Recovery), adhere to process and security compliance
Experience in Online utility: Running Reorgs, unload, load and Runstats, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities and troubleshooting restricted object to RW
Ensure integrity, availability and performance of DB2 database systems by providing technical support and Maintenance
Ability to craft and alter of DB2 object according to custom's requirement (Ex: Database, Table space, Table, Index, etc.)
Generate reports for performance analysis when required, run explain for the queries identified and review the results, perform SQL tuning if required
In-depth knowledge on monitoring the application threads, tuning the SQL queries, making modifications to the query for better performance
Installing third party tools in DB2. Applying maintenance and providing support for those tools
Troubleshoot and solving production database issue
Good hands-on experience with DB2 command interface (familiar with other command), Stop/Start Databases, display command, cancel thread and term utility
Proficient in Stand-alone utilities: DSNJU003 and DSNJU004, DSNJ003 to change DB2 BSDS, DSNJU004 to print BSDS. Trained with DSN1COPY
Ability to provide Grants to users for appropriate groups/authorities, familiar with DB2 privileges
Working knowledge of SQL, knows to use query to check catalog table and find necessary details for system usage
Experience with replication from Mainframe to other RDBMS is a plus
Experience on tools like Log analyzer, BMC Apptune, Catalog/Change manager, BMC utiities, CA sysview for DB2, QMF , Omegamon is an advantage

Qualification

DB2 managementDB2 upgradesSMP/E maintenanceSQL tuningDisaster RecoveryDatabase object creationPerformance analysisSoft skills

Required

Perform DB2 upgrades, migrate from older version to newer version DB2, reviewing the enhancements and activating the function level, make online and offline system parameter (DSNZPARMs) changes
Should have good knowledge on SMP/E RSU maintenance process (Receive/Apply/Accept/Restore), applying maintenance through SMP/E
Installation and management of DB2 and associated third party products
Configure and manage DB2 in a parallel sysplex environment
Develop innovation, strategies, processes and best practices in software management
Creating Database objects, Tablespaces, Tables, Views, Indexes etc
Coordinating with application team for design related issues, object changes
Experience with DR (Disaster Recovery), adhere to process and security compliance
Experience in Online utility: Running Reorgs, unload, load and Runstats, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities and troubleshooting restricted object to RW
Ensure integrity, availability and performance of DB2 database systems by providing technical support and Maintenance
Ability to craft and alter of DB2 object according to custom's requirement (Ex: Database, Table space, Table, Index, etc.)
Generate reports for performance analysis when required, run explain for the queries identified and review the results, perform SQL tuning if required
In-depth knowledge on monitoring the application threads, tuning the SQL queries, making modifications to the query for better performance
Installing third party tools in DB2. Applying maintenance and providing support for those tools
Troubleshoot and solving production database issue
Good hands-on experience with DB2 command interface (familiar with other command), Stop/Start Databases, display command, cancel thread and term utility
Proficient in Stand-alone utilities: DSNJU003 and DSNJU004, DSNJ003 to change DB2 BSDS, DSNJU004 to print BSDS. Trained with DSN1COPY
Ability to provide Grants to users for appropriate groups/authorities, familiar with DB2 privileges
Working knowledge of SQL, knows to use query to check catalog table and find necessary details for system usage

Preferred

Experience with replication from Mainframe to other RDBMS is a plus
Experience on tools like Log analyzer, BMC Apptune, Catalog/Change manager, BMC utilities, CA sysview for DB2, QMF, Omegamon is an advantage

Company

The Dignify Solutions, LLC

twittertwitter
company-logo
The Dignify Solutions with Global Capabilities and Local Excellence – has combined experience of 30 +years in Client Services/ Engagement/ Relationship/ Partnership, Sales/ Account Management, Service Delivery, Recruiting, Staffing and Talent Acquisition for the whole gamut of skillsets in Information Technology (Digital Transformation, Artificial Intelligence, Machine Learning and other business domains).
location
San Francisco, California, USA
people-size51-200 employees
web-link
https://thedignify.com

Funding

Current Stage
Growth Stage
Company data provided by crunchbase