Software Engineer / Database Developer
Software Engineer / Database Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 TOP SECRET/ 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
GeoLogics is an Equal Opportunity/Affirmative Action Employer that is committed to hiring a diverse and talented workforce. EOE/Disability/Veteran
Employment Type
Contract
