Role Overview

Consilium Software is seeking an experienced Database Developer to design, develop, optimize, and maintain robust databases for our AI orchestrated CX Solution Platform. You will be responsible for ensuring data integrity, performance, and security across large-scale, high-volume systems, working closely with development teams to meet complex business requirements.

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

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, and monitoring
Experience with Relational Database Design, Normalization techniques, and 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, and Master Data Management
Hands-on experience with SSIS, SSAS, and SSRS
Familiarity with data replication, backup & restore, archival practices, and API execution

Bonus Points If You

Have exposure to the Contact Center domain