SQL Developer/DBA
Join a leading global speciality chemicals company embarking on a significant data migration project.
We usually respond within a day
Join a leading global speciality chemicals company embarking on a significant data migration project.
The business is kicking off on a transformative data migration project from an AIX-based ERP system to SAP. To support this critical initiative, they are seeking a highly experienced SQL Developer/DBA to join their team on an 18-month fixed-term contract, with a strong likelihood of extension.
Your New Role:
As a SQL Developer/DBA, you will be crucial in ensuring the smooth transition and ongoing efficiency of the business's database systems. You will be responsible for understanding and documenting existing data structures, designing and optimising new database schemas, and ensuring data integrity throughout the migration process.
Responsibilities:
Database Administration:
- Perform routine database maintenance tasks, including backups, restores, and performance tuning.
- Manage high traffic loads through sharding and indexing.
- Ensure compliance with data security and protection legislation.
- Use tools like Microsoft Access, Oracle Database, and phpMyAdmin for management and analysis.
Data Migration:
- Handle data migration to SAP ERP, ensuring data integrity and minimal downtime.
- Utilise SSIS (SQL Server Integration Services) for data integration tasks.
Database Development:
- Write and optimise complex queries and stored procedures in SQL variants like MySQL, MSSQL, and PostgreSQL.
- Design efficient database structures to support business needs.
- Develop and implement SSAS (SQL Server Analysis Services) for advanced data analysis.
Reporting and Analysis:
- Build and output reports from multiple data sources using tools such as Power BI.
- Analyze database performance and generate actionable reports.
Collaboration and Problem-Solving:
- Work closely with team members to understand data requirements and ensure effective communication.
- Troubleshoot and resolve database-related issues using programming languages like JavaScript.
Experience Needed:
- 5-7 years of SQL experience.
- Advanced knowledge of database procedures and Microsoft SQL Server concepts.
- Proficiency with MySQL, MSSQL, and PostgreSQL.
- Experience with Power BI and other reporting tools.
- Proven experience in data migration, particularly to SAP ERP.
- Ability to create fast and efficient database queries, including complex joins and cross-referencing.
- Familiarity with Microsoft Access, Oracle Database, and phpMyAdmin.
- Experience with SSAS and SSIS.
- Excellent problem-solving and communication skills.
Benefits:
- Competitive salary of £50,000 per annum
- Opportunity for hybrid working (post first couple of months onboarding)
Equal Opportunity: Humnize represents clients that are equal opportunity employers and do not discriminate based on race, nationality, gender, religion, age, sexual orientation, marital status, disability, or any other protected category. We and our clients celebrate diversity and are committed to creating inclusive environments for all employees.
Please note: in line with the UK employment law, candidates must be eligible to live and work in the UK, and upon offer, proof of eligibility will be required.
- Role type
- Data Analytics and BI
- Locations
- Leeds
- Remote status
- Hybrid Remote
- Yearly salary
- £50,000 - £55,000
![Picture of Dean Watmough](https://images.teamtailor-cdn.com/images/s3/teamtailor-production/square_226-v4/image_uploads/d3e90933-dd36-48ef-b0f8-294f55f4bfe0/original.jpeg)
SQL Developer/DBA
Join a leading global speciality chemicals company embarking on a significant data migration project.
Loading application form