Total 4 Junior Executive database administrator job vacancies in Information Technology category in Singapore

We are looking for individuals who are meticulous to be part of our store.

Job description:

1) processing sales and purchase orders into delivery orders and invoices

2) assist to key in stock data into inventory system

3) assist and packing and coordination of overseas shipments

4) general filling for records upkeeping

5) answering of phone calls

6) assist in cleaning and maintaining good housekeeping practices of store and office

Working hours - 9am to 6pm (Mon - Fri), excellent medical benefits. No work on weekends unless you cannot finish your job..

Candidates with relevant experience will be given priority.

Strong skills in Oracle/MS-SQL/MySQL database administration supporting large database

environments.

 Proficient in Database installation, configuration on UNIX (Solaris & AIX) / Linux / Windows

platforms.

 Experience in Database High Availability setup using Oracle RAC/Dataguard, SQL Server

Failover Cluster/AlwaysOn Availability Groups, MySQL InnoDB Cluster/NDB Cluster.

 Good database performance tuning, troubleshooting skills and locating bottlenecks at both

server and database level.

 Experience in database install, upgrade, plan and execute critical database migration using

Oracle Goldengate/Shareplex.

 Familiar with database partitioning design, TDE encryption and implementing security

standards to secure critical environments.

 Well versed with Database optimizer changes, database internals and troubleshoot

production issues.

 Covering all administrative tasks, such as planning and building new database servers, ASM

disk management, backup and restore, user account and data security management,

capacity planning.

 Disaster Recovery implementations based on Oracle Dataguard. Work with infrastructure

team on upgrades, patching and resolution of cross functional issues.

 Participate in system audits, adhere to the internal security standards.

 Knowledge on Oracle JDBC, ODP.Net, UCP, TAF, FCF and MySQL Connectors.

 Provide deployment support for database objects in production and UAT environments.

 Provide 24x7 production database support and willing to work after office hours /

weekends. Experienced with standard database monitoring tools.

 Good communication and presentation skills and be able to interact with multiple teams at

various levels.

 Skills and Qualification:

Min 2 years of experience working as production database administration supporting Oracle,

SQL Server and MySQL databases. Good skills in unix shell scripting and Oracle PL/SQL

programming.

 Desired skills:

Oracle certification - OCP on Oracle 11g/12c/18c/19c preferred.

Responsibilities
• Strong skills in Oracle/MS-SQL/MySQL database administration supporting large database environments.
• Proficient in Database installation, configuration on UNIX (Solaris & AIX) / Linux / Windows platforms.
• Experience in Database High Availability setup using Oracle RAC/Dataguard, SQL Server
• Failover Cluster/AlwaysOn Availability Groups, MySQL InnoDB Cluster/NDB Cluster.
• Good database performance tuning, troubleshooting skills and locating bottlenecks at both server and database level.
• Experience in database install, upgrade, plan and execute critical database migration using Oracle Goldengate/Shareplex.
• Familiar with database partitioning design, TDE encryption and implementing security standards to secure critical environments.
• Well versed with Database optimizer changes, database internals and troubleshoot production issues.
• Covering all administrative tasks, such as planning and building new database servers, ASM disk management, backup and restore, user account and data security management, capacity planning.
• Disaster Recovery implementations based on Oracle Dataguard. Work with infrastructure team on upgrades, patching and resolution of cross functional issues. 
• Participate in system audits, adhere to the internal security standards.
• Knowledge on Oracle JDBC, ODP.Net, UCP, TAF, FCF and MySQL Connectors.
• Provide deployment support for database objects in production and UAT environments.
• Provide 24x7 production database support and willing to work after office hours / weekends. 
• Experienced with standard database monitoring tools.

Requirements
• Degree/ Computer Science / Computer Engineering in Information Technology, Information Systems, or Equivalent.
• Min 2 years of experience working as production database administration supporting Oracle,
• SQL Server and MySQL databases. Good skills in unix shell scripting and Oracle PL/SQL programming.

Desired skills: Oracle certification - OCP on Oracle 11g/12c/18c/19c preferred.

Licence no: 12C6060

Key Responsibilities

·       Design the database’s architecture and modelling strategies to ensure that the database is secure, scalable and performs reliably.

·       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.

·       Provide operational support including:

o   Ensuring database patches are performed in accordance with the patch release cycle.

o   Troubleshoot and remediate security vulnerabilities reported by security scan.

o   Reviewing and maintaining of database accounts.

o   Monitoring and optimising database performance, such as optimising queries, creating indexes etc.

o   Capacity planning.

o   Configuring backup on database.

o   Ensuring database is hardening in accordance with Authority standards.

What we are looking for

·       Past track records with Oracle/MSSQL/DB2/MySQL/Postgres/Maria/Mongol 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.