Candidate must have a Bachelor’s Degree in a related field of study with a minimum of five (5) years of database related experience.
High school diploma or GED required with a minimum of ten (10) years database related experience.
Experience with PostgreSQL v9.0 database development & testing required.
Experience with and administration of PostgreSQL v9.0 database required.
Experience in setting up and maintaining PostgreSQL v9.0 database.
Experience with SQL required within a RHEL/Linux server environment.
Experience with PL/SQL preferred.
Knowledge of NAS and NAS support systems
Knowledge of FAA data and disaster recovery policies
ESSENTIAL JOB FUNCTIONS
Function as team member with other IT employees and numerous functional team leaders.
Responsible for the following: testing; monitoring; performance tuning; backups; disaster recovery planning (jointly with the Systems Administrator and/or Infrastructure Management); security patching; annual Oracle version upgrades and security patches when they become available.
Maintain scripts to create databases and database objects.
Maintain scripts to create views, procedures, and functions in support of application development.
Use of utility programs to monitor database performance including query execution plans, query execution times, indexing, and resource usage.