SQL Server Developer

Apollo
Germantown, United States of America
27 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Germantown, United States of America

Tech stack

Business Software
Code Review
Databases
Data Integration
Data Integrity
ETL
Data Transformation
Data Migration
Data Mining
Data Systems
Database Design
Database Development
Microsoft SQL Server
Performance Tuning
Query Optimization
Release Management
SQL Stored Procedures
SQL Databases
SQL Server Agent
SQL Server Integration Services
T-SQL
Database Optimization
Data Analytics

Job description

We are seeking a skilled SQL Database Developer with strong expertise in T-SQL, Microsoft SQL Server, and SQL Server Integration Services (SSIS). The ideal candidate will be responsible for designing, developing, optimizing, and maintaining database solutions, ETL processes, and data integration workflows that support business applications and reporting needs. The role requires excellent database development skills, strong performance tuning experience, and the ability to deliver scalable and efficient data solutions., * Design, develop, and maintain complex database solutions using T-SQL and Microsoft SQL Server.

  • Develop and optimize stored procedures, functions, views, triggers, and scripts to support business applications.
  • Create, deploy, and maintain ETL packages using SQL Server Integration Services (SSIS).
  • Write and optimize complex T-SQL queries for data extraction, transformation, and reporting.
  • Analyze query execution plans and perform database performance tuning.
  • Design and implement data migration, integration, and synchronization processes.
  • Develop database jobs, schedules, and automation using SQL Server Agent.
  • Troubleshoot database and ETL issues, ensuring timely resolution.
  • Collaborate with developers, business analysts, and stakeholders to gather requirements and deliver data-driven solutions.
  • Ensure data integrity, security, and adherence to database development standards.
  • Participate in database deployment, release management, and code reviews.
  • Maintain technical documentation for database objects, ETL workflows, and support procedures., * T-SQL (Transact-SQL) Advanced proficiency.
  • Microsoft SQL Server (2016/2019/2022).
  • SQL Server Integration Services (SSIS).
  • Strong expertise in:
  • Stored Procedures
  • Functions
  • Views
  • Triggers
  • CTEs
  • Window Functions
  • Dynamic SQL
  • Temporary Tables and Table Variables
  • Query optimization and performance tuning.
  • Database design, normalization, and data modeling.
  • ETL development, data transformation, and data migration.

Requirements

Do you have experience in T-SQL?

Apply for this position