PostgreSQL Database Administrator
Location : Bengaluru, India
Experience : 5.1 Year
Rate: $11 / Hourly
Availability : Immediate
Work From : Offsite
Category : Information Technology & Services
Ø Specialized in PostgreSQL Database administration, design, operating systems administration.
Ø Practical knowledge and experience in all aspects of PostgreSQL database administration including Installations, Patching and Upgrading the Postgres server.
Ø Good expose on PostgreSQL architecture.
Ø Experience in replication setup with Streaming or other replication tools.
Ø Configuration of Steaming replication hot standby DB and warm standby DB.
Ø Experience in Upgrading databases. (9.6,10,11,12).
Ø Having Good Experience in Process: Incident, Changes, Service requests and severity, Escalation Matrix etc
Ø Database performance tuning, Trouble shooting database issues, Basic PSQL and PG/PLSQL knowledge.
Ø Proficient with Backup and Recovery using pg_rman, hot and cold physical backup and recovery & traditional utilities like Pg_dump,pg_dump all, pg_basebackup and pg_restore utilities.
Ø Experience on Routine Maintenance Tasks and Moving data(Copy Command).
Ø Good knowledge on cloud database monitoring( Like Backups,scale up/down and clone db).
Ø Load balancing, Connection pooling and Master/slave replication in Pgpool and pgbadger.
Ø Experience on generate log analysis report in Pgbouncer.
Ø Work closely with developer, provides PostgreSQL DBA support and technical support for multiple applications in DEV, TEST and PRODUCTION environments
Ø Participate in a 24/7 on-call rotation
§ Database : PostgreSQL 9.6/10/11/12,13 beta and.
§ Operating Systems : Red Hat Linux, Unix, Aix, SunSolaries, Windows 2000/XP
§ Languages : PSQL ,PG/PLSQL and SQL ,PL/SQL.
§ Tools / Utilities : PGadmin4 /4.6, pg_dump, Pg_restore, Edb*Loader, Explain plan, Explain analyze