Senior Sql Server DBA-MNC Financial Organization (India)

Senior Sql Server DBA-MNC Financial Organization (India)

19 Nov
|
RiverForest Connections Private
|
India

19 Nov

RiverForest Connections Private

India

Senior SQL Server DBA (Azure & AWS Cloud Focus)

## About the Role
We are seeking a Microsoft SQL Server Subject Matter Expert to serve as the senior technical authority for our SQL Server estate. This role requires deep, hands-on SQL Server DBA expertise combined with strong experience running SQL Server in both Microsoft Azure and Amazon Web Services (AWS), alongside a genuine drive to standardize and automate.
You will be accountable for the health, performance, security, and resilience of our SQL Server databases, whether hosted on-premises or in the cloud, and for elevating the standards of how the Data Services Team builds and operates them.
You will lead by example, solving complex technical problems, replacing manual effort with reliable automation, and mentoring less senior DBAs. Collaboration with the Data Services Manager, application, infrastructure, and security teams is essential.

## Key Responsibilities

- **SQL Server Administration & Architecture**

- Design, implement, and maintain SQL Server environments (2019 and 2022) on-premises, covering capacity planning, schema design, filegroup and storage management, and tempdb configuration.
- Manage Always On Availability Groups, Failover Cluster Instances (WSFC), log shipping, and replication to meet defined availability targets.
- Administer SQL Server Management Studio, Azure Data Studio, SQL Server Agent, and related monitoring tooling.
- Maintain documented instance configuration baselines and define and enforce standards for naming, collation, partitioning, and object management.
- **Microsoft Azure**
- Own the build, operation, and optimization of SQL Server on Azure, including Azure SQL Managed Instance, Azure SQL Database, and SQL Server on Azure VMs.
- Use Query Performance Insight, SQL Insights in Azure Monitor, and automatic tuning recommendations to analyze real-time and historical performance.
- Manage Azure SQL auto-failover groups, automated backups, and long-term retention, with identity and access through Microsoft Entra ID and Azure RBAC, and keys and secrets in Azure Key Vault.
- Configure and review private endpoints, VNet rules, and firewall settings in line with security standards.
- **Amazon Web Services (AWS)**
- Own the build, operation, and optimization of SQL Server on AWS, including Amazon RDS for SQL Server, RDS Custom, and SQL Server on EC2, with Multi-AZ deployments and read replicas.
- Use Amazon Cloud Watch, RDS Performance Insights, and Enhanced Monitoring to analyze real-time and historical performance.
- Manage RDS automated backups, snapshots, and AWS Backup plans, native backup and restore to Amazon S3, and platform maintenance windows.
- Apply AWS IAM, AWS KMS, AWS Secrets Manager, VPC subnet groups, and security groups in line with security standards.
- **Cloud Platform Operations & Architecture**
- Act as the technical owner for SQL Server workloads across both clouds, applying a single set of operational standards regardless of the hosting platform.
- Advise on hosting choices for new and migrating workloads (managed service versus VM or EC2, and Azure versus AWS), with a clear rationale covering cost, resilience, and feature requirements.
- Provision and modify database resources through infrastructure as code and repeatable pipelines rather than manual portal changes.
- Monitor and report on database cloud spend, identifying right-sizing, reserved capacity, licensing,



and storage optimization opportunities.
- Track service roadmaps and deprecations in both clouds and plan remediation before end-of-support dates.
- **Performance Tuning & Optimization**
- Proactively identify and resolve bottlenecks using Query Store, DMVs, wait statistics, and Extended Events.
- Tune execution plans, indexing strategy, and statistics; diagnose and remediate parameter sniffing and plan regression; manage tempdb contention, I/O throughput, blocking, and deadlocks.
- Maintain consistent performance baselines and thresholds across on-premises, Azure, and AWS so estate health can be compared like for like.
- Lead periodic performance health checks and present findings and recommendations to the Data Services Manager.
- **Backup, Recovery & Business Continuity**
- Own the backup strategy (full, differential, and transaction log, including backup to URL and Amazon S3) and regularly validate recovery procedures.
- Maintain and test disaster recovery runbooks for all production databases, coordinating failover exercises and point-in-time restore tests in both clouds.
- Ensure RPO and RTO targets are documented, tested, and achievable, and run integrity checks (DBCC CHECKDB), acting promptly on any corruption.
- **Security & Compliance**
- Enforce least-privilege access across logins, database users, roles, and service accounts.
- Implement and audit Transparent Data Encryption (TDE), Always Encrypted, Dynamic Data Masking, Row-Level Security, and SQL Server Audit.
- Work with the security team on vulnerability assessments and patch remediation to meet regulatory and organizational standards in every hosting environment.
- **Patching, Upgrades & Change**
- Plan and execute Cumulative Update (CU) and GDR patching cycles with minimal downtime, and manage platform-driven maintenance in Azure and AWS.
- Lead major version upgrades and migrations to Azure SQL or Amazon RDS, including compatibility testing, Azure DMS or AWS DMS, and rollback planning.
- Prepare change advisory board submissions and complete post-implementation reviews.
-

**Automation & Continuous Improvement**
- Identify and eliminate repetitive DBA tasks through automation using T-SQL, Power Shell (including dbatools and the Az and AWS Tools modules), and SQL Server Agent.
- Standardize routine maintenance through a proven framework covering index and statistics maintenance, integrity checks, and backup scheduling.
- Improve monitoring and alerting, tuning thresholds to cut noise and strengthen signal quality.
- Maintain a technical debt register and drive its reduction through prioritized, tracked work.
- **Incident & Problem Management**
- Take technical command of P1/P2 database incidents, delegating diagnostics clearly and prioritizing service restoration.
- Provide prompt initial assessments and regular, factual status updates throughout an incident.
- Lead post-incident reviews and ensure resulting actions are tracked through to completion.
- **Technical Leadership & Collaboration**




- Act as primary technical mentor to less senior DBAs: assigning and briefing work, reviewing scripts, changes, and runbooks before they reach production, and giving timely, constructive feedback.
- Run knowledge-sharing sessions and contribute to technical assessments and onboarding of new team members.
- Provide a concise weekly status summary and quarterly database health reports to the Data Services Manager.
- Represent the team at release and change meetings, and explain database risks and dependencies in transparent, non-technical language.
- **Documentation & Work Management**
- Own and maintain the database inventory, architecture documentation, runbooks, and DR procedures, treating documentation as part of the "definition of done."
- Track all work in the team's ticketing and project tools (Jira), keeping status and effort up to date and supporting regular backlog triage.

## Requirements
### Essential Skills & Experience
- Substantial commercial experience as a SQL Server DBA (typically 8+ years), operating as a senior technical authority or subject matter expert.
- Expert knowledge of SQL Server 2019 / 2022 administration, including Always On Availability Groups, WSFC, backup and recovery, and security.
- Proven performance tuning ability using Query Store, DMVs, wait statistics, Extended Events, and execution plan analysis.
- Hands-on experience running SQL Server in Azure (Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure VMs).
- Hands-on experience running SQL Server in AWS (Amazon RDS for SQL Server, RDS Custom, or SQL Server on EC2).
- Strong automation skills: T-SQL and Power Shell applied to real DBA operations.
- Experience with patching, upgrades, and migrations, and with TDE, auditing, and least-privilege security models.
- Experience designing and testing high availability and disaster recovery solutions against defined RPO and RTO targets.
- Experience leading technical response to major incidents.
- Strong written and verbal communication, with the ability to adapt message and detail to technical and non-technical audiences.

### Desirable Skills & Experience
- Infrastructure-as-code tooling (for example, Terraform, Bicep, or Cloud Formation), Git, and CI/CD pipeline experience applied to database change.
- Experience with Azure CLI and AWS CLI tooling.
- Experience of cloud cost optimization, reserved capacity, and SQL Server licensing.
- Exposure to Oracle in a multi-platform estate.
- PostgreSQL administration experience, including performance tuning, backup and recovery, and high availability, on-premises or on managed cloud services (for example, Azure Database for PostgreSQL or Amazon RDS for PostgreSQL).
- Relevant Microsoft and AWS certifications (for example, Azure Database Administrator Associate).
- Experience mentoring or coordinating the work of other DBAs.

### Behaviours
- **Proactive:** Anticipates problems and acts on early warning signs rather than waiting for an alert.
- **Accountable:** Owns mistakes openly and focuses on solutions, not blame.
- **Collaborative:** Builds strong working relationships across development, infrastructure, and security teams.
- **Supportive:** Creates a psychologically safe environment, recognizes good work, and develops others.
- **Trustworthy:** Maintains the confidentiality of sensitive data, credentials, and commercial information.

📌 Senior Sql Server DBA-MNC Financial Organization (India)
🏢 RiverForest Connections Private
📍 India

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior sql server dba-mnc financial organization (india) / india

Subscribe to this job alert:

Get the latest job offers by email for: senior sql server dba-mnc financial organization (india) / india