Database Developer at Pi Techniques Pvt Ltd

Pi Techniques; Pune District, Mumbai; Hybrid; INR 1,800,000 - 3,000,000; Full time

Job summary

Pi Techniques Pvt. Ltd. in Pune is looking for a Senior SQL Server Developer to design, optimise, and maintain robust database infrastructure across a hybrid data ecosystem. The role focuses on Microsoft SQL Server (T-SQL) with PostgreSQL familiarity as a significant plus for cross‑platform workflows.

The candidate will handle performance tuning, on‑premises and cloud deployments, and ETL pipelines using SSIS or ADF, contributing to a modern data infrastructure.

Qualifications

• 4+ years of advanced database development experience focused on Microsoft SQL Server.
• Expert-level proficiency in writing complex queries, window functions, CTEs, and dynamic SQL.
• Deep familiarity with SSMS, SQL Profiler, Extended Events, and Query Store.

Responsibilities

• SQL Server Engineering: Design robust database schemas, tables, views, and write highly optimised T-SQL stored procedures, triggers, and functions.
• Performance Tuning: Analyse execution plans, manage index fragmentation, resolve deadlocks, and eliminate performance bottlenecks in production.
• Hybrid Data Management: Support and maintain data infrastructure spanning both on-premises infrastructure and cloud/hybrid deployments.
• ETL & Integration: Develop, test, and deploy enterprise-level data integration pipelines using tools like SSIS or ADF.
• Database Modernisation: Assist with cross-platform data initiatives, leveraging PostgreSQL knowledge where applicable for modern hybrid workflows.

Skills

Core Expertise

Advanced T-SQL

Performance Tools

Tools

SSMS

SQL Profiler

Extended Events

Query Store

Job description

Role Overview

As a Senior SQL Server Developer, you will design, optimise, and maintain database infrastructure across a hybrid environment. While your primary focus will be engineering high-performance solutions using Microsoft SQL Server (T-SQL), experience or familiarity with PostgreSQL is a significant plus as we navigate our hybrid data Ecosystem.

Core Responsibilities

• SQL Server Engineering: Design robust database schemas, tables, views, and write highly optimised T-SQL stored procedures, triggers, and functions.
• Performance Tuning: Analyse execution plans, manage index fragmentation, resolve deadlocks, and eliminate performance bottlenecks in production.
• Hybrid Data Management: Support and maintain data infrastructure spanning both on-premises infrastructure and cloud/hybrid deployments.
• ETL & Integration: Develop, test, and deploy enterprise-level data integration pipelines using tools like SSIS or ADF.
• Database Modernisation: Assist with cross-platform data initiatives, leveraging PostgreSQL knowledge where applicable for modern hybrid workflows.

Required Skills & Qualifications

• Core Expertise: 4+ years of advanced database development experience strictly focused on Microsoft SQL Server.
• Advanced T-SQL: Expert-level proficiency in writing complex queries, window functions, CTEs, and dynamic SQL.
• Performance Tools: Deep familiarity with SQL Server Management Studio (SSMS), SQL Profiler, Extended Events, and Query Store.