Senior MySQL Programmer

Unilog; Bengaluru; On-site; INR 4,500,000 - 6,500,000; Full time

Benefits offered by this job

Competitive salary

Professional development

Collaborative environment

Health programs

Job summary

Unilog in Bangalore is seeking a Senior Database Developer with deep MySQL stored-procedure expertise to own the data-tier logic for CX1 PIM. You will read, write and optimize large procedures and collaborate with the Java Architect and DBA teams to keep the layer reliable and performant.

You will extract portable SQL helpers, contribute to schema design, review code, and ensure zero-downtime changes. The role requires leadership, clear communication, and resilience when debugging production

Qualifications

• 10+ years of hands-on relational database development
• 7+ years writing and maintaining complex MySQL stored procedures, functions and triggers in production
• Strong ability to read, understand and modify very large procedures with dynamic SQL and cursors

Responsibilities

• Read, understand and document complex stored procedures, functions and triggers
• Write, modify and optimize stored procedures, functions and triggers
• Diagnose and resolve production issues in the stored-procedure layer
• Optimize query and procedure performance with EXPLAIN analysis and indexing
• Harden transaction boundaries and data integrity across the catalog
• Contribute to schema design and version-controlled changes (Liquibase / Flyway)
• Participate in code reviews and establish SP coding standards
• Collaborate with Java, DBA, Product and DevOps teams

Skills

MySQL stored procedures

SQL performance tuning

Dynamic SQL

Data modeling

Git & CI

Tools

Liquibase

Flyway

Git

Job description

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 dynamic-SQL overhead.
• Harden transaction boundaries, error/exception handling and data integrity across the procedure catalog.
• Support the stored-procedure-to-Java modernization by extracting narrow, parameterized, portable SQL helpers from monolithic procedures while preserving set-based performance.
• Contribute to schema design and partitioning, and manage version-controlled schema changes (Liquibase / Flyway).
• Participate in code reviews of stored-procedure changes; establish and follow SP coding standards, documentation and testing practices.
• Partner with the DBA team on production readiness, replication and tuning.

MySQL & Stored Procedures

• 10+ years of hands-on relational database development, with 7+ years writing and maintaining complex MySQL stored procedures, functions and triggers in production.
• Demonstrated ability to read and safely modify very large procedures (1,000-6,000+ lines) involving dynamic SQL (PREPARE / EXECUTE), cursors, temporary tables and multi-table joins.
• Expert in query optimization - EXPLAIN / execution-plan analysis, indexing, partitioning, and converting row-by-row logic to set-based operations.
• Strong command of transaction management, isolation levels, locking / deadlock diagnosis, and error handling in MySQL procedural code.

Data & Performance

• Proven experience with large data volumes (tables / catalogs in the millions of rows) and ETL-style bulk transformations and materialized-refresh routines.
• Experience with schema version control and zero-downtime migration strategies (Liquibase / Flyway).
• Working knowledge of Solr (or Elasticsearch) indexing / search workloads is a plus.

Tools & Practice

• Comfortable with Git-based workflows, merge requests / code review, and CI for database code.
• Ability to produce clear technical documentation for complex procedures and data flows.

Leadership & Soft Skills

• Strong ownership mindset - willing to dive into production incidents and lead root-cause analysis.
• Good written and verbal communication; able to explain complex data logic to engineers and non-DBA stakeholders.
• Collaborative across Java, DBA, Product and DevOps teams.

Benefits

• Competitive salary and benefits package
• Opportunities for professional development and training
• Collaborative and innovative work environment
• Health and wellness programs

(ref:hirist.tech)