Job Description - MS SQL DB Developer
Job Summary :
We are seeking a highly skilled and experienced MS SQL Database Developer with over 5 years of experience in designing, developing, and optimizing enterprise-level SQL Server databases. The ideal candidate will have deep expertise in T-SQL, performance tuning, ETL processes, and reporting tools such as SSIS and SSRS. You will be responsible for ensuring data reliability, performance, and scalability across mission-critical applications.
Key Responsibilities :
- Develop and maintain complex T-SQL queries, stored procedures, triggers, functions, views, and scripts.
- Perform database design, data modeling, and schema optimization to support application development and reporting needs.
- Create and manage ETL processes using SSIS to extract, transform, and load data across systems.
- Develop and support SSRS reports and dashboards for various business units.
- Analyze slow-running queries and perform query optimization and indexing.
- Ensure data integrity, quality, security, and compliance with database best practices.
- Collaborate with application developers, QA, and DevOps to deliver scalable data solutions.
- Perform data migration, backup / recovery planning, and job scheduling using SQL Server Agent.
Required Skills and Experience :
Strong proficiency in T-SQL with experience in writing and debugging complex SQL queries.Solid understanding of relational database design, normalization, and indexing techniques.Expertise in SQL Server Integration Services (SSIS) and creating automated ETL pipelines.Hands-on experience with SQL Server Reporting Services (SSRS) or similar tools.Experience in SQL Server 2016 / 2019 or Azure SQL environments.Knowledge of performance tuning tools like SQL Profiler, Execution Plans, and Database Tuning Advisor.Familiarity with version control systems (Git / TFS) and Agile development methodologies.Preferred Skills :
Experience with Power BI for report visualization (optional).Familiarity with Azure Data Factory, Azure SQL Database, or other cloud-based data platforms.Understanding of CI / CD processes for database changes.Show more
Show less
Skills Required
Git, T-sql, Tfs, Sql Server 2016, Azure Sql