| PostgreSQL DBA || Remote || 6+ Months Contract at Remote, Remote, USA |
| Email: [email protected] |
| From: Divya K, Talent Groups [email protected] Reply to: [email protected] Role: PostgreSQL DBA Location: Remote Duration: 6+ Months Contract 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 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 PLSQL. Senior position with 5+ years of Experience supporting Postgres in an enterprise environment. What does the ideal candidate background look like (ex: healthcare-specific background, etc.) Healthcare experience is not a must, but a plus. The one key thing I mentioned is we need the person to be an infrastructure DBA, not a developer. Infrastructure DBAs maintain the system, help optimize, and ensure backups, DR processes, etc. They do not write any code like a developer. Of the required skills listed, which would you consider the top 3 Please list your expectations regarding years of experience for each requirement. Supporting Postgres in an large-scale environment with 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 have 5+ years of experience. What experience will set candidates apart from one another Knowledge of other database technologies would be a huge plus (MSSQL and MySQL). Regards Divya K [email protected] Keywords: |
| [email protected] View all |
| Sat Nov 18 00:54:00 UTC 2023 |