Postgres Database Administrator (HYBRID)

AMERICAN SYSTEMS; Mechanicsburg (Cumberland County); Hybrid; USD 125,000 - 155,000; Full time

Job summary

AMERICAN SYSTEMS is seeking a Postgres Database Administrator to support on-prem VMware and AWS Cloud environments for DoD programs. The role requires PostgreSQL and Oracle expertise, a Secret clearance, and 4+ years of professional experience. The position is hybrid, with work in Mechanicsburg, PA 2 days per week.

Responsibilities include database management, lifecycle support, performance tuning, security procedures, and collaboration with engineers and analysts on modified programs.

Qualifications

• Must have or be able to obtain a Secret Clearance.
• Must be able to work in Mechanicsburg, PA 2 times per week.
• Experience with Postgres and Oracle.
• COMPTIA Security + required.
• 4+ years of overall professional experience.

Responsibilities

• Provide SME support for PostgreSQL and Oracle in a traditional on-prem VMware environment and an AWS Cloud environment.
• Provide PostgreSQL database management and lifecycle 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 investigate problems in the database environment.
• Determine the impact of new or revised software on system operations and applications.
• Investigate factors such as storage usage, access times, and read/write frequencies.
• Develop and maintain security procedures to guard against unauthorized intrusion into databases.
• Assist programmers/analysts in program development, testing, and implementation of modified programs.

Skills

PostgreSQL

Oracle

Security+

Secret Clearance

VMware

AWS Cloud

Job description

Postgres Database Administrator (HYBRID)

US-PA-Mechanicsburg

2026-4758

Databases & Data Warehousing

Full-Time

No

Secret

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. Must be able to work in Mechanicsburg, PA 2x per week.

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 Oracle and PostgreSQL in a traditional on-premise VMware environment and 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.

AMS1

Qualifications

• Must have or be able to obtain a Secret Clearance.
• Must be able to work in Mechanicsburg, PA 2 times per week.
• Experience with Postgres and Oracle.
• COMPTIA Security + required
• 4+ years of overall professional 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 $125,000.00/Yr. - USD $155,000/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.

• healthcare benefits
• paid leave
• retirement plans
• insurance programs
• education and training assistance

EEO Statement

EEO Race/Sex/Disability Status/Veteran Status