The Role
Design, develop, and optimize PostgreSQL databases and backend services using PL/pgSQL, C#/.NET, and/or Python. Build GraphQL APIs with Hasura and RESTful endpoints, tune query performance, manage transactions and concurrency, write automated tests, troubleshoot complex database issues, and document technical implementations while ensuring reliability, data integrity, and compliance.
Summary Generated by Built In
Backend Developer
Experience: 4 - 7 Years
Location: Chennai
About the Job
We are looking for a Senior PostgreSQL Developer / Backend Developer with strong hands-on expertise in PostgreSQL, PL/pgSQL, C#/.NET and/or Python, GraphQL, Hasura, and REST APIs. The role will focus on designing, developing, optimizing, and maintaining scalable database solutions and backend services.
The ideal candidate should have deep expertise in PostgreSQL query development, stored procedures, functions, triggers, views, indexing, query optimization, transaction management, and database performance tuning, along with practical experience in building backend applications and developing GraphQL APIs using Hasura.
The role will contribute to backend development, database architecture, API development, performance optimization, testing, and documentation, while ensuring application reliability, data integrity, and compliance with organizational standards.
What You'll Do
- Design, develop, and optimize complex PostgreSQL queries, including stored functions, triggers, views, joins, and window functions.
- Develop and maintain PL/pgSQL stored procedures, functions, and database routines to support business requirements.
- Improve database performance through index tuning, query plan analysis, execution optimization, and table partitioning wherever required.
- Analyze and resolve database performance issues, including locking, deadlocks, and concurrency-related challenges.
- Build and maintain backend services using C#/.NET and/or Python, integrating them with PostgreSQL databases.
- Develop and maintain GraphQL APIs using Hasura on top of PostgreSQL.
- Design and implement RESTful and GraphQL endpoints with appropriate validations, error handling, and structured responses.
- Implement effective transaction management, concurrency control, isolation levels, and data integrity mechanisms.
- Write and maintain unit tests, integration tests, and database-level tests to ensure application reliability.
- Document SQL routines, backend business logic, API schemas, and technical implementation details.
- Ensure compliance with applicable internal and external regulations, procedures, and development guidelines.
- Follow organizational values of safety and integrity, taking ownership of responsibilities while maintaining a collaborative work environment.
What We Seek In You
- 4 - 7 years of experience working with relational databases, with deep hands-on expertise in PostgreSQL.
- Strong experience in PostgreSQL, PL/pgSQL, stored procedures, functions, triggers, views, joins, and window functions.
- Strong hands-on experience in query optimization, execution plan analysis, indexing strategies, and database performance tuning.
- Strong understanding of PostgreSQL locking mechanisms, deadlocks, concurrency management, and transaction isolation levels.
- 5+ years of backend application development experience using C#/.NET and/or Python.
- 2+ years of hands-on experience with GraphQL and Hasura, particularly with PostgreSQL integration.
- Strong understanding of REST API development, API design principles, backend architecture, validations, and error handling.
- Experience in designing and implementing scalable backend services integrated with relational databases.
- Hands-on experience with Git, version control, branching strategies, and standard software development workflows.
- Experience writing unit tests, integration tests, and database testing scripts.
- Strong analytical, debugging, and problem-solving skills with the ability to troubleshoot complex database and backend issues.
- Good communication, collaboration, documentation, and ownership skills.
Preferred Qualifications
- Experience working on enterprise-scale PostgreSQL database applications.
- Strong expertise in advanced PL/pgSQL programming and database-side business logic implementation.
- Experience handling high-volume databases, complex queries, and database performance bottlenecks.
- Practical experience with PostgreSQL query execution plans (EXPLAIN/EXPLAIN ANALYZE), indexing, and partitioning strategies.
- Experience developing backend microservices using C#/.NET Core or Python.
- Hands-on experience building GraphQL APIs, Hasura Actions, Events, Relationships, and Permissions.
- Experience integrating GraphQL and REST APIs with enterprise backend applications.
- Knowledge of database security, access management, and data governance practices.
- Experience working in Agile development environments and collaborating with cross-functional engineering teams.
Life At Next
At our core, we're driven by the mission of tailoring growth for our customers by enabling them to transform their aspirations into tangible outcomes. We're dedicated to empowering them to shape their futures and achieve ambitious goals. To fulfil this commitment, we foster a culture defined by agility, innovation, and an unwavering commitment to progress. Our organizational framework is both streamlined and vibrant, characterized by a hands-on leadership style that prioritizes results and fosters growth.
Perks Of Working With Us
- Clear objectives to ensure alignment with our mission, fostering your meaningful contribution.
- Abundant opportunities for engagement with customers, product managers, and leadership.
- You'll be guided by progressive paths while receiving insightful guidance from managers through ongoing feedforward sessions.
- Cultivate and leverage robust connections within diverse communities of interest. Choose your mentor to navigate your current endeavors and steer your future trajectory.
- Embrace continuous learning and upskilling opportunities through Nexversity.
- Enjoy the flexibility to explore various functions, develop new skills, and adapt to emerging technologies. Embrace a hybrid work model promoting work-life balance.
- Access comprehensive family health insurance coverage, prioritizing the well-being of your loved ones.
- Embark on accelerated career paths to actualize your professional aspirations.
Who We Are
We enable high growth enterprises build hyper personalized solutions to transform their vision into reality. With a keen eye for detail, we apply creativity, embrace new technology and harness the power of data and AI to co-create solutions tailored made to meet unique needs for our customers.
Join our passionate team and tailor your growth with us!
Skills Required
- 4–7 years of experience working with relational databases, including deep PostgreSQL expertise
- Strong experience with PostgreSQL, PL/pgSQL, stored procedures, functions, triggers, views, joins, and window functions
- Experience with query optimization, execution plan analysis, indexing strategies, and database performance tuning
- Understanding of PostgreSQL locking, deadlocks, concurrency management, and transaction isolation levels
- 5+ years of backend application development using C#/.NET and/or Python
- 2+ years of hands-on GraphQL and Hasura experience with PostgreSQL integration
- Experience developing REST APIs and understanding API design, backend architecture, validation, and error handling
- Experience designing scalable backend services integrated with relational databases
- Experience with Git, version control, branching strategies, and software development workflows
- Experience writing unit tests, integration tests, and database testing scripts
- Strong analytical, debugging, problem-solving, communication, collaboration, documentation, and ownership skills
- Experience with enterprise-scale PostgreSQL database applications
- Advanced PL/pgSQL programming and database-side business logic implementation
- Experience with high-volume databases, complex queries, and performance bottlenecks
- Experience with EXPLAIN/EXPLAIN ANALYZE, indexing, and partitioning strategies
- Experience developing backend microservices using C#/.NET Core or Python
- Experience with Hasura Actions, Events, Relationships, and Permissions
- Experience integrating GraphQL and REST APIs with enterprise backend applications
- Knowledge of database security, access management, and data governance
- Experience working in Agile development environments and with cross-functional engineering teams
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
TVS Next is a digital technology and consulting company that accelerates growth for clients through digital transformation and enterprise modernization solutions, leveraging software engineering, intelligence, and experience design.
