PostgreSQL Database Administrator

Infostretch Corp

  • Nashville, TN
  • 1 day ago
  • Remote

    Highlights

    Apexon brings together distinct core competencies in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering, and UX, along with deep expertise in BFSI, healthcare, and life sciences, helping businesses capitalize on the unlimited opportunities digital offers. 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.

    Numbers & Facts

    LocationNashville, TN (
    Remote
    )

    Description

    About Apexon:

    Apexon is a digital first technology services firm specializing in accelerating business transformation and delivering human centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.

    Apexon brings together distinct core competencies in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering, and UX, along with deep expertise in BFSI, healthcare, and life sciences, helping businesses capitalize on the unlimited opportunities digital offers.

    Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients'' toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon has a global presence across four continents.

    We enable #HumanFirstDIGITAL

    We are hiring for a PostgreSQL Database Administrator opportunity.

    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 Commitment to Diversity & Inclusion:

    Did you know that Apexon has been Certified by Great Place To Work in multiple global regions? Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other characteristic protected by law.

    Our Commitment to Environment:

    Actively contribute to Apexon''s commitment to environmental responsibility by following sustainable practices and supporting ESG initiatives.

    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

    Job Location :

    Nashville, Tennessee, United States

    Similar Jobs

    Geodis

    Sr IT Architect- Database

    • Brentwood, TN
    3 days ago
    See more jobs