At a Glance
- Tasks: Join our dev team to design and manage SQL solutions for data migration projects.
- Company: Bromcom is a forward-thinking company focused on innovative data solutions.
- Benefits: Enjoy a collaborative work environment with opportunities for growth and skill development.
- Why this job: This role offers hands-on experience with SQL and impactful projects in a supportive team.
- Qualifications: 3+ years of SQL experience and knowledge of MS SQL Server required; teamwork skills are essential.
- Other info: Knowledge of Azure Data Factory is a bonus; we value diversity and equal opportunities.
The predicted salary is between 36000 - 60000 £ per year.
Work within the development team reporting to the Software Manager.
Responsibilities
- Responsible for design, development and management of high quality, efficient and effective solutions in Microsoft SQL Server T-SQL and related tools to support and extend various large-scale data migration projects.
- Provide database performance-tuning expertise for internal and third-party systems in SQL Server.
- Provide technical knowhow on projects and work with third parties to understand how their software works to support data migration.
- Design, develop, and maintain appropriately scaled, effective solutions to support data cleansing, migration and reconciliation activity in Microsoft SQL Server T-SQL and related tools.
- Define technical requirements, working with non-technical members of the Data Migration Team.
- Manage MS SQL Server database environments that support data migration and backups and recoveries in test environments.
- Demonstrate a logical and structured approach to time management and task prioritisation. Work within project timelines and requirements. Organise own time, schedule tasks for completion and deliver work to that schedule.
The Ideal Candidate
- Substantial experience of SQL programming and an excellent knowledge of the techniques and the functionality and capabilities of MS SQL Server 2014 and above.
- A strong background in data modelling, data management and data manipulation, code management and version control (GIT) is also important, as is having good attention to detail.
- Capable of working through problems independently and liaising with team members to find quality solutions.
- Knowledge of Azure Data Factory (ADF) would be a bonus.
Your Job Will Involve
- Writing complex scripts for data manipulation and management report generation.
- Export/Import of data.
- Data conversion/migration.
- Database object creation (Functions, Stored Procedures, Tables, etc).
- Performance tuning of new and existing code.
- Analyse SQL code for potential flaws.
- Optimization and maintenance of existing products.
- Problem solving for actual customer data.
Desired Skills
- 3+ years of SQL Developer experience and administrating/supporting MS SQL Server Database infrastructures in large-scale environment.
- Excellent teamwork, communication, and documentation skills.
- Reasonable understanding of OS and Infrastructure / Network layer.
- Experience of querying API end points (SOAP, REST).
- Basic experience with programming (ASP.NET, XML, HTML, C#) is a plus.
Bromcom is an equal opportunities employer.
#J-18808-Ljbffr
SQL Developer employer: Bromcom
Contact Detail:
Bromcom Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Developer
✨Tip Number 1
Make sure to showcase your experience with Microsoft SQL Server, especially versions 2014 and above. Highlight specific projects where you've successfully implemented data migration solutions or performance tuning.
✨Tip Number 2
Familiarize yourself with Azure Data Factory (ADF) as it’s mentioned as a bonus skill. Even if you don’t have extensive experience, showing that you’ve done some research or have basic knowledge can set you apart.
✨Tip Number 3
Demonstrate your problem-solving skills by preparing examples of how you've tackled complex SQL issues in the past. Be ready to discuss these scenarios during the interview.
✨Tip Number 4
Since teamwork is emphasized, think of instances where you've collaborated effectively with non-technical team members. Being able to communicate technical concepts clearly will be a big plus.
We think you need these skills to ace SQL Developer
Some tips for your application 🫡
Understand the Role: Make sure to thoroughly read the job description for the SQL Developer position. Understand the responsibilities and required skills, especially focusing on SQL programming, data migration, and performance tuning.
Tailor Your CV: Customize your CV to highlight your experience with MS SQL Server, T-SQL, and any relevant projects you've worked on. Emphasize your problem-solving skills and teamwork experience, as these are crucial for the role.
Craft a Strong Cover Letter: Write a cover letter that connects your background in SQL development and data management to the specific needs of the company. Mention any experience with Azure Data Factory or other relevant tools to stand out.
Showcase Your Technical Skills: In your application, provide examples of complex SQL scripts you've written, data migration projects you've managed, and any performance tuning you've conducted. This will demonstrate your technical expertise and attention to detail.
How to prepare for a job interview at Bromcom
✨Showcase Your SQL Expertise
Be prepared to discuss your experience with SQL programming in detail. Highlight specific projects where you've used MS SQL Server 2014 or above, and be ready to explain the techniques and functionalities you utilized.
✨Demonstrate Problem-Solving Skills
Prepare examples of how you've tackled complex data migration challenges in the past. Discuss your approach to performance tuning and how you identified and resolved potential flaws in SQL code.
✨Communicate Clearly with Non-Technical Team Members
Since you'll be working with non-technical members of the Data Migration Team, practice explaining technical concepts in simple terms. This will show your ability to bridge the gap between technical and non-technical stakeholders.
✨Time Management and Task Prioritization
Be ready to discuss how you manage your time and prioritize tasks effectively. Share examples of how you've organized your workload to meet project timelines and deliverables.