AWS - IBM DB2 Database Administrator

Job highlights

• IBB DB2 LUW- i.e Database administrator of DBExperience on installation of different versions of DB2 on Redhat Linux Environment . Good knowledge of Liux . Scheduling shell scripts on LINUX environments . Good experience in generating DDL s using DB2LOOK command on existing database and its objects

• IBB DB2 LUW- i.e Database administrator of DB2.Experience on installation of different versions of DB2 on Redhat Linux Environment

• Good knowledge of Liux

• 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. Purescale implementation desired

• DB2architecture and Administrator, solutioning of Arctitecture. LUW, pacemaker setup(HADR) 6 to 12 both Designer and Administrator.

• Experience required:

• Performe 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