A

Postgres Database Administrator

American Systems
Full-time
Remote
United States
Administrative

Overview

AMERICAN SYSTEMS is an employee-owned federal government contractor supporting national priority programs through our strategic solutions in the areas of Information Technology, Test & Evaluation, Program Mission Support, Engineering & Analysis, and Training.

Responsibilities

As a Postgres Database Administrator with AMERICAN SYSTEMS you will have the opportunity to do the following: Provide Subject Matter Expert (SME) support for PostgreSQL in an AWS Cloud environment.

  • Provide PostgreSQL database management and life cycle support for a collaborative engineering tools environment.
  • Implement the conversion of existing databases to meet new release requirements.
  • Evaluate the effectiveness of database management technology and investigates problems and inefficiencies in a well-established data base environment.
  • Determine the impact of new or revised software on system operations and applications.
  • Investigate factors such as amount of storage space consumed, access times, frequencies of reads and writes, and problems encountered by other application and systems programmers using the DBMS software.
  • Evaluate and determines alternatives, and initiates corrective action to recover/restore data and return system back to normal operations.
  • Administer day-to-day database operation and maintenance in an environment in which the system software is typically available from vendors and widely used.
  • Ensure the database efficiently collects, stores, and processes data.
  • Run utility routines/programs and investigate when reports indicate a decline in computer performance.
  • Develop and maintain security procedures to guard against unauthorized intrusion into databases.
  • Develop procedures and recommend methods to insure rapid access to all data.
  • Analyze use of archived data and develop ways to insure optimum use of existing systems.
  • Provide assistance to programmers/analysts in program development, testing, and implementation of modified programs.

Qualifications

  • Secret Clearance required.
  • Must be able to work in Mechanicsburg, PA 1 time per week.
  • COMPTIA Security + required
  • 5 or more years of DBA Experience
  • 3 or more years of Postgres SQL DBA experience
  • 2 or more years of AWS/Cloud experience

Pay Transparency Statement

AMERICAN SYSTEMS is committed to pay transparency for our applicants and employee-owners. The salary range for this position is USD $94,400.00/Yr. - USD $157,600.00/Yr. Actual compensation will be determined based on several factors permitted by law. AMERICAN SYSTEMS provides for the welfare of its employees and their dependents through a comprehensive benefits program by offering healthcare benefits, paid leave, retirement plans, insurance programs, and education and training assistance.

EEO Statement

EEO Race/Sex/Disability Status/Veteran Status
Apply now