**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.** - 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). - 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.