At a Glance
- Tasks: Manage SQL data migrations and develop SQL Server platforms for diverse clients.
- Company: Join a leading software company in Bristol known for its award-winning products.
- Benefits: Enjoy a hybrid work model with 1-2 days on-site and full-time employment.
- Why this job: Be part of a dynamic team driving data solutions that impact various industries.
- Qualifications: Proven SQL development experience, especially in data migrations and SQL Server tools.
- Other info: Collaborate with stakeholders to ensure data requirements are met and documented.
The predicted salary is between 36000 - 60000 £ per year.
Job description * Work within the development team reporting to the Software Manager. * 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. Job requirements * Responsibilities will include designing, developing, and maintaining appropriately scaled, effective solutions to support data cleansing, migration and reconciliation activity in Microsoft SQL Server T-SQL and related tools. * Defining technical requirements, working with non-technical members of the Data Migration Team. * The role requires you to manage MS SQL Server database environments that support data migration and backups and recoveries in test environments. * Demonstrating a logical and structured approach to time management and task prioritisation. Working within project timelines and requirements. Being able to organise own time, schedule tasks for completion and deliver work to that schedule. The Ideal Candidate * The ideal candidate will have 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) * Good to have basic experience with programming (ASP.NET, XML, HTML, C#) Bromcom is an equal opportunities employer
SQL Developer employer: Bromcom Computers
Contact Detail:
Bromcom Computers Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Developer
✨Tip Number 1
Familiarize yourself with the specific SQL Server tools mentioned in the job description, such as T-SQL and SSIS. Having hands-on experience or projects that showcase your proficiency with these tools can set you apart from other candidates.
✨Tip Number 2
Highlight any previous experience you have with data migrations and ETL processes. Be prepared to discuss specific challenges you faced and how you overcame them during the interview, as this will demonstrate your problem-solving skills.
✨Tip Number 3
Since collaboration is key in this role, think of examples where you've successfully worked with stakeholders to meet data requirements. Being able to communicate your experiences effectively will show that you're a team player.
✨Tip Number 4
Stay updated on the latest trends and best practices in SQL database development and optimization. Mentioning recent developments or techniques during your conversation can demonstrate your commitment to continuous learning and improvement.
We think you need these skills to ace SQL Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL development experience, especially in data migrations and database optimization. Use specific examples that demonstrate your proficiency with T-SQL, SSIS, and performance tuning.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your skills align with the key responsibilities, particularly in managing SQL-based data migrations and collaborating with stakeholders.
Showcase Relevant Projects: If you have worked on relevant projects, describe them briefly in your application. Focus on your role in data migration, ETL processes, and any challenges you overcame to enhance database performance.
Proofread Your Application: Before submitting, carefully proofread your application for any errors or typos. A polished application reflects your attention to detail, which is crucial for a SQL Specialist role.
How to prepare for a job interview at Bromcom Computers
✨Showcase Your SQL Expertise
Be prepared to discuss your experience with SQL Server, particularly in data migrations and mapping. Highlight specific projects where you successfully managed SQL-based data migrations and the tools you used, such as T-SQL and SSIS.
✨Demonstrate Problem-Solving Skills
Expect questions about troubleshooting data migration issues. Prepare examples of challenges you've faced in past projects and how you resolved them, focusing on maintaining data quality and consistency.
✨Discuss Database Optimization Techniques
Since performance optimization is key, be ready to talk about your approach to query tuning and indexing. Share specific instances where your optimizations led to improved database performance.
✨Emphasize Collaboration and Communication
As collaboration with stakeholders is crucial, prepare to discuss how you've worked with different teams to meet data requirements. Provide examples of how you communicated updates and documented processes effectively.