MS 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.

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!