PostgreSQL Database Administrator

Apexon

$110K — $130K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 10+ years of PostgreSQL Database Administration experience
  • Extensive AWS RDS PostgreSQL administration experience
  • Strong PostgreSQL architecture, configuration, and administration knowledge
  • 8+ years of PL/pgSQL development experience
  • Proficient in SQL and PL/pgSQL programming
  • Solid understanding of database backup, recovery, and security best practices
  • Experience with automation scripting in Shell, Bash, and Python

Responsibilities

  • Architect, design, implement, and administer PostgreSQL databases on AWS RDS
  • Manage multi AZ deployments for high availability and disaster recovery
  • Monitor and maintain PostgreSQL databases with complex schemas
  • Perform database performance tuning and capacity planning
  • Implement database security, encryption, and access control policies
  • Create automation scripts for database administration tasks
  • Collaborate with teams to optimize database performance

Benefits

  • Health Insurance with Dental & Vision
  • 401K Plan
  • Life Insurance, STD & LTD
  • Paid Vacations & Holidays
  • Continuous Skill Based Development and Career Advancement Opportunities
Full Job Description
Role: PostgreSQL Database Administrator Location: Remote Position: 1 Role Overview: We are seeking a highly experienced PostgreSQL Database Administrator with a minimum of 10 years of experience managing large scale PostgreSQL environments. The ideal candidate will have deep expertise in AWS RDS PostgreSQL, database architecture, performance tuning, PL/pgSQL development, backup and recovery, security, automation, and production support. This role requires hands on experience managing enterprise databases with complex schemas while ensuring high availability, scalability, and operational excellence. Key Responsibilities: Architect, design, implement, and administer PostgreSQL databases on AWS RDS. Configure PostgreSQL parameter groups, option groups, security groups, users, and roles. Manage multi AZ deployments for high availability and disaster recovery. Configure automated backups, snapshots, monitoring, and point in time recovery. Monitor and maintain PostgreSQL databases with thousands of tables across multiple schemas. Perform database performance tuning, optimization, troubleshooting, and capacity planning. Design database schemas, access patterns, indexing, and locking strategies. Implement database security, encryption, and access control policies. Develop and maintain backup, recovery, and operational runbooks. Create Shell, Bash, and Python scripts to automate database administration tasks. Monitor production databases, support incident management, and provide after hours on call support. Collaborate with development, infrastructure, and application teams to optimize database performance and support business requirements. Required Skills: 10+ years of PostgreSQL Database Administration experience Extensive AWS RDS PostgreSQL administration experience Strong PostgreSQL architecture, configuration, and administration knowledge 8+ years of PL/pgSQL development experience SQL and PL/pgSQL programming Database performance tuning and optimization Database backup and recovery strategies Database security best practices Database schema design and locking strategies Production monitoring and incident management Capacity planning and performance analysis Shell, Bash, and Python scripting DevOps tools including Bitbucket, Bamboo, GitHub, and Jenkins Excellent analytical, troubleshooting, communication, and collaboration skills Preferred Skills: MySQL Oracle Database Health and Human Services application experience Continuous learning mindset and knowledge of emerging database technologies Expected Deliverables: PostgreSQL Database Architecture and Administration AWS RDS Database Configuration and Management Database Performance Tuning and Optimization Backup, Recovery, and Disaster Recovery Solutions Database Security and Access Management Automation Scripts and Operational Runbooks Production Monitoring and Incident Resolution Capacity Planning and Technical Documentation Education Requirement: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field or equivalent work experience. Our Perks and Benefits: Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning experience, and provide care and support for you and your loved ones. We also offer: Health Insurance with Dental & Vision 401K Plan Life Insurance, STD & LTD Paid Vacations & Holidays Continuous Skill Based Development and Career Advancement Opportunities

Similar Jobs

More Jobs at Apexon

  • Quality Assurance Engineer
    $80K — $95K *
    Lake Mary, FL 32746 (Seminole County)
    Technical Services
    In-Person
  • SysAdmin/DevOps
    $95K — $115K *
    Nashville, TN 37211 (Davidson County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar PostgreSQL Database Administrator jobs: