At a Glance
- Tasks: Administer and optimise SQL Server, develop T-SQL, and build transformation logic.
- Company: Join a dynamic tech company in London with a hybrid work model.
- Benefits: Enjoy competitive salary, health benefits, and opportunities for professional growth.
- Other info: Collaborate with diverse teams in a fast-paced environment.
- Why this job: Make an impact by transforming data structures that support analytics and reporting.
- Qualifications: Strong SQL Server experience and problem-solving skills required.
The predicted salary is between 55000 - 70000 € per year.
Job Location: London, UK/ Hybrid
Job Type: FTE
Strong experience administering and optimizing Microsoft SQL Server in production (versions relevant to your environment).
Deep T-SQL expertise, stored procedure and function development, and experience building transformation logic at scale.
Practical experience with ETL/ELT tools and processes (SSIS, Azure Data Factory, or equivalent).
Solid understanding of data modeling (normalized and dimensional models), schema design, and data warehousing concepts.
Experience with query tuning, indexing strategies, partitioning, and columnstore/index types.
Familiarity with high-availability, disaster recovery, and security features of SQL Server.
Experience creating and maintaining metadata, data dictionaries, and schema governance.
Strong problem-solving, communication, and stakeholder-management skills.
Preferred qualifications:
- Experience with cloud-based SQL Server solutions (Azure SQL Database, Managed Instance) and hybrid architectures.
- Familiarity with BI stacks (SSRS, SSAS, Power BI) and how unified structures support reporting/analytics.
- Experience with automation and DevOps for databases (Redgate, Flyway, Liquibase, Azure DevOps pipelines).
- Certifications such as Microsoft Certified: Azure Database Administrator Associate or equivalent.
Role focused on transforming and harmonizing disparate SQL Server output structures into a single, maintainable, and high-performance data structure strategy that supports analytics, reporting, and downstream systems.
Work closely with data architects, ETL/BI engineers, application teams, and stakeholders to define standards, implement transformations, and enforce governance.
SQL Server DBA employer: Falcon Smart IT Limited
At Falcon Smart IT, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters collaboration and innovation in the heart of London. Our commitment to employee growth is evident through continuous learning opportunities and support for professional certifications, ensuring our team members thrive in their careers. With a hybrid working model, competitive benefits, and a focus on meaningful projects, we create an environment where talented individuals can make a significant impact while enjoying a balanced work-life experience.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Server DBA
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join online forums. You never know who might have the inside scoop on a SQL Server DBA role that’s perfect for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your T-SQL expertise, ETL processes, and any projects you've worked on. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios. Be ready to discuss your experience with query tuning, data warehousing, and high-availability solutions. Practice makes perfect!
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities waiting for talented SQL Server DBAs like you. Plus, it’s a great way to get noticed by our hiring team.
We think you need these skills to ace SQL Server DBA
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Microsoft SQL Server and T-SQL. We want to see how you've optimised databases and tackled challenges in your previous roles, so don’t hold back on the details!
Showcase Your Skills:When writing your application, emphasise your familiarity with ETL/ELT tools and data modelling. We love seeing practical examples of how you've used these skills to solve real-world problems.
Be Clear and Concise:Keep your application straightforward and to the point. Use bullet points where possible to make it easy for us to spot your key achievements and relevant experience. We appreciate clarity!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen to join our team!
How to prepare for a job interview at Falcon Smart IT Limited
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills and be ready to discuss stored procedures and functions. Prepare to showcase your experience with query tuning and indexing strategies, as these are crucial for the role.
✨Familiarise Yourself with ETL Tools
Since the job involves working with ETL/ELT processes, get comfortable discussing tools like SSIS and Azure Data Factory. Be prepared to share examples of how you've used these tools in past projects to optimise data transformation.
✨Understand Data Modelling Concepts
Have a solid grasp of data modelling, schema design, and data warehousing concepts. You might be asked to explain how you would approach normalised and dimensional models, so think through your experiences and be ready to articulate them.
✨Showcase Your Problem-Solving Skills
This role requires strong problem-solving abilities, so come prepared with examples of challenges you've faced in previous positions. Highlight your communication and stakeholder management skills, as collaboration is key in this position.
