DB2 LUW Admin

Job Description

Must Have Skills:-

• IBM DB2 LUW- i.e Database administrator of DB2.Experience on installation of different versions of DB2 on Redhat Linux Environment
• Good knowledge of Linux
• Scheduling shell scripts on LINUX environments
• Good experience in generating DDL's using DB2LOOK command on existing database and its objects.
• Use RUNSTATS, REORGCHK and REORG to enhance application performance.
• Good knowledge on data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions.
• Tuning using db2advisor and db2explain tools.
• Database performance tuning by configuring database and DBM Parameters.
• Configuring the HADR and monitoring the HADR databases. Pure scale implementation desired.

Responsibilities:-

• Performs day-to-day administration of DB2 databases, including security, backup/recovery, capability planning and performance tuning.
• Perform feasibility studies for installation
• Monitor database performance and recommend improvements for operational efficiency.
• 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.
• 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.
• Manage database logins and permissions for users
• Well versed with DB restores including Redirected restores on production and wherever required