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/MS BI Server Database Administrator

Introduction

In the IT Services area we provide ADM (Application Development and Maintenance) services to customers worldwide. We are working with a wide range of technologies and programming languages (common and rare ones) from Spring, Hibernate, .NET, SharePoint to C++, C#, Java, RPG till AS400, Oracle, Progress. Our aim is to achieve high correspondence to our customers by introducing and applying new coming technology features. We strive to increase our clients’ effectiveness in their day to day work and reach a high level of satisfaction. This also gives space for our developers to continuous learning and growth. At the same time we do not forget that life is not only about work so we organize and participate in beyond the business activities within the IT Services stream and occasionally with our customers.

Function

  • · Granting/revoking access to databases / databases objects for users, adding/revoking alias
  • · Monitoring SQL & Backup Server DB processes
  • · 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
  • · Ensure backup/recoverability of managed systems
  • · Ensure security compliance of managed systems
  • · Coordination for technical support for all MS SQL Servers, SSAS, SSRS, PowerBI and SSIS Servers
  • · Ensure that production databases are available in accordance with the agreed service levels
  • · Provide on-duty production support, rollout support and on-call support outside office hours and on public holidays according to the on-call shift plans
  • · Following up with Network/Windows Administrators for server related performance issues
  • · Advise management on Long-Term capacity plans and growth
  • · Analyze and recommend database improvements – execution plans, DMVs
  • · Debug database issues on LIVE data
  • · Strong technical and interpersonal communication
  • · Troubleshoot database errors

Requirements

· Degrees: Any degree

· IT skills (in details with required levels):

  • MS SQL database administration 2014, 2016 & 2017 – with minimum 3 years of experience
  • MSBI Technologies – SSAS, SSIS, SSRS, PowerBI

· Experience in the execution of certain tasks:

  • SQL Server HA Features, cluster, log shipping and Always-ON
  • Performance tuning of SQL queries
  • SSRS/PowerBI Configuration

Information

The working hours is on shift period, 8 hours (anytime between 7:00 and 23:00 hrs CET). The candidate may be expected to travel to Zurich on a Short-term/Long-term assignment.

Application

balint.kisbenedek@tcs.com