PostgreSQL Database Administrator L2

Hi All

Greetings from Live Connections!

PostgreSQL Database Administrator L2

Position Title: PostgreSQL Database Administrator L2 role

Experience Level: 7-15 Years

Full Time

Location

Notice: Immediate to 1 Month

Note: Kindly apply if your official notice period is 1 Month

MUST HAVE

• Create the objects in the database, such as tables , views , functions , triggers, indexes, extensions 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 high-availability
• Give best practice guidance to the development team on recurring issues
• Resolve any production data issues
• Tablespace management
• Role management
• Manage user access and permissions by adding and removing users as required
• Maintain the database using different utilities like vacuum, vacuumlo, pg_dump, pg_basebackup, pg_badger
• Replication setup and maintenance , exposure to physical and logical replication , repmgr,patroni
• Should have handled database installations, patch upgrade , upgrade from lower to higher version, migration from Sybase, Oracle, MSSQL to PostgreSQL using the migration tools like syb2pg , ora2pg
• Good knowledge on Linux operating system and administrative commands

Regards,

Sharmila

sharmila@liveconnections.in