Senior SQL Developer (Azure Environment & Legacy System Migration)
Location : Pune / Mumbai (Hybrid)
Job Type : Full-time
Department : IT / Data Engineering
Experience : 8+ Years
About the Role
We are seeking an experienced Senior SQL Developer to lead and execute the migration of legacy systems to modern Azure environments. The ideal candidate will have deep expertise in SQL Server, proven experience with Azure SQL Database, and a successful track record in end-to-end data migration projects. This role involves collaborating with cross-functional teams, optimizing database performance, and ensuring a seamless transition with minimal disruption to business operations.
Key Responsibilities
- Lead the migration of legacy databases (on-premises or cloud) to Azure SQL Database or Azure SQL Managed Instance, ensuring data integrity and minimal downtime
- Analyze, reverse-engineer, and optimize existing MSSQL schemas; design efficient, modern data models aligned with new application architectures.
- Develop, implement, and optimize complex T-SQL queries, stored procedures, triggers, and views to support business functionality.
- Plan and execute data extraction, transformation, and loading (ETL) processes using tools such as Azure Data Factory and SSIS.
- Implement robust security protocols (e.g., TDE, RBAC, Private Link) and ensure compliance with organizational standards.
- Monitor and tune database performance, manage backups, and configure disaster recovery strategies.
- Troubleshoot and resolve complex database issues, ensuring high availability and scalability.
- Document migration plans, processes, and post-migration configurations; provide regular progress reports to stakeholders.
- Collaborate with application developers, DBAs, and infrastructure teams to support migration and modernization efforts.
- Mentor junior team members and promote best practices for SQL Server and Azure environments.
Required Qualifications & Skills
Bachelor's degree in Computer Science, Information Technology, or a related field.5+ years of hands-on experience in SQL Server development and administration, including recent experience with Azure SQL Database.Proven expertise in migrating databases from legacy systems (e.g., Oracle, on-prem MSSQL) to Azure SQL.Strong proficiency in T-SQL, database design, indexing, and performance tuning.Experience with Azure Data Factory, SSIS, and data migration / ETL pipelines.Familiarity with Azure cloud services, including Azure SQL, Azure Data Lake, and Azure security features.Solid understanding of database security, backup, and disaster recovery best practices.Excellent problem-solving, analytical, and communication skills.Ability to work independently and collaboratively in a fast-paced, cross-functional environment35.Why Join Us
Opportunity to lead high-impact modernization projects and work with cutting-edge Azure technologies.Collaborative team environment with a focus on professional growth and innovation.Competitive compensation and benefits.Skills Required
Database Design, T-sql, Performance Tuning, Sql Server, Ssis, Database Security, Azure Data Factory, Azure Data Lake, Azure Cloud Services, Indexing