Hybrid Database Designer/Developer

at U.S. Department of Labor

• Job title: Database Designer/Developer
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $95,000 - $140,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: AWS, Cloud, Oracle, RDBMS, SQL
• Location requirements: Hybrid, Lexington Park, United States

About the role

• Database Designer/Developer focusing on database integrity for Airworthiness and Flight Clearance systems. Collaborating with developers and IT staff in a hybrid remote/in-office setup.

Responsibilities

• The Application DBA 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.
• 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.
• Other duties as assigned.

Requirements

• 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.
• BS/BA degree and 3 years related experience OR AA/AS degree and 7 years related experience OR HS and 9 years related experience.
• Experience using GitLab for version control and deployment highly desired.

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Short Term & Long Term Disability
• Training & Development
• Wellness Resources
• Stock Option Benefit