Senior Database Developer

TriSource Staffing Solutions; Maryland; Hybrid; USD 120,000 - 150,000; Full time

Job summary

TriSource Staffing Solutions is seeking a Senior Database Developer to design, build, and maintain scalable data pipelines and data platforms. The role focuses on SQL Server, SSIS/SSRS, and cloud-based solutions to support analytics and reporting.

The candidate will optimize ETL/ELT processes, ensure data quality, and mentor junior developers while collaborating with reporting tools like Power BI. Strong scripting skills in Python/PowerShell and Azure experience are required.

Qualifications

• 7+ years of experience in database development, data engineering, and business intelligence solutions.
• Hands-on experience with Microsoft technologies including SQL Server, SSIS, SSRS, Microsoft Fabric, PySpark, and Power BI
• Experience working with modern development and deployment platforms, including Azure DevOps
• Familiarity with cloud-based database solutions, such as Azure SQL Database, preferred
• Familiarity with Microsoft Fabric is preferred and will be considered a plus.
• Proficiency with scripting and automation languages such as Python and/or PowerShell
• Working knowledge of Microsoft 365 applications, including Office 365 and SharePoint Online.

Responsibilities

• Design, build, and maintain scalable data pipelines to ingest, process and transform data efficiently and reliably.
• Design, develop, optimize, and maintain complex SQL queries, stored procedures, functions, and database views to ensure efficient and reliable data.
• Develop and optimize ETL/ELT processes to support analytics and reporting needs.
• Ensure data quality, consistency, and reliability across all data platforms through validation, monitoring, and continuous improvement practices.
• Optimize database performance by tuning queries through indexing, execution plan analysis, and advanced query optimization techniques.
• Implement data validation and monitor to detect and resolve issues proactively.
• Optimize large-scale data loads and batch processing workflows for efficient high-performance data operations.
• Support reporting tools such as SSRS and Power BI.
• Mentor junior developers and provide technical guidance.
• Performs other similar and related duties as required.

Skills

Data engineering

Query optimization

Mentoring

ETL/ELT design

BI reporting

Education

Bachelor’s degree in Computer Science or related field

Tools

SQL Server

SSIS

SSRS

Microsoft Fabric

PySpark

Power BI

Azure DevOps

Azure SQL Database

Job description

Job Description

Senior Database Developer

1 day a week in office

Principal Duties and Responsibilities:

• Design, build, and maintain scalable data pipelines to ingest, process and transform data efficiently and reliably.
• Design, develop, optimize, and maintain complex SQL queries, stored procedures, functions, and database views to ensure efficient and reliable data.
• Develop and optimize Extract, Transform and Load (ETL) / Extract, Load and Transform (ELT) processes to support analytics and reporting needs.
• Ensure data quality, consistency, and reliability across all data platforms through validation, monitoring, and continuous improvement practices.
• Optimize database performance by tuning queries through effective use of indexing, execution plan analysis, and advanced query optimization techniques.
• Implement data validation and monitor to detect and resolve issues proactively.
• Optimize large-scale data loads and batch processing workflows to ensure efficient, reliable, and high performance data operations.
• Support reporting tools such as SSRS and Power BI.
• Mentor junior developers and provide technical guidance.
• Performs other similar and related duties as required.

MINIMUM QUALIFICATIONS:

• Bachelor’s degree in Computer Science, Information Technology, or a related technical field
• 7+ years of progressive experience in the IT industry, with a strong focus on database development, data engineering, and business intelligence solutions
• Hands-on experience with Microsoft technologies including SQL Server, SSIS, SSRS, Microsoft Fabric, PySpark, and Power BI
• Experience working with modern development and deployment platforms, including Azure DevOps
• Familiarity with cloud-based database solutions, such as Azure SQL Database, preferred
• Familiarity with Microsoft Fabric is preferred and will be considered a plus.
• Proficiency with scripting and automation languages such as Python and/or PowerShell
• Working knowledge of Microsoft 365 applications, including Office 365 and SharePoint Online.