Today
Top Secret/SCI
Unspecified
Unspecified
IT - Database
Sterling, VA (On-Site/Office)
Senior Database Developer - Sterling, VA - TS/SCI
Job Description:
Qualifications You Must Have
Qualifications Preferred
Employment Pre-requisites
The following requirements must be met to be eligible for this position: Successful completion of a background investigation, and drug urinalysis.
SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability.
#INDSOC
Estimated Min Rate: $63.00
Estimated Max Rate: $90.00
Job Description:
- Design, develop, and maintain relational databases using AWS Aurora PostgreSQL.
- Create and optimize PostGIS-enabled schemas and geo-temporal queries for high-speed data retrieval.
- Define and implement complex security protocols for data filtering and redaction
- Translate data models into normalized, relational schemas aligned with application requirements.
- Collaborate with developers to integrate and optimize database access via JPA/Hibernate and other persistence frameworks.
- Tune performance through advanced indexing, partitioning, and query optimization techniques.
- Set up and manage database environments, including schema version control and migration support.
- Establish secure, efficient structures to support evolving development needs and future scalability.
Qualifications You Must Have
- Typically requires Bachelor's degree in Science, Technology, Engineering or Mathematics (STEM) and a minimum of 5 years of prior relevant experience.
- Active and transferable U.S. government issued TS/SCI security clearance prior to start date. U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance.
- Five (5) years of experience in Database Administration, including installation, configuration, and maintenance of (RDBMS) Relational Database Management System (e.g., Oracle, PostgreSQL, MySQL) and SQL scripting.
- CompTIA Security+ certification (required for privileged access).
Qualifications Preferred
- Architecture experience: the ability to design schemas (and migrate schemas in place).
- Experience setting up and optimizing AWS Aurora PostgreSQL environments.
- Experience of relational data modeling and schema versioning in support of software development.
- Experience with security, setting up RLS, session and permissions management, experience with column or cell level security a plus
- Experience with query optimization, mapping tables to blocks and partitions, sub-table structure and keying/indexing for efficiency
- Experience with PostGIS, ability to optimize geo temporal queries and indexes
- Java Persistence (JPA) experience and an understanding of the coupling between+ JPA structure and the Database.
- Experience managing an operationally fielded Database while simultaneously being under further development
- Experience with JPA/Hibernate structures and how they interact with the underlying database.
- Experience supporting classified or government systems with strict security requirements.
- Exposure to DevOps practices related to database deployment and automation.
- Experience as the sole or lead database expert on a development team.
- Familiarity with source control systems (e.g., Git/Bitbucket) and CI/CD integration.
- Familiarity with Java-based software ecosystems and schema integration in microservice architecture.
Employment Pre-requisites
The following requirements must be met to be eligible for this position: Successful completion of a background investigation, and drug urinalysis.
SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability.
#INDSOC
Estimated Min Rate: $63.00
Estimated Max Rate: $90.00
group id: cxhlpand
Diversity is one of our core values as a Company, and it’s also something very personal and unique to each employee. Who better to tell our story of diversity than the people who are part of that story. “The Many Diverse Voices of Betterment” shares how our unique backgrounds and perspectives make us stronger, together, as a Company as a whole, and as individuals. Our diverse and inclusive culture and what diversity means at SOC and Day & Zimmermann is told through personal, unscripted first-person narratives.
