Senior Ms Sql Developer

Summary

Join a high-achieving team as a Senior SQL Developer at a leading provider of enterprise-class managed data center services. You will focus on MS SQL, creating efficient queries, views, functions, and stored procedures for a robust cloud data warehouse. Lead SQL development, optimization, and database design efforts. Collaborate with team members to optimize application SQL queries and troubleshoot database performance issues. Design and implement database schemas and security protocols. Orchestrate data migrations and create robust scripts for data manipulation and reporting.

Requirements

• 6+ years of professional SQL development experience
• Deep expertise in T-SQL and Microsoft SQL Server
• 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

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

Preferred Qualifications

• 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