About the Role:
We are seeking a highly skilled T-SQL Developer to join our team in Pune. This role blends advanced database development expertise with modern data engineering skills, supporting enterprise-scale applications and driving data-driven solutions. You will collaborate with cross-functional teams to design, develop, and optimize data pipelines and database systems, ensuring high performance, reliability, and scalability.
Key Responsibilities:
Database Design & Development
- Design, define, and create robust database schemas for large-scale enterprise applications.
- Develop and optimize stored procedures, functions, complex queries, and indexing strategies for SQL Server and Azure SQL.
- Analyze and extend existing database applications, focusing on normalization, performance optimization, and improvement.
- Implement data security measures and maintain database objects.
Performance & Monitoring
- Continuously identify opportunities to improve performance of production systems (OS, IO, SQL config, indexing, and SQL optimization).
- Partner with QA and application architects to identify and rectify performance bottlenecks pre-release.
- Establish proactive database-level monitoring of all production systems.
Collaboration & Leadership
- Work closely with Product Managers, Scrum Managers, Dev Teams, Test Leads, and other stakeholders.
- Mentor junior engineers and contribute to knowledge sharing across the team.
- Assist in analysis and reporting of aggregate application data to provide insights into operational and business trends.
Modernization & Transformation
- Support technology transformation initiatives, including migration to modern platforms and Azure.
- Leverage ETL tools (SSIS, ADF) and BI tools (Power BI, SSRS, SSIS) for data integration and reporting.
Required Skills & Experience
Technical Skills
- 5+ years of experience in database development for large enterprise applications.
- Expert in SQL Server (2012 and above), T-SQL, PL/SQL, database tuning, and performance optimization.
- Strong experience with Azure SQL, SQL MI, and cloud-based data solutions.
- Experience with ETL tools (SSIS, Azure Data Factory) and BI/reporting tools (Power BI, SSRS).- Desired but not mandatory.
- Solid understanding of relational and dimensional data modeling, data warehousing concepts, and database normalization. (Good to have)
- Experience in implementing data security and monitoring solutions.
Other Skills
- Strong problem-solving, analysis, design, and estimation skills.
- Excellent communication and collaboration abilities.
- Experience working in Agile/Scrum environments and familiarity with DevOps practices.
- Experience with CI/CD pipelines and version control systems (e.g., Git)
Our Interview Practices
