SQL DBA

Job Description

SQL DBASearchDATA Group are partnered with a Newcastle-based Fintech business that is revolutionising wealth management by using technology to deliver innovative solutions that simplify financial planning. Their approach blends the best in qualified and regulatedfinancial advice with easy-to-use technology that gives you the know-how of an expert investor in the palm of your hand.Not only are they a fully tech-led company, but their DBAs are the most highly specialised SQL professionals in the organization, so your work will be highly visible, and you can look forward to great career progression opportunities!In fact, there is no better time to join them as they are focused on growing their team and career progression is at the forefront of their commitment to staff. In addition, they are implementing a new company-wide data strategy, so there is plenty to getstuck into!In this role you will use T-SQL to manage and fine-tune databases, executing improvements as you track their performance. You’ll get to play with a vast database ecosystem, and this is the role for you if you want to be able to share your expertise, providebest practice guidance and really make an impact by focusing on the performance tuning of their giant databases.What makes this company differentWorking here will allow you to join an award-winning technology firm and influence their future technology and get embedded in a highly successful team of experts.Everyone has a voice and gets to take real ownership of their work. The fact that they have retained 100% of the original developers who built the technology from version 1 speaks for itself - they have a truly positive and supportive work culture!They are rooting for your career development - they are not afraid of upskilling their staff, and they will support you with industry-specific training (whether you are onsite or working from home), often running training courses and bootcamps for theirteams.Just as important - they will give you clearly defined expectations and opportunities for career development and progression, and don’t shy away from having open and honest conversations on the subject.When it comes to career progression, they don’t have any set deadlines or qualifications required. You get to make the position your own, and if you perform well, have a good work ethic, share knowledge with the rest of the team and help upskill junior staff,you really can get fast-tracked for career progression when compared to most other companies out there!What are they offering

• Salary from £45k up to £55k
• Monthly bonus
• 23 days of holiday (plus bank holidays)
• Hybrid working (2 days a week in their Newcastle office)
• Industry-leading training
• Free parking

What are the requirements

• Very strong SQL Server (SQL 2016) / Azure SQL database administration experience
• Strong practical experience of creating optimised procedures, tables, SQL server agent jobs and functions using T-SQL script, as well as providing solutions and workarounds to incidents/problems in script
• Very strong experience of database performance-tuning and the ability to assist software developers in the identification and resolution of performance bottlenecks
• Great script, index and procedure tuning skills
• Capable of managing, maintaining, and supporting the group’s SQL Server databases (around 1100 databases)
• Experience of and comfortable querying and maintaining very large databases (6TB) and partitioning large tables
• Experience of reading an execution plan with all details, cardinality estimate, logical reads, etc.
• Experience of query optimisation and database design optimization, and the ability to provide consultation to software developers on querying and table design (including index recommendation or script optimization)
• Experience of back-up/recovery of databases that include full, differential and log backup-ups
• Understanding of failover clusters
• The ability to pro-actively research and recommend courses of action to improve database performance
• Working alongside software development teams, supporting and advising on best practice to maintain performance and availability

Desirable skills (or what you can upskill on)

• Experience of database migrations from on-prem to on-prem and/or cloud (Azure)
• Understanding of performance-tuning software like Solarwinds DPA
• Azure Data Factory and Azure Synapse Analytics knowledge/experience

Keyskills :
Database AdministrationDatabase DesignDatabasesSQLSql ServerWindows AzureDatabase AdminT-SQL