Data Platform Engineer (DBA)

Location: Haywards Heath, Home Office (Remote) or Manchester

Salary: £34,500 - £54,000 - depending on experience

Department: Technology and Data

We’re First Central Insurance & Technology Group (First Central for short), an innovative, market-leading insurance company. We protect the things customers love so they can get on with what matters to them in life. Data drives us. It fuels our outstanding distribution, finance, technology and legal services. Our underwriting skills are built on data expertise; it creates the insights we need to give the right cover to the right customers at the right price.

Our Technology and Data team needs a result-driven, agile and logical thinking DBA, who knows a thing or two about MS SQL Server Technology Stack and T-SQL. Ideally, you’ll have been involved in database schema design and some exposure to performance tuning; if you’ve Azure Fundamentals and/or Azure Data Fundamentals certification, all the better!

Joining a busy team within the Data Operations business pillar and inside the Data as a Service (Daas) team, you’ll support our core platform database estate and be responsible for managing and providing assistance to all aspects of our database landscape, working closely with colleagues to design, build and manage our database solutions. The estate consists of both stand-alone and Windows Server Failover Cluster builds, with SQL Server Always On technology providing a further layer of High Availability.

You’ll not just offer a basic solution, you’ll find improvements to current processes and seek to implement Best Practice, document systems and workarounds and latest versions of SQL. With a strong understanding and experience of T-SQL, and the SQL Server technology stack (including the Database Engine, SSRS and SSIS), and SQL Server in MS Azure, you’ll have a proven track record of supporting business-critical databases and infrastructure in a large corporate environment. This role requires you to work out of hours during releases when needed.

Core skills we’re looking for to succeed in the role:

• SQL and Database Ownership: You’ll enjoy taking ownership of SQL and database-related tasks.
• MS-SQL and T-SQL Experience: You’ll possess solid experience of working with MS-SQL and T-SQL from SQL 2008 through to 2019.
• Innovative Solutions and Enthusiasm: You’ll be confident and enthusiastic, willing to offer innovative solutions that contribute to our continued success.
• High Availability and Disaster Recovery (HA/DR): You’ll have experience of working with available SQL Server HA and DR technologies.
• Positive Attitude and Boundary-Pushing: You’ll possess an outstanding and enthusiastic attitude, will enjoy pushing boundaries to develop best-of-breed solutions.
• Proactivity and Passion for Data: You’ll be proactive and passionate about all things data and SQL Server.

What’s involved:

• You’ll be proficient with MS-SQL and T-SQL tools, and Microsoft SQL Server 2008 or above.
• You’ll be proficient with Microsoft SQL Server Integration options.
• You’ll need intermediate experience troubleshooting and resolving database problems.
• You’ll need intermediate experience implementing and managing backup and recovery processes.
• You’ll have some experience managing coding standards, security and auditing procedures.
• You’ll have experience managing monitoring/proactive alerting processes.
• You’ll need intermediate experience with root cause analysis, database performance monitoring and capacity planning.
• You’ll ensure all database systems meet business and performance requirements.
• You’ll have the ability to work towards strict deadlines within a busy, high transactional environment.
• You’ll assist with SQL code reviews and implementation of performance improvements.
• You’ll possess excellent communication and interpersonal skills.
• You’ll possess excellent time management and coordinating skills.
• You’ll possess excellent analytical and problem-solving skills.
• You’ll comply with the requirements, and act in accordance with, the Group Code of Conduct and Fitness and Propriety policies at all times.
• You’ll ensure compliance with Company Policies, Values and guidelines and other relevant standards/regulations at all times.

Experience & knowledge:

• Intermediate T-SQL.
• Understanding of DEVOPS principles and how such can be implemented.
• Intermediate experience of source control technologies and application of such, such as Azure DEVOPS.
• Intermediate understanding of SSIS, SSRS and SSAS components, installation, maintenance and security.
• An intermediate understanding of the different levels of DB security and interaction with Active Directory.
• An understanding of GDPR and how it relates to the database world.
• An understanding of Data Warehousing concepts and support would be useful.
• A level of exposure and intermediate experience of SQL upgrade paths.
• Intermediate experience with performance tuning/index maintenance/index creation/statistics maintenance.
• Some experience of the configuration and use of SQL Server backups (types/implementation/use).
• Some experience of the configuration and use of SQL Server replication (transactional and snapshot).
• Some experience of the configuration and use of SQL Server Always on and Windows/SQL Server clustering.
• An understanding of Blocking/Locking/Deadlocks – how to monitor and overcome.
• Environment baselining and load testing.
• Exposure to The RedGate SQL Toolset/SSMS 18.xxx/Quest Spotlight | Replication Monitor and other industry standard monitoring tools.
• An understanding of and some exposure to SQL Server auditing/encryption/vulnerability assessments/data classification/Query Store etc.
• Creation and use of DACPAC and BACPACs.
• An appreciation of and willingness to learn SQL Azure PAAS and IAAS database solutions.
• Support out of hours and on-call workloads.
• Understand, maintain and recommend suitable SQL environment RTOs and RPOs.
• Exposure to table partitioning techniques within SQL Server.
• Server and storage management knowledge and experience.
• Experience working with XML data types and large objects.
• Experience working within an agile development environment.
• Experience with Atlassian Confluence Team foundation Server (TFS). (desirable)

Skills & Qualifications:

• Good communication skills, both verbal and written.
• Good time management and organisation skills.
• MCSE: Data Platform or equivalent.
• A degree in computer science or a similar subject area (desirable).
• Have relevant and current experience as a production DBA supporting multiple instances (3-4 years’ experience working with the MS SQL Server Technology Stack).
• Willing to learn and build on their professional development, and keep pace with industry trends within the SQL Server, to enable effective support of the business.
• Be an active member of the wider SQL community (desirable).
• Industry recognised Change and Project Management certifications (ITIL, Prince2 etc desirable).
• Azure Fundamentals and/or Azure Data Fundamentals certification or willingness to obtain such.

Behaviours:

• Commercially focussed and results driven.
• Self-motivated and enthusiastic.
• An organised and proactive approach.
• Ability to work on own initiative and as part of a team.
• A flexible approach and positive attitude.
• Strives to drive business improvements to contribute to the success of the business.

This is just the start. Imagine where you could end up! The journey’s yours… Want to know more? Sounds like you? Then click on Apply.