SearchDATA Group are partnered with a Newcastle-based business that arestriving to revolutionise wealth management byusing technology to drive change and deliver innovative solutions that simplify financial planning. Their approachblends the best in qualified andregulated financial advice with technology that gives you the know-how of an expert investorin the palm of your hand.
In this role you will use T-SQL to manage and fine-tune databases, executing improvements asyou track their performance.
This role allows for a balance of independent work as well asworking with a successful and expert team. Tomeasure your success, they assign you objectives and take into accountthe successful delivery of eachindividual project, how intuitively and quickly you respond to real-life issues, and your ability to work and shareknowledge with others.
What makes this company different?
Working with our client will allowyou to join their award-winning technologyfirm and influence their future technology.
Everyone is able to make themselves heard and take real ownership oftheir work. The fact that they have retained 100% of the original developerswho built the technology from version 1 speaks for itself – they have a trulypositive and supportive work culture!
They want you to fulfill your potential – they are not afraid ofupskilling their staff, and they will support you with industry-specifictraining (whether you are onsite orworking from home), often running training courses for everyone who wouldbenefit from it.
Just as important – they will giveyou a clearly defined expectations and opportunities for development and careerprogression conversations, and don’t shy away from having open and honestconversations on the subject.
When it comes to career progression, they don’t have any set deadlines or qualifications required, and they allow you to make the position your own. If you perform well, have a good work ethic, and show that you can become a more senior member of the team, they will then reward you with a promotion and additional reasonable responsibilities.
What are they offering?
* Salary from £45k up to £50k
* 23 days of holiday (plus bank holidays)
* Hybrid working (2 days aweek in their Newcastle office)
* Industry-leading training
What are the requirements?
* 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
* 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 database performance-tuning and the ability to assist software developers in the identification and resolution of performance bottlenecks
* 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 the 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
* of performance bottlenecks
* 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 the 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)
1. Experience of databasemigrations from on-prem to on-prem and/or cloud (Azure)
2. Understanding of performance-tuning software like Solarwinds DPA
3. Azure Data Factory and Azure SynapseAnalytics knowledge/experience
#J-18808-Ljbffr