Aurora Postgres,Postgres SQL Professionals

Job highlights

• Manage database logins and permissions for users . Well versed with DB restores including Redirected restores on production and wherever required .
• Negotiating client facing,communication,assertive,team leading / team member skills,supportive . Good communication skills,assertive and team player .

JOB DESCRIPTION

Client Name:

TATA Consultancy Services Limited

Job Title:

AWS IBM DB2 database Administrator

WON/SWON :

Reporting to:

Ravindra Navada

Location:

Bangalore

Department/Practice:

FSIT

Job Purpose and primary objectives:

DB2 Administrator

Key responsibilities (please specify if the position is an individual one or part of a team):

Part of team

• Supervisory / Managerial responsibilities (please specify if the position will have persons reporting to it):

NA

• Other responsibilities Budgets, targets, equipment etc (please specify):

Key Skills/Knowledge:

I BB DB2 LUW- ie 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 DDLs 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

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

Well versed with DB restores including Redirected restores on production and wherever required

Duration of the Assignment:

Two years

Rate per day/month of billing that TCS will get from client:

NA

Salary Range Payable (please specify if sales incentive plan will be applicable ):

Number of persons required:

2

Special working conditions (travel, on call etc):

Production support both on call and working in different time zones

Additional remarks (if any):

cloud knowledge is an added advantage

Knowledge of applicable Security standards for Databases

Knowledge of linux

Negotiating client facing, communication, assertive, team leading/team member skills, supportive

Good communication skills, assertive and team player

Flexible in approach

The above is an accurate and concise description of the said position

Recruiting Manager: Ravindra Navada

Employee Number: 141764

Authorised Signature:

: