Consultant - PostgreSQL Developer

<div><b>Job Description:</b></div><div>

• Work with the API integration team to implement business specific views to accommodate simple to complex logic, including implementation of functions.</div><div>
• Work with team to analyze and optimize data API pipelines using GCP logs and dynatrace. </div><div>
• Work closely with the leads to design optimal query solutions to provide a robust platform for GQL to intelligently pick the data from PG and expose it to front-end for API portal usecase.</div><div>
• Develop stored procedures, functions, and triggers to support application logic</div><div>
• Collaborate with data analysts and business stakeholders to understand data requirements and provide efficient data access solutions</div><div>
• Work with GCP services such as Cloud SQL (PostgreSQL), BigQuery, Cloud Storage, and other relevant data services.</div><div>
• Monitor database and application logs to identify and troubleshoot issues, performance anomalies, and security events.</div><div>
• Design and implement GraphQL APIs to provide efficient and flexible data access for front-end applications and other services.</div><div>
• Research, evaluate, and recommend AI/ML tools and technologies that can enhance data processing, analysis, or application functionality</div><div>
• Collaborate effectively with cross-functional teams, including developers, product managers, and operations.</div><div>
• Contribute to documentation, best practices, and knowledge sharing within the team</div><div>
• Work closely with front-end developers to define API requirements and contracts</div><div>
• Design, develop, and maintain robust and scalable PostgreSQL database schemas</div><div>
• Perform routine database maintenance, including backups, restores, and performance tuning</div><div><br /></div><div><b>Experience:</b></div><div>1-2 years in PostgreSQL, full database lifecycle.</div><div><br /></div><div><b>Technical Skills:</b></div><div>
• Postgresql</div><div>
• SQL knowledge.</div><div>
• Query optimization</div><div>
• Git</div><div>
• GCP </div><div>
• log analysis</div><div>
• GraphQL APIs</div><div>
• AI tool adoption</div>