What are the responsibilities and job description for the Senior PostgreSQL Developer (W2/ Need Locals only) position at iPivot, LLC?
Job Details
Role: Senior PostgreSQL Developer
Location: Princeton, NJ (Hybrid 3 Days)
Duration: Contract (5 Years)
Responsibilities:
We are looking for a seasoned PL/pgSQL Developer with extensive experience in PostgreSQL to join our team and take a leading role in the design, development, and optimization of our database systems. The ideal candidate will have extensive experience with relational databases, strong skills in writing complex queries, and a proven track record in database schema design and performance tuning.
Key Responsibilities:
- Design and develop robust PL/pgSQL, procedures, functions, and triggers to meet business requirements.
- Design and optimize PostgreSQL databases to ensure high performance and scalability.
- Collaborate with application developers to integrate databases with backend systems.
- Perform data analysis and generate complex queries to meet business needs.
- Implement and maintain data integrity, security, and performance optimization.
- Troubleshoot database issues and ensure minimal downtime.
- Create and maintain database documentation, including ER diagrams and schema designs.
- Stay updated with PostgreSQL advancements and suggest improvements to the database ecosystem.
Required Experience:
- 3 years of experience working with PostgreSQL and PL/pgSQL development or similar RDBMS products
- Strong understanding of relational database design and normalization.
- Proficiency in writing complex SQL queries, CTEs, and advanced indexing strategies.
- Experience in performance tuning, including optimization of complex queries and database servers.
- Knowledge of data backup, recovery, security, integrity, and SQL.
- Familiarity with AWS technologies and their application in database solutions is highly desirable.
- Experience in Liquibase or flyway is a plus
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
