• Design, write, and optimize PostgreSQL queries including:
• Stored functions
• Triggers
• Views
• Complex joins and window functions
• High-performance queries
• Optimize PostgreSQL performance through:
• Index tuning
• Query plan analysis
• Partitioning (when needed)
• Build backend services using C# .NET and Python, integrating with PostgreSQL.
• Develop and maintain GraphQL APIs using Hasura connected to PostgreSQL.
• Apply strong transaction handling, error control, and concurrency management.
• Build both REST and GraphQL endpoints with proper validations and structured responses.
• Maintain database schemas, table designs, and relational structures.
• Troubleshoot issues related to:
• PostgreSQL performance
• Hasura metadata or GraphQL behavior
• Backend API logic
• Write unit tests, integration tests, and database tests.
• Document SQL routines, backend logic, and GraphQL schema structures.
  
  

Hitachi Energy is a global technology leader in electrification, powering a sustainable energy future through innovative power grid technologies with digital at the core. Over three billion people depend on our technologies to power their daily lives.

With over a century in pioneering mission-critical technologies like high-voltage, transformers, automation, and power electronics, we are addressing the most urgent energy challenge of our time – balancing soaring electricity demand, while decarbonizing the power system.

Headquartered in Switzerland, we employ over 50,000 people in 60 countries and generate revenues of around $16 billion USD. We welcome you to apply today.