Beschreibung
SQL Engineer
My client who are a large financial institution are recruiting a SQL Engineer to join their team.
Project
You will be primarily responsible for the Microsoft Server and MS SQL environment, with secondary responsibilities for 3rd level and application support. Additionally, you will be required to undertake solution architecture duties as needed and work across multiple projects.
Tasks
- Implementation, support, maintenance, and performance tuning of standalone, FCI MS SQL clusters
- Maintenance of the Microsoft server platform baseline configuration and introduction of new features
- Management of the security and configuration baselines for the Windows server environment
- Performance of project management activities alongside 3rd level support
- Creation of scripts for the purposes of automating technical infrastructure services and requests
- Provide SME support for applications, SQL, and the Windows platform
- Keeping anti-virus agents up to date as well as the associated ePO server
Required Experience
- Demonstrable knowledge of Microsoft SQL database technologies, especially in FCI (WSFC and AlwaysOn), as well as backup restore management
- Strong knowledge in optimization of complex T-SQL queries and indexes, using execution plans, Extended Events, and other appropriate tools
- Profound knowledge of Microsoft Sever operating systems (MS Server 2012 R2 through to 2019)
- Very strong Scripting skills in Powershell with a capability to develop complex scripts from scratch
- Strong understanding of common enterprise infrastructure and technologies (eg, AD, GPO, DNS, load balancing and clustering, virtualization and storage)
- Good understanding of how to implement least privilege security within an AD environment
- Good understanding of the web application technology stacks
- 7+ years of experience as system engineer within an enterprise environment, with at least 4 of them having been as an MS SQL database administrator in a clustered environment
- 4+ years of hands-on experience with Windows server management
- 2+ years of experience in integrating infrastructure applications
- University degree (preferred) or formal IT related education
- Worked within a regulated environment (eg, pharmaceuticals, banking) that has structured Incident, Problem, and Change Management
- vRealize Automation (vRA) and Orchestration (vRO) an advantage
- McAfee ePO AV management an advantage