Oracle Database Administrator

Spectrum Software Technology (SST) is currently seeking an Oracle Database Administrator for our civil aviation programs. BS or higher in related field with 15 years of experience, will substitute degree for additional experience. Must have strong Oracle knowledge some SQL experience.

The position is based at the Federal Aviation Administration (FAA)’s William J. Hughes Technical Center adjacent to the Atlantic City International Airport, New Jersey. This is an Onsite role.

The DBA builds, configures and administers Production, Test and Development Databases for FAA Traffic Flow Management System (TFMS), National Traffic Management Log (NTML) and Departure Spacing Program (DSP). Migrate, configure and administer Production, Test and Development Databases for FAA Traffic Flow Management – Modernization TFM-M (DCCT)

Essential Job Functions:

· Provide 24/7 Production, test and Development Systems Support.

· Install and Upgrade Oracle Cluster Software, Oracle RDBMS Software for 10g, 11g and 12c

· Install and Configure the Oracle Weblogic, Oracle Report, Oracle OFM Webtier, Oracle Discover, Oracle HTTP Server and Oracle APEX

· Install, Configure and Manage the Oracle Data Guard Database in Oracle Cluster environment

· Install SQL server 2005/2007 and created and configured sql server instances

· Managing Oracle Grid including converting Oracle Datafiles from file system to ASM, adding or dropping nodes

· Migrated FAA Traffic Flow Management-Modernization DCCT to NJ FAA tech center - Databases including the Oracle and SQL Server

· Database Performance Tuning including debugging, modifying OS kernel and oracle initial parameters and sql tuning

· Trouble shooting various issues related to the database and applications - oracle and sql server

· Managing and maintain OLTP Databases with over 400G

· Created various database maintenance scripts for backup and recovery (RMAN, data pump), monitor and check Database status, and capture the Database waning or alert messages. Created user-friendly application to support web applications by adding, checking or correcting application data

· Application supports including debug the code, correct the data, modify the codes and create the reports to support management decisions, QA Groups and customer requirements

· As the key person, responsible for all type of databases to support applications for the FAA TFM-2 project, DSP, NTML, TSS and Data Quality projects including analyze the data and debug/modify the application codes

Requirements:

• Bachelor’s degree Computer Science or related field with 15 yrs. related experience
• Previous experience as an Oracle DBA
• Strong Oracle knowledge
• SQL experience
• Previous FAA experience a bonus but not required

SST offers competitive salaries and 100% paid benefits including health, vision, & dental insurance that start day one. 401K with match. PTO plus 11 paid holidays.

Job Type: Full-time

Pay: $140,000.00 - $175,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Referral program
• Vision insurance

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday
• No weekends

Education:

• Bachelor's (Preferred)

Experience:

• Oracle: 10 years (Required)

Ability to Commute:

• Egg Harbor Township, NJ 08234 (Required)

Work Location: In person

Salary : $140,000 - $175,000