Senior Associate Database Administrator PostgreSQL DBA
Share
Job Location:
Monthly Salary:
Posted on:
14 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Senior Associate Database Administrator - PostgreSQL DBA
Education: Any Graduate
Experience: 6years
Location: Bengaluru Hyderabad Mumbai.
Key Skills: PostgreSQL Open Source and EDB PostgreSQL. AWS Microsoft Azure and GCP - PgAdmin Pgbouncer BARMAN pgbackrest repmgr Patroni and pgrepack.
Job Description:
6 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.
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 on Aurora PostgreSQL
Configured Query Store and Analytics workspace on MS Azure Cloud.
Required Experience:
Senior IC
Key Skills
- Databases
- SQL
- High Availability
- PL/SQL
- Solaris
- Microsoft SQL Server
- Database Design
- Performance Tuning
- MySQL
- Shell Scripting
- Database Administration
- Oracle
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
