Job description
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!
