Consultant - PostgreSQL Developer

enGen Global; Hyderabad, Chennai District; On-site; INR 350,000 - 650,000; Full time

Job summary

enGen Global in Hyderabad is seeking a junior data engineer to build PostgreSQL-based data pipelines and robust GraphQL APIs. You will collaborate with API, frontend, and data teams to expose efficient data access for portal use cases.

You will optimize queries, develop procedures, and work with Cloud SQL, BigQuery, and other GCP services while contributing to documentation and best practices.

Qualifications

• 1-2 years in PostgreSQL, full database lifecycle.
• Experience designing GraphQL APIs and data access layers.
• Familiar with cloud data pipelines, logging, and performance tuning.

Responsibilities

• Work with the API integration team to implement business views and logic.
• Analyze and optimize data API pipelines using logs and traces.
• Design and implement GraphQL APIs for front-end data access.
• Develop stored procedures, functions, and triggers.
• Collaborate with data analysts and stakeholders to meet data needs.
• Work with GCP services like Cloud SQL, BigQuery, Cloud Storage.
• Monitor logs to identify issues, performance bottlenecks, and security events.
• Collaborate with cross-functional teams and contribute to docs and best practices.

Skills

PostgreSQL

SQL knowledge

Query optimization

GraphQL APIs

AI tool adoption

log analysis

Tools

Git

GCP

Job description

Job Description

• Work with the API integration team to implement business specific views to accommodate simple to complex logic, including implementation of functions.
• Work with team to analyze and optimize data API pipelines using GCP logs and dynatrace.
• 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.
• Develop stored procedures, functions, and triggers to support application logic
• Collaborate with data analysts and business stakeholders to understand data requirements and provide efficient data access solutions
• Work with GCP services such as Cloud SQL (PostgreSQL), BigQuery, Cloud Storage, and other relevant data services.
• Monitor database and application logs to identify and troubleshoot issues, performance anomalies, and security events.
• Design and implement GraphQL APIs to provide efficient and flexible data access for front-end applications and other services.
• Research, evaluate, and recommend AI/ML tools and technologies that can enhance data processing, analysis, or application functionality
• Collaborate effectively with cross-functional teams, including developers, product managers, and operations.
• Contribute to documentation, best practices, and knowledge sharing within the team
• Work closely with front-end developers to define API requirements and contracts
• Design, develop, and maintain robust and scalable PostgreSQL database schemas
• Perform routine database maintece, including backups, restores, and performance tuning

Experience

• 1-2 years in PostgreSQL, full database lifecycle.

Technical Skills

• Postgresql
• SQL knowledge.
• Query optimization
• Git
• GCP
• log analysis
• GraphQL APIs
• AI tool adoption