• Job Description

  Req#: 362413
  SQL Server DBA
  
  
  Must Have Technical/Functional Skills
  - 5+ Years SQL Server DBA
  - DAG (Distributed Avail Groups) – across to data centers
  - Data Warehouse experience
  - Must be onsite
  
  
  Roles & Responsibilities
  • Must have 5+ years SQL Server DBA working experience with SQL Server.
  • Must be knowledgeable and experienced in the different versions of SQL Server (2012 - 2016). Knowledge of upgrading to SQL Server 2019 & 2022 and benefits to the migrating to these environments.
  • Must have skills and experience in Database data management – backups, ETL, and archive using native SQL Server backup tools.
  • Experienced using internal diagnostic and maintenance tools such as DBCC and internal SP functions as well as SQL Diag, SQL Profiler, and third-party diagnostics tools.
  • Demonstrate Knowledge of Partitioning Architecture.
  • Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSAS, SSRS, and MS SharePoint.
  • Management of multiple processing schedules and notification strategies. Strong skills in T-SQL, DOS, PowerShell, tuning, and debugging. Experience with SQL Server Manager, Visual Studio, DTS/SSIS, and other SQL Server tools including but not limited to Profiler & SQL Server Command Line Utilities
  • Experience with SQL Server database replication and mirroring
  • Experienced in security/access strategies for a wide pool of user groups and developers with different access requirements.
  • Ability to maintain a positive attitude while working with high demands and short deadlines
  • Ability to prioritize heavy workload with minimum supervision
  • Highly adaptable with the ability to work in a fast-paced demanding environment
  • Must have excellent communication and interpersonal skills
  • Ability to work well with development and infrastructure teams in doing database design, changes, and enhancement to new and existing applications.
  • Strong organizational and analytical skills.
  Understanding of High Availability and Disaster Recovery requirements and solutions.
  
  
  Essential Job Functions:
  • Apply All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery.
  • Work 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-through, and participation in weekly operations reviews.
  • Change management including maintenance of multiple development, test, QA, and production environments. Responsible for de ploying approved changes to production.
  • Proactive database monitoring and issue resolution
  • Database and T-SQL optimization including performance tuning, query optimization, and supportability.
  • Actively participate and contribute to projects involving enterprise database systems enhancements to meet business requirements. Participate in project design and SQL Server database design decisions.
  • Develop and implement Database security policies and procedures, in line with corporate objectives
  • Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
  • Implementation and ongoing support of high availability architecture standards and technologies.
  • Create and maintain appropriate documentation about the database and the data architecture.
  • Support data management solutions including ETL processing, data archive, data purge, etc.
  • Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
  • Work on project sizing processes - including design reviews as necessary to appropriately size new environments, recommend design strategies and deliver associated cost and resource effort estimates.
  • Perform other duties as assigned.
  
  
  Salary Range- $95,000-$115,000 a year
  
  
  #LI-CO1
  #LI-SN1

• About the company

  Tata Consultancy Services is an Indian multinational information technology services and consulting company headquartered in Mumbai, Maharashtra, India with its largest campus located in Chennai, Tamil Nadu, India.

Notice