SQL Server/Integration Developer

• Develop and maintain complex T-SQL stored procedures, views, user-defined functions, and triggers.
• Design and implement data transformation workflows using SSIS (SQL Server Integration Services).
• Translate business requirements into scalable, efficient database solutions.
• Refactor and optimize existing T-SQL code for performance, maintainability, and scalability.
• Collaborate with business analysts, application developers, and data engineers on integration and transformation needs.
• Develop and support ETL pipelines to move and transform data across various systems.
• Monitor, troubleshoot, and tune database performance (query tuning, indexing, execution plans).
• Ensure data integrity, consistency, and quality across staging and production environments.
• Maintain documentation of database objects, data flows, and processes.

• 3+ years of experience with Microsoft SQL Server (2016 or newer preferred).
• Expert-level proficiency in T-SQL: stored procedures, views, functions, and performance tuning.
• Strong experience with SSIS for data import/export, transformations, and scheduled workflows.
• Solid understanding of relational database design, data normalization, and indexing strategies.
• Experience troubleshooting and optimizing queries using SQL Server Management Studio (SSMS) and execution plans.
• Familiarity with REST APIs connecting to third-party Services.
• Experience with a variety of design patterns, Database-to-Database, File-based, and REST API based integrations

• Experience with Windows Task Scheduler for job scheduling and automation.
• Experience with Azure SQL Database, Azure Data Factory, or other Microsoft cloud services.
• Experience with AWS RDS, EC2, and S3 AWS services

Apply Now