What are the responsibilities and job description for the Sr. Database Developer position at TriSource Staffing Solutions?
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.
#INDDG
Pay: $130,000.00 - $145,000.00 per year
Work Location: Hybrid remote in Silver Spring, MD 20997
Salary : $130,000 - $145,000