RE Partners
Database Administrator Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
-
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location