Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Microsoft SQL Server 2019 @ Tata Consultancy

Home > IT Network

 Microsoft SQL Server 2019

Job Description

Job Description


Exp Range- 4 yo 9

Location- Pune and Chennai

MSSQL DBA & AWS RDS Database Requirement-


Certifications & Skills:

ITIL Certified

SQL Server Database Administration (Versions 2012, 2014, 2016, 2019)

Hands-on experience with Azure Foundational Services, Data Management Services (Optional), and Cloud Awareness

PowerShell, Shell Scripting, Python (Optional)


Responsibilities:

MSSQL DBA (L2 Level):

End-to-end Physical Database Administration duties

Backup & Restore Management

Database Lifecycle Management (SQL Server Build, Version Upgrades, Patch Management, Decommissioning Activities)

Experience in writing T-SQL (Stored Procedures, Views, Tables, Triggers, User-Defined Functions)

Hands-on experience with business continuity solutions such as Log Shipping, Database Mirroring, and SQL Always-On

Support Disaster Recovery (DR) Drills

Database Migrations (On-Premise, Azure Cloud)

Database Maintenance (Index Management, Statistics Management, Database Refresh, Cloning)

SQL Server Agent Management

Experience in handling performance issues related to capacity management, performance tuning (Locking, Blocking, Deadlocks)

Trend Analysis, Reporting & Auditing

Security Implementation: Database Encryption (TDE / Always-Encrypted), Role-Based Access Control, Linked Servers

AWS RDS (L1 Level):

Basic administration of AWS RDS instances (SQL Server, MySQL, PostgreSQL)

Monitoring and handling basic performance issues

Assisting in backups and snapshot management

Managing parameter groups and security groups

Assisting with failover testing and minor troubleshooting

Basic user and role management in RDS

Understanding of RDS maintenance tasks, including minor version upgrades and patches

Coordinating with senior team members for major RDS-related issues


Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Hardware & Networks
Role Category: IT Network
Role: IT Network - Other
Employement Type: Full time

Contact Details:

Company: Tata Consultancy
Location(s): Pune

+ View Contactajax loader


Keyskills:   Mssql Dba Powershell Shell Scripting

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Windows Server Admin- Integration Engineer

  • Vichara Technologies
  • 8 - 13 years
  • Hyderabad
  • 3 days ago
₹ 20-35 Lacs P.A.

Server Administrator

  • Codemax It Solutions
  • 3 - 5 years
  • 24 days ago
₹ Not Disclosed

OS Certification and Automation Engineer - Server Validation

  • Cisco
  • 5 - 9 years
  • Bengaluru
  • 1 month ago
₹ Not Disclosed

Tableau Server Administrator

  • Blend360 India
  • 6 - 10 years
  • Hyderabad
  • 1 month ago
₹ Not Disclosed

Tata Consultancy

Jobs