**Job Title: Technical Specialist** **Experience: 7\+years** **Location: Remote in Colombia** **Key Skills: PostgreSQL Open Source and EDB PostgreSQL, AWS, Microsoft Azure and GCP \- PostgreSQL, Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg\_repack.** **Job Description:** * 7\+ years of relevant PostgreSQL DBA Experience. * Good knowledge of PostgreSQL Database Architecture. * Installing, configuring PostgreSQL using source code, RPM, one\-click installation on\-prem and Cloud Technologies. * Strong experience in handling Database Logical and Physical Backups. * Hands on experience on restoration techniques on PostgreSQL like pg\_restore and Point in time recovery (PITR). * Expertise in Applying database patches from lower version to higher version. * Major and Minor upgrade of PostgreSQL DB's on multiple platforms (pg\_dump/pg\_restore \& pg\_upgrade). * Implemented PostgreSQL DR servers and PostgreSQL load balancing using pgpool. * Expertise in Streaming Replication (Including Cascading Replication). * Configuring pgbouncer for connection pooling. * Configuring pgbadger for generating statistic report on the basis PostgreSQL log file. * Handling Database corruption issues. * Have done Oracle to PostgreSQL Migration for multiple clients. * Strong knowledge on PostgreSQL configuration parameter for tuning the DB health. * Managed Users and Tablespace on PostgreSQL Servers. * Configuring Heterogeneous DB connections between Oracle, PostgreSQL. * Expertise in Shell scripts for performing Online Backup and maintenance activity. * Strong experience in setting up RDS \& Aurora Cluster. * Strong experience in Query Tuning and performance improvement. * Tuning parameter group and configuring Aurora cluster for Read Replica. * Configuring RDS \& Aurora PostgreSQL Logs to push to S3 Bucket. * Experience on Reviewing performance Metrics and query tuning on Aurora PostgreSQL. * Configured Query Store and Analytics workspace on MS Azure Cloud.