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

SQL Server 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 (2008 R2, 2012 and 2014).

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 Swiss Re 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, rollout 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:
  • DBA Support Microsoft SQL Server version 2008 R2, 2012 & 2014
  • SQL Server HA Features, cluster and log shipping
  • Monitoring of Servers using SCOM
  • Performance tuning of SQL queries
  • SQL Server Database Administration with 2-4 years of experience
  • MS BI stack (SSRS & SSAS) is a must have

Nice to have:

  • PL SQL knowledge
  • ITIL Process knowledge or certification

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.