PostgreSQL DBA

This is a remote position.

• This is a 100% Remote Position.
  
• Candidate should willing to work in the PST time zone
  

• Installation and set
  
• Migration exp from Oracle to PostgreSQL with tools like ora2pg
  
• 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.
  
• 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.
  
• Taplespace management
  
  
  
  

Requirements

• Bachelors degree or Higher education
  
• Migration experience from Oracle to PostgreSQL with tools like ora2pg
  
• 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 pgctl and psql
  
• Proficiency in managing databases using DBMS tools like Backup/Restore Performance Tuning Security Management etc.