Location: Plano TX- (5 Days onsite & 24×7 Rotational)
Shift:- Rotational (Shift 1 (8 AM – 5 PM), Shift 2 (4 PM – 1 AM), Shift 3 (12 AM – 9 AM))
Job Description:
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.