PostgreSQL Database Engineer

Arena Technical Resources, LLC (ATR); Springfield (VA); On-site; USD 100,000 - 130,000; Full time

Job summary

Arena Technical Resources, LLC (ATR) is seeking a PostgreSQL Database Engineer located in Springfield, VA. The ideal candidate will manage PostgreSQL databases, ensuring integrity, security, and performance while collaborating with developers and participating in database migrations.

Applicants should have a Bachelor's Degree in Computer Science, 5+ years of experience in database administration, and must possess an active TS/SCI clearance. This position requires hands-on experience with PostgreSQL, Oracle, and strong knowledge of database migration strategies.

Qualifications

• 5+ years of related database analysis and/or administration experience.
• Experience with PostgreSQL administration/tuning.
• Candidates must hold a TS/SCI clearance.

Responsibilities

• Manages functionality and efficiency of servers running PostgreSQL.
• Maintains database integrity and security.
• Develops and implements testing strategies and documents results.

Skills

PostgreSQL experience

Database administration

Performance tuning

Monitoring PostgreSQL server

Database migration strategies

Education

Bachelor's Degree in Computer Science or related field

Tools

Oracle 19c

MySQL

CompTIA Security+

Job description

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