BiofuelCircle’s products and services are used by businesses and individuals in the bioenergy supply chain: from large industries to rural enterprises, to transporters, service providers and farmers.
The Database Developer will be responsible for designing, developing, managing and enhancing the database as per feature requirements, to ensure stability, reliability, and performance.
What will you do every dayCollaborate with the software development team to write, debug, optimise and fine-tune SQL queries, stored procedures (SPs), functions, and views
Analyse slow-performing queries and improve execution time using indexing, partitioning, and query refactoring
Monitor and troubleshoot deadlocks, blocking, and performance bottlenecks in the database
Implement query execution plan analysis and other such tooling to enhance database performance.
Advise the software development team to implement best practices in database design, indexing strategies, and data normalisation.
Conduct database profiling and performance audits to proactively improve system efficiency Maintain data integrity, security, and backup strategies
The ideal candidate profileYou have at least 3 years of experience in SQL development and performance tuning
You have hands-on experience in query optimisation techniques (including execution plans, indexing, caching, partitioning, etc.)
You are analytical, with demonstrable problem-solving skills, and can troubleshoot performance issues arising out of locks, deadlocks and long-running queries
You have strong knowledge of MS SQL and database management concepts
You are comfortable writing complex SQL queries, stored procedures, triggers and functions
You are familiar with SQL Server Profiler, DMVs or similar performance monitoring tools
You do not get overwhelmed by large datasets and high-traffic database environments
You can coordinate, follow up, follow through and drive matters to closure proactively
You take ownership and accountability and don't need a manager reminding of tasks or deadlines
You can work with cross functional and remote teams
Certification in or knowledge of managing cloud databases (Azure SQL) will give you an advantage over other applicants
Knowledge of ETL processes and data warehousing will also give you an advantage over other applicants
Skills Required
- At least 3 years of experience in SQL development and performance tuning
- Strong knowledge of MS SQL / SQL Server
- Hands-on experience in query optimization techniques including execution plans, indexing, caching, partitioning
- Comfortable writing complex SQL queries, stored procedures, triggers and functions
- Experience analysing slow-performing queries and improving execution times
- Familiarity with SQL Server Profiler, DMVs or similar performance monitoring tools
- Ability to troubleshoot deadlocks, blocking, and long-running query issues
- Maintain data integrity, security, and backup strategies
- Ability to work with cross-functional and remote teams
- Proactive ownership, coordination, and drive issues to closure
- Certification in or knowledge of managing cloud databases (Azure SQL)
- Knowledge of ETL processes and data warehousing
What We Do
Biofuelcircle is a digital platform for biomass and biofuel supply chains. Our web and mobile apps enhance the reach for buyers and sellers and offer unique digital tools to help create sustainable and scalable business model for bioenergy companies. Bioenergy holds big promise for economies such as India. Harnessing residual agrowaste can also help achieve energy security. Reliable supply chain holds the key to unlocking this potential. One end of this supply chain is Rural, and the other- Industrial. Bioenergy companies produce a wide variety of energy alternatives from power to blend-able liquid fuels to drop in liquid and gaseous fuels. They also produce bio fertilisers in large quantities. Biofuelcircle is using advanced digital tools to help integrate this supply chain. It is also bringing on board a broad range of services to become a true supply chain partner to bioenergy companies. The new age of enhanced economic value from biomass for the farmers, supply chain efficiency for bioenergy companies and transformative rural enterprises is now beginning with Biofuelcircle.
