DB2 Consultant

Wipro Limited (NYSEWIT, BSE507685, NSEWIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.
 About The Role  _x000D_



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

 ? _x000D_

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 involvingdatabase 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 (ExDatabase, Table space, Table, Index, etc)

ü Experience in Online/Offline utilityRunning 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.



 ? _x000D_

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

 ? _x000D_

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    

 ? _x000D_

Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.