We are hiring for a
Senior PostgreSQL Database Administrator opportunity.
Role: Senior PostgreSQL Database Administrator
Location: Remote
Position: 1
Work Arrangement: Remote
Role OverviewWe are seeking an experienced Senior PostgreSQL Database Administrator with 5 to 7 years of hands on PostgreSQL database administration experience, including managing PostgreSQL databases on AWS RDS.
The ideal candidate will have strong expertise in database administration, high availability, replication, backup and recovery, migrations, performance tuning, security, and production troubleshooting. This role will also involve automating DBA operations, supporting disaster recovery, and collaborating with application, infrastructure, DevOps, security, and data engineering teams.
Required Skills- 5 to 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.
- Hands on experience with backup, restore, point in time recovery, and disaster recovery testing.
- Experience with Change Data Capture (CDC) and logical replication.
- Experience with database migrations and version upgrades.
- Strong knowledge of performance tuning and query optimization.
- Experience implementing database security and access controls.
- Experience responding to production incidents and managing problems.
- Strong shell scripting skills.
- 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.
Key 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 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.
Education RequirementBachelor's degree in Computer Science, Information Technology, Engineering, Business Administration, or a related field is preferred.
Our Perks and BenefitsOur 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
