Senior SQL Database Administrator
Description:
One of our clients in the government domain is seeking a Senior SQL Database Engineer.
The ideal candidate must have 10 years of 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