At a Glance
- Tasks: Lead database optimisation efforts, analyse performance issues, and educate developers on best practices.
- Company: Join a fast-growing, woman-owned tech consultancy trusted by Fortune 500 companies since 2019.
- Benefits: Enjoy a supportive culture with a low attrition rate and referral bonuses for bringing friends.
- Other info: We value diversity and are an equal opportunity employer welcoming all qualified applicants.
- Why this job: Tackle complex database challenges while shaping the future of business technology consulting.
- Qualifications: 5+ years of SQL Server experience, strong performance tuning skills, and ability to communicate effectively.
The predicted salary is between 36000 - 60000 £ per year.
Database Administrator Engineer
We are seeking a highly skilled SQL Server Database Optimization Engineer to lead our efforts in auditing, analyzing, and optimizing our complex database systems. Our current SQL Server environment has accumulated significant technical debt—millions of stored procedures, inefficient joins, frequent query locks, and performance bottlenecks. This role is perfect for someone who thrives on solving tough database challenges, understands the intricacies of SQL Server internals, and can work cross-functionally to improve performance, structure, and maintainability.
Key Responsibilities
- Database Analysis & Audit • Analyze existing SQL Server schema, stored procedures, indexes, and relationships.
- Identify performance bottlenecks, frequent locking/blocking issues, and inefficient query patterns. • Query Optimization
- Refactor and optimize poorly written SQL queries and stored procedures. • Educate developers on writing performant SQL and best practices.
- Database Clean-Up & Refactoring • Rationalize and refactor redundant or obsolete stored procedures and tables. • Simplify overly complex joins and table relationships.
- Performance Tuning • Implement and monitor indexing strategies, query plans, and partitioning as needed. • Use tools like SQL Profiler, Extended Events, and DMVs for diagnostics.
- Governance & Best Practices • Define and implement database standards and governance procedures. • Contribute to database documentation and change management protocols.
Qualifications
- 5+ years of hands-on experience with SQL Server (2016+).
- Proven experience in performance tuning and troubleshooting SQL locks, deadlocks, and query bottlenecks.
- Deep knowledge of SQL, T-SQL, indexing strategies, and execution plans.
- Experience in reverse engineering large-scale, legacy stored procedure logic.
- Ability to communicate findings and improvement plans to both technical and non-technical stakeholders.
Nice to Have
- Experience with data modeling and schema redesign.
- Familiarity with database monitoring tools (e.g., Redgate, SolarWinds, or SQL Sentry).
- Understanding of CI/CD practices for database changes.
- Experience working in an Agile or DevOps environment.
Database Administrator Engineer employer: RE Partners Consulting
At RE Partners, we are committed to fostering a dynamic and inclusive work environment where innovation thrives. As a Frontend Engineer (Angular), you will have the opportunity to collaborate with talented professionals on cutting-edge projects while enjoying a supportive culture that prioritises employee growth and well-being. With our impressive 7% attrition rate, we take pride in our ability to keep talent happy and engaged, making us an excellent employer for those seeking meaningful and rewarding careers in technology consulting.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator Engineer
✨Tip Number 1
Familiarise yourself with the specific challenges mentioned in the job description, such as performance bottlenecks and inefficient query patterns. Prepare examples from your past experience where you've successfully tackled similar issues, as this will demonstrate your problem-solving skills.
✨Tip Number 2
Research RE Partners and their approach to database management. Understanding their values, like the '3 G's', can help you align your responses during interviews and show that you're a good cultural fit for the team.
✨Tip Number 3
Network with current or former employees of RE Partners on platforms like LinkedIn. Engaging with them can provide insights into the company culture and the specific expectations for the Database Administrator Engineer role, which can be invaluable during your application process.
✨Tip Number 4
Prepare to discuss your experience with SQL Server 2016+ and any relevant tools like SQL Profiler or DMVs. Being able to articulate your hands-on experience with these technologies will set you apart from other candidates.
We think you need these skills to ace Database Administrator Engineer
Some tips for your application 🫡
Understand the Role:Before applying, make sure you fully understand the responsibilities and qualifications required for the Database Administrator Engineer position. Familiarise yourself with SQL Server performance tuning, query optimisation, and database governance.
Tailor Your CV:Customise your CV to highlight relevant experience in SQL Server, performance tuning, and troubleshooting. Use specific examples from your past work that demonstrate your ability to solve complex database challenges.
Craft a Compelling Cover Letter:Write a cover letter that reflects your passion for database optimisation and your understanding of the company's mission. Mention how your skills align with their needs and how you can contribute to their success.
Showcase Your Technical Skills:In your application, emphasise your hands-on experience with SQL Server (2016+), including any tools you've used for diagnostics and performance tuning. Be prepared to discuss your knowledge of indexing strategies and execution plans during the interview.
How to prepare for a job interview at RE Partners Consulting
✨Showcase Your SQL Expertise
Be prepared to discuss your hands-on experience with SQL Server, especially version 2016 and above. Highlight specific examples of performance tuning, troubleshooting locks, and optimising queries you've successfully handled in the past.
✨Demonstrate Problem-Solving Skills
Since the role involves tackling complex database challenges, be ready to share instances where you've identified and resolved performance bottlenecks or inefficient query patterns. Use the STAR method (Situation, Task, Action, Result) to structure your responses.
✨Communicate Effectively
You’ll need to explain technical concepts to both technical and non-technical stakeholders. Practice articulating your findings and improvement plans clearly and concisely, ensuring you can adjust your language based on your audience.
✨Familiarise Yourself with Their Culture
Understand the company's values, particularly their focus on getting things done and caring for their team. Be ready to discuss how your personal work ethic aligns with their '3 G's' philosophy: Get Shit Done, Get Over Shit, and Give a Shit.
