Postgres Database Administrator (HYBRID)

Postgres Database Administrator (HYBRID)

Location

US-PA-Mechanicsburg

ID

2025-2528

Category

Databases & Data Warehousing

Position Type

Full-Time

Remote

Yes

Clearance Required

Secret

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. Must be able to work in Mechanicsburg, PA 1 time 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 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.

#hotjobs

AMS1

Qualifications

EEO Statement

EEO Race / Sex / Disability Status / Veteran Status