SQL Developer

Ampa - Legal & Professional Services; England; Hybrid; GBP 40,000 - 55,000; Full time

Benefits offered by this job

Agile working environment

Flexible work arrangements

Diverse workplace culture

Job summary

A leading legal and professional services firm is looking for an experienced SQL Developer to join their Applications & Development division. The role involves designing and optimizing SQL-based solutions, working collaboratively in Agile environments, and supporting existing applications. Candidates should have a minimum of 3 years experience with Microsoft SQL, T-SQL programming, and be familiar with DevOps practices.

Qualifications

• Minimum of 3 years experience in SQL development and integration.
• Experience with DevOps and version control systems.
• Strong communication and collaboration skills.

Responsibilities

• Design, develop, test, and optimize SQL-based solutions.
• Support existing SQL applications within Agile processes.
• Analyze performance and optimize solutions.

Skills

Microsoft SQL development

T-SQL programming

ETL processes

Data analysis

DevOps

Analytical skills

Problem-solving

Collaboration

Tools

SSIS

SSRS

Visual Studio

Job description

Join to apply for the SQL Developer role at Ampa - Legal & Professional Services.

Ampa are looking to add an experienced SQL Developer to their growing Applications & Development division on an initial 20-month contract.

Responsibilities

• Design, develop, test, and optimise SQL-based solutions
• Developing and supporting existing SQL applications and integrations across the organisation’s application architecture within our Agile Delivery Processes
• Collaborate with a team of developers and project managers to identify business requirements and translate them into technical specifications
• Propose and implement solutions to business requirements that align with our product roadmap and architecture
• Support Change and Release Management processes as part of the software development lifecycle
• Work as part of a team to transform the Application Architecture of the organisation and formalise best practice standards and methodologies
• Perform data analysis and ensure data quality by performing data validation and quality checks
• Use DevOps for workload management and version control
• Analyse performance and optimise solutions to ensure maximum efficiency and scalability
• Provide technical support and troubleshoot reporting-related issues
• Create visualisations and reports for requested projects
• Conduct unit testing/test-driven development processes and troubleshooting
• Evaluate and improve existing SQL-based solutions

Role priorities

• Becoming familiar with the applications, integrated solutions, backlogs and current roadmaps as well as the supported business processes
• Begin to undertake testing tasks, progressing to basic modifications and creations of features and then on to more complex developments

What you will need

A minimum of 3 years demonstrable track record of successful delivery of complex technical applications and services. You will need to have previous experience with the below tech stack:

• Extensive experience in Microsoft SQL development, including Integration Services (SSIS), Reporting Services (SSRS)
• Strong knowledge of T-SQL programming
• Experience with Visual Studio
• Strong knowledge of ETL (Extract, Transform, Load) processes and tools, such as SSIS
• Experience with DevOps and version control systems
• Strong analytical and problem-solving skills
• Ability to work independently and as part of a team
• Strong communication and collaboration skills

Experience with the following would be beneficial

• DevOps Automated Testing
• Microsoft .Net
• Ability to produce high quality technical material, and to identify and develop opportunities to provide business benefit
• Strong operational transformation experience with an analytical skillset to assess, identify and exploit opportunities
• Excellent organisation and the ability to prioritise and carry out multiple tasks
• Strong problem-solving abilities with the ability to think ahead and anticipate problems, issues, and solutions
• Ability to build good relationships with stakeholders and colleagues

Benefits, Agile Working and Additional information

We embrace agile working and offer a blended approach to where and how we work. We appreciate that people have different needs and preferences and we’re keen to be flexible, after all, we value what you do, not where you do it.

We have the following hubs across the UK: Birmingham, Bristol, Leicester, Lincoln, London, Milton Keynes, Nottingham, Solihull, Stratford upon Avon, Sheffield and in the South; Crawley, East Grinstead, Lewes, Brighton, Eastbourne, Seaford, Peacehaven, Storrington, Chichester & Southampton as well as our Scotland office located in Edinburgh.

Equal opportunities

Ampa Group is a committed equal opportunities employer. We seek to attract, develop and retain talented people from a diverse range of backgrounds and cultures. We value and respect individuality and encourage a culture within our business where people can be themselves and be valued for their strengths and experiences. Everyone who either applies to or works for the firm is treated equally, regardless of gender, age, ethnic origin, nationality, marital status, sexual orientation or religious beliefs.

About Ampa Group

Welcome to Ampa - a leading group of legal and professional services brands, home to leading legal services firms such Shakespeare Martineau, Lime Solicitors, Mayo Wynne Baxter, Marrons and others. Our ‘House of Brands’ is where legal and professional service brands converge to unlock opportunities for career advancement, collaboration, and comprehensive business services support across HR, IT, finance, and marketing. Our purpose is to enable growth of every brand within our collective through shared infrastructure and central support.