Job Description

SQL DBA/ORACLE DBA WORK LOCATION : BANGALORE YEARS OF EXPERIENCE : 4-8 YEARS
4.00 to 8.00 Years
3
BENGALURU [India]
IT
20/03/2019
20/04/2019
Scripting experience required -Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO) -Test backups to ensure we can meet the business' Recovery Time Objectives (RTO) - Troubleshoot MS-SQL Server service outages as they occur, including after-hours and weekends -Configure MS-SQL Server monitoring utilities to minimize false alarms -As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies -Install and configure new SQL Servers -Deploy database change scripts provided by third party vendors -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 environmentTo do a great job in this position, experience should include: - On-call troubleshooting experience with at least one production MS-SQL Server for a year. You don't have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the MS-SQL Server service stopped working. - Finding DMV queries to answer questions about server-level performance -Using free tools like sp_Blitz(r) and sp_WhoIsActive to diagnose server reliability and performance issues