Mainframe DB2 DBA Developer

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 Sign in to set job alerts for “Database Administrator” roles.

Research Database Administrator - Computing Service

Richfield, OH $120,000.00-$145,000.00 3 weeks ago Cleveland, OH $113,825.40-$146,919.75 6 days ago Cleveland, OH $113,825.40-$146,919.75 15 hours ago Cleveland, OH $80,000.00-$110,000.00 3 hours ago Senior Oracle Database / E-Business Suite Engineer

Cleveland, OH $113,825.40-$146,919.75 2 weeks ago Cleveland, OH $140,000.00-$180,000.00 2 hours ago Greater Cleveland $130,800.00-$241,000.00 6 days ago Data Architect/Infrastructure Engineer - Data and Automation (Neo4j Clustering, Linux)

Strongsville, OH $65,000.00-$179,400.00 1 month ago Greater Cleveland $49.29-$73.94 21 hours ago Greater Cleveland $75,000.00-$115,000.00 5 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr