Senior Database Administrator (DBA)
The Senior Infrastructure Engineer Databases role is to ensure the stable operation of IT managed databases and their related infrastructure components. This includes database design, performance monitoring and tuning, database availability, backup and recovery, data integrity and security. The Senior Infrastructure Engineer will be managing and configuring databases and services across a heterogeneous environment of software and hardware vendors and with a hybrid architecture of on-premise and cloud hosted solutions. The Senior Infrastructure Engineer is expected to be involved in the strategy, design, planning, developing, installing, configuring, maintaining, supporting, and optimising of the related infrastructure component services. The person will also mentor and act as a centre of excellence to Infrastructure analysts and assist them in resolving end user hardware and software problems in a timely and accurate fashion, and provide end user training where required. Providing outstanding customer service and a customer focused approach to outcomes is a core responsibility of this role. Knowledge, Skills and Experience: - Proven experience in a comparable DBA role with detailed knowledge of SQL server 2005 - 2016. - Demonstrable experience of service design, configuration and management of SQL services and related infrastructure - In depth experience of providing second and third line DBA support - Strong knowledge on how to implement Stored Procedures, Extended Store Procedures, Triggers and Cursors, Views, Indexes, Database Normalisation, Replication, Database performance, Availability Groups - Experience of data warehousing, data architecture, data quality, ETL processes, OLAP concepts, meta data concepts and project methodology an advantage. - Experience and knowledge of Windows clustering and SQL High Availability. - Experience with database and application performance tuning and monitoring tools. - Demonstrate excellent trouble shooting skills. - Demonstrate scripting skills using T-SQL. - Good understanding of virtualisation, load balancing, clustering, caching processes. - General knowledge of storage technologies such as SAN or NAS. - Good understanding of fundamental IP routing & switching concepts. - Project management skills a definite asset.