Database Developer

Design, build, and tune the databases behind Healthennia and Pharmennia. You'll model clinical and pharmacy data, write and optimise the queries and procedures our platforms depend on, and keep performance steady as hospitals grow their data, on systems where accuracy and uptime are not negotiable. Healthennia and Pharmennia hold the data hospitals and pharmacies run on: patients, prescriptions, inventory, billing. As Database Developer you'll own how that data is structured, queried, and kept fast: designing schemas, writing procedures, tuning slow queries, and building the migrations that bring new hospitals onto the platform. What you'll do: Design and evolve relational schemas for clinical, pharmacy, inventory and billing data; Write and optimise stored procedures, functions, views and complex queries in SQL Server; Diagnose and fix slow queries through indexing, execution plans, and query rewriting; Build data migrations that move hospitals from legacy systems onto our platforms without data loss; Support reporting and analytics workloads: aggregations, scheduled jobs, and the data behind dashboards; Work with backend developers on the data layer of new features; Protect patient data with access control, encryption at rest, and audit trails in line with India's DPDP Act; Maintain data integrity, backups, and recovery procedures; Work AI-assisted: we use tools like Claude Code as part of our daily engineering workflow, and you'll use them to move faster while owning the correctness of everything you ship What we're looking for: 2–5 years working with relational databases in production; Strong SQL: joins, window functions, CTEs, stored procedures, and query optimisation; Hands-on with SQL Server, or a comparable database such as PostgreSQL, MySQL or Oracle, including indexing and execution plans; Experience designing schemas that stayed workable as data and requirements grew; Experience writing data migrations and handling large data volumes safely; Understanding of transactions, locking, and concurrency; Comfort with Git and modern development workflows; Bonus: healthcare data exposure (HL7/FHIR, clinical or pharmacy systems); Bonus: NoSQL experience (MongoDB, Redis), reporting tools, or cloud-managed databases such as Azure SQL; Bonus: experience with AI-assisted development tools, or genuine enthusiasm to learn that way of working