Apply for Postgres Admin Job

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.