Emsyne(Muthoot Systems and Technologies Pvt.Ltd)
4th Floor, LULU Cyber Tower, Infopark, Kusumagiri P.O, Kakkanad, Kochi-682 030, Kerala, India. +91 484 4051765
MS SQL DBA
Resource should have minimum 2-3 year experience as DBA
• Capacity Planning
• Creation and Configuration of DB
• Daily check list and monitoring
• Ensure high uptime
• Ensure that no SQL Server job has failed.
• Perform the necessary backups, whether transactional or complete.
• Check the general health of the server (space, CPU utilization, memory)
• Track locking issues, including deadlocks, blocking, and lock timeouts.
• Remove any unwanted space from the transaction log and data files.
• Perform any necessary index tuning, including defragmenting the indexes.
• Gather Statistics if Auto gathering is turned off
• Applying suitable patches whenever it's needed
• Check the health of the DB by running DBCC CHECKDB.
• Make necessary changes based on application team requirement.
• Implement best practices
• Hardening of DB
• Prepare SOP
Qualification: B.Tech, B.E, M.Tech, M.E, MCA, MSc Computer Science
Please send your CV to email@example.com. The subject line should be MS SQL DBA