Database Designer/Developer (4951)

SMX • Patuxent River, MD

3d • $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

Benefits

• At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees