Senior Postgres Database Administrator, Remote, , US

Intellibee Inc; United States; Remote; USD 110,000 - 170,000; Full time

Benefits offered by this job

Long-Term Stability

Comprehensive Health Coverage

401(k) program

Job summary

IntelliBee seeks an experienced PostgreSQL Database Administrator to oversee PostgreSQL environments across development, test, and production. You will manage AWS RDS deployments, design resilient HA/DR solutions, and ensure data integrity through backups and PITR.

The role focuses on performance tuning, security, incident response, and automation using shell, Python, and CI/CD tools. Collaboration with DevOps, security, and data teams is essential.

Qualifications

• 5–7 years of hands-on PostgreSQL database administration experience.
• Strong expertise in PostgreSQL installation, configuration, administration, monitoring, and troubleshooting.
• Practical experience managing PostgreSQL on AWS RDS.
• Experience with high availability and replication.
• Backup, restore, point-in-time recovery, and disaster recovery testing.
• CDC and logical replication.
• Database migrations and version upgrades.
• Performance tuning and query optimization.
• Database security and access controls.
• Experience responding to production incidents and managing problems.
• Experience using GitHub or GitLab for source control and collaboration.

Responsibilities

• Administer PostgreSQL databases across development, test, and production environments.
• Manage AWS RDS for PostgreSQL, including provisioning, configuration, patching, upgrades, scaling, monitoring, and maintenance.
• Design and support high-availability and disaster recovery solutions, including Multi-AZ deployments, replication, failover, and read replicas.
• Manage backup, restore, point-in-time recovery, retention, and recovery validation processes.
• Support database migrations, upgrades, consolidation, and cross-environment refreshes.
• Develop and maintain change data capture (CDC) solutions using AWS DMS, Debezium, logical replication, or equivalent technologies.
• Tune database performance through query analysis, indexing, vacuuming, statistics management, connection optimization, and configuration changes.
• Monitor database health, capacity, availability, replication lag, storage, connections, and performance.
• Troubleshoot incidents involving outages, replication, locking, deadlocks, backup failures, and performance degradation.
• Implement security controls for access, roles, privileges, encryption, auditing, and credential rotation.
• Automate DBA activities using shell scripting, Python, AWS services, and CI/CD tools.
• Maintain operational documentation, runbooks, recovery procedures, and database standards.
• Collaborate with application, infrastructure, DevOps, security, and data engineering teams.
• Participate in on-call support, incident management, root-cause analysis, and continuous improvement.

Skills

PostgreSQL DBA

AWS RDS

High availability

Backups & recovery

CDC/logical replication

Performance tuning

Security controls

Incident response

GitHub/GitLab

Tools

GitHub

GitLab

Job description

Required Skills:

• 5–7 years of hands‑on PostgreSQL database administration experience.
• Strong expertise in PostgreSQL installation, configuration, administration, monitoring, and troubleshooting.
• Practical experience managing PostgreSQL on AWS RDS.
• Proven experience with:
• High availability and replication
• Backup, restore, point‑in‑time recovery, and disaster recovery testing
• CDC and logical replication
• Database migrations and version upgrades
• Performance tuning and query optimization
• Database security and access controls
• Experience responding to production incidents and managing problems.
• Experience using GitHub or GitLab for source control and collaboration.

Preferred Skills:

• Experience with Amazon Aurora PostgreSQL.
• Knowledge of AWS Lambda and event‑driven automation.
• Python programming for DBA automation and operational tooling.
• Experience with Jenkins and CI/CD pipeline integration; familiarity with GitHub Actions or GitLab CI/CD.
• Experience administering or supporting Oracle databases.
• Knowledge of AWS Database Migration Service, CloudWatch, IAM, Secrets Manager, and S3.
• Familiarity with infrastructure‑as‑code tools such as Terraform or CloudFormation.
• Relevant PostgreSQL, AWS, or database certifications.

Responsibilities:

• Administer PostgreSQL databases across development, test, and production environments.
• Manage AWS RDS for PostgreSQL, including provisioning, configuration, patching, upgrades, scaling, monitoring, and maintenance.
• Design and support high‑availability and disaster recovery solutions, including Multi‑AZ deployments, replication, failover, and read replicas.
• Manage backup, restore, point‑in‑time recovery, retention, and recovery validation processes.
• Support database migrations, upgrades, consolidation, and cross‑environment refreshes.
• Develop and maintain change data capture (CDC) solutions using AWS DMS, Debezium, logical replication, or equivalent technologies.
• Tune database performance through query analysis, indexing, vacuuming, statistics management, connection optimization, and configuration changes.
• Monitor database health, capacity, availability, replication lag, storage, connections, and performance.
• Troubleshoot incidents involving outages, replication, locking, deadlocks, backup failures, and performance degradation.
• Implement security controls for access, roles, privileges, encryption, auditing, and credential rotation.
• Automate DBA activities using shell scripting, Python, AWS services, and CI/CD tools.
• Maintain operational documentation, runbooks, recovery procedures, and database standards.
• Collaborate with application, infrastructure, DevOps, security, and data engineering teams.
• Participate in on‑call support, incident management, root‑cause analysis, and continuous improvement.

Benefits at IntelliBee

• Long‑Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.