American Systems
Postgres Database Administrator (HYBRID)
American Systems, Mechanicsburg, Pennsylvania, United States, 17050
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 #recruitingsurge Qualifications
Must have or be able to obtain a Secret Clearance. 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
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 #recruitingsurge Qualifications
Must have or be able to obtain a Secret Clearance. 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