Database Developer

Job Title : Database Developer

Shift Timing : 01:00 PM to 10:00 PM IST

Exp Range : 4 to 6 Yrs

Role Summary:

We are looking for a Database Developer to support and enhance database systems used in Battery Energy Storage System (BESS) projects. The role involves working closely with SCADA/HMI applications, Fleet Management (FM) systems, and live production environments where data accuracy, performance, and stability are critical. The Database Developer will be responsible for designing, optimizing, and safely implementing database changes that support real-time energy operations, analytics, and reporting across multiple live sites. Given the nature of the system, this role requires strong analytical skills, disciplined change management, and a high level of ownership.

• The Database Developer will work on production-grade enterprise systems where data accuracy, performance, and stability are critical to business operations.

• The role involves managing and optimizing databases that support real-time and near– real-time applications, analytics, and reporting across multiple environments.

• This position requires a high level of ownership and accountability, as database changes can have direct impact on live systems and dependent applications.

• The individual will collaborate closely with application developers, platform teams, and support teams to design and implement efficient, reliable data solutions.

• The role demands strong analytical and problem-solving skills, with an emphasis on understanding system dependencies and performing impact analysis before changes.

• The Database Developer will contribute to improving database performance, scalability, and long-term maintainability in a complex and evolving application landscape.

• The position supports both project-driven enhancements and operational support, including investigation of data-related issues in production environments.

Responsibilities:

• Design, develop, and maintain PostgreSQL and MySQL databases, including schemas, tables, indexes, and partitions.

• Build efficient stored procedures, functions, triggers, and views using PL/pgSQL and SQL.

• Optimize complex queries to ensure high performance, scalability, and reliability of database operations.

• Implement core PostgreSQL maintenance strategies such as MVCC, VACUUM, ANALYZE, autovacuum tuning, and advanced indexing techniques.