Postgres Database Administrator

As a Database Administrator, you will be responsible for installing, configuring, and maintaining PostgreSQL database systems in various environments like development, testing, and production. Your primary tasks will include monitoring database performance, troubleshooting issues, and implementing optimizations to improve performance and scalability. Ensuring data integrity, availability, and security is a key aspect of your role. This involves conducting regular backups, setting up replication, and planning for disaster recovery. You will also be involved in developing and implementing strategies for database partitioning, indexing, and performance tuning. Creating and updating database documentation is crucial, including design specifications, data dictionaries, and operational procedures. Collaboration with application developers to optimize database schemas and queries will be necessary to enhance overall system efficiency. Managing user access controls, roles, and permissions is essential for maintaining data security and compliance. You will also be responsible for overseeing database migrations, upgrades, and patches to minimize downtime and disruption to operations. Providing support for troubleshooting and resolving database-related incidents and service requests is part of your daily responsibilities. Staying informed about PostgreSQL best practices, features, and tools, and evaluating their relevance to the organization, is also essential. Participation in an on-call rotation to address high-impact database incidents is required to ensure continuous database availability. Your dedication to maintaining a high level of database performance and security will be critical to the success of the organization.,