Associate Tech Specialist / Tech Specialist- Database

Harbingergroup; Pune District; Hybrid; INR 2,000,000 - 3,500,000; Full time

Job summary

Harbingergroup in Pune (Hybrid) seeks an Associate Tech Specialist / Tech Specialist- Database with 8+ years of hands-on SQL Server experience to design, develop, and maintain end-to-end data solutions that optimize performance and ensure data integrity. The role emphasizes advanced T‑SQL development, HA/DR, and ETL pipelines using SSIS and Azure Data Factory.

Collaborate with cross-functional teams, implement data solutions, and lead incident response for data‑related issues while contributing

Qualifications

• 8+ years of hands‑on experience with Microsoft SQL Server in enterprise environments.
• 5+ years in Database Development & Performance Optimization.
• Experience in creating and reviewing database tables, stored procedures.
• Advanced T‑SQL development – complex queries, CTEs, window functions, views, UDFs, triggers, and transaction handling.
• Strong knowledge of SQL query optimization and execution plans; ability to identify performance root causes and provide recommendations.
• Hands‑on experience with Query Store, DMVs, Extended Events, and wait statistics for performance troubleshooting.
• Experience identifying missing indexes, handling blocking/deadlocks, and troubleshooting performance issues.
• Database optimization using partitioning, clustering, indexing strategies.
• Experience with index/statistics maintenance including columnstore indexes and automated maintenance jobs.
• HA/DR – Always On Availability Groups, auto‑failover groups, backup/restore and PITR.
• Database security – RBAC, RLS, TDE, Always Encrypted, DDM, auditing.
• ETL/ELT pipelines with SSIS and/or Azure Data Factory.
• Automating ETL processes and creating self‑healing data workflows.
• Proficient in using scripts/tools to identify and resolve production and dev issues.
• Reviewing database code and SQL scripts to enforce quality and prevent production issues.
• CI/CD tools for database deployments (GitHub, Bitbucket, Azure DevOps).
• Database source control and schema deployments via SSDT/DACPAC and sqlpackage.

Skills

Microsoft SQL Server

Database Development

Performance Optimization

T-SQL development

Query optimization

DMVs & Extended Events

Indexing & tuning

HA/DR (Always On)

Azure SQL / Cloud data pipelines

ETL with SSIS

Azure Data Factory

CI/CD for databases

SSDT/DACPAC

sqlpackage

PowerShell scripting

Production support & incident response

Cross-functional collaboration

Tools

SSIS

Azure Data Factory

SSDT/DACPAC

sqlpackage

GitHub

Azure DevOps

SQL Server Agent

Query Store

Azure Monitor

Job description

Baner, Pune, Maharashtra, India

8 - 10 Years

Permanent

Job Description

Position- Associate Tech Specialist / Tech Specialist- Database

Experience - 8+ Years

Location- Pune (Hybrid)

The Senior Database Engineer is responsible for designing, developing, and maintaining end-to-end data solutions that optimize performance, ensure data integrity, and support business growth. This role combines deep SQL database expertise with modern cloud-based data pipeline development.

Mandatory Skills

• Minimum 8+ years of hands‑on experience with Microsoft SQL Server in enterprise environments
• Minimum 5+ years of experience in Database Development & Performance Optimization
• Experience in Creating and reviewing database tables, stored procedures
• Advanced T‑SQL development skills – complex queries, CTEs, window functions, views, user-defined functions, triggers, and transaction/isolation-level handling
• Strong knowledge of SQL query optimization and query analysis, reviewing Execution Plans and able to find out performance root cause and advise on recommendations.
• Hands‑on experience with Query Store, Dynamic Management Views (DMVs), Extended Events, and wait‑statistics analysis for performance troubleshooting
• Must have experience on identifying missing Indexes, handling blocking/Deadlocks and troubleshooting the performance issues.
• Perform advanced database optimization using partitioning, clustering, and indexing strategies
• Experience with index and statistics maintenance, including columnstore indexes and automated maintenance jobs (SQL Server Agent / Elastic Jobs)
• Experience with High Availability & Disaster Recovery – Always On Availability Groups, auto‑failover groups, backup/restore, and point‑in‑time restore
• Knowledge of database security – role‑based access, Row‑Level Security, Transparent Data Encryption (TDE), Always Encrypted, Dynamic Data Masking, and auditing
• Experience on Database Migration using ETL Scripts.
• Experience building ETL/ELT pipelines using SSIS and/or Azure Data Factory
• Proficiency in automating ETL processes and creating self‑healing data workflows
• Use custom SQL/Powershell scripts or database tools to proactively identifying and resolving production and application development problems.
• Review database code and SQL scripts to ensure quality standards and prevent production issues
• Experience with CI/CD tools (e.g., GitHub, BitBucket, Azure DevOps) for database deployments
• Experience with database source control and schema deployments using SSDT/DACPAC and sqlpackage (Flyway or Liquibase is a plus)
• Support production database environments and lead incident response for data‑related issues
• Collaborate with cross‑functional teams to implement data solutions and resolve high‑priority issues

Good to have Skills

• Worked on Azure SQL PaaS (Azure SQL Managed Instance)
• Azure Managed Redis / Azure Cache for Redis for caching and session data
• Open‑source relational databases – Azure Database for PostgreSQL or MySQL (Flexible Server)
• Database monitoring tools – Azure Monitor / Log Analytics, Datadog Database Monitoring, Redgate SQL Monitor, or SolarWinds SQL Sentry
• Infrastructure as Code (Terraform or Bicep) for database provisioning

Personal Skills

• Good communication skill (articulation using verbal & non‑verbal skills, clarity of thought)
• Attention to details
• Integrity & Stretch Mindset
• Ownership of work and working independently
• Flexible and Teamwork mindset
• Strong analytical thinking and problem‑solving skills
• Ability to ramp up quickly and deliver against defined milestones in a contract engagement
• Clear documentation and knowledge transfer to the internal team