Position : Senior Database Developer/Principal Engineer - MYSQL

Location : Bangalore/Mysore/Remote

We are hiring a Senior Database Programmer with deep, hands-on MySQL stored-procedure expertise to own and evolve the data-tier business logic of CX1 PIM. Today the majority of CX1 PIM's business logic - item lifecycle, subset refresh, workspace initialization, catalog computation (precompute), promotion, export, item matching and shadow-table hash-key generation - lives inside large, complex MySQL stored procedures, functions and triggers; the Java application layer is intentionally thin and mostly orchestrates database calls.

This role requires the proven ability to read, understand, debug, write and safely modify very large procedures (individual procedures range from a few hundred to several thousand lines, with heavy dynamic SQL, cursors and multi-table joins over catalogs in the millions of items).

The programmer will work closely with the Java Architect, Engineering Management and the DBA team to keep the current stored-procedure layer reliable and performant,



while incrementally carving out narrow, portable, set-based SQL helpers that support the platform's modernization roadmap.

Key Responsibilities

Read, understand and document complex existing stored procedures, functions and triggers - including multi-thousand-line, dynamic-SQL procedures such as subset precompute, merge, refresh and promotion.
Write, modify and optimize stored procedures, functions and triggers to deliver new features and defect fixes with minimal regression risk.
Diagnose and resolve production issues in the stored-procedure layer - stuck or failed background jobs, performance regressions and data-correctness defects - with durable root-cause fixes.
Optimize query and procedure performance : execution-plan (EXPLAIN) analysis, indexing and partitioning strategy, set-based rewrites of row-by-row (cursor) logic, and reduction of energetic-SQL overhead.
Harden transaction boundaries, erro

📌 Senior MySQL Programmer (Bengaluru)
🏢 unilog
📍 Bengaluru