Johnson Technology Systems Inc ยท 7 hours ago
EDB Postgres Database Administrator
Johnson Technology Systems Inc is a federal government consulting firm providing technical services to various agencies. They are seeking an EDB Postgres Database Administrator who will be responsible for database administration, including installation, configuration, and troubleshooting within a fast-paced environment.
Information Technology & Services
Responsibilities
This database administrative position will challenge the candidate to expand his/her skillsets and learn new technologies in a fast-paced and friendly environment
The successful candidate remains up to date on vendor technologies and recommended best practices in a highly available, enterprise environment
The successful candidate for this position will be solid in EDB Postgres and familiar with MySQL and Oracle
This position typically works 40 hours per week with a blend of onsite and telework
Currently, onsite work is required 2 days a week and telework is 3 days a week
Qualification
Required
Five or more years of experience (including design, installation, configuration, administration, upgrades, tuning, backup and recovery, and troubleshooting) with EDB Postgres in a Unix/Oracle Enterprise Linux environment on virtual servers; similar skills are desired for MySQL and Oracle
Experience with EDB Postgres 14.19 or higher
Experience utilizing DoD and commercial certificates (rather than self-signed certificates) for logins
Experience with PEM (Postgres Enterprise Manager)
Experience using Ora2pg to migrate Oracle databases to EDB Postgres
Strong backup and recovery experience using Barman (Backup and Recovery Manager)
Strong performance tuning experience for both transactional and analytical workloads
Strong troubleshooting experience utilizing database and operating system capabilities
Strong shell scripting experience in PL/pgSQL
Strong bash shell scripting experience in Unix/Oracle Enterprise Linux
Strong system administration experience
Strong documentation skills
Strong interpersonal skills
Participation in a 24x7 on-call support rotation
EDB Postgres Administration (5+ years)- Design, installation, configuration, upgrades, tuning, backup/recovery, and troubleshooting in enterprise environments
EDB Postgres 14.19+ & PEM- Hands-on experience with Postgres Enterprise Manager and modern Postgres versions
Backup, Recovery & Performance Tuning- Barman, transactional & analytical workload optimization
Unix / Oracle Enterprise Linux & Scripting- Strong bash scripting and PL/pgSQL; system administration experience
DoD-Compliant Secure Environments- Secret clearance, CompTIA Security+, certificate-based authentication (DoD/commercial certs), and participation in 24x7 on-call
Preferred
Databases: EDB Postgres 14.19 or higher, MySQL 8 or higher, Oracle 19c or higher
EDB Postgres replication experience
Experience with Kerberos
Experience with Apache Tomcat
Shell scripting experience in MySQL, and Oracle PL/SQL
Working knowledge of DoD Security Technical Implementation Guides (STIG) and Security Requirements Guides (SRG)
Amazon RDS for PostgreSQL
Azure Database for PostgreSQL
Company
Johnson Technology Systems Inc
Driving Digital Transformation with Cutting-Edge IT & Engineering Solutions Established in 2003, JTSi (Johnson Technology Systems Inc.) is a trusted IT and Engineering Services provider with a strong track record of delivering mission-critical solutions to both the Public and Private Sectors.
Funding
Current Stage
Growth StageCompany data provided by crunchbase