Postgres SQL Admin

Detailed JD (Roles and Responsibilities)

• 7 years of experience in DBA tasks like DB backup (physical and logical), DB restore, Users Access control, Postgres upgrade major and minor, DB performance tuning

• Experience in Data Migration Activity.

• Experience in Performance monitoring, User roles and permissions

• Extensive knowledge in SQL Writing.

• Experience in AppDynamics tools

• Very good Analytical skills.

Mandatory skills

• Very good knowledge and hands-on experience in Postgres replication setup

• Very good knowledge and hands-on experience in Postgres architecture

• Good understanding of wal file setup and archive file setup in Postgres

• Good knowledge of table partitioning