Job Title: SQL Database Developer
Number of vacancies:1
Job Salary: £50000 - £55000 per annum
Starting date: 07/11/2024
Closing date: 07/12/2024
Location: Fairbourne Drive, Milton Keynes
Job reference:SUNIT/1024/SQL-01/1051
Job Summary:
We are seeking a skilled SQL Database Developer to design, develop, and maintain robust database systems. The ideal candidate will have experience in database architecture, SQL development, and data analysis to optimize database performance and support our organization's data needs.
Key Responsibilities:
o Design and implement complex database solutions based on business requirements.
o Develop and optimize SQL queries, stored procedures, views, and functions.
o Ensure data integrity, security, and performance across databases.
o Conduct performance tuning of databases, query optimization, and indexing strategies.
o Monitor and improve database performance and scalability.
o Create and maintain data structures to support reporting and analytics.
o Develop ETL processes to transform data from various sources into usable formats.
o Collaborate with data analysts and stakeholders to support data reporting needs.
o Perform regular database maintenance, including backups, restores, and data migration.
o Troubleshoot database issues, identify root causes, and implement solutions.
o Ensure compliance with data security policies and procedures.
Education:
o Bachelor’s degree in computer science, Information Technology, or good experience in related field.
Required Skills and Experience:
•Technical Skills:
o Strong proficiency in SQL and experience with database systems such as MySQL, PostgreSQL, Oracle, or SQL Server.
o Experience with database design, normalization, and data modeling.
o Knowledge of ETL processes and data integration tools (e.g., SSIS, Informatica, or Talend).
o Familiarity with data warehousing, reporting, and BI tools like Power BI, Tableau, or SSRS.
o Good experience as an SQL Database Developer or similar role.
o Proven experience with database optimization, including indexing and query performance tuning.
o Experience with version control systems (e.g., Git).
o Strong problem-solving skills and attention to detail.
o Ability to work both independently and as part of a team.
o Excellent communication skills to work with cross-functional teams and stakeholders.
Preferred Qualifications:
• Familiarity with cloud database solutions (e.g., AWS RDS, Azure SQL Database).
• Experience in data warehousing or Big Data environments.
• Knowledge of programming languages such as Python, R, or Java.