Johnson Technology Systems, Inc. (JTSi) · 16 hours ago
EDB Postgres Database Administrator
Radford,VA, VA
Full-time
Hybrid
Senior Level
5+ years expJohnson Technology Systems, Inc. (JTSi) is a federal government consulting firm providing technical services to the Federal Government. The EDB Postgres Database Administrator will be responsible for managing and optimizing EDB Postgres databases in a hybrid work environment, focusing on best practices and vendor technologies.
Business DevelopmentConsultingEnterprise Resource Planning (ERP)Information TechnologyIT ManagementManagement ConsultingSoftware
No H1B
Security Clearance RequiredU.S. Citizen Only
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. (JTSi)
Established in 2003, JTSi is an IT & Engineering Services provider with years of documented experience in the Information Technology and Engineering services field.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase