Lead Database Administrator
We are looking for an experienced Database Engineer with strong expertise in Microsoft SQL Server (On-Premises) to design, optimize, and maintain high-performance database systems. The ideal candidate will have deep hands-on knowledge of SQL optimization, SQL Server internals, and performance troubleshooting.
Key Responsibilities
- Design, develop, and maintain SQL Server databases in an on-premises environment.
- Write and optimize complex T-SQL queries (SELECT, INSERT, UPDATE, DELETE) for high performance.
- Perform advanced query tuning, indexing strategies, and statistics management.
- Analyze and resolve performance issues related to locking, blocking, deadlocks, and resource contention.
- Monitor and tune SQL Server internals including memory management, Page Life Expectancy (PLE), buffer pool, and wait statistics.
- Diagnose and troubleshoot database performance problems using execution plans, DMVs, Extended Events, and system monitoring tools.
- Maintain database structure, tables, indexes, partitions, and overall database health.
- Implement best practices for database design, normalization, and data integrity.
- Collaborate with development and infrastructure teams to ensure optimal database performance and availability.
- Document database designs, performance issues, and resolution steps.
Required Skills & Experience
- Strong expertise in Microsoft SQL Server (On-Premises).
- Excellent T-SQL skills with proven experience in query optimization (INSERT, UPDATE, DELETE, and complex SELECT statements).
- Deep knowledge of indexing strategies, statistics, and query execution plans.
- Solid understanding of SQL Server internals (memory architecture, buffer pool, Page Life Expectancy, tempdb, etc.).
- Hands-on experience diagnosing and resolving locking, blocking, and deadlock issues.
- Strong problem-solving and diagnostic skills.
- Good understanding of database structure, table design, and overall database architecture.