Responsible for ensuring all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) and test backups to ensure the business’ Recovery Time Objectives (RTO) is met.
Responsible for configuring SQL server monitoring utilities to minimize false alarms and as new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, AWS, or other technologies.
Install and configure new SQL servers and when performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. Document the company’s database environment. Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each and design indexes for existing applications, choosing when to add or remove indexes. When users complain about the performance of a particular query, help Developers improve the performance of that query by tweaking it or modifying indexes. Also, review queries written by Developers.
Failover clustering, SAN replication, and other high availability technologies, SQL server merge, peer to peer, or transnational replication.
· Monitor servers’ performance.
· Monitor slower quires through Activity Monitor.
· Use of SQL server tools to enhance performance.
· Make sure disk space is enough.
· Coordinate with Hosting team for shrinking database in case large log files are being generated.
· Make sure the backup plans are up to date.
· Make sure backups are stored properly and test backups can be restored.
· Review queries written by Developers.
· Suggest performance enhancement optimization techniques to Developers.
Job Details
| Posted Date: | 2018-09-18 |
| Job Location: | Al Kuwait, Kuwait |
| Job Role: | Information Technology |
| Company Industry: | Internet/E-commerce |
| Monthly Salary: | US $3,000 |
Preferred Candidate
| Career Level: | Mid Career |
| Degree: | Bachelor's degree |
To apply for this job click here
Jobs in Kuwait - career in Kuwait - vacancies in Kuwait-MS SQL Database Administrator - Talabat GTC-Jobs in Kuwait - career in Kuwait - vacancies in Kuwait
Post a Comment