Role Overview

Consilium Software is an AI orchestrated CX Solution Platform provider, synthesizing data from over 5 billion annual interactions. We are seeking a Database Developer to design, develop, optimize, and maintain robust databases supporting our global enterprise clients.

Responsibilities

Design, develop, optimize, and maintain robust databases
Write efficient SQL queries, stored procedures, triggers, and functions
Troubleshoot critical production bugs/issues and keep systems healthy
Work closely with front-end and backend teams to understand business requirements
Create and maintain reports from multiple data sources
Handle ETL processes, data cleansing, and master data management
Ensure database security, backup, recovery, replication, and archival practices are in place
Improve database performance for large-scale applications
Support API execution and integrations
Participate in database architecture and design discussions
Make data behave. Politely when possible. Aggressively when needed.

Requirements

Must-Have Skills

3+ years of proven experience as a Database Developer
Strong hands-on experience with SQL
Excellent analytical and problem-solving skills
Good understanding of: Database permissions, Recovery strategies, Security, Monitoring
Experience with: Relational Database Design, Normalization techniques, ORM modelling
Expertise in writing complex queries and stored procedures in: MSSQL, MySQL, IBM Informix (preferred)
Experience working with large databases and high-volume systems
Knowledge of: ETL (Extract, Transform & Load), Data Cleansing, Master Data Management
Hands-on experience with: SSIS, SSAS, SSRS
Familiarity with: Data replication, Backup & restore, Archival practices, API execution
Exposure to the Contact Center domain is a big plus

Bonus Points If You

Love optimizing slow queries more than solving puzzles
Believe semicolons deserve respect
Can explain database concepts to non-database humans
Stay calm during production issues
Think performance tuning is oddly satisfying