Database Designer/Developer (4951)

SMX

4d•$86,000 - $143,300•Hybrid

About The Position

The Database Designer/Developer will play a critical role in supporting Airworthiness and Flight Clearance systems by ensuring database integrity, performance, and security across Oracle and SQL Server environments. This position involves designing, developing, and optimizing database solutions, mitigating risks associated with code changes, and collaborating closely with developers, IT staff, and customers. This is a hybrid position based at Patuxent River NAS.

Requirements

Clearance Required: Secret
Minimum of Interim Secret is required to start
Bachelor's degree and 3+ years of experience
Allowable substitution: Associate's and 7 years of experience, or 9 years of experience in lieu of a degree
Experience designing/developing Oracle and SQL Server databases for application backend required
Solid understanding of Oracle RDBMS concepts required
Experience in performance tuning and query optimization required
Familiarity with secure coding practices and compliance standards, including application STIGs required
Familiarity with cloud services (preferably AWS) and migration from on-prem to serverless required
Toad for Oracle and SQL Server Management Console experience required

Nice To Haves

Experience using GitLab for version control and deployment highly desired

Responsibilities

Performance tuning using Toad and SQL Server Management Console
Data modeling and ERD creation
Writing and optimizing SQL and PL/SQL for Oracle and SQL Server
Evaluating and rewriting procedures and queries for performance improvements
Implementing constraints, foreign keys, primary keys, and indexes
Managing version control and deployment processes using GitLab
Ensuring database security (SQL injection mitigation, Label Security, Column Security, STIG compliance)
Supporting modernization efforts from on-premises to cloud/serverless technologies
Using dynamic SQL and metadata-driven approaches to reduce repetitive coding tasks
Collaborating effectively with cross-functional teams and customers