We have an immediate requirement of PostgreSQL DBA. Please share the profiles matching with below JD.
Location : Austin (TX) Day 1 Onsite
Long Term contract
JD :
- 5 + years of experience in PostgreSQL.
- Hands-on experience in configuring and supporting replication using different replication tools.
- Background in building large database infrastructure supporting a high volume of transactions in a mission-critical environment.
- Hands-on experience backup, restore and PITR.
- Good experience on PostgreSQL architectures (Memory components, Different processes, And basic understanding of the working of PostgreSQL).
- Working experience on PostgreSQL Installation.
- Working Experience on Switchover/failover task depends on the scenarios.
- Scheduled maintenance activities to vacuum, analyze for improving of query response time.
- Deploying and managing PostgreSQL on AWS Cloud infrastructure including both EC2 and RDS instances.
- Maintaining different clients on AWS and monitoring them using CloudWatch.
- Working experience on upgrades (Minor and major versions).
- Troubleshooting Day-to-day operations and issues like ( CPU and Load average, locking blocking, long-running sql, and Disk-space issues ).
- Proficient with SQL,Shell or Python languages.
- Working experience in any other DBA skills like MYSQL/Singlestore will be plus.