Database Engineer

Harbinger Systems; United States; Hybrid; USD 21,000 - 43,000; Full time

Job summary

Harbinger Systems in Pune (Hybrid/Remote) seeks an Associate Tech Specialist / Tech Specialist- Database Engineer with 8+ years of SQL Server experience. You will design, develop and maintain data solutions, optimize performance and ensure data integrity across cloud-based pipelines.

You will lead ETL/ELT processes using SSIS and Azure Data Factory, review execution plans, implement high availability, and collaborate with cross-functional teams to resolve high-priority data issues.

Qualifications

• Minimum 8+ years with Microsoft SQL Server in enterprise environments.
• Minimum 5+ years in Database Development & Performance Optimization.
• Experience creating and reviewing database tables and stored procedures.
• Advanced T-SQL development with complex queries, CTEs, and transactions.
• Experience reviewing Execution Plans and optimization recommendations.
• Hands-on with Query Store, DMVs, Extended Events, and wait statistics.
• Experience with indexing, blocking, deadlocks, and performance troubleshooting.
• Database optimization via partitioning, clustering, indexing strategies.
• Maintenance of indexes and statistics including columnstore indexes.
• HA/DR with Always On, backup/restore, point-in-time recovery.
• Knowledge of security: RBAC, TDE, Always Encrypted, DDM, auditing.
• ETL pipelines with SSIS and/or Azure Data Factory; self-healing workflows.
• CI/CD for databases using GitHub/Azure DevOps; source control with SSDT/DACPAC.

Responsibilities

• Design, develop, and maintain end-to-end data solutions.
• Optimize performance and ensure data integrity.
• Collaborate with cross-functional teams to implement data solutions.
• Lead production incidents related to database issues.
• Review code and SQL scripts to uphold quality standards.
• Migrate databases using ETL scripts and automate processes.
• Monitor and troubleshoot using DMVs, Extended Events, and wait stats.
• Implement high availability and disaster recovery strategies.

Skills

Microsoft SQL Server

Database Development

T-SQL

Query optimization

DMVs & Extended Events

Indexing & Partitioning

HA & DR Always On

SQL Server Agent / Elastic Jobs

ETL/ELT pipelines

CI/CD for databases

SSDT/DACPAC / sqlpackage

PowerShell / Scripting

RBAC / Data security

Tools

SSDT

DACPAC

sqlpackage

GitHub

Azure DevOps

Azure Data Factory

Job description

Position - Associate Tech Specialist / Tech Specialist- Database Engineer

Experience - 8+ Years

Location- Pune (Hybrid/Remote)

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 –

• 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