PostgreSQL Database Administrator

Dear Candidate,

Greetings!!

" PostgreSQL DBA "

• Role:

  PostgreSQL DBA

• Location:

  Navi Mumbai, Airoli

• Mode:

  Work from office

• Payroll:

  Intellioz

• Client:

  MNC

Job Summary:

PostgreSQL Database Administrator

Key Skills & Responsibility:

• Good hands-on experience on PostgreSQL DBA. Good to have experience on YugabyteDB.
• Create the objects in the database, such as triggers, indexes etc.
• Able to set up streaming replication between two databases
• Monitor performance of the database and ensure optimum performance.
• Identify potential issues in the database to solve them early.
• Maintain backups and should be able to restore the database
• Monitor security and apply preventive measure to adhere security guidelines
• 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
• Tablespace management
• Role and privilege 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.
• Should be able to write complex queries, function /function/ procedure to get the required data
• Should be able to analyse cost of the query and do necessary changes to improve performance