DB2 mainframe DBA

03 Jul 2024

Vacancy expired!

IKCON TECHNOLOGIES INC delivers exceptional IT services and solutions that provide clients with definite edge over competitors and promoting highest standards of quality. We are currently looking for a [DB2 mainframe DBA] with one of our clients in, [Remote]. If you are actively looking for opportunities, please send us your updated resume with your contact details. JOB TITLE DB2 mainframe DBA CITY Remote STATE Remote TAX TERMS W2/C2C EXPERIENCE 7+ Years INTERVIEW MODE Phone/Video Job Description:

  • Candidate with 7+ years of experience in Mainframe development using DB2 v9 / UDB
  • Write embedded DB2 SQL queries
  • Analyse the existing DB2 based code
  • Participate in DB2 query performance optimization
  • Ensure integrity, availability, and performance of DB2 database systems by providing technical support and maintenance.
  • Monitor database performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities for database system.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Develop and maintain patches for database environments.
  • Assist in implementation of new features and program fixes in databases.
  • Maintain database security and disaster recovery procedures.
  • Perform troubleshooting and maintenance of multiple databases.
  • Monitor databases regularly to check for any errors such as existing locks and failed updates.
  • Oversee utilization of data and log files.
  • Manage database logins and permissions for users.
  • Supporting client and internal requests for building all types of DB2 objects.
  • Analyzing new versions of DB2 for functionality that can improve client's systems
  • Refreshing test data for whole environments
  • Reorganization of application data
  • Space calculations for new objects and environments
  • Reviewing, tuning of internal DB2 buffer pools and SQL code
  • DR recovery of application objects
  • Troubleshooting and solving production database issues
MINIMUM QUALIFICATIONS
  • Bachelor's Degree or master's degree in the field of Computer Science or Information Systems or a related field.