Senior SQL Server DBA

One of our clients in the government domain is seeking a Senior SQL Database Engineer.

The ideal candidate must have strong hands-on experience with SQL Server database design, performance tuning, backup/recovery, and production support, along with the ability to diagnose and resolve locking, deadlocks, and performance issues. Must also have solid Java backend development experience using JPA/Hibernate, JDBC, RESTful APIs, and JUnit, and be comfortable designing efficient data access layers and collaborating on database schema design. Experience supporting the full SDLC, writing automation scripts, working within CI/CD pipelines, and operating independently with strong communication skills is required.

Must-Have Requirements:

• Strong hands-on experience with SQL Server database design, development, performance tuning, backup, recovery, and monitoring

• Proven ability in performance engineering: tuning slow SQL queries, stored procedures, indexing, and resolving locking/deadlock issues

• Solid experience with Java backend development, specifically:
– Java in a Windows environment
– JPA / Hibernate, JDBC, DAO patterns
– SQL integration
– JUnit for unit testing

• Experience designing, developing, and consuming RESTful APIs

• Strong understanding of data modeling:
– Logical and physical data modeling
– Data dictionary analysis and standards

• Experience supporting the full application SDLC, including deployment and production support

• Ability to monitor database health, space usage, and performance, and perform routine maintenance

• Hands-on experience writing scripts for backup, restore, monitoring, and automation

• Experience collaborating with developers on schema design (DDL) and data access best practices

• Experience diagnosing and resolving production issues with minimal supervision

• Familiarity with CI/CD pipelines for database migrations and application deployments

• Strong communication skills and ability to work effectively in a team environment