SQL DBA (Senior)

• Design, develop, and optimize complex SQL Server database solutions, writing efficient, scalable, and maintainable T -SQL code, including stored procedures, views, functions, and queries.
  
• Analyse execution plans, troubleshoot performance issues, and implement indexing, partitioning, and optimization strategies to resolve bottlenecks related to large datasets and high -volume workloads.
  
• Design scalable relational and analytical data models, building structures optimised for both operational and reporting workloads.
  
• Build and maintain data ingestion and transformation processes, developing reliable ETL/ELT pipelines and integrating data from internal and external systems.
  
• Ensure solutions are scalable, reliable, and maintainable, optimising data access patterns and reducing the impact on transactional systems.
  
• Define standards for naming conventions, database design, and documentation; contribute to code reviews and enforce SQL/database best practices.
  
• Mentor developers and engineers on SQL optimization and data engineering practices, and work closely with application developers, BI teams, analysts, and stakeholders.
  
• Support backend application data requirements and reporting needs, promote high -quality, testable solutions, and contribute to ongoing improvements in data architecture and engineering practices.
  

• 6+ years of hands -on experience in complex query development, stored procedures, execution plan analysis, and comprehensive query optimization and troubleshooting.
  
• Deep expertise in indexing strategies, partitioning, transaction management, and resolving performance bottlenecks related to locking, blocking, deadlocks, and IO/memory optimization, especially with large -scale data.
  
• Strong experience designing both normalised relational models (3NF/OLTP) and dimensional models (star/snowflake schemas), with a focus on data integrity, scalability, and historical data tracking.
  
• Proven ability to design solutions separating transactional and reporting workloads, diagnose and resolve performance issues through index tuning, query refactoring, and data access optimization.
  
• Experience in ETL/ELT processes and data pipeline design, utilising tools like Azure Data Factory (ADF), SSIS, dbt, Informatica, and integrating various data sources (APIs, flat files, JSON/XML).
  
• Familiarity with Azure SQL, Synapse Analytics, Microsoft Fabric, Data Lake architectures, Git, Azure DevOps, CI/CD pipelines, engineering standards, and beneficial familiarity with BI tools like Power BI/Tableau.
  

Requirements