Technical Specialist
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.