At a Glance
- Tasks: Migrate and optimise SQL Server and DocumentDB environments in AWS for a major cloud project.
- Company: Join SCC, a leader in tech solutions with a focus on innovation and collaboration.
- Benefits: Competitive daily rate, hybrid work model, and opportunities for professional growth.
- Other info: Work in a supportive team with excellent career advancement opportunities.
- Why this job: Be part of a transformative cloud migration and enhance your skills in a dynamic environment.
- Qualifications: Microsoft SQL Server certification and experience with AWS migrations required.
The predicted salary is between 40000 - 48000 € per year.
We are looking for an experienced SQL Server DBA with DocumentDB skills to support a major cloud database migration programme. This SQL Server DBA role focuses on building, migrating and optimising SQL Server and DocumentDB environments within AWS, while ensuring robust governance, automation and knowledge transfer across DBA teams.
Your responsibilities as the SQL Server DBA:
- Create and migrate SQL Server database systems into AWS RDS using CDK, including DocumentDB.
- Upgrade and migrate existing MongoDB schemas and configurations into AWS DocumentDB.
- Administer DocumentDB environments, following AWS best practices.
- Script, test and implement database migrations and changes with a strong focus on performance and design.
- Ensure all database changes follow DDL governance processes, including Flyway deployments via GitLab and Jenkins pipelines.
- Liaise with Front End and delivery squads to ensure database code quality and alignment.
- Produce standardised templates for DDL changes and distribute to relevant stakeholders.
- Automate database deployments using Flyway and Git.
- Develop custom scripts to automate routine DBA tasks.
- Design and implement database refresh processes as required.
- Troubleshoot database issues and deliver resolutions within agreed SLAs.
As a successful SQL Server DBA, you will have:
- Microsoft SQL Server certification (2016/2019/2022).
- Proven experience migrating SQL Server databases into AWS.
- Hands-on experience migrating MongoDB to AWS DocumentDB.
- Strong knowledge of AWS RDS administration and best practices.
- Experience using AWS DMS and related migration tools.
- Experience building AWS RDS infrastructure using CDK (TypeScript, Python or Java).
- CI/CD experience with Jenkins and GitLab.
- Experience maintaining high-performance ETL/ELT pipelines using PySpark, SQL and Databricks Delta Live Tables.
- Experience migrating databases from on-premise to cloud platforms.
- Experience working in project environments using Kanban and JIRA.
- Familiarity with ServiceNow and Confluence.
- Excellent analytical, communication and stakeholder management skills.
NOTE: At SCC, we take the privacy and security of your information very seriously. Any information we hold will be handled in accordance with current data protection legislation. Upon submitting your application, SCC will process your information in line with our privacy policy, which can be found on our website under Legal - Privacy Notice - Flexible Resourcing.
SQL Database Administrator employer: SCC
At SCC, we pride ourselves on being an excellent employer, offering a dynamic work culture that fosters innovation and collaboration. Our Leeds location provides a hybrid working model, allowing for flexibility while engaging in exciting projects like our major cloud database migration programme. We are committed to employee growth, providing opportunities for professional development and skill enhancement, making us an attractive choice for those seeking meaningful and rewarding employment.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Database Administrator
✨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 job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your past projects, especially those involving SQL Server and DocumentDB. This will give potential employers a clear view of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios and AWS best practices. Practice explaining your thought process when tackling database migrations and optimisations, as this will impress interviewers.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might be perfect for you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace SQL Database Administrator
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL Server and DocumentDB experience. We want to see how your skills match the job description, so don’t be shy about showcasing your relevant projects and achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. Mention specific experiences that relate to migrating databases into AWS and any automation tools you've used.
Show Off Your Technical Skills:We love seeing technical expertise! Be sure to mention your Microsoft SQL Server certification and any hands-on experience with AWS RDS and migration tools. This will help us understand your capabilities right off the bat.
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your details and keep everything organised. Plus, it shows you’re keen on joining our team at StudySmarter!
How to prepare for a job interview at SCC
✨Know Your Tech Inside Out
Make sure you brush up on your SQL Server and DocumentDB knowledge. Be ready to discuss your experience with AWS, especially around RDS and migration processes. They’ll likely ask you about specific challenges you've faced and how you overcame them.
✨Showcase Your Automation Skills
Since automation is key in this role, prepare examples of how you've automated database deployments or routine tasks in the past. Highlight your experience with tools like Flyway, GitLab, and Jenkins to demonstrate your hands-on skills.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that test your problem-solving abilities. Think about common database issues and how you would troubleshoot them. Practising these scenarios can help you articulate your thought process clearly during the interview.
✨Communicate Effectively
Strong communication skills are essential, especially when liaising with front-end teams. Practice explaining complex technical concepts in simple terms. This will show that you can bridge the gap between technical and non-technical stakeholders.
