Job Summary

We are seeking a highly skilled Senior SQL Developer with over 8 years of experience in designing, developing, and optimizing complex database systems within Azure-based cloud environments. The ideal candidate will be an expert in writing sophisticated stored procedures, performance tuning, and architectural design. You will be responsible for ensuring the integrity, availability, and performance of our enterprise-level data platforms while mentoring junior developers and collaborating with cross-functional stakeholders.

Key Responsibilities

· Database Development: Design and develop highly scalable database objects, including complex stored procedures, triggers, views, and multi-table joins.

· Performance Tuning: Identify and resolve database performance bottlenecks through query optimization, index management, and execution plan analysis.

· Data Modeling: Create and maintain logical and physical data models (ERDs) for OLTP and OLAP systems to support business intelligence needs.

· Cloud Data Integration: Design and implement end-to-end ETL/ELT processes in Azure to ingest and transform data from disparate sources while maintaining high data quality standards.

· Automation: Develop automated scripts for database maintenance, data validation, and routine monitoring tasks using Azure-native tools to reduce manual overhead.

· Architecture & Strategy: Participate in architectural discussions regarding data partitioning, sharding, and high-availability (HA) configurations.

· Code Review & Mentorship: Lead code reviews for junior and mid-level developers to ensure adherence to best practices and security standards.

· Documentation: Prepare detailed technical documentation, including data dictionaries, SOPs, and system architecture diagrams.

Required Technical Skills

· Azure Mastery (Mandatory): Extensive hands-on experience with Azure SQL Database, Azure Synapse Analytics, and Azure Data Factory.

· Expert-Level SQL: Mastery of Advanced SQL (CTEs, Window Functions, Dynamic SQL, and Complex Aggregations).

· Database Platforms: Extensive experience with MS SQL Server (T-SQL), PostgreSQL (PL/pgSQL), or Oracle (PL/SQL).

· Performance Optimization: Deep understanding of indexing strategies (Clustered vs. Non-Clustered), statistics, and query profiling tools.

· ETL/ELT Tools: Proficiency in tools like Azure Data Factory, SSIS, or Informatica.

· Programming: Solid understanding of Python or PowerShell for database automation and scripting.

· Data Warehousing: Experience with Medallion architecture (Bronze/Silver/Gold) or Star/Snowflake schemas.

Preferred Qualifications

· Cloud Infrastructure: Exposure to cloud-based data warehouses such as Snowflake or Amazon Redshift.

· Reporting: Experience integrating SQL backends with visualization tools like Power BI or Tableau.

· Agile/Scrum: Familiarity with Agile methodologies and sprint-based delivery using Jira or Azure DevOps.

Soft Skills

· Stakeholder Management: Ability to translate complex data challenges into actionable insights for business leadership.

· Problem Solving: A root-cause analysis mindset with the ability to troubleshoot critical production issues under pressure.

· Communication: Strong verbal and written skills for technical documentation and cross-team collaboration.



More from Kivi-Tronics Consulting
Kivi-Tronics Consulting 1 day ago
Kivi-Tronics Consulting 1 day ago
Kivi-Tronics Consulting 14 days ago

Senior SQL Developer

Apply Now
Back to search page