DistantJob
MS SQL Developer
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!
DistantJob
Hire remote tech talent that will outperform your local ones for 50% less pay
See more jobsSafe Remote Job Search Tips
Verify Employer Thoroughly
Research the company's identity thoroughly before applying. Check for a professional website with contacts, active social media, and LinkedIn profiles. Verify details across platforms and look for reviews on Glassdoor or Trustpilot to confirm legitimacy.
Never Pay to Get a Job
Legitimate employers never require payment for applications, training, background checks, or equipment. Always reject upfront payment requests or demands for bank details, even if they claim it's for purchasing necessary work gear on your behalf.
Safeguard Your Personal Information
Protect sensitive data like SSN, bank details, or ID copies. Share this only after accepting a formal, written job offer. Ensure it's submitted via a secure company system or portal, never through insecure channels like standard email attachments.
Scrutinize Communication & Interviews
Watch for communication red flags: poor grammar, generic emails (@gmail), vague details, or undue pressure. Be highly suspicious of interviews held only via text or chat apps; legitimate companies typically use video or phone calls.
Beware of Unrealistic Offers
If an offer's salary or benefits seem unrealistically high for the work involved, be cautious. Research standard pay for similar roles. Offers that appear 'too good to be true' are often scams designed to lure you into providing information or payment.
Insist on a Formal Contract
Always secure and review a formal, written job offer or employment contract before starting work or sharing final personal details. Ensure it clearly defines your role, compensation, key terms, and conditions to avoid misunderstandings or scams.