Tata Consultancy Services Tata Consultancy Services Facebook page Tata Consultancy Services Linkedin page Tata Consultancy Services YouTube page
Tata Consultancy Services Tata Tata Consultancy Services

MSSQL Database Administrator

Introduction

We are looking for experts into our team which supports our client’s SQL environment. The ideal candidate provides DBA support on Microsoft SQL servers (2012, 2014 & 2016).

Function

Your daily tasks will include the following:

  • Granting/revoking access to users, Adding/Revoking alias
  • Monitoring SQL & Backup Server DB processes
  • Granting/Revoking select/execute permission on tables/stored procedures
  • Taking dumps/load of a database in Prod, Test environments
  • Monitoring Locks, Killing a blocking process, Creating Databases, Altering Databases
  • Action on tempdb full and transaction log full
  • Applying latest patches on DB Servers/Instances
  • Performance tuning of queries
  • Performing Migration activities from Lower SQL Server version to higher.
  • Implementing High Availability Architecture for minimal downtime
  • Ensure Backup/Recoverability of managed systems
  • Ensure security compliance of managed systems
  • Coordination for technical support for all MS SQL Servers, SSAS, SSRS and SSIS Servers
  • Ensure that production databases are available in accordance with the agreed service levels
  • Provide on-duty production support, roll out support and special support outside office hours and on public holidays
  • Following up with Network/Windows Administrators for server related Performance issues
  • Following up SAN Team for requesting LUNs (Raw Device partitions)

Requirements

We need you to have experience with the following:
  • MS SQL Server database administration (2012, 2014 & 2016) with minimum 2-5 years experience
  • Fluent English
  • Knowledge on ITIL processes
  • Performance tuning of SQL queries
  • MSBI technologies including SharePoint
  • SSRS configuration

Nice to have:

  • SQL server – PL SQL knowledge
  • SharePoint 2013 and 2016 foundation

Offer

We offer a colorful and dynamic work environment with:
  • market competitive compensation package
  • a great diversity of people, cultures and business areas
  • language courses and trainings
  • Global and diverse working environment
  • on-site relax & gym rooms
  • volunteering, sport and employee events.