CIEL/SEL/23904: PostgreSQL DBA

• Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
• Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
• Establish and maintain security and integrity controls.
• Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
• Plans and configures the physical database environment. Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools and data access.
• Develops project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.
• Diagnoses, resolves and implements preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
• Recommends and oversees implementation of database level configuration changes to optimize performance. Ensures maintenance of physical integrity of all production databases.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
• Should be aware and has experience PG tools
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.
• Good to have experience working in Public and Private Cloud Platforms.
• Good have certification in DBA or in cloud areas
• Good in communication and independently handle the assignments