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
- Bachelor's Degree or master's degree in the field of Computer Science or Information Systems or a related field.
- ID: #43597069
- State: New Jersey Southplainfield 07080 Southplainfield USA
- City: Southplainfield
- Salary: $DOB
- Job type: Contract
- Showed: 2022-06-24
- Deadline: 2022-08-22
- Category: Software/QA/DBA/etc