Job Title: PostgreSQL Database Engineer
Location: Springfield, VA
Eligibility: Candidate must possess an active TS/SCI clearance and be willing to obtain a CI Polygraph
Job Description
- Manages the functionality and efficiency of a group of servers running on one or more operating systems.
- Maintains database integrity and security, configures role-based access control (RBAC), and sets up administrative accounts.
- Sets up administrator and service accounts.
- Maintain documentation for configurations, standards, and procedures.
- Interacts with users and evaluates vendor products.
- Develops and monitors policies and standards for allocation related to the use of computing resources.
- Develops and implements testing strategies and documents results.
- Provides advice on performance tuning and training to end-users.
- Maintains current knowledge of relevant technologies as assigned.
- Evaluates open-source or vendor tools and participates in database migration/special modernization projects.
- Collaborates with developers on schema design, query optimization, and stored procedures.
- Planned and execute database upgrades, patching, and migrations.
- Ensure compliance with industry standards and regulatory requirements.
- Participates in on-call rotations for after-hours support.
Requirements
- Bachelor's Degree in Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.
- 5+ years of related database analysis and/or administration experience.
- PostgreSQL experience required. Oracle database administration a plus.
- CompTIA Security+ or equivalent recommended.
- Experience in PostgreSQL administration/tuning; including knowledge and implementation of database high-availability solutions.
- Experience in monitoring, creating, and managing PostgreSQL server agent alerts.
- Experience with database backup, restore, migration, and database snapshot technologies/strategies.
- Knowledge on how to build/maintain efficient database table structures for both transactional and warehouse data.
- Knowledge of Oracle 19c administration and performance tuning.
- Migration experience with Oracle, MySQL, and PostgreSQL.
- Candidates must hold a TS/SCI.
Location: On Customer Site – Arnold, MO/St. Louis, MO/Springfield, VA
US Citizenship Required
#J-18808-Ljbffr