MSSQL Admin
TCS
3 - 7 years
Mumbai
Posted: 31/05/2025
Job Description
Job Description
Role-MSSQL Admin
Location-Mumbai
Desired Experience Range-6 to 8
"•Database Monitoring: Perform 24 X 7 monitoring of all the critical parameters for the database such as:
Table space, segment
Availability of background processes
Buffer cache utilization
Redo log contention
Resource intensive queries through AWR reports
Fragmentation of table spaces, tables and indexes
Perform maintenance activities like index maintenance as per the SUN PHARMA’s policy provided during transition-
Memory, I/O, CPU utilization for the RDBMSs
Disk free space
Alert logs for errors
Database backup Logs
Unsuccessful logins
•Monitor system performance and provide performance data to SUN PHARMA
•Create, modify, and delete database and database objects
•Create, modify, and delete users and properties
•Create, modify, and delete jobs
•Perform periodic database performance tuning as per the documented procedures
•Perform periodic housekeeping of Database
•Perform maintenance activities like index maintenance as per the SUN PHARMA’s policy provided during transition.
•Perform orderly start-up and shutdown of database services.
•Restore databases in the event of a server crash
•Add, modify, and delete permissions to database objects and troubleshoot user logins
•Rectify database configuration problems
•Perform regular defragmentation activities for better space management and performance Grant and revoke database access to users as per Sun Pharma provided guidelines
•Participation in DR drill
•Housekeeping on DR server- cleaning up of Archive logs and Alert logs/transaction logs
•Re-build DR in case of crash
•Submission of monthly database incident reports as per mutually agreed schedule
•Daily, weekly and monthly checklist of all Oracle DB’s
•Administration of Oracle databases, RAC
Creation of Development, Product and UAT database Environment.
Configuration of Database parameters
Database User management (Creation, modification, deletion, Permission etc)
Performance Tuning of Production databases
•Installation of Oracle Database Server
•Installation and troubleshooting issues for Oracle Client
•Installation of DB patches
•Co-ordination application and development teams at SUN Pharma in case of issues
•Co-ordination with Oracle Support team to resolve issues related to Oracle database server
•Hardening of Oracle DB - Hardening of oracle Database server
•Oracle DB backup and restoration.
•Oracle scripts to automate Oracle DBA related task and activities wherever possible
•Daily monitoring and checking of all SQL databases
•Creation of database
•Configuration of Database parameters
•Users, tables, SQL Jobs creation
•Troubleshooting of SQL Database server related issues
•Performance tuning of SQL production database
•Hardening of SQL databases
•Backup and Restoration of SQL databases
•Microsoft SQL cluster support
•Configuration of Microsoft Cluster
•Monitoring of SQL Cluster
•Troubleshooting of SQL Cluster
•Installation and configuration of SQL database as per requirements"
Location
Mumbai
Job Function
TECHNOLOGY
Role
Engineer
Job Id
363631
Desired Skills
MS SQL Server
Desired Candidate Profile
Qualifications : BACHELOR OF ENGINEERING
About Company
Tata Consultancy Services (TCS) is one of the largest multinational IT services and consulting companies in the world, headquartered in Mumbai, India. It operates in over 50 countries and is a part of the Tata Group, India's largest business conglomerate. TCS offers a wide range of services including software development, consulting, digital transformation, and business solutions, serving industries such as finance, healthcare, retail, and telecommunications. Known for its global reach, technological expertise, and innovation, TCS is consistently ranked among the top IT services companies globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).