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

 Job seems aged, it may have been expired!
 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Application L2 Support - Pl/sql Experience Professional

  • Birlasoft
  • 4 - 9 years
  • Mumbai
  • 15 days ago
₹ Not Disclosed

Windows Server Specialist

  • Infobeans
  • 5 - 9 years
  • Indore
  • 21 days ago
₹ Not Disclosed

Window Server Administrator

  • Godrej Infotech
  • 2 - 4 years
  • Mumbai
  • 3 mths ago
₹ Not Disclosed

Tata Consultancy

\n\nMavlers is a full-service digital marketing agency that has propelled growth for over 7,000 brands and agencies worldwide. As Google, Mailchimp, WP VIP, Microsoft, Salesforce, and HubSpot partners, we possess the expertise to deliver high-impact projects and campaigns tailored to our clients uni...