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 (Flexible 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

Valuable 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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Associate Tech Specialist / Tech Specialist- Database (Pune)
🏢 Harbinger Techventures
📍 Pune