Junior SQL Developer
Junior SQL Developer Job Description
Key Responsibilities
- Write, optimize, and maintain SQL queries, stored procedures, functions, triggers and views.
- Work with Microsoft SQL Server Management Studio (SSMS 2012 and above) for daily database development and troubleshooting.
- Assist in building and maintaining reports using SQL Server Reporting Services (SSRS).
- Support data integration workflows and packages using SQL Server Integration Services (SSIS).
- Collaborate with team members to design and consume APIs (.NET, Python) that interface with backend databases.
- Use PowerShell scripts to automate routine maintenance, deployments, or data operations.
- Work with .NET Framework and .NET Blazor projects, particularly in areas where backend SQL and frontend components interact.
- Write Python scripts for data extraction, transformation, and ad-hoc analysis tasks.
- Use Git for version control and basic source code management (branching, committing, merging, pulling).
- Troubleshoot issues across the stack — from database to reporting to API layers.
- Document code, processes, and technical changes clearly and consistently.
Required Skills & Qualifications
- Solid foundation in T-SQL (queries, joins, stored procedures, indexing, etc.).
- Familiarity with SSMS and SQL Server environment.
- Basic experience with .NET Framework.
- Exposure to Python for data manipulation or automation tasks.
- Understanding of APIs (REST) and how to interact with them in code.