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.
- nalyze 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.