jobapplier

Associate Tech Specialist / Tech Specialist- Database

Harbingergroup

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