Job Location: hybrid in (town)

Overall Objective of the Role:

We are looking for a Mid-Level SQL Developer to manage and improve our on-premisedatabase environment. 

This role focuses on performance, design, and maintenance. 

The ideal candidate has strong experience with SQL (preferable SQL Server), knows how to optimize database performance, and works well with developers and BA to build efficient and scalable solutions.

Responsibilities

Requirements Engineering: Collaborate with Business Analysts and development teams to design and optimize database structures that align with business requirements. 

End-to-End Development: Design and deliver new data projects end-to-end, from source systems through data processing and modeling, to the final reporting layer, including implementing new requests and enhancements for existing projects. 

Query Optimization: Design and optimize database structures (indexing, partitioning, normalization). 

Documentation: Author and maintain comprehensive technical specifications.

Performance: Proactively analyze, troubleshoot, and resolve query performance bottlenecks and production database slowdowns. 

Production Reliability: Provide ongoing support for production servers, ensuring system stability, performance, and reliability, while assisting with issue resolution and continuous improvements. 

Data Support (L3): Act as the Level 3 escalation point for Power BI data issues, ensuring data lineage accuracy and high availability for executive reporting.

Mentorship & Best Practices: Provide technical guidance and peer code reviews to development teams to uphold quality SQL standards across the organization. 

Modernization: Stay current with emerging database technologies.

Must Have:

Education: B.Sc. / B.A. in Computer Science, Software Engineering, or a related technical field. 

Experience: 3–5 years of proven hands-on experience as a SQL Developer or Database Engineer in a production environment. 

Performance Engineering: Understanding of SQL query optimization, indexing strategies and analyzing execution plans to resolve bottlenecks. 

Architecture & Design: Practical experience in relational database design (Normalization/Denormalization), Dimensional Modeling. 

Large-Scale Data: Experience managing and querying large datasets (millions/billions of rows), including partitioning strategies and archival processes. 

Problem Solving: Analytical skills with a "forensic" approach to troubleshooting data discrepancies and production slowdowns. 

Soft Skills: Strong communication skills with the ability to explain technical database concepts to non-technical stakeholders. Fluent in English.

Nice to Have:

BI Ecosystem: Practical experience with the Microsoft BI Stack (SSIS, SSAS, SQL Server) or Power BI (DAX/Power Query) to better support end-user reporting requirements.

Database Administration (DBA) Fundamentals: Basic knowledge of SQL Server maintenance tasks, such as managing backups/restores, configuring SQL Agent jobs, and monitoring disk latency/IOPS. 

Advanced Analytics: Knowledge of Window Functions, Recursive CTEs, and JSON/XML processing within SQL Server for complex data transformations

Version Control: Utilize Visual Studio and TFS to manage SSIS/SSAS solutions, maintaining a "single source of truth" for all development projects and ensuring structured deployment workflows.