PostgreSQL Database Administrator with Security Clearance
Company: PROSOFT, HQ
Location: Suffolk
Posted on: April 26, 2024
|
|
Job Description:
PostgreSQL Database Administrator Location: VA-Suffolk Company
Order Number: 2614 # of openings: 1 Description Position:
PostgreSQL Database Administrator Location: Suffolk, VA
23432Clearance: Secret, TS eligibleReq: 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.
Keywords: PROSOFT, HQ, Suffolk , PostgreSQL Database Administrator with Security Clearance, IT / Software / Systems , Suffolk, Virginia
Click
here to apply!
|