PostgreSQL Database Administrator - Remote / Telecommute
Apply NowCompany: Cynet Systems
Location: Cary, NC 27513
Description:
Job 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 pgctl 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 DBAs maintain the system, help optimize, ensure backups, DR processes, etc.
- They do not write any code like a developer.
- Supporting Postgres in a 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.
- ll should have 5+ years of experience.
- Knowledge of other database technologies would be a huge plus (MSSQL and MySQL).