About the role

  • Application Database Administrator supporting Airworthiness and Flight Clearance systems. Ensuring database performance and security across Oracle and SQL Server environments with a collaborative approach.

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

Job title

Application Database Administrator

Job type

Experience level

Mid levelSenior

Salary

$95,000 - $140,000 per year

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job