Talent Group
Location
Winchester, VA | United States
Job description
We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. The ideal candidate should have a minimum of 8 years of DBA working experience with PostgreSQL 9.6+ version, coupled with a solid understanding of Oracle Database and Microsoft SQL Server.
Responsibilities:
Operating System Management: Proficient in managing PostgreSQL on various operating systems, including Microsoft Windows, Linux (RHEL), and Kubernetes in the OpenShift platform.
Cluster Management: Experienced in setting up PostgreSQL clusters and supporting databases in on-prem and hybrid cloud environments, particularly with AWS RDS instances.
Scripting Skills: Strong proficiency in UNIX/Linux Shell Scripting for automation and task optimization.
Security Implementation: Experience in implementing Postgres STIG, conducting testing, and addressing vulnerability remediation.
Connection Pooling: Working knowledge of connection poolers such as pgPool and pgBouncer.
Installation and Monitoring: Install, monitor, and maintain PostgreSQL software, implementing effective monitoring and alerting systems.
High Availability Architecture: Build high-scalable clusters, implement failover and hot standby solutions based on Maximum Available Architecture.
Enterprise Failover Management: Experience in architecting, configuring, and setting up Enterprise Failover Manager or similar technologies for High Availability solutions.
Performance Tuning: Lead efforts related to system and SQL performance tuning, and assist in business process integration with various data sources.
Collaboration: Work closely with development and infrastructure teams for database design, changes, and enhancements to both new and existing applications.
Disaster Recovery Solutions: Proven ability to provide High Availability and Disaster Recovery solutions.
Documentation: Maintain operational documentation, including procedures, task lists, and architecture blueprints.
Troubleshooting: Possess strong troubleshooting skills to address issues promptly and efficiently.
Adaptability: Ability to maintain a positive attitude while working under high demands and short deadlines, occasionally requiring after-hours work.
Communication: Excellent communication and interpersonal skills to effectively collaborate with team members and stakeholders.
Job tags
Salary