Database Administrator - SQL Server

<p><p><b>Roles & Responsibilities:</b></p><br/><p>- Hands on experience in working with MSSQL SERVER 2005, 2008, 2008R2, 2012/2014/2016, 2019 features</p><br/><p>- Experience in database maintenance, Security, upgrading, and Performance Tuning.</p><br/><p>- Database administration and management (capacity planning, installation, backup, recovery, monitoring, Performance optimizations, troubleshooting, load/hardware analysis mapping, security etc.</p><br/><p>- Extensive knowledge on Backup/Recovery of databases, and databases Maintenance Job failures, connectivity, and performance issues.</p><br/><p>- Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, IO, Memory bottlenecks.</p><br/><p>- Experience in log shipping, Always-on and replication.</p><br/><p>- Good knowledge of Windows cluster.</p><br/><p>- Should be able to take complete ownership of the project/activities assigned to the DBA.</p><br/><p>- Work with users and vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting service levels and conduct root cause analysis</p><br/><p>- Query optimization and tuning skills, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage</p><br/><p>- Collect and analyse database performance information; identify and implement solutions for performance problems</p><br/><p><b>Skills Required:</b></p><br/><p>- Experience in setting up and supporting database replication, mirroring, failover clustering</p><br/><p>- Relevant working experience as an MS SQL Database Administrator in production environment</p><br/><p>- Managing experience of MS SQL servers (2008, 2012, 2014, 2016,2019)</p><br/><p>- Strong understanding in Database clustering techniques and operations</p><br/><p>- Past working experience in Cloud environment is an advantage</p><br/><p>- Able to handle demanding service response and recovery turnaround</p><br/><p>- Able to manage daily support tasks to meet stringent SLA requirements</p><br/><p>- Excellent scheduling and multitasking skills</p><br/><p>- Meticulous and process-oriented</p><br/><p>- Good, hard-working attitude with ability to work well under pressure</p><br/><p>- Good communication skills English (written, spoken)</p><br/><p>- Good analytical skills with ability to work with others to resolve problems.</p><br/><p>- Good organization skills, with ability to properly document and track information.</p><br/><p>- Preferably with Microsoft Certification and/or ITIL certification</p><br/></p> (ref:hirist.tech)