My client is looking to recruit a SQL DBA / Database Administrator to join the firm on a permanent basis to provide technical expertise in the management, support and continuing improvement of core systems with a specific focus on the organisations SQL Server environment.
Key Responsibilities
• Installation, Administration and Maintenance of SQL Server environments - versions 2012-2019 & Azure/AWS desirable
• Setup High-Availability as part Disaster Recovery Strategy for the SQL environments,
• where required. (SQL Failover Clustering, Database Mirroring, and SQL Merge/Transactional Replication)
• Support for SQL server – Asynchronous/Synchronous replication
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Maintaining Index fragmentation, SQL storage, memory settings, monitoring CPU usage and Disk I/O activity etc)
• Maintain SQL servers set up with local VMware VMDKs hosted on NetApp presentable storage drives (LUNS)
• Understand database Backup and Restoration Strategy – RPO/RTO strategy. (Native SQL Backups via SQL Server Agent/Commvault agent based/NetApp snap mirroring)
• Administration of internal maintenance tasks – SQL Backups/DBCC checks/Index maintenance
Skills, experience and qualifications:
• 5+ years’ experience supporting large SQL Server environments including application installation, configuration and integration
• SQL Server 2012 to 2019 clustering, Data Warehouses and Reporting Services
• Experience working with and supporting Always On Availability Groups
• Strong understanding of Disaster Recovery solutions and principles
• Strong Windows Server operating system skills with exposure to Active Directory and Clustering
• Exposure to and use of Enterprise Monitoring Tools such as Microsoft System Centre Operations Manager (SCOM)
• Experience working with Microsoft Azure is highly regarded
• Strong understanding of VMware virtual server technologies (vSphere / ESXi) would be highly regarded
