Lead Administrator

Role Purpose

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

Do

1. Provide adequate support in architecture planning, migration& installation for new projects in own tower (platform/dbase/middleware/ backup)

   1. Lead the structural/ architectural design of a platform/middleware/ database/ back up etc. according to various systemrequirements to ensure a highly scalable and extensiblesolution
   2. Conduct technology capacity planning by reviewing the currentand future requirements
   3. Utilize and leverage the new features of all underlyingtechnologies to ensure smooth functioning of the installed databases andapplications/ platforms, as applicable
   4. Strategize & implement disaster recovery plans and createand implement backup and recovery plans

2. Manage the day-to-day operations of the tower

   1. Manage day-to-day operations by troubleshooting any issues,conducting root cause analysis (RCA) and developing fixes to avoidsimilar issues.
   2. Plan for and manage upgradations, migration, maintenance,backup, installation and configuration functions for own tower
   3. Review the technical performance of own tower and deploy ways toimprove efficiency, fine tune performance and reduce performancechallenges
   4. Develop shift roster for the team to ensure no disruption in thetower
   5. Create and update SOPs, Data Responsibility Matrices, operationsmanuals, daily test plans, data architecture guidance etc.
   6. Provide weekly status reports to the client leadership team,internal stakeholders on database activities w.r.t. progress, updates,status, and next steps
   7. Leverage technology to develop Service Improvement Plan (SIP)through automation and other initiatives for higher efficiency andeffectiveness

3. Team Management

   1. Resourcing
      1. Forecast talent requirements as per the current and future businessneeds
      2. Hire adequate and right resources for the team

• Train direct reportees to make right recruitment and selectiondecisions

1. Talent Management
   1. Ensure 100% compliance to Wipro’s standards of adequateonboarding and training for team members to enhance capability &effectiveness
   2. Build an internal talent pool of HiPos and ensure their careerprogression within the organization

• Promote diversity in leadership positions

1. Performance Management
   1. Set goals for direct reportees, conduct timely performance reviewsand appraisals, and give constructive feedback to direct reports.
   2. Ensure that organizational programs like Performance Nxt are wellunderstood and that the team is taking the opportunities presented bysuch programs to their and their levels below
2. Employee Satisfaction and Engagement
   1. Lead and drive engagement initiatives for the team
   2. Track team satisfaction scores and identify initiatives to buildengagement within the team

• Proactively challenge the team with larger and enriching projects/initiatives for the organization or team

1. Exercise employee recognition and appreciation

Stakeholder Interaction

| | | | | --- | --- | --- | | Stakeholder Type | Stakeholder Identification | Purpose of Interaction | | Internal | Technology Solutions Group, BU Teams, Different Infrastructureteams | Understanding requirements, planning and status updates,maintenance and back up, issue resolution etc. | | IRMC, QA | Guidance on risk mitigation and quality standards | | External | Clients | Understanding requirements, planning and status updates,maintenance and back up, issue resolution etc. | | Vendors/ Manufacturers | Development and deployment of platforms, applications, databasesetc. |

Display

Lists the competencies required to perform this role effectively:

• Functional Competencies/ Skill
  • Technical Knowledge – Knowledge of own tower (platform,application, database etc) - Expert
  • Domain Knowledge – Understanding of IT industry and itstrends – Competent to Expert

| | | | --- | --- | | Competency Levels | | Foundation | Knowledgeable about the competency requirements. Demonstrates (inparts) frequently with minimal support and guidance. | | Competent | Consistently demonstrates the full range of the competencywithout guidance. Extends the competency to difficult and unknownsituations as well. | | Expert | Applies the competency in all situations and is serves as a guideto others as well. | | Master | Coaches others and builds organizational capability in thecompetency area. Serves as a key resource for that competency and isrecognised within the entire organization. |

• Behavioral Competencies
  • Managing Complexity
  • Client centricity
  • Execution Excellence
  • Passion for Results
  • Team Management
  • Stakeholder Management

Deliver

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

MSSQL Database Admin