Responsibilities:
- Design and develop reports, ensuring data accuracy and visualization.
- Create task schedules for automation and implement ETL processes.
- Work with the application development team to define the application data model, design and implement database tables, views, functions, and stored procedures to meet business requirements.
- Develop and maintain database-related codes / scripts such as data sync scripts, data masking scripts, stored procedures etc.
- Develop and optimize SQL queries for integration with other applications, ensuring high performance and data integrity.
- Modify databases according to requests, perform tests, and ensure data consistency.
- Review data mapping/conversion/integration specs between systems to ensure appropriate mapping quality and adherence to modelling strategies.
- Plan and strategize data mapping for migration of data from legacy systems to support the deployment of the project, ensuring no data loss during conversion.
- Monitor and manage user enquiries and issues on the systems helpdesk, providing timely and effective support.
- Provide production support and responsible for the resolution of database related issues and standby duty rotation for after-office-hours support.
- Provide support on to application team on database related matters (e.g. data patching, application deployments, extracting data from database for reporting)
- Troubleshoot system issues, identifying and resolving problems efficiently.
- Work on tuning and optimizing database related operation.
Requirements:
- Bachelor's degree in Computer Science, Engineering, Information Technology or related technical discipline, with strong troubleshooting and communication skills, with attention to detail.
- At least 8 to 12 years proven experience as a Database Developer or in a similar role, with high proficiency in SQL, PL/SQL scripting, T-SQL, or other procedural extensions.
- 5 to 8 years of IT database administration, performance tuning, and troubleshooting experience, with good track records with Oracle / MS SQL / DB2 / MySQL / PostgreSQL / MariaDB / MongoDB databases including setting up and managing the environment.
- At least 3 years’ experience with data integration, ETL processes & tools, and data co-existence technology with legacy systems.
- Familiarity with Java, Python, .Net Framework, JavaScript, and HTML, with a good understanding of Agile methodologies.
- Experience with big data platforms or data warehouses like Snowflake, Hadoop, or DataBricks.
- Experience in setting up and managing databases in a high availability active-active setup will be added advantage.
- Must be able to perform standby duty rotation for after-office-hours support.