Technical Specialist PostgreSQL DBA
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Description
Job Title: Technical Specialist
Education: MCA/B.E/ Graduation
Experience: 8years
Location: Bangalore/Mumbai/Hyderabad
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 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:
IC
Key Skills
- Dhcp
- SQL
- Active Directory
- VOIP
- VMware
- Customer Service
- Windows
- Trouble Shooting
- Java
- VPN
- Sharepiont
- hardware
- Dns
- Technical Support
- Software Applications
About Company
Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leadi ... View more
