Position: PostgreSQL Database Administrator
Location: Suffolk, VA 23432
Clearance: Secret, TS eligible
Req: 2024.17.2.21.03.07
PROSOFT is seeking an Enterprise Database (EDB) PostgreSQL-experienced DBA candidate to support the management and maintenance of PostgreSQL for existing command applications and systems. The candidate should have design and implementation experience of mid- to large-scale technical solutions. The ideal candidate has a strong blend of people skills and in-depth knowledge of database deployments including but not limited to being able to perform all aspects of database administration and maintenance for PostgreSQL in a virtualized Red Hat Enterprise Linux operating system environment, as well as thoroughly understand multi-site replication, backup, and restore configurations.
Candidate should possess following skills:
- 8+ years of DBA level experience with PostgreSQL or other major relational databases, including Oracle.
- 3+ years of experience working on Linux operating systems, preferably Red Hat.
- 3+ years of experience working in VMware virtualized environment.
- Ability to configure, monitor, and maintain databases preferably with PostgreSQL and Oracle. SQL Server experience will be considered.
- Experience in implementing PostgreSQL STIG implementation, testing, and other vulnerability remediation.
- Proficient with Postgres database management tools like EDB Enterprise Manager (PEM), EDB’s Backup and Recovery Tool (BART).
- Proficient with database tuning and use of Postgres tools such as PgBadger, EDB PgStatsPack, EDB DRITA.
- Proficient with PostgreSQL replication technologies Binary Streaming Replication, EDB xDB Replication, Logical Replication via Slony, Londiste.
- Proficient with PostgreSQL networking, HBA and connection pooling (PgBouncer, PgPool).
- Working knowledge of OLTP/DSS/DW system design.
- Automate routine tasks with scripts, optimize databases for needs of applications, improve database backups, and test recoverability.
- Solve production problems and participate in extended/outside core work hours as needed.
- · Strong SQL Developer skills and experience developing SQL and PL/SQL (triggers, procedures, functions, views, etc.)
- · Experience writing and tuning SQL queries to maximize performance in large data volume environments, and extracting and transforming data from databases to generate reports and/or data exports.
- · Ability to approach problems proactively, a self-starter, well organized and exhibit attention to detail.
- · Strong verbal and written communication skills
Education: Bachelor’s degree or equivalent 10 years of IT experience, in information systems engineering, or computer science.
Certifications: Security+CE and Computing Environment certification such as EDB PostgreSQL Advanced Server Professional (preferred) or SQL/Oracle Database Administration, or Linux Red Hat.
All candidates selected will be subject to a background security investigation and must meet all eligibility requirements for access to classified information.