SQL Developer Job at Ampa - Legal & Professional Services (Flexible)

Job Description

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

Developing and supporting existing SQL applications and integrations across the organisation’s application architecture within our Agile Delivery Processes
Proposing and implementing solutions to business requirements that align with our product roadmap and architecture
Supporting Change and Release Management processes as part of the software development lifecycle
Working as part of a team to transform the Application Architecture of the organisation and formalise best practice standards and methodologies
Becoming familiar with the applications, integrated solutions, backlogs and current roadmaps as well as the supported business processes
Participate in Agile Ceremonies
Begin to undertake testing tasks, progressing to basic modifications and creations of features and then on to more complex developments
Design, develop, test, and optimise SQL-based solutions
Collaborate with a team of developers and project managers to identify business requirements and translate them into technical specifications
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

A minimum of 3 years demonstrable track record of successful delivery of complex technical applications and services
Extensive experience in SQL Server development
Strong knowledge of T-SQL programming, including complex queries and stored procedures
Strong knowledge of ETL (Extract, Transform, Load) processes and tools, specifically with SQL Server Integration Services (SSIS)
Extensive experience with Azure DevOps and version control systems
Extensive experience with Microsoft Visual Studio
The 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
The ability to build good relationships with stakeholders and colleagues