Job
Description
Key Purpose of this Role: BiofuelCircles 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 To Apply: https://app.dover.com/apply/BiofuelCircle/0bcfe83e-40b6-4549-85a0-b41d26ebb945?rs=56176124
