L2 SQL Database Administrator

TCS is Hiring for MS SQL, PostegreSQL DBA

Interview Date:-25-08-2026

Location:- Chennai/ Gurgaon

Exp:-6-8 Yr

Must have:-SQL Server Administration

RDBMS Backup, Restore & DR

Performance Monitoring & Tuning HA Replication

Security, Patching & Compliance

JD

Job Requirements*

1. Years of experience on SQL Administration (preferably MCDBA)
2. Strong in RDBMS concepts
3. Installing SQL server and client software, creating, upgrading.
4. Experience in SQL 2005, 2008, 2012, 2014
5. Experience in Tablespace, Schemas, Application/ DB Tuning & Performance Monitoring.
6. Patching databases in Windows environments.
7. Experience in Upgrade and Migration of SQL database
8. Performance Tuning of SQL databases
9. Proficiency in SQL and PL/SQL programming.
10. Planning, scheduling and taking SQL backups.
11. Hands on experience in database backups and Recovery
12. Export/Import, Cold, Hot backups & DR solutions.
13. Successfully implemented physical standby database using SQL Data replication and log shipping
14. High availability configuration, AlwaysOn, Log shipping
15. Installation, Configuration and deployment of SQL database
16. Capacity Management
17. Database security
18. Co-ordination with multiple stake holders / Third party Vendors for break-fix.
19. Flexibility to work in shifts for 24x7 support
20. Must be able to lead the critical outage calls
21. Create the Standard Operating Procedure and update the knowledge database documentation whenever required
22. Participate in weekly/ monthly/ customer meeting and provide activities report.
23. Experience in Oracle 9i, 10g, 11g & 12c Tablespace, Schemas, Application/ DB Tuning & Performance Monitoring.

Patching databases in UNIX (Solaris, HP-UX & AIX), Linux and Windows environments.>

Key Responsibilities*

1. Years of experience on SQL Administration (preferably MCDBA)
2. Strong in RDBMS concepts
3. Installing SQL server and client software, creating, upgrading.
4. Experience in SQL 2005, 2008, 2012, 2014
5. Experience in Tablespace, Schemas, Application/ DB Tuning & Performance Monitoring.
6. Patching databases in Windows environments.
7. Experience in Upgrade and Migration of SQL database
8. Performance Tuning of SQL databases
9. Proficiency in SQL and PL/SQL programming.
10. Planning, scheduling and taking SQL backups.
11. Hands on experience in database backups and Recovery
12. Export/Import, Cold, Hot backups & DR solutions.
13. Successfully implemented physical standby database using SQL Data replication and log shipping
14. High availability configuration, AlwaysOn, Log shipping
15. Installation, Configuration and deployment of SQL database
16. Capacity Management
17. Database security
18. Co-ordination with multiple stake holders / Third party Vendors for break-fix.
19. Flexibility to work in shifts for 24x7 support
20. Must be able to lead the critical outage calls
21. Create the Standard Operating Procedure and update the knowledge database documentation whenever required
22. Participate in weekly/ monthly/ customer meeting and provide activities report.
23. Experience in Oracle 9i, 10g, 11g & 12c Tablespace, Schemas, Application/ DB Tuning & Performance Monitoring.

Patching databases in UNIX (Solaris, HP-UX & AIX), Linux and Windows environments.>