Archived listing. The details below describe a past opening.
Job Description
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.
Skills and Requirements
Active 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.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.