Roles and Responsibilities

• Planning and implementing all types of backup and restore operations
• Administrating high availability solution like mirroring, replication and always on
• Space management and transactional log files
• Installing and configuring SQL server
• Setting up security policies and creating logins and roles
• Resolution of incidents, determination of Root Cause for higher priority incidents
• Identify and mitigate risks, including security risks.
• Work on continually increasing the productivity of the team and reducing the waste on the other end.
• Identifying risks and forming contingency plans as soon as possible.
• Analysing existing operations and scheduling training sessions and meetings to discuss improvements.
• Keeping up-to-date with industry trends and developments.
• Updating work schedules and performing troubleshooting as required.
• Promote a collaborative work environment

Required Technical and Professional Expertise

• Create Users and assign permissions based on the level of database access the user would need. (Security)
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)
• Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)
• Work as part of a team and provide 24x7 support
• Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)
• From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)
• Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication)
• Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))
• Documenting major changes to the SQL Servers. (General)
• Capacity Planning