Software Engineer / Database Developer with Security Clearance - GeoLogics Corporation

TITLE: Software Engineer / Database Developer RATE RANGE: $70 - $100.00/hr W2 (Based on Benefits Chosen while on contract) ONSITE LOCATION: Sterling, VA 20166 or State College. PA 16801 REQUIRED: TS/SCI CLEARANCE DURATION: 12+ months Contract to Hire ***No C2C, we can NOT work with outside agencies/vendors, and we can NOT do 1099-ACTIVE TS/SCI CLEARANCE IS REQUIRED*** REQUIRED EDUCATION AND SKILLS: * Active and transferable U.S. government issued TS/SCI security clearance is required prior to start date. * Typically requires a degree in Science, Technology, Engineering, or Mathematics (STEM) and a minimum of 5 years of experience.
* 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).
DESIRED SKILLS: * Experience/ 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. POSITION OVERVIEW * 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.
If you would like to interview for this position, please send an updated resume to Meredith Baldwin, *Rates listed are not a guarantee of salary/rate. Rate offered at time of hire will depend on many factors including education, experience, interview results and skill level GeoLogics is an Equal Opportunity/Affirmative Action Employer that is committed to hiring a diverse and talented workforce. EOE/Disability/Veteran Meredith Baldwin Recruiter #CJ