09 Nov
|
techjays
|
Coimbatore
09 Nov
techjays
Coimbatore
Position : Senior Database Engineer / DBA.Experience : 7+ Years.Location : Coimbatore / Hybrid (Remote option available).Employment Type : Contract.Joining : Immediate or within 30 days preferred.Core Focus : Microsoft SQL Server Administration, Always On Availability Groups, Performance Tuning, Database Security, Disaster Recovery, Production Database Operations, High Availability, and Multi-Terabyte Database Management.Tools & Platforms : Microsoft SQL Server (HA / Clustered), Always On Availability Groups (AGs), TDE & Auditing, T-SQL, Partitioning & Archiving, PowerShell, Snowflake / Redshift / AWS Aurora (Nice to Have).About The Role : We are looking for a Senior Database Engineer / DBA to own a large, multi-terabyte Microsoft SQL Server environment running in a highly available, clustered configuration. This is a hands-on production database role supporting a live, customer-facing SaaS platform. The role focuses on maintaining database availability, performance, security, and reliability. This is not an analytics or reporting role. The ideal candidate will have strong hands-on experience managing SQL Server databases in a 24x7 production environment, troubleshooting complex database issues, maintaining Always On Availability Groups, and ensuring business continuity through effective disaster recovery practices.Key Responsibilities : - Own and maintain the production SQL Server workplace in an Always On Availability Group configuration.- Handle failover operations, synchronization delay troubleshooting,
and read replica load management.- Maintain database availability and ensure the stability of production database environments.- Manage SQL Server alerts and provide on-call coverage for production database operations.- Lead incident response and root cause analysis for production database issues.- Troubleshoot query plan regressions, TempDB contention, deadlocks, and blocking issues.- Perform index and statistics maintenance to ensure optimal database performance.- Review developers' T-SQL queries and schema changes before deployment.- Maintain database security through Transparent Data Encryption (TDE), auditing, and certificate and key rotation.- Perform quarterly cumulative update patching across database environments.- Manage partitioning and archiving on multi-terabyte databases without impacting production performance.- Design, implement, and test disaster recovery strategies for SQL Server environments.Must-Have Requirements : - 7+ years of hands-on Microsoft SQL Server DBA experience in a 24x7 production environment.- 3+ years of direct experience with Always On Availability Groups.- Experience managing multi-terabyte production databases.- Experience leading incident response and root cause analysis.- Solid experience with database security practices, including TDE, auditing, and certificate rotation.- Hands-on experience with SQL Server performance tuning and query optimization.- Experience designing and testing disaster recovery strategies.- English fluency sufficient for real-time incident communication, with meaningful business-hours overlap with Pacific time.What We Offer : - Flexible work environment with Coimbatore office, hybrid, and remote options.- Paid holidays and flexible time off.- Medical insurance coverage of up to 4 lakh per person for self and family.- Opportunities to support production infrastructure for global clients. (ref:hirist.tech)
📌 Techjays - Senior Database Engineer - SQL Server (Coimbatore)
🏢 techjays
📍 Coimbatore