Job description
1. To perform the capacity planning, required to create and maintain the Postgres Databases.
2. To work closely with System Administration and Network Administration.
3. To install new versions of Postgres Database and its tool and any other tools that access the Database(s).
4. To implement and enforce Security for Postgres Databases and maintain database(s) constraints to ensure integrity of the database(s).
5. To create and maintain Postgres Databases, required for Development, Testing, Education and Production Usage.
6. To control the Migration of Programs, Database Changes, Reference Data Changes and Menu Changes through the Development Life Cycle.
7. To perform Postgres Database Re-Organization as required to assist performance and ensure Maximum Uptime of the Database(s).
8. To plan and Implement Backup and Recovery of the Postgres Database along with HA configuration and maintenance.
9. To put standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
10. S/He will perform reviews on Design and Code frequently to ensure the site standards are being adhered to.
11. To assist with Impact Analysis of any changes to the Database Objects.
12. To be logically responsible for Logical and Physical Database Design and Modeling.
Candidate Profile
1. Candidate should have very good technical skill in Postgres Database Administration
2. Candidate should be able to work in team & manage team members, if required
3. Communication skill should be excellent
4. Candidate should be smart & personality should be very good