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 SQL Database (single database, elastic pools, Hyperscale)
- Azure Managed Redis / Azure Cache for Redis for caching and session data
- Open-source relational databases – Azure Database for PostgreSQL or MySQL (Versatile Server)
- NoSQL databases – Azure Cosmos DB or MongoDB
- Analytics platforms – Microsoft Fabric, Azure Synapse Analytics, Databricks, or Snowflake
- Database monitoring tools – Azure Monitor / Log Analytics, Datadog Database Monitoring, Redgate SQL Monitor, or SolarWinds SQL Sentry

- Azure CLI
- Infrastructure as Code (Terraform or Bicep) for database provisioning
- Python scripting for data automation
- Microsoft Certified: Azure Database Administrator Associate (DP-300)

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

Job Snapshot

Updated Date

09-11-2026

Job ID

Harb759

Department

Delivery Unit 1

Location

Baner, Pune, Maharashtra, India

Experience

8 - 10 Years

Employee Type

Permanent

📌 Associate Tech Specialist / Tech Specialist- Database (Baner)
🏢 HRG Group
📍 Baner