13 Nov
|
ComUnus Technologies
|
Mumbai
13 Nov
ComUnus Technologies
Mumbai
Job highlights
- Job Summary. We are looking for an experienced MS SQL Developer with 3-5 years of hands-on experience in SQL Server database development,T-SQL programming,database design,and performance tuning
- Develop and maintain SQL Server Integration Services (SSIS) packages,where required. . Identify and resolve database-related production issues.
Job Summary
We are looking for an experienced MS SQL Developer with 3-5 years of hands-on experience in SQL Server database development, T-SQL programming, database design, and performance tuning. The candidate should have robust knowledge of writing complex SQL queries, developing stored procedures, functions, triggers, and views, and optimizing database performance.
Responsibilities
- Design, develop, and maintain database solutions using MS SQL Server.
- Write complex SQL queries using joins, subqueries, CTEs, and temporary tables.
- Develop and maintain stored procedures, functions, views, and triggers.
- Perform SQL query optimization and database performance tuning.
- Analyze execution plans and resolve performance bottlenecks.
- Work with indexes, constraints, and database objects.
- Perform database development, maintenance, and troubleshooting.
- Implement data validation and data integrity checks.
- Work on database backup, restore, and recovery activities.
- Develop and maintain SQL Server Integration Services (SSIS) packages, where required.
- Identify and resolve database-related production issues.
- Collaborate with application developers, business analysts, and QA teams.
- Prepare technical documentation and support database deployments.
Requirements
- MS SQL Server
- SQL Server 2016/2019/2022
- T-SQL
- Strong programming knowledge
- SQL Queries
- Complex queries, joins, subqueries
- Stored Procedures
- Development and debugging
- Functions
- Scalar and table-valued functions
- Triggers
- DML triggers
- Views
- Creation and maintenance
- CTE Common Table Expressions
- Indexes
- Clustered and non-clustered indexes
- Performance Tuning
- Query optimization, execution plans
- Transactions
- COMMIT, ROLLBACK, transaction handling
Nice-to-Have Skills
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- SQL Server Agent Jobs
- Database backup and recovery
- Database migration and data warehousing
- Knowledge of Azure SQL Database
- Power BI knowledge
- Basic knowledge of .NET or other programming languages
Qualifications
- Bachelors degree in Computer Science, IT, or a related field.
- 3-5 years of hands-on experience in MS SQL Server development.
- Strong knowledge of T-SQL and relational database concepts.
- Experience in database performance tuning and optimization.
- Strong analytical, debugging, and problem-solving skills.
- Good communication and coordination skills.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 MS SQL Developer (Mumbai)
🏢 ComUnus Technologies
📍 Mumbai