SQL Database Administrator

Tata Consultancy Services

0 years

0 Lacs

Chennai Tamil Nadu India

Posted:4 days ago| Platform:

Apply

Skills Required

sql database server monitoring automation powershell test service clustering shipping azure oracle data postgresql migration mysql configuration query code reliability design indexes tuning

Work Mode

On-site

Job Type

Full Time

Job Description

Role and Responsibilities

Extensive working knowledge on SQL Server and PostgreSQL
Configure DBMS monitoring utilities to minimize false alarms. Implement Automation using PowerShell Scripts. Good Knowledge on PowerShell Scripts is must.
Comprehensive implementation knowledge on SSIS, SSAS and SSRS.
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Troubleshoot Database service outages as they occur, including after-hours and weekends.
As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, SQL Azure, Always ON.
Implementation Knowledge on High Availability of Oracle Data Guard, Golden Gate, Always ON & SQL Azure.
Install and configure SQL Server, PostgreSQL and Oracle.
Deploy database change scripts provided by third party vendors
SQL Server Migration experience from SQL older to newer versions.
Cross Platform Migration experience (Oracle to SQL & Oracle to DB2 & MySQL to PostgreSQL).
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
Document the company’s database environment.
Ensure that new database code meets company standards for readability, reliability, and performance.
Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each.
Design indexes for existing applications, choosing when to add or remove indexes
When users complain about the performance of a particular query, help developers improve

performance of that query by tweaking it or modifying indexes.

19.Advise developers on the most efficient database designs (tables, datatypes, stored procedures,

functions, etc.).

20. Implementation experience in Application Performance Tuning and Optimization.

More Jobs at Tata Consultancy Services

Tcs Hiring For GRC , Pan India

Pune, Bengaluru, Mumbai (All Areas)

7 - 12 yrs

INR 9 - 19 Lacs

Java / Spring boot with API Developer

Pune

5 - 10 yrs

INR 9 - 19 Lacs

SAP PP and QM Consultant

Pune

4 - 9 yrs

INR 8 - 18 Lacs

SAP BTP Consultant

Pune

4 - 9 yrs

INR 9 - 19 Lacs

Customer Service Associate

Pune

1 - 6 yrs

INR 1 - 5 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.