SQL Developer

SQL Developer

Posted 6 days ago by 1756367243

Negotiable
Outside
Remote
USA

Summary: We are looking for a Senior SQL Developer to design, develop, optimize, and maintain complex SQL solutions for enterprise applications and data platforms. The candidate should possess extensive experience in SQL Server development, performance tuning, and ETL processes, and be able to collaborate effectively with cross-functional teams. This role requires a strong focus on delivering high-quality data solutions while ensuring data integrity and compliance. The ideal candidate will have a proven track record in SQL development and database management.

Key Responsibilities:

  • Design, develop, and optimize complex SQL queries, stored procedures, functions, triggers, and views.
  • Perform query optimization and database performance tuning for large-scale data sets.
  • Develop and maintain ETL processes to extract, transform, and load data from multiple sources.
  • Work with business analysts and stakeholders to translate requirements into technical database solutions.
  • Design and implement data models, schemas (Star, Snowflake), indexes, and partitions.
  • Ensure data integrity, security, and compliance across databases.
  • Conduct code reviews and enforce best practices for SQL development.
  • Collaborate with application developers, BI teams, and data engineers to ensure seamless integration.
  • Troubleshoot and resolve database issues, performance bottlenecks, and query failures.
  • Support database upgrades, migrations, and deployment activities.

Key Skills:

  • 7+ years of hands-on experience as a SQL Developer.
  • Strong proficiency in Microsoft SQL Server (2016/2019 or higher).
  • Expertise in writing T-SQL, stored procedures, triggers, functions, and performance tuning.
  • Experience with ETL tools (SSIS, Azure Data Factory, or equivalent).
  • Strong knowledge of data warehousing concepts, normalization, indexing, and query optimization.
  • Experience with cloud databases (Azure SQL, AWS RDS, or similar) is a plus.
  • Familiarity with SSRS, Power BI, or Tableau for reporting and integration.
  • Solid understanding of SDLC, Agile methodologies, and version control (Git/DevOps).
  • Excellent problem-solving, communication, and analytical skills.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Title: Senior SQL Developer
Employment Type: Contract


Job Summary
We are seeking an experienced Senior SQL Developer to design, develop, optimize, and maintain complex SQL solutions across enterprise applications and data platforms. The ideal candidate will be highly skilled in SQL Server development, performance tuning, stored procedures, ETL, and data modeling, with the ability to work in cross-functional teams to deliver high-quality data solutions.
Key Responsibilities
  • Design, develop, and optimize complex SQL queries, stored procedures, functions, triggers, and views.
  • Perform query optimization and database performance tuning for large-scale data sets.
  • Develop and maintain ETL processes to extract, transform, and load data from multiple sources.
  • Work with business analysts and stakeholders to translate requirements into technical database solutions.
  • Design and implement data models, schemas (Star, Snowflake), indexes, and partitions.
  • Ensure data integrity, security, and compliance across databases.
  • Conduct code reviews and enforce best practices for SQL development.
  • Collaborate with application developers, BI teams, and data engineers to ensure seamless integration.
  • Troubleshoot and resolve database issues, performance bottlenecks, and query failures.
  • Support database upgrades, migrations, and deployment activities.

Required Skills & Qualifications:
  • 7+ years of hands-on experience as a SQL Developer.
  • Strong proficiency in Microsoft SQL Server (2016/2019 or higher).
  • Expertise in writing T-SQL, stored procedures, triggers, functions, and performance tuning.
  • Experience with ETL tools (SSIS, Azure Data Factory, or equivalent).
  • Strong knowledge of data warehousing concepts, normalization, indexing, and query optimization.
  • Experience with cloud databases (Azure SQL, AWS RDS, or similar) is a plus.
  • Familiarity with SSRS, Power BI, or Tableau for reporting and integration.
  • Solid understanding of SDLC, Agile methodologies, and version control (Git/DevOps).
  • Excellent problem-solving, communication, and analytical skills.

Preferred Qualifications
  • Experience with Azure Synapse, Databricks, or Snowflake.
  • Exposure to NoSQL databases (MongoDB, CosmosDB, etc.).
  • Knowledge of CI/CD pipelines for database deployments.
  • Relevant certifications (Microsoft SQL, Azure Data Engineer, etc.).