Job Title: AWS PostgreSQL Developer
Location: San Diego CA, Charlotte NC, Florham Park NJ (2-3 Days Onsite)
Fulltime:
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
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.
Preferred Qualifications:
- Experience with Liquibase
- Experience in Python
- Experience with replication and load balancing for PostgreSQL.
Familiarity with database migration tools and techniques
