Database Developer at Pi Techniques Pvt Ltd
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.