DB2 DBA

Job Key Responsibilities:

Skills Needed – DB2, Production Support, Monitoring, L1, L2, L3, DB Joins, LEW
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.