Mainframe DB2 DBA Developer

The Dignify Solutions, LLC; Cleveland (OH); On-site; USD 49,000 - 152,000; Full time

Job summary

A leading IT Services and IT Consulting company in Cleveland is seeking a Database Administrator. The role involves ensuring the integrity and performance of DB2 database systems through upgrades, installations, and technical support. Ideal candidates will have strong DB2 and SQL knowledge, with a focus on improving database efficiency and troubleshooting issues.

Qualifications

• In-depth knowledge of monitoring application threads and tuning SQL queries.
• Experience with DB2 command interface and stand-alone utilities.
• Good knowledge of disaster recovery processes.

Responsibilities

• Perform DB2 upgrades and system parameter changes.
• Install and manage DB2 and third-party products.
• Ensure integrity, availability, and performance of DB2 database systems.

Skills

DB2 Upgrades

SQL Tuning

Disaster Recovery

Database Management

SMP/E Maintenance

Tools

DB2 Command Interface

Log Analyzer

BMC utilities

Job description

1 month ago Be among the first 25 applicants

• 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.
• 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Other

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at The Dignify Solutions, LLC by 2x

Get notified about new Database Administrator jobs in Cleveland, OH.

Cleveland, OH $49,980.00-$69,972.00 5 hours ago

Beachwood, OH $75,000.00-$110,000.00 3 weeks ago

Cleveland, OH $111,000.00-$152,000.00 1 day ago

Greater Cleveland $122,400.00-$153,000.00 1 day ago

Strongsville, OH $55,000.00-$152,375.00 7 hours ago

Cleveland, OH $70,000.00-$85,000.00 1 week ago

Informatica Software Engineer - Oracle SQL/PLSQL

Strongsville, OH $55,000.00-$152,375.00 4 days ago

Cleveland, OH $130,000.00-$220,000.00 1 week ago

Cleveland, OH $150,000.00-$200,000.00 1 week ago

Data Architect/Infrastructure Engineer - Data and Automation (Neo4j Clustering, Linux)

Strongsville, OH $65,000.00-$179,400.00 2 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.