Quick Overview
Job Description
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.
EEO Statement EEO Race/Sex/Disability Status/Veteran Status
Similar jobs
- AN
Principal Data Engineer - AI
NewAnaplan
PA🇺🇸Hybrid12 hours agoSQLAWSETL+15Technology - SI
Data Engineer & Analyst — Federal Analytics Consulting
SUNRAY INFORMATICS
Washington, DC🇺🇸Hybrid6 days agoDynamoDBMongoDBOracle+15Technology - CL
Snowflake Data Engineer – ReactJS
ClifyX
Dallas, TX🇺🇸Hybrid1 week agoMySQLSQLSQL Server+7Technology - PT
Data Engineer with Neo4j and Spanner Graph
Pyramid Technology Solutions, Inc.
United States🇺🇸Remote2 weeks agoNeo4jSQLGoogle CloudTechnology - EG
VaultSpeed Data Engineer
Eliassen Group
Almont, CO🇺🇸$75 - $85/hrHybrid4 weeks agoSQLETLAirflow+12Technology - VB
Data Integrations Manager
Vaco by Highspring
Hoboken, NJ🇺🇸On-site5 weeks agoAgileERPProcess Improvement