Job Description

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 pressure

Additional Qualification / Skills :

Wxp - 6+ yrs

Location - Kochi Bangalore

CBR-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 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

͏