Description

You will manage the performance, integrity, and security of PostgreSQL databases hosted on AWS.

Responsibilities

• Design and implement PostgreSQL database solutions, focusing on schema design, indexing, and partitioning.
• Manage database instances on AWS RDS, Aurora, or EC2, including installations, upgrades, and maintenance.
• Monitor performance and execute tuning strategies, such as query optimization and indexing.
• Configure high availability and disaster recovery using streaming and logical replication.
• Automate routine tasks and infrastructure deployment using Python, Bash, or AWS CLI.

Required Skills

• 5-8 years of experience as a PostgreSQL Database Administrator.
• Hands-on experience with AWS services, specifically Aurora, RDS, and EC2.
• Deep understanding of database design principles and security best practices.
• Proficiency in scripting with Python, Bash, or PowerShell.
• Experience with database migration strategies and tools.
• Ability to perform backups, restores, and disaster recovery procedures.
• Bachelor's degree in Computer Science, Information Technology, or a related field.

Preferred Skills

• AWS Certified Database - Specialty.
• PostgreSQL Certification.

Key Skills

Education

Not specified