SQL Server Developer

Apollo Technology Solutions LLC

Germantown, MD

JOB DETAILS
SKILLS
Automation, Business Analysis, Business Solutions, Code Reviews, Data Migration, Data Modeling, Data Processing, Data Quality, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Optimization, Database Programming, Database Triggers, Identify Issues, Information/Data Security (InfoSec), Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Performance Tuning/Optimization, Query Analysis, Query Optimization, Release Management/Engineering, Requirements Management, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Server Programming/Applications, Software Administration, Stored Procedures, Technical Writing, Time Management
LOCATION
Germantown, MD
POSTED
1 day ago
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.

About the Company

A

Apollo Technology Solutions LLC