Senior Associate Database Administrator

Datavail

5 - 10 years

7 - 12 Lacs

Hyderabad

Posted:4 days ago| Platform:

Apply

Skills Required

GCP Postgresql Associate Database Administrator Cloud Oracle Open source Load balancing Analytics RPM Database handling

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Title: Senior Associate Database Administrator

Education: MCA/B.E/B.Tech/B.Sc/Any Graduation

Experience: 5+years

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 pg_repack

5+ 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 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 DBs 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.
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.

More Jobs at Datavail

Senior Mobile App Developer - Contractor

Kolkata, Mumbai, New Delhi, Hyderabad, Pune, Chennai, Bengaluru

3 - 7 yrs

INR 5 - 9 Lacs

Principal Consultant

Hyderabad

10 - 15 yrs

INR 20 - 25 Lacs

Technical Specialist

Bengaluru

8.0 - 13.0 yrs

INR 22 - 27 Lacs

Associate System Administrator

Mumbai

5.0 - 10.0 yrs

INR 7 - 8 Lacs

Principal Consultant

Hyderābād

Experience: Not specified

INR 6 - 9 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.