Position: Database Administrator (Dba)
• * Responsibilities**:
- 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.
- Provide deployment support for database objects in production and UAT environments.
- Provide 24x7 production database support and willing to work after office hours / weekends.
• * Requirements**:
- Singaporean only
- 3 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.
- Strong skills in Oracle/MS-SQL/MySQL database administration supporting large database environments.
- Knowledge on Oracle JDBC, , UCP, TAF, FCF and MySQL Connectors.
- Proficient in Database installation, configuration on UNIX (Solaris & AIX) / Linux / Windows platforms.
- Good database performance tuning, troubleshooting skills and locating bottlenecks at both server and database level.
- Experience in Database High Availability setup using Oracle RAC/Dataguard, SQL Server Failover Cluster/Always On Availability Groups, MySQL InnoDB Cluster/NDB Cluster.
- Experience in database install, upgrade, plan and execute critical database migration using Oracle Goldengate/Shareplex.
- Experienced with standard database monitoring tools.
- Oracle certification - OCP on Oracle 11g/12c/18c/19c preferred.
- 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.
- Good communication and presentation skills and be able to interact with multiple teams at various levels