Job Role: DB2 DBA

Location: Plano TX- (5 Days onsite & 24x7 Rotational)

Shift: Rotational (Shift 1 (8 AM 5 PM), Shift 2 (4 PM 1 AM), Shift 3 (12 AM 9 AM))

Duration: 12 Months

SUMMARY:

• Skills Needed DB2, Production Support, DB Joins, LUW
• Offer DBA DB2 support for application development team.
• 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 enhancement and modification as per the requirements.
• Perform database recovery and backup tasks on daily and weekly basis.
• Develop and maintain patches for database environments.
• Identify and recommend database techniques to support business needs.
• 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.
• Resolve any database issues in accurate and timely fashion.
• 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.