PostgreSQL Database Engineer (TS/SCI Clearance required)

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 document 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.

•             Collaborate with developers on schema design, query optimization, and stored procedures

•             Plan and execute database upgrades, patching, and migrations

•             Ensure compliance with industry standards and regulatory requirements

•             Participate in on-call rotations for after-hours support

WHAT YOU'LL NEED TO SUCCEED:

Requirements:

•             Bachelors Degree in a 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 PostgresSQL

•             Candidates must hold a TS/SCI