Database Developer at Pi Techniques Pvt Ltd

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 ResponsibilitiesSQL 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 & QualificationsCore 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.