Database Developer

Founded in 2007 Consilium Software is incorporated in Singapore, with software development and engineering labs in India, and subsidiaries and branch offices in India(New Delhi), Malaysia (Kuala Lumpur), Taiwan (Taipei City), Indonesia (Jakarta), Thailand (Bangkok), Australia (Melbourne) and Canada (Toronto.). Raised Series A funding from a leading investor, supported by Singapore economic development board (EDB), strong technology alliance with global leading companies like Cisco, Salesforce, Amazon, Oracle.Consilium Software and our Uni digital customer engagement platform have helped over 1,000 companies in 110 countries connect their employees with customers. Our choice of cloud-based and on-premise software powers 3 billion-plus interactions each year, simplifying the management of voice, video, and digital channels. Consilium conceives, develops, and delivers enterprise software for unified communications (UC) and contact centers to power transformative Customer Experience Management (CEM.) Consilium is led by practitioners who have differentiated customer experiences through every major cycle of evolution for 30 continuous years.We encourage you to visit our website https://www.consiliuminc.com before the interview to get an overview of our company and products.Job DescriptionJob BriefWe are looking for a Database developer to design stable and reliable databases, according to our companys needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.You will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.Ultimately, you should be able to ensure our database systems run effectively and securely daily.RequirementsProven work experience as a Database developerIn-depth understanding of data management (e.g. permissions, recovery, security and monitoring)Hands on experience with SQLExcellent analytical and organization skillsAn ability to understand front-end users requirements and a problem-solving attitudeTrouble shooting of critical bugs / issues.Should have experience Relational Database design practices, normalization techniques, ORM modelling.Experience in writing complex queries, stored procedures in MSSQL or MySQL and exposure of working on large database would be preferred.Should have skills and hands on experience on generating reports from Multiple Data Stores, Master Data Management, ETL (Extract, Transform and Load) and Data cleansing.Knowledge of SSIS, SSAS and SSRS.Should be familiar with data replication, back up , restore and archival practices.Other Behavioral / Attitude aspects:Dynamic, self-motivated, and self-drivenTeam PlayerHaving a sense of ownershipBe willing to travel periodically, both Domestic and International