Lead Administrator - L1

  
At least SQL DBA experience, 6+ years required Thorough Knowledge of Windows Operating System, Networks and Active Directory . Knowledge of creating and maintaining standby / replication setup . Strong in SQL fundamentals . Knowledge of using Enterprise Manager and Query Analyzed for basic administration . Knowledge of configuring and setting up maintenance activities for DB . Knowledge of SQL statements tuning and DB Tuning . Knowledge on DB structures (filegroups, Indexes - clustered /non clustered/fillfactor) . Knowledge on Memory structures (configurable parameters) Knowledge of complete /differential / transactional backups and their recovery scenarios . Knowledge on High Availability configuration like replication and log shipping , cluster setup . Knowledge of DTS and bcp and other data load tools across same and different RDBMS Knowledge on database design and storage recommendation and NTFS file systems & capacity planning . Knowledge in making scripts for automations , writing procedures and functions . Knowledge of ITIL processes & Transition Management . Excellent communication Skills Prior experience in a 24x7 environment desired Strong analytical and troubleshooting skills. Provide on-call support as and when required Ability to handle pressureAdditional Qualification / Skills :Wxp - 6+ yrsLocation - Kochi, PuneCBR-130K Team Leader MCSE MSSQL Certification is mandatory Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on In depth Knowledge on SQL server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019 Versions. cloud, Azure, AW  
Do

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

Lead the structural/ architectural design of a platform/ middleware/ database/ back up etc. according to various system requirements to ensure a highly scalable and extensible solution

Conduct technology capacity planning by reviewing the current and future requirements

Utilize and leverage the new features of all underlying technologies to ensure smooth functioning of the installed databases and applications/ platforms, as applicable

Strategize & implement disaster recovery plans and create and implement backup and recovery plans

Manage the day-to-day operations of the tower

Manage day-to-day operations by troubleshooting any issues, conducting root cause analysis (RCA) and developing fixes to avoid similar issues.

Plan for and manage upgradations, migration, maintenance, backup, installation and configuration functions for own tower

Review the technical performance of own tower and deploy ways to improve efficiency, fine tune performance and reduce performance challenges

Develop shift roster for the team to ensure no disruption in the tower

Create and update SOPs, Data Responsibility Matrices, operations manuals, daily test plans, data architecture guidance etc.

Provide weekly status reports to the client leadership team, internal stakeholders on database activities w.r.t. progress, updates, status, and next steps

Leverage technology to develop Service Improvement Plan (SIP) through automation and other initiatives for higher efficiency and effectiveness

  
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 Wipros 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
NoPerformance ParameterMeasure1Operations of the towerSLA adherenceKnowledge managementCSAT/ Customer ExperienceIdentification of risk issues and mitigation plansKnowledge management2New projectsTimely deliveryAvoid unauthorised changesNo formal escalations  
Mandatory Skills:

MSSQL Database Admin.
Experience5-8 Years.