Lead MS SQL Developer

Job Description

Duties & Responsibilities

• Design & development: Build robust schemas, tables, views, stored procedures, functions, and ETL/ELT pipelines in Microsoft SQL Server (Azure SQL, Managed Instance).
  
• Performance & reliability: Profile and tune queries, indexes, and execution plans; 
  
• come up with solutions to improve the performance to meet SLAs.
  
• Data quality & governance: Implement constraints, validation, and auditing; contribute to data standards, naming conventions, and documentation.
  
• Integration: Build and maintain integrations with upstream/downstream systems and ensure transactional integrity.
  
• Collaboration: Work with application engineers and analysts to translate requirements into scalable database solutions; participate in code/design reviews.
  
• Support: Respond to any production issues with urgency.
  

Requirements

Basic Qualifications

• Bachelor’s degree or equivalent work experience.
  
• Proficient in SQL programming. 
  
• Expert TSQL skills (set-based programming, window functions, CTEs, error handling, dynamic SQL, MERGE).
  
• Experience with the full software development lifecycle, including design, testing, deployment, and documentation activities.
  
• 8+ years of experience designing and implementing MS SQL Server database objects.
  
• 8+ years of full software development lifecycle experience, including independent analysis, coding, testing, and deployment.
  
• 8+ years of experience working with SQL Management Studio. 
  
• Experience with ETL/ELT (SSIS or modern alternatives) and scheduling/orchestration.
  
• 8+ years of combined experience developing solutions with relational database technologies.
  
• Proficient understanding of code versioning tools, such as Git.
  
• Ability to debug complex stored procedures. 
  
• Knowledge of file transmission methods such as SFTP.
  
• Understanding of batch command /PowerShell scripts.
  

Preferred Qualifications

• Ability to understand C# code.
  
• Exposure to NoSQL stores (e.g., Cosmos DB, Redis, Couchbase)
  

Requirements
Basic Qualifications · Bachelor’s or Master’s degree in Computer Science, Software Engineering, or related field. · 6+ years of hands-on Salesforce development experience. · Expertise in Apex, Lightning Web Components (LWC), SOQL/SOQL, REST/SOAP API integrations. · Strong proficiency in Salesforce configuration (Flows, Process Builder, Custom Objects, Validation Rules). · Strong understanding of Salesforce data model, relationships, and security (roles, profiles, sharing rules). · Excellent problem-solving and communication skills to work with cross-functional teams. · Proven experience with data modeling, relational databases, and designing scalable enterprise-level Salesforce solutions. · Expertise in CI/CD, DevOps practices, and delivering projects using Agile methodologies. Preferred Qualifications · Salesforce Platform Developer I and II certifications. · Experience in Agentforce · Experience integrating Large Language Models (LLMs) or generative AI tools into Salesforce workflows. · Fluent in XML-based web services and REST APIs approach with 5+ years of experience. · Proficiency in MS SQL programming, querying, and relational database management systems (RDBMS) with 3+ years of experience. · Experience with Agile/Scrum methodologies and use of tools such as Jira, Jenkins, Bit Bucket