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
Read Less