SQL Server Database Developer

Job Title: SQL Server Database Developer

Location: Germantown, MD – Onsite

Duration: Long Term

Interview: MS Teams

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.

Key Responsibilities

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.

Required Skills & Qualifications

Primary Skills

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.