Source description
About the role
Job Description: Design, write, and optimize PostgreSQL queries including:Stored functionsTriggersViewsComplex joins and window functionsHigh-performance queries Optimize PostgreSQL performance through:Index tuningQuery plan analysisPartitioning (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 performanceHasura metadata or GraphQL behaviorBackend API logicWrite unit tests, integration tests, and database tests.Document SQL routines, backend logic, and GraphQL schema structures. Qualified individuals with a disability may request a reasonable accommodation if you are unable or limited in your ability to use or access the Hitachi Energy career site as a result of your disability. You may request reasonable accommodations by completing a general inquiry form on our website. Please include your contact information and specific details about your required accommodation to support you during the job application process. This is solely for job seekers with disabilities requiring accessibility assistance or an accommodation in the job application process. Messages left for other purposes will not receive a response. Job Description: Design, write, and optimize PostgreSQL queries including:Stored functionsTriggersViewsComplex joins and window functionsHigh-performance queries Optimize PostgreSQL performance through:Index tuningQuery plan analysisPartitioning (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 performanceHasura metadata or GraphQL behaviorBackend API logicWrite unit tests, integration tests, and database tests.Document SQL routines, backend logic, and GraphQL schema structures. Qualified individuals with a disability may request a reasonable accommodation if you are unable or limited in your ability to use or access the Hitachi Energy career site as a result of your disability. You may request reasonable accommodations by completing a general inquiry form on our website. Please include your contact information and specific details about your required accommodation to support you during the job application process. This is solely for job seekers with disabilities requiring accessibility assistance or an accommodation in the job application process. Messages left for other purposes will not receive a response.
More at Hitachi Careers
Related open roles
Lead Engineer React.JS Node.JS Dev IRC300897
Bangalore
Fullstack Developer React.JS and Node.js IRC300137
Bangalore
DevOps Engineer || Production Engg IRC299877
Bangalore
GCP DevOps Lead IRC299052
Hyderabad
Data and AI Architect IRC300951
Bangalore
R&D Engineer Power system application specialist - IDC
Bangalore