Db2 DBA LUW

Job Role :DB2 LUW

Location : Plano TX (Rotational shifts)

Job details :

DB2 LUW: 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.

Roles and Responsibilities

1. Transition from previous shift and get familiar with the ongoing things

2. Monitoring Dashboards and Email alerts.

3. Investigating and Troubleshooting any issues or alerts that reports in the dashboards

4. Helping Application Teams with their BAU requests S. Making sure the changes are scheduled and transition them for the next oncall

6. Follow up on the support tickets if any.

7. Join major incident calls/incident calls as needed and troubleshoot the issues

(1.) To provide support for on call Lscalations and doing root cause analysis of given issue

(2.) To independently resolve tickets within agreed SlA of ticket volume and time

(3.) To adhere to quality standards regulatory requirements and company policies

(4.) Work on value adding activities such Knowledge base update and management. Training freshers coaching analysts

(5.) To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases