Software Engineer / Database Developer

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, mbaldwin@geologics.com

GeoLogics is an Equal Opportunity/Affirmative Action Employer that is committed to hiring a diverse and talented workforce. EOE/Disability/Veteran