Description

  • 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
  • Performance tuning
  • Give best practice guidance to the development team
  • Resolve any production data issues
  • Taplespace 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.
  • Senior position with 5+ years of Experience supporting Postgres in an enterprise environment.
  • We need the person to be an infrastructure DBA not a developer.
    Infrastructure DBA’s maintain the system, help optimize, ensure backups, DR processes, etc. They do not write any code like a developer.
  • Supporting Postgres in an large scale environment 10+TB databases.
  • Knowledge of management tools necessary to support and monitor the environment.
  • Knowledge of how Postgres operates on Red Hat Linux to most effectively configure the system for performance
  • All should be 5+ years experience
  • Knowledge of other database technologies would be a huge plus (MSSQL and MySQL).

 


 

Key Skills
Education

Any Gradute