PostgreSQL DBA

PostgreSQL DBA Roles and Responsibilities 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. Tablespace 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, including pg_ctl and psql. Qualifications Senior position with 5+ years of experience supporting Postgres in an enterprise environment. Healthcare experience is not a must, but a plus. The ideal candidate should 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. Top Skills Required Supporting Postgres in a large scale environment (10+TB databases) - 5+ years experience. Knowledge of management tools necessary to support and monitor the environment - 5+ years experience. Knowledge of how Postgres operates on Red Hat Linux to most effectively configure the system for performance - 5+ years experience. Additional Experience Knowledge of other database technologies (MSSQL and MySQL) would be a huge plus. #J-18808-Ljbffr TechDigital Group