Sosuv logo

Senior Sql Database Administrator

Sosuv
Bengaluru

Posted:7 hours ago

Job Description


Company Profile:


We are a product and services company focussed on the financial services domain. Our clients are the world's major fintech players. We are looking for intelligent, talented and motivated individuals who are up for a challenge and believe in our vision. We are an equal opportunity employer. We value diversity and inclusion and encourage all qualified individuals to apply.

We're looking for exceptional Full Stack Developers who are passionate about technology and coding.


Core Enterprise Administration (multi-TB scale)

• Database architecture for VLDBs (very large databases) — partitioning strategies, filegroup design,

data compression (row/page/columnstore)

• Storage engine internals: tempdb configuration, I/O subsystem tuning, storage tiering for 10-40TB+

databases

• Backup/recovery at scale: differential/log backup strategies, backup compression, striped backups,

Instant File Initialization, point-in-time recovery for huge DBs

• Index management: online index rebuilds, resumable index operations, maintenance windows for large

tables

• Capacity planning and storage forecasting for continued growth


High Availability / Disaster Recovery

• Always On Availability Groups: multi-replica design, synchronous/asynchronous commit modes,

automatic/manual failover, read-scale replicas

• Distributed Availability Groups (cross-region/cross-cluster DR)

• Windows Server Failover Clustering (WSFC) integration and quorum configuration

• Log shipping and database mirroring (legacy, still seen in hybrid environments)

• Backup/restore testing and DR runbook validation

• RTO/RPO planning and SLA management


Enterprise Edition Features

• Table/index partitioning and partition switching for large fact tables

• Data compression (ROW, PAGE, columnstore compression)

• Transparent Data Encryption (TDE)

• Online operations (index rebuild, schema changes without downtime)

• Resource Governor for workload isolation

• In-Memory OLTP (memory-optimized tables) where applicable

• Query Store for plan regression tracking at scale


Performance Tuning

• Query plan analysis, execution plan reading, and plan cache management

• Wait statistics analysis (sys.dm_os_wait_stats, sys.dm_exec_requests)

• Index tuning: missing index DMVs, index fragmentation, covering indexes, filtered indexes

• Statistics management (auto-update thresholds, manual stats maintenance on large tables)

• TempDB contention troubleshooting (PFS/GAM/SGAM latches)

• Parameter sniffing mitigation, plan forcing, query hints

• Extended Events / Profiler-replacement tracing

Monitoring & Automation

• Proactive monitoring tooling (native DMVs, third-party APM like SolarWinds/Redgate/SentryOne, or

Azure Monitor)

• PowerShell/dbatools scripting for repeatable admin tasks across many instances

• Automated health checks, alerting thresholds, and job/maintenance plan standardization

• Patch management strategy across a large instance fleet


Security & Compliance

• Role-based access control, least-privilege design

• Auditing (SQL Server Audit, Extended Events-based auditing)

• Encryption at rest/in transit, key management

• Compliance frameworks relevant to your industry (HIPAA, PCI-DSS, SOX, etc.)


Cloud-Native / Modernization

• Azure SQL Database and Azure SQL Managed Instance — feature parity gaps vs. on-prem,

sizing/tiers (vCore vs DTU)

• Azure SQL Managed Instance for near-lift-and-shift migrations with minimal app changes

• SQL Server on Azure VMs (IaaS) for full control scenarios

• AWS RDS for SQL Server / Amazon Aurora as an alternative cloud target

• Migration tooling: Azure Database Migration Service (DMS), Data Migration Assistant (DMA),

backup/restore to blob storage

• Hybrid connectivity: Azure Arc-enabled SQL Server for unified management across on-prem/cloud

• Elastic scaling, auto-pause/resume (serverless tiers), and cost optimization for cloud workloads

• Evaluating PaaS/DBaaS tradeoffs: reduced admin overhead vs. loss of certain Enterprise features

• Containerized SQL Server (Docker/Kubernetes) exposure for dev/test and modern CI/CD pipelines

• Infrastructure-as-Code exposure (ARM/Bicep/Terraform) for provisioning cloud SQL resources


Cross-Cutting / Soft Skills

• Comfortable managing dozens to hundreds of instances via centralized tooling rather than one-off manual work

• Change management and migration planning for zero/low-downtime cutovers

• Documentation and runbook discipline given team/environment complexity

Skills Required

SQL Database SQL DBA Financial Services Diversity and Inclusion Full Stack Windows Capacity Planning Forecasting High Availability Disaster Recovery Windows Server LOG Shipping

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Sosuv logo
Sosuv

RecommendedJobs for You