Job Summary
Job Description for DB2 Systems & DBA :
The DB2 Data Base Administrator (DBA) provides Application Database administration, management and Support
Allocating system storage and planning future storage requirements for the database system
Modifying the database structure, as necessary, from information given by application developers
Enrolling users and maintaining system security
Ensuring compliance with database vendor license agreement
Controlling and monitoring user access to the database
Monitoring and optimizing the performance of the database
Planning for backup and recovery of database information
Maintaining archived data
Backing up and restoring databases
Contacting database vendor for technical support
Generating various reports by querying from database as per need
Managing and monitoring data replication
Refreshing the Database
Qualifications:-
Hands on experience of SQL language
Ability to create DB2's objects with DDL
Hands on experience of DB2 database administration
Knowledge of z/OS System
Knowledge of Endevor or other source code management and release management tool
SNOW knowledge
Key Responsibilities
2. To perform value addition activities (such as mentoring administrators/team members, preparing SOPs, maintaining effective documentation simultaneously and Knowledge sharing.) In addition act as a liaison to the business segment, facilitating effective communication and presentation to key business stakeholders as & when required.
3. To validate Change Order Implementation Plan & Human Error Compliance and participate in Capacity planning
4. To ensure positive customer feedback & satisfaction through active participation in customer meetings to understand any issues faced
5. To validate analyses (eg. Root Cause Analysis ,Trend Analysis) and reports to facilitate performance in tasks to be presented to key business stakeholders