We are on the lookout for a passionate and highly experienced SQL Developer who brings both technical depth and practical experience in Azure SQL Database, Linked Servers, Database Replication, and Azure Synapse Analytics (formerly Azure Parallel Data Warehouse). This is an exciting opportunity to be part of a forward-thinking, innovation-driven team working on scalable, cloud-based data solutions that power critical business decisions.
As a key member of our data engineering and development team, you will play a vital role in designing, developing, optimizing, and maintaining robust SQL-based systems and integrations across hybrid infrastructures. You will collaborate closely with architects, developers, DevOps, and business stakeholders to ensure that our data systems are performant, secure, and aligned with business goals.
What You’ll Be Doing
- Design, write, and maintain advanced SQL queries, stored procedures, functions, views, and triggers tailored for Azure SQL Database and other SQL Server environments.
- Set up, configure, and manage Linked Servers to facilitate seamless connections between cloud-hosted and on-premise databases.
- Implement, monitor, and troubleshoot SQL Server Replication (Transactional, Merge, Snapshot) for both Azure and on-premises environments to support data synchronization across systems.
- Work hands-on with Azure Synapse Analytics / Azure Parallel Data Warehouse (PDW) to design scalable data models and ensure seamless data integration.
- Perform advanced query optimization, indexing strategies, and performance tuning to ensure optimal database performance and minimize latency.
- Collaborate with DevOps and cloud architects to ensure high availability, disaster recovery, and automated backup strategies for all production environments.
- Play an active role in migrating databases from legacy on-premise systems to modern Azure cloud-based solutions.
- Monitor performance using Azure-native tools and third-party monitoring solutions to proactively identify and resolve bottlenecks.
- Adhere to and promote best practices in database design, cloud security, data governance, and compliance standards.
- Prepare and maintain comprehensive documentation related to data architecture, stored procedures, replication configurations, and database operations.
- Support and mentor junior developers and work collaboratively with cross-functional teams including data analysts, software developers, and solution architects.
What We’re Looking For
- 5+ years of experience as an SQL Developer, Database Engineer, or in a similar role involving large-scale database systems.
- Strong hands-on expertise in Azure SQL Database, Azure Data Services, and Azure Synapse Analytics (PDW).
- Proven experience with SQL Server Replication strategies (Transactional, Merge, Snapshot) in both cloud and hybrid infrastructures.
- Deep understanding of Linked Servers setup, maintenance, and security implications.
- Advanced skills in T-SQL, including performance tuning, query plan analysis, indexing, and troubleshooting.
- Familiarity with tools like SQL Profiler, Dynamic Management Views (DMVs), Query Store, and other Azure performance monitoring utilities.
- Proficiency with SQL Server Integration Services (SSIS) or other ETL tools to support data extraction, transformation, and load processes.
- Working knowledge of Azure Active Directory (AAD) and role-based access controls (RBAC) in a database environment.
- A solid grasp of data architecture principles, including normalization, partitioning, and sharding in high-availability environments.
- Excellent communication, analytical, and problem-solving skills with a keen attention to detail.
Nice to Have
- Microsoft certifications such as Azure Database Administrator Associate, Azure Data Engineer Associate, or MCSA/MCSE: SQL Server.
- Experience with PowerShell scripting for automating database tasks, deployments, and monitoring routines in Azure.
- Knowledge of Azure Data Factory (ADF) for orchestrating and automating data pipelines.
- Exposure to NoSQL or hybrid storage solutions for handling semi-structured/unstructured data.
- Previous experience working in Agile/Scrum environments, contributing to sprints and collaborating in cross-functional teams.
Why Join Us?
- Work on cutting-edge cloud technologies and scalable solutions.
- Be part of a dynamic and innovative team focused on continuous improvement and learning.
- Access to training and certifications in cloud technologies.
- Competitive salary, benefits, and opportunities for career growth.
- Flexible work environment supporting work-life balance.
If you’re a detail-oriented SQL developer with a strong background in Azure and a passion for building high-performance data systems, we’d love to hear from you. Apply now to be a part of a transformative data journey!