Senior SQL Database Administrator
- |5 years of exp
- |Full Time
In office
Not Available
About the job
Job Description: Senior SQL DBA
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.dmoswaitstats, sys.dmexec_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
• Server-level tuning: max memory, MAXDOP, cost threshold for parallelism, NUMA considerationsMonitoring & 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
About the company
Similar Jobs









