> Markdown version of [/jobs/ext/2591189-postgresql-database-administrator](https://www.wearedevelopers.com/jobs/ext/2591189-postgresql-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# PostgreSQL Database Administrator

- **Company:** Peaklnk Technologies, Inc.
- **Location:** Irvine, CA, United States
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, Amazon S3, Databases, Data Infrastructure, Disaster Recovery, Document-Oriented Databases, Identity and Access Management, PostgreSQL, Oracle (Applications), Pascal (Programming Language), Performance Tuning, Query Optimization, SQL Stored Procedures, SQL Databases, Data Streaming, Backup and Restore, System Availability, Database Performance, Indexer, Database Migration, Cloudwatch, Database Tools and Utilities
- **Published:** August 31, 2026
- **Apply:** https://www.dice.com/job-detail/a89625eb-8305-4922-a30f-b7fa86961c2e

## About the Role

We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) with strong expertise in AWS. The candidate will be responsible for the day-to-day management of PostgreSQL databases and will lead efforts to migrate and optimize our database infrastructure in the AWS cloud. This role requires deep knowledge of PostgreSQL database administration and AWS services, particularly related to database migration, performance tuning, and high availability.

## Description

Lead and execute migration of on-prem (SQL/Oracle) databases to AWS Cloud Environment (PostgreSQL).
Remediate code hands-on from SQL/Oracle to PostgreSQL including all schema components including stored procedures, triggers, functions. Experienced in finding and fixing naming conventions (Snake case vs Pascal case vs others). Code remediation not just to correct technically but able to engage with application teams to fix code functionally.
Install, configure, and manage PostgreSQL databases across various versions.
Optimize database performance and ensure high availability and scalability.
Design and implement backup and recovery strategies using native database tools and AWS services.
Manage PostgreSQL replication (streaming replication, logical replication) and high availability setups.
Implement and maintain PostgreSQL security policies, roles, and privileges.
Monitor database health and performance using tools like pgAdmin, AWS CloudWatch, and other monitoring solutions.
Perform regular database maintenance tasks including vacuuming, indexing, and query optimization.
Configure and manage PostgreSQL on AWS
Utilize AWS services such as S3, IAM, CloudWatch, and DMS for database operations and migration.
Design and implement disaster recovery strategies, including Multi-AZ deployments and failover configurations.
Collaborate with development and infrastructure teams to support application requirements.
Document database environments, configurations, and procedures.

Certifications (Preferred but not mandatory)
PostgreSQL Certified Professional (or equivalent)
AWS Certified Solutions Architect - Associate/Professional


## Related Videos

- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Postgres in the Age of AI (and Devin)](https://www.wearedevelopers.com/videos/1042-postgres-in-the-age-of-ai-and-devin)
- [Hate organising your photos? Try it with 5 Terabytes](https://www.wearedevelopers.com/videos/79-hate-organising-your-photos-try-it-with-5-terabytes)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [20 Essential Tools For Backend Development](https://www.wearedevelopers.com/magazine/218-20-essential-tools-for-backend-development)
- [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers)