Role Description:

We are looking for a skilled PostgreSQL Database Developer to join our team for a high-impact project. The ideal candidate should have worked in AWS for at least 5 years and hold extensive experience in designing and developing database applications, with a strong background in both serverless and managed instances of PostgreSQL. This role requires expertise in AWS Aurora PostgreSQL, including proficiency with DDL, DML, SQL, and a strong focus on performance tuning for mission-critical applications.

Must Have:

• Experience with Liquibase
• Experience in Python
• Experience with replication and load balancing for PostgreSQL
• Familiarity with database migration tools and techniques.

Key Responsibilities:

• Design, develop, and optimize PostgreSQL database applications.
• Work with AWS Aurora PostgreSQL (both serverless and managed instances) to ensure high availability
• and scalability.
• Create and manage database schemas, DDL, and DML operations. Strong SQL knowledge.
• Perform performance tuning and optimization of database systems to support mission-critical
• workloads.
• Manage PostgreSQL databases through multiple product lifecycle environments, from development to
• mission-critical production systems.
• Perform regular system monitoring, verifying the integrity and availability of all hardware, database
• server resources, systems, and key processes.
• Apply experience with Liquibase to operationalize database changes, ensuring smooth version control
• and deployment of database updates.
• Leverage knowledge of advanced data structures like JSON to enable smooth and efficient egress
• processing, ensuring data integrity and performance.
• Collaborate with application developers to create optimized queries and schemas to meet the project needs.

Required Skills and Experience:

• 5+ years of experience working in AWS cloud and PostgreSQL database.
• Proven experience with PostgreSQL development, including performance tuning.
• Hands-on experience with AWS Aurora PostgreSQL, including serverless architecture.
• Strong knowledge of database design, DDL, DML and SQL.
• Ability to troubleshoot and resolve complex database performance issues
• Expertise in performance tuning and query optimization. Strong problem-solving skills, a proactive attitude, and the ability to work in a fast-paced environment.