HiringCafe
Save Job
Posted 1y ago

Database Developer

@ BiofuelCircle
View All Jobs
Pune, Maharashtra, India
OnsiteFull Time
Responsibilities:writing queries, optimizing queries, monitoring performance
Requirements Summary:3+ years SQL development and performance tuning; MS SQL expertise; strong problem-solving; experience with ETL and data warehousing advantageous.
Technical Tools Mentioned:MS SQL, SQL Server Profiler, DMVs, Azure SQL, ETL, Data Warehousing
Save
Mark Applied
Hide Job
Report & Hide
Job Description

Key Purpose of this Role

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 day

Collaborate 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 profile

  • You 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