SQL Server Developer

Apollo

Germantown, MD, United States

2 months ago

Apply on indeed.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Business Software Code Review Databases Data Integration Data Integrity Extract Transform Load (ETL) Data Transformation Data Migration Data Mining Data Systems Database Design Database Development

+11 more

Microsoft SQL Server Performance Tuning Query Optimization Release Management SQL Stored Procedures SQL Databases SQL Server Agent SQL Server Integration Services Transact-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.