Requirements:
- Design the database’s architecture and modelling strategies to ensure that the database is secure, scalable and performs reliably.
- Create and modify database objects (tables, views, indexes, stored procedures, triggers, etc.).
- Develop and optimize SQL queries for performance and scalability.
- Work with the application development team to define the application data model and work on tuning and optimizing database related operation.
- Be point of contact to principal vendors for software and hardware.
- Provide production support and responsible for the resolution of database related issues and 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)
- 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.
- Review data mapping/conversion/integration specs between systems to ensure appropriate mapping quality and adherence to modelling strategies.
- Ensure timeliness and accuracy of data sync during co-existence with legacy systems.
- Develop and maintain database-related codes / scripts such as data sync scripts, data masking scripts, stored procedures etc.
- Ensure database services and servers availability.
- Install and configure Database and associated products.
- Ensuring database patches are performed in accordance with the patch release cycle.
- Troubleshoot and remediate security vulnerabilities reported by security scan.
- Reviewing and maintaining of database accounts.
- Monitoring and optimising database performance, such as optimising queries, creating indexes etc.
- Capacity planning.
- Configuring backup on database.
- Ensuring database is hardening in accordance with Authority standards.
Requirements:
- Bachelor’s degree in computer science, Computer or Electronics Engineering, Information Technology or related technical discipline.
- Proven experience as a Database Developer or in a similar role.
- Familiarity with data integration and ETL processes and tools.
- Experience with big data platforms or data warehouses like Snowflake, Hadoop, or DataBricks
- Proficiency in SQL, with experience in PL/SQL, T-SQL, or other procedural extensions.
- Minimum of 5 years of IT database administration experience.
- Past track records with Oracle/MSSQL/DB2/MySQL/Postgres/Maria/Mongo databases including setting up and managing the environment.
- Experience in setting up and managing databases in a high availability active-active setup will be added advantage.
- Knowledge in PL/SQL scripting will be added advantage.
- Knowledge in working with ETL and data co-existence technology with legacy systems will be added advantage.
- Knowledge with DB audit and security will be added advantage.
- Knowledge with data masking products will be added advantage.
Disclaimer: The company is committed to ensuring the privacy and security of your information. By submitting this form, you consent to the collection, processing, and retention of the information you provide. The data collected (which may include your contact details, educational background, work experience and skills) will be used solely for the purpose of evaluating your qualifications for the position you're applying for. Your data will be stored securely and retained for the duration necessary to fulfill our hiring process. If you are not selected for the position, your data will be kept on file for a limited period in case future opportunities arise. You have the right to access, correct, or delete your data at any time by contacting us at Quess Singapore | A Leading Staffing Services Provider in Singapore (quesscorp.sg)
