Job Summary
Company Name
Godrej
Division
OPERATIONS & TECHNOLOGY GROUP
Function
MSSQL DBA
Designation
SQL DBA
Location
PLANT-10
About the Business & Position Overview
Job Profile
Key Responsibilities
Monitoring of Alerts DB Administration Documentation Maintaining Trackers/Logs
SQL Installation and Configuration OTRS Handling
Job Description
Monitoring database instances Monitoring and analysing resources allocation Install
& configure SQL Server software with upgrades/ fixes Check to make sure the SQL Server is online and connectivity is working fine. Check error logs and if found any
critical errors then escalate to L2 DBA Ensure all (Full, differential and log)backups
are running fine. Check open tickets/issues and be sure issues/requests are addressed
within SLA. Ensure that no SQL Server job has failed and follow the SOPs if any job
is failing. Check the general health of the server (space, CPU utilization, memory) to
confirm there are no issues. Acknowledge every mail within SLA and if required
escalate to senior DBA. Join bridge calls for P1(SEV1) and P2 (SEV2) incidents along
with L2/L3 DBAs. Make sure to respond to all the SQL DB alerts and take proper
action. Work on DB Refresh activity Work with DBA team to provide support to
development team Support open-source database platforms like MYSQL,
PostGreSQL would be an add on


Qualification Details
Essential Qualification: Bachelor-s degree, Microsoft Certified Solutions Associate (MCSA)
Preferred Qualification: NA
Experience Details
Essential Experience: 3-5 year of DBA experience in a SQL Server environment. He / she should have handled medium to large databases in multi-server environment.Well versed with SQL ALways ON
Preferred Experience: NA
Special Skill
Essential : SQL server Administration :- Installation & configuration, users & disk
management, Management of SQL server logs and Backups Monitoring various
versions SQL Server Production servers using standard tools Knowledge of Windows
Server OS Coordination with other teams like Operations/Windows/Networking
Preferred : Analyse and correct problems that occur in the SQL Server environment.
Troubleshooting basic Performance related issues Installation & configuration of
SQL Server 2014 and above versions Familiar with High Availability solutions
Familiarity with IT standards like ISO 27000 Familiarity with PIM tool is an add on
Good English (Oral & Written) Working knowledge of Linux as OS Knowledge on
Cloud DB (Azure, Aws)