Database Engineer

Krunchbox is transforming retail analytics with our next-generation platform (Krunchbox Reimagined). We are migrating from 800 hardcoded ETLs to a modern, real-time analytics architecture powered by ClickHouse. This is a greenfield opportunity to architect the analytical backbone for 100+ enterprise clients. The Database Maintenance Engineer will maintain and optimize our critical Azure SQL Server databases that power Krunchbox's retail analytics platform. You will ensure data integrity, performance, and reliability across millions of daily retail transactions. You will work closely with the data engineering and platform teams to implement robust maintenance plans, healthy schema evolution, and scalable backup/restore strategies. Your contributions will directly enable real-time insights for large retailers and help scale our SaaS solution globally.

Job opportunity on

• Execute routine database maintenance tasks with precision and accuracy to ensure high availability and performance of Azure SQL Server databases powering the analytics platform.
• Manage schema modifications, table updates, and index maintenance to support evolving data models.
• Write and optimize T-SQL queries, stored procedures, and scripts to support data processing and operational tasks.
• Conduct data validation and integrity checks across complex schemas to guarantee accuracy for 100+ enterprise clients.
• Perform data cleanup, archival, and migration tasks while preserving data lineage and auditability.
• Monitor database health metrics, set up alerts, and proactively address issues before impact occurs.
• Document procedures and maintain operational runbooks for disaster recovery and incident response.
• Collaborate with the engineering team on schema changes and deployments, ensuring smooth releases.
• Support backup verification and disaster recovery testing as part of regular maintenance cycles.

• 2+ years hands-on experience with SQL Server database administration in production environments.
• Strong T-SQL skills, including complex queries, stored procedures, and functions.
• Expertise with SQL Server Management Studio (SSMS) and relational database design concepts.
• Experience with database maintenance plans, index optimization, and schema evolution.
• Attention to detail and a methodical approach to work, with the ability to work independently and accurately execute tasks.
• Experience with data validation and quality assurance processes, including data lineage and auditing.
• Understanding of backup/restore procedures and disaster recovery planning.
• Familiarity with Azure SQL Server or cloud database platforms; ability to adapt to cloud-native tools.
• Strong problem-solving and troubleshooting skills, with the ability to follow documented procedures precisely.

• Experience with high-volume retail or e-commerce databases.
• Knowledge of Change Data Capture (CDC) and replication mechanisms.
• Familiarity with ClickHouse or columnar databases.
• Database performance tuning and query optimization expertise.
• Experience with ETL/ELT pipelines (e.g., Azure Data Factory) and data warehousing concepts.
• Automation scripting in Python or PowerShell; experience with Git or version control systems.

• Competitive compensation package.
• Comprehensive health and benefits coverage.
• A predominantly in-person, collaborative work environment located in Mexico City to encourage fast iteration and real-time problem solving.
• Opportunity to scale and lead a global SaaS platform that solves real-world customer challenges.
• A direct, impactful role in shaping the future of AI-powered supplier-retailer collaboration.

GETONBRD Job ID: 57272

Flexible hours

Flexible schedule and freedom for attending family needs or personal errands.

Partially remote

You can work from your home some days a week.

Computer provided

Krunchbox provides a computer for your work.

Informal dress code

No dress code is enforced.

Hybrid

This job is performed partly from home and partly at the office in Santiago (Chile).