Technical Specialist
Technical Specialist
Posted on :
24-08-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Description
Job Title: Technical Specialist
Experience: 7years
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 pgrepack.
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 pgrestore and Point in time recovery (PITR).
- Expertise in Applying database patches from lower version to higher version.
- Major and Minor upgrade of PostgreSQL DBs on multiple platforms (pgdump/pgrestore & pgupgrade).
- 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.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
