American Systems Corporation - Mechanicsburg, PA
posted 3 months ago
As a Postgres Database Administrator at American Systems Corporation, you will play a crucial role in managing and supporting PostgreSQL databases within an AWS Cloud environment. This position requires a Secret clearance and involves working closely with a team of highly skilled professionals. You will be responsible for providing Subject Matter Expert (SME) support for PostgreSQL, ensuring the effective management and lifecycle support of databases in a collaborative engineering tools environment. Your expertise will be essential in implementing the conversion of existing databases to meet new release requirements and evaluating the effectiveness of database management technology. In this role, you will investigate problems and inefficiencies within a well-established database environment, determining the impact of new or revised software on system operations and applications. You will analyze various factors such as storage space consumption, access times, and the frequency of reads and writes, while also addressing issues encountered by application and systems programmers using the DBMS software. Your responsibilities will include initiating corrective actions to recover or restore data and returning systems to normal operations. You will administer day-to-day database operations and maintenance, ensuring that the database efficiently collects, stores, and processes data. This includes running utility routines and investigating performance declines. Additionally, you will develop and maintain security procedures to protect against unauthorized access to databases and recommend methods to ensure rapid access to all data. Your role will also involve assisting programmers and analysts in program development, testing, and implementation of modified programs. American Systems Corporation offers a robust benefits package, including an Employee Stock Ownership Plan (ESOP) and flexible work hours, allowing you to manage your personal needs effectively. This position is hybrid, requiring you to be in Mechanicsburg, PA, up to one time per week, and includes a sign-on bonus of $3,000.