Dear Candidate

Greetings from TATA CONSULTANCY SERVICES LIMITED !!!

Required Skills# Experience in AWS – IBM DB2 database Administrator

Experience Range: 4-8 yrs

Work Location: Bangalore

Key Skills/Knowledge:

*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. TSA and HADR in cloud environments. Purescale implementation desired.

Responsibility of / Expectations from the Role

*Perform 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