Should have good hands-on experience in SQL, My Sql and Cube Data Database: PostgreSQL 8.2
Good understanding and hands-on experience in Metadata Database: Derby 10.14.2.0
Creating and maintaining database standards and database scripting
Supporting database design, creation and testing activities
Managing the database availability and performance, including incident and problem management
Install, monitor and maintain PostgreSQL and implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning and assist in business process integration with various data sources.
should be able to handle Infrastructure issues (storage , IO , clustering etc)
Must have a deeper understanding of the PostgreSQL architecture and internals.
Should have an understanding of the limitations and the work arounds for managing PostgreSQL deployed on DBaaS platforms.
Designing database backup, archiving, and storage strategy
Create accounts for all users and assign security levels