Database Administrator

Description

The Senior Database Administrator (DBA) is responsible for managing, maintaining, and optimizing Microsoft SQL Server database environments to ensure high performance, availability, reliability, and security. This role requires deep technical expertise in SQL Server internals, query optimization, concurrency management, and high-availability solutions. The DBA will work closely with application, infrastructure, and IT teams to support mission-critical systems and resolve complex performance and scalability challenges.

Role

• Demonstrate deep understanding of SQL Server internals, including query processing, memory management, and I / O subsystems.
• Analyze execution plans and understand query processor architecture and storage engine behavior.
• Diagnose complex performance issues rooted in engine-level behavior.
• Analyze, troubleshoot, and rewrite inefficient SQL queries to improve performance.
• Design and maintain effective indexing strategies, including clustered, non-clustered, filtered, and columnstore indexes.
• Leverage INCLUDE columns appropriately to balance query performance and storage efficiency.
• Understand how SQL Server uses statistics during query optimization and plan generation.
• Create, update, and manage statistics to improve cardinality estimation accuracy.
• Identify and resolve performance issues caused by outdated or inaccurate statistics.
• Diagnose and resolve blocking, deadlocks, and contention issues.
• Understand and tune transaction isolation levels to balance consistency and performance.
• Optimize workloads to support high concurrency without compromising system stability.
• Support and maintain SQL Server Always On Availability Groups and other replication technologies.
• Troubleshoot and resolve query performance issues related to SQL Server version upgrades or changes in cardinality estimator behavior.
• Assist with planning and executing SQL Server version upgrades with minimal disruption.
• Strong experience administering Microsoft SQL Server in production environments.
• Advanced knowledge of SQL Server performance tuning and troubleshooting.
• Proven experience working with Always On Availability Groups and / or replication technologies.
• Strong analytical and problem-solving skills with attention to detail.
• Experience supporting large-scale, high-concurrency database systems.
• Familiarity with SQL Server upgrades and performance regression analysis.
• Ability to collaborate effectively with developers, infrastructure teams, and stakeholder