PostgreSQL Developer

Role: PostgreSQL Developer

Industry: Wealth Management (Similar Domain experience is needed)

Location: Philadelphia, PA 19103 (Local or within drivable distance only)

Schedule: We are in the office 1x/week (Thursday).

MoI: 2 Video Rounds

Excellent Comms Needed

KEY FOCUS: MUST BE A DEVELOPER… Similar domain exp is must…. Job stability highly desirable….

Excellent

Comms is a MUST

Our client, an organization in Philadelphia, is seeking a skilled and motivated PostgreSQL Database Developer with API experience to join their dynamic team. The ideal candidate will have a strong foundation in PostgreSQL database design and development, coupled with hands-on experience working with APIs. You will play a key role in the design, implementation, and optimization of database systems, while also contributing to the integration of these systems with APIs to support seamless communication across platforms.

Key Responsibilities

Database Development:

• Design, develop, and optimize relational database schemas, tables, indexes, and queries using PostgreSQL.
• Write efficient SQL queries and stored procedures to meet application requirements.
• Perform database tuning and optimization to ensure high performance and scalability.
• API Development & Integration:
• Develop, maintain, and enhance RESTful APIs to interface with PostgreSQL databases.
• Work with backend developers to integrate APIs with external systems and services.
• Ensure smooth and efficient data flow between the database and the API layer.
• Collaboration & Support:
• Collaborate with cross-functional teams to gather requirements and deliver robust database solutions.
• Provide support for database-related issues, including troubleshooting performance bottlenecks and resolving data integrity issues.
• Set up regular database backups and recovery processes.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Proven experience as a PostgreSQL Database Developer.
• Strong proficiency in SQL, database design, optimization, and performance tuning.
• Solid experience developing and consuming RESTful APIs.
• Hands-on experience with API frameworks (e.g., Flask, Express, Django).
• Familiarity with tools for database migration, version control, and CI/CD pipelines.
• Strong problem-solving skills and the ability to work independently and in a team.