Remote DBA: PostgreSQL & HP Vertica - High Availability

Flexion; Madison (WI); Remote; USD 145,000 - 165,000; Full time

Benefits offered by this job

Health, dental, vision coverage

Life and disability insurance

Accrued time off

401(k) plan

Generous PTO

Referral bonuses

Wellbeing and career success

Job summary

Flexion is seeking a Database Administrator to own the database end-to-end for enterprise government systems. You will administer PostgreSQL and HP Vertica on self-managed EC2 instances, manage backups, DR, HA, and security while optimizing performance and reliability.

You will collaborate with cross-functional teams to support application data needs, troubleshoot issues, and implement robust, compliant database solutions in a remote setting.

Qualifications

• Bachelor's degree or commensurate experience.
• 5+ years of experience as a Database Administrator in enterprise environments.
• Hands-on experience administering PostgreSQL on self-managed infrastructure (not a managed service like RDS) including backup/restore, replication, performance tuning, and security hardening
• Experience administering HP Vertica including cluster management, workload management, and query optimization
• Experience running production databases directly on EC2, including OS-level patching, storage management, networking, and monitoring/alerting without managed-service automation
• Solid understanding of backup/DR strategy and high-availability/failover configuration
• Passion for learning new technologies and the ability to do so quickly
• Agile Development and Mindset
• Familiarity with SQL and database security/compliance best practices in a federal or regulated environment is a plus

Responsibilities

• Administer the databases behind an enterprise government system on multi-disciplinary teams.
• Administer PostgreSQL and HP Vertica on self-managed EC2 instances; install, configure, patch, and upgrade.
• Own backup, restore, and disaster recovery end-to-end.
• Configure and maintain high availability, replication, and failover for both databases.
• Monitor health, performance, storage, connections, and tuning.
• Manage database security: access controls, encryption, credential rotation, and federal compliance.
• Administer HP Vertica's cluster management, workload management, and query optimization.
• Collaborate with Software Engineers, DevOps, and Product Managers to support data needs.
• Tackle a wide variety of technical problems including infrastructure-level issues.

Skills

PostgreSQL

HP Vertica

EC2

Backup & DR

High availability

Security hardening

Query optimization

Agile development

Education

Bachelor's degree or commensurate experience

Tools

PostgreSQL

HP Vertica

EC2

Job description

Flexion is seeking a Database Administrator to own the database end-to-end for enterprise government systems. You will administer PostgreSQL and HP Vertica on self-managed EC2 instances, manage backups, DR, HA, and security while optimizing performance and reliability.

You will collaborate with cross-functional teams to support application data needs, troubleshoot issues, and implement robust, compliant database solutions in a remote setting.