MS/Snowflake SQL Developer

Why did the SQL developer leave the party early?

He wanted to JOIN his friends at HOME and GROUP BY the fire!

Our client provides enterprise-class managed data center services. They have around 70 datacenters servicing 29 different markets, and we can't disclose their clients – but think about any significant industry player from hyperscalers, banks, healthcare and social media platforms, and they're likely in their CRM. We're looking for a QA Tester with a solid background in manual testing and the ability to implement automation strategies in the future. The selected candidate will play a pivotal role in formulating a comprehensive end-to-end test plan, executing it meticulously, and overseeing all associated activities. The primary goal is to ensure the achievement of objectives and the software solution's seamless functionality, performance, reliability, and stability.

They are a high-achieving team looking for a passionate SQL expert to join them as a Senior Developer. Your primary focus will be on MS SQL and Snowflake, crafting efficient queries, views, functions, and stored procedures. They're building a robust cloud data warehouse with seamless data replication across platforms, and they need someone who can lead in SQL development, optimization, and database design.

Responsibilities:

• Lead SQL development efforts, enforcing coding standards and best practices
• Develop and maintain efficient T-SQL code, including stored procedures, functions, triggers, and optimized views
• Analyze and improve existing database structures to enhance performance
• Troubleshoot and resolve database access and performance bottlenecks
• Work closely with team members to optimize application SQL queries
• Design and implement database schemas aligned with application requirements
• Orchestrate data migrations across different systems
• Create robust scripts for data manipulation, ETL processes, and reporting
• Develop and implement database security protocols and optimization strategies

Requirements:

• 6+ years of professional SQL development experience
• Deep expertise in T-SQL and Microsoft SQL Server
• Proficiency in Snowflake and dbt development
• Working knowledge of HTML and JavaScript
• Experience with Transparent Data Encryption (TDE)
• Strong skills in query performance tuning and optimization
• Excellent communication and problem-solving abilities
• Ability to work both independently and in team settings
• Familiarity with NoSQL databases

Bonus points for:

• Experience with SQL Server Reporting Services, Power BI, SSAS, and SSIS
• Knowledge of web application development
• Understanding of Data Analysis Expressions (DAX)
• Familiarity with Azure SQL, Redgate, and advanced analytics tools

If you meet these qualifications and are ready to contribute your expertise to a dynamic team, we encourage you to apply!