Associate Tech Specialist / Tech Specialist- Database
Harbingergroup
- Pune, India
- Entry Level
- 8+ years
- Posted
Skills
Required
- Azure
- SQL
- Microsoft
- optimization
- ETL
- Server
- SQL Server
- troubleshooting
- SQL Database
- SSIS / Azure Data Factory
- GitHub
- BitBucket
- PostgreSQL / MySQL
Preferred
- Managed Redis / Azure Cache
- Redis
- caching
- NoSQL databases
- Cosmos DB / MongoDB
- Microsoft Fabric
- Synapse Analytics / Databricks / Snowflake
- Database monitoring tools
- Monitor / Log Analytics
- Terraform / Bicep
Position- Associate Tech Specialist / Tech Specialist- Database
About Harbingergroup
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.
Requirements
Experience - 8+ Years
- •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
- •Worked on Azure SQL PaaS (Azure SQL Managed Instance)
- •Azure SQL Database (single database, elastic pools, Hyperscale)
- •Open-source relational databases – Azure Database for PostgreSQL or MySQL (Flexible Server)
- •Microsoft Certified: Azure Database Administrator Associate (DP-300)
Personal Skills –
- •Good communication skill (articulation using verbal & non-verbal skills, clarity of thought)
- •Integrity & Stretch Mindset
- •Ownership of work and working independently
- •Flexible and Teamwork mindset
- •Ability to ramp up quickly and deliver against defined milestones in a contract engagement
Preferred
- •Azure Managed Redis / Azure Cache for Redis for caching and session data
- •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
- •Clear documentation and knowledge transfer to the internal team
