Role & responsibilities

- Design, develop, optimize, and maintain SQL Server databases, including tables, stored procedures, functions, views, triggers, and database objects.
- Develop, enhance, and support SSIS packages for data extraction, transformation, and loading (ETL) processes.
- Analyze business requirements and translate them into efficient database solutions and technical designs.
- Develop complex T-SQL scripts, stored procedures, functions, triggers, CTEs, window functions, and dynamic SQL solutions.
- Perform SQL query optimization, indexing, execution plan analysis, and performance tuning to improve database efficiency.
- Design and implement data migration, data transformation, data cleansing, and reconciliation processes across multiple systems.
- Troubleshoot and resolve production database issues, ETL failures, and performance bottlenecks with minimal business impact.
- Implement database security practices, backup strategies, recovery processes, and maintenance activities.
- Develop and maintain technical documentation including database design documents, data dictionaries, and technical specifications.
- Monitor and support ETL jobs, SQL Server Agent jobs, and database performance activities.
- Collaborate with application developers, QA teams, business analysts, and data engineers throughout the software development lifecycle.
- Participate in code reviews and ensure adherence to database development standards and best practices.
- Support deployment activities across development, testing, and production environments.
- Contribute to continuous improvement initiatives around database performance, automation, and operational stability.

Preferred candidate profile

Required Technical Skills

- 7+ years of hands-on experience in Microsoft SQL Server development.




- Strong expertise in T-SQL programming, including:
- Complex stored procedures
- User-defined functions
- Triggers
- CTEs
- Window functions
- Dynamic SQL

- Extensive experience in SQL Server Integration Services (SSIS) development and ETL implementation.
- Solid understanding of:

- SQL Server database design
- Relational database concepts
- Normalization
- Data modeling
- Database objects and optimization techniques

- Hands-on experience with:

- Query tuning
- Index optimization
- Execution plan analysis
- Performance troubleshooting

- Experience in:

- Data migration projects
- Data validation and reconciliation
- Data transformation and cleansing activities

- Experience working with:

- SQL Server Agent jobs
- Job scheduling
- ETL monitoring and automation

- Knowledge of database backup, restore, recovery, and disaster recovery processes.
- Experience with source control tools such as:

- Git
- Azure DevOps
- TFS

Preferred Technical Skills

- Experience with SSRS and/or Power BI reporting solutions.
- Exposure to cloud database technologies such as:
- Azure SQL Database
- Azure Data Factory (ADF)
- Azure Data Services

- Experience working with SQL Server 2016/2019/2022.
- Knowledge of CI/CD practices for database deployments.
- Experience with automation and deployment tools for database release management.

Soft Skills

- Strong analytical and problem-solving abilities.
- Excellent debugging and troubleshooting skills.
- Strong communication and stakeholder management skills.
- Ability to work independently as well as collaboratively within cross-functional teams.
- Strong documentation and technical writing skills.
- Good time management skills with the ability to handle multiple priorities in a fast-paced environment.

📌 MS SQL Developer (Chennai)
🏢 CGI
📍 Chennai