- 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
PostgreSQL Database Administrator with Security Clearance - Suffolk, VA, United States - PROSOFT, HQ
Description
PostgreSQL Database Administrator Location:
VA-
Suffolk Company Order Number: 2614 # of openings: 1
Description Position:
PostgreSQL Database Administrator Location:
Suffolk, VA 23432
Clearance:
Secret, TS eligible
Req:
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.
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.