• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 16th Nov 2020

Job Description: 

Need local to San Jose CA

It’s remote to start but they want someone in or near San Jose to be on site once Covid is lifted.

Technical Skills:

•             RDBMS: PostgreSQL

•             Languages: Shell scripting, PL/PGSQL

•             Operating Systems: Linux, Unix, Windows

•             Backups: Logical and Physical backups

•             High Availability: WarmStandby, Hotstandby, Streaming replication

Working experience: 

- 9-10 years EXP.

- Five plus years of working experiences on PostgreSQL

- Experience with AWS and GCP

- This is 70% application development and 30% admin work on PostgresSQL

Responsibilities:

•             Ability to proactively identify, troubleshoot, and resolve live database systems issues.

•             Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore

•             Hands-on experience in database administration, backup recovery, and troubleshooting

•             Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.

•             Monitor databases to optimize database performance and diagnose issues.

•             Work with development and operations teams to tune production queries for optimal performance.

•             Monitor and manage database indexes for optimal performance.

•             Maintain custom vacuum strategies at table and DB levels.