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 – 

•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