- 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.
