Postgresql Database Administrator

Skill - PostgreSQL DBA

Location -Pune /Hyderabad

Description
• Relevant more than 5 - 15 plus Years of experience handling Postgres Database (On-Prem and Cloud). Knowledge of Cassandra, Redis and Oracle is added advantage. • Ability to work on database setup of public cloud (like AWS and Azure). • Responsible for installation, configuration, applying patching, DB upgrades, object creations and administration of Postgres databases. • Implement proactive monitoring and observability dashboards of all databases to predict and diagnose the majority of problems before they impact application performance or user experience. Create dashboard and configure alerts on Splunk, Dynatrace, and PEM. • Configure and manage Postgres Installation, replication, upgrades, applying minor patching activities. • Good problem solving and troubleshooting skills. • Manage user access and security: Set up user accounts and ensure database security protocols are followed. • Backup and recovery: Implement backup and recovery plans to protect data against loss. • Undertake periodic upgrades of database schema and perform testing and verification of released database schema upgrades. • Support the installation and configuration of Databases for high availability. • Work on maintaining database security (roles, privileges, authentication) • Work with auditors (ISA and QSA) to support internal and external audits (like PCI). • Create and maintain documentation, procedures and best practice guides for database deployment and maintenance • Uses strong writing and verbal communication skills to build awareness and to proactively promote DBAs position in support of sound database structures, data governance and other