Postgresql Dba

Job Description:

• Experienced in installing PostgreSQL Database on premises and provisioning on AWS EC2, AWS RDS and AWS Aurora Serverless
• Experienced in day to day database maintenance activities on premises and on AWS EC2 and AWS Aurora Serverless
• Working experience on PG tools like psql, pg_stat, pg_dump / pg_restore, pg_repack, pg_logical, pgbadger, pg_bouncer, pgadmin, pgbasebackup
• Experienced in managing PostgreSQL databases on AWS EC2 and AWS Aurora serverless
• Experienced in setting up and managing Replications on-prem, on AWS EC2 and AWS Aurora
• Experienced in working on AWS DB Management console and Database services.
• Experienced in PostgreSQL DB migration to AWS Aurora using PostgreSQL native tools and AWS native services.
• Experienced in PostgreSQL patching / upgrade on on-prem servers and AWS Aurora Serverless