DB2 Consultant

Job Description

 

Role Purpose

The purpose of this role is to provide significant technical expertise in architecture planning and design of the concerned tower (platform, database, middleware, backup etc) as well as managing its day-to-day operations

͏

Do

Support the organization in developing, operating and managing large and sophisticated enterprise database environments

ü  Coordinate activities performed by the team, track and report on team activities, define and document team processes, troubleshoot escalated issues and will be hands-on in operational DBA tasks which involves database-monitoring, performance tuning, backup and recovery, installation, maintenance, and disaster recovery.

ü  Responsible for upgrades, performance monitoring, installations, managing replications, diagnosing system problems, disaster recovery testing and maintaining user

ü  accessibility

ü  Resolving complex issues involving: database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology

ü  Ability to craft and alter of DB2 object according to the requirement (Ex: Database, Table space, Table, Index, etc)

ü  Experience in Online/Offline utility: Running Reorgs and Runstats, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities, Administering database organizations, standards, controls, procedures, and documentation

ü  Providing technical support for day-to-day DB2 with High Availability (HADR) in AIX Power HA environment including developing and applying procedures for periodic

ü  Database backups using IBM TSM, measuring database performance and troubleshooting complex database and HADR issues

ü  Backup plan configuration using the T-SQL statement Rebuild/ Re-organize index configuration using the maintenance plan DB maintenance and I/O error report Checking the Lock and block on the instance.

ü  Configuring TSM online DB backups, TDP configurations.

ü  Database restoration based on the request for support assets.

ü  Start up and shutdown of database instances Data file and log file movement.

ü  Application PATCH execution.

ü  Service pack /PATCH updates on cluster server.

ü  DR reconfiguration and setup in case of failure due to incident.

 

͏

Team Management

• Resourcing
  • Forecast talent requirements as per the current and future business needs
  • Hire adequate and right resources for the team 
  • Train direct reportees to make right recruitment and selection decisions 
• Talent Management
  • Ensure 100% compliance to Wipro’s standards of adequate onboarding and training for team members to enhance capability & effectiveness
  • Build an internal talent pool of HiPos and ensure their career progression within the organization
  • Promote diversity in leadership positions
• Performance Management
  • Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports.
  • Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below
• Employee Satisfaction and Engagement
  • Lead and drive engagement initiatives for the team
  • Track team satisfaction scores and identify initiatives to build engagement within the team
  • Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team 
  • Exercise employee recognition and appreciation 

͏

Deliver

No	Performance Parameter	Measure
1	Operations of the tower	SLA adherence Knowledge management CSAT/ Customer Experience Identification of risk issues and mitigation plans Knowledge management
2	New projects	Timely delivery Avoid unauthorised changes  No formal escalations

͏