Description

You will manage and optimize PostgreSQL database systems to ensure efficiency, security, and reliability.

Responsibilities

• Install, configure, and maintain PostgreSQL database systems, including regular maintenance, updates, and patches.
• Monitor database performance, optimize query plans, and manage indexing to improve efficiency.
• Implement and manage database backup, recovery, and disaster recovery plans.
• Collaborate with developers to design and optimize database schemas and provide best practice guidance.
• Manage database storage, capacity planning, and security compliance.

Required Skills

• 6 to 8.5 years of experience as a PostgreSQL Database Administrator.
• Proficiency in writing query plans, creating indexes, and executing SQL commands.
• Hands-on experience with database replication and PostgreSQL commands.
• Ability to write scripts for database upgrades using Python and Bash.
• Experience managing backup, recovery, and disaster recovery processes.
• Strong knowledge of database design and performance tuning.
• Experience with AWS RDS or Azure Database for PostgreSQL.
• Bachelor's degree in a relevant field.

Preferred Skills

• Experience automating routine database tasks.

Key Skills

Education

Bachelor's degree