Job Descritpion of Postgres Admin
8+ Years Relevant Experience
- Create the objects in the database, such as triggers, indexes, etc.
- Monitor the performance of the database and ensure optimum performance.
- Identify potential issues in the database to solve them early.
- Maintain backups and perform disaster recovery in case a disaster destroys the database.
- Monitor security and prevent any unauthorized access to the database
- Schedule consistent maintenance on the server
- Maintain database schema
- Manage database availability
- Give best practice guidance to the development team
- Resolve any production data issues
- Table space management
- Role management
- Develop automation technologies to accelerate the process of data loading.
- Develop relational databases
- Ensure data integrity
- Manage user access and permissions by adding and removing users as required
- Maintain the database using different utilities. This includes using like pg_ctl and psql.
- Replication within PostgresSQL Nodes
- Cluster Creation & Maintenance
- Sharding of big tables
- Expert in Performance Tuning and Optimization.
- Upgrade of Progress on the Latest Version
- Hands-on Experience on High Availability and Disaster Recovery with in-depth knowledge.
Required Skills for Postgres Admin Job
Our Hiring Process
- Screening (HR Round)
- Technical Round 1
- Technical Round 2
- Final HR Round