Sr. Database Engineer

Job Title: Database Engineer (SQL Server / DACPAC)

Location: Ahmedabad

Job Type: Full-time

Experience: 5+ years

Department: Data Engineering

About Simform:

Simform is a premier digital engineering company specialising in Cloud, Data, AI/ML, and Experience Engineering to create seamless digital experiences and scalable products. Simform has strong capabilities across Microsoft, AWS, Google Cloud, and Databricks. With a presence in 6 countries, Simform primarily serves North America, the UK, and the Northern European market. Simform is well-recognised as one of the most reputed employers in the region, having created a thriving work culture with a high work-life balance that gives a sense of freedom and opportunity to grow.

Role Overview:

We are looking for an experienced Database Engineer who owns database changes end-to-end, from development through validated production release. This role involves building and maintaining SQL Server schemas using SSDT/DACPAC and running reliable, repeatable database deployments through CI/CD pipelines such as Azure DevOps or GitHub Actions. The engineer will ensure every change, including indexes, schema drift fixes, and data migrations, is tested and validated in lower environments before reaching production. The role requires close collaboration with client stakeholders and development teams, with full ownership of the deployment runbook and release sign-off.

Key Responsibilities:

• Design, build, and maintain SQL Server database schemas using SSDT and DACPAC

• Manage database deployments through CI/CD pipelines using Azure DevOps or GitHub Actions

• Configure and maintain SqlPackage publish profiles, pre/post-deployment scripts, and deploy report/script generation for review

• Validate schema changes, index updates, schema drift fixes, and data migrations in lower environments before production release

• Conduct dry runs, prepare rollback plans, and maintain clear error logging and diagnostics to ensure zero-surprise production releases

• Perform performance tuning, indexing strategy design, and troubleshooting under pressure to maintain database reliability

• Own the deployment runbook end-to-end and provide release sign-off for production changes

• Communicate clearly with client stakeholders on deployment status, risks, and release readiness

• Collaborate with development and DevOps teams to align database changes with application release cycles

• Document database change processes, deployment procedures, and troubleshooting steps for team and client reference

• Monitor production deployments post-release to confirm stability and address any issues promptly

Preferred Qualifications (Nice to Have):

• Experience with Azure SQL

• Familiarity with Flyway or Liquibase for database migrations

• Experience with automated database testing using tSQLt

• Experience driving database DevOps maturity improvements

Why Join Us:

• Young Team, Thriving Culture

• Flat-hierarchical, friendly, engineering-oriented, and growth-focused culture.

• Well-balanced learning and growth opportunities

• Free health insurance.

• Office facilities with a game zone, in-office kitchen with affordable lunch service, and free snacks.

• Sponsorship for certifications/events and library service.

• Flexible work timing, leaves for life events, WFH and hybrid options.