Senior MySQL Database Architect - Remote

United States Digital Space LLC; United States; Remote; USD 63,000 - 95,000; Full time

Job summary

the company is seeking a Senior Database Programmer with deep MySQL expertise to own and evolve the data-tier logic of CX1 PIM. The role involves large stored procedures, dynamic SQL, and close collaboration with the Java Architect, Engineering Management, and DBA teams to keep the stored‑procedure layer reliable and performant.

You will work on migrating toward portable SQL helpers, improving schema design, and ensuring zero-downtime changes while maintaining set‑based performance across

Qualifications

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

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, including 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.

Skills

MySQL

Stored Procedures

Query optimization

Transaction management

Tools

Liquibase

Flyway

Git

CI

Solr

Elasticsearch

Job description

the company is seeking a Senior Database Programmer with deep MySQL expertise to own and evolve the data-tier logic of CX1 PIM. The role involves large stored procedures, dynamic SQL, and close collaboration with the Java Architect, Engineering Management, and DBA teams to keep the stored‑procedure layer reliable and performant.

You will work on migrating toward portable SQL helpers, improving schema design, and ensuring zero-downtime changes while maintaining set‑based performance across