Daniel Tan

Experience

• 

  Software Ventures International

  Apr 2008 - Oct 2010

  Oracle DBA

  • Installation of the oracle software and database.• Involved in overall schema design for applications in development• Implement backup and recovery strategies mostly with the use of RMAN.• Implemented a 2 node RAC installation for improved business performance.

• 

  Hewlett-Packard

  Oct 2010 - Mar 2014

  Oracle Database Engineer

  • 3rd Level Incident Management Platform and Applications DBA.• Troubleshoot and resolve platform or application related incidents.• Perform root cause analysis and provide permanent fixes or workarounds to platform related problems• Optimize database performance• Tune and optimize long running queries• Resolve database related job failures encountered by applications• Develop PL/SQL packages and procedures to improve day to day operations• Develop database triggers for increased database security• Provide management reports on the performance of the database• Manage user roles and permissions• Review and execute routine service requests• Conduct technology specific trainings and/or qualification exams• Participate in design review meetings and provide recommendations to platform related changes• Provide consultancy to other HP support team on database related matters• Create, review, maintain, and deploy technology platform documentations (e.g. technical documents, etc.)• Coordinate with ITO group in resolving technology system and infrastructure issues• Interface with Oracle Support for database related bugs. Show less

• 

  DANATEQ

  Mar 2014 - Feb 2017

  Senior Oracle DBA

  • Responsible for ensuring availability and performance of the databases and implementation and release of database changes as submitted by the Research and Development Team.• Ability to interact with development teams, business owners, and varioius levels of management with the experience with performance tuning and monitoring.• Ensure high availability and performance• Experience working as part of a team that delivers a high availability service• Proactively monitor the database systems to ensure secure services with minimum downtime• Provide trend analysis to enable the team to make informed decisions regarding resource management.• Responsible for improvement and maintenance of the databases to include rollout and upgrades.• Provide Oracle database assessments and subsequent hardware,software, and services recommendations relative to both the overall health of an oracle environment and deep-dive into new Oracle products/features.• Upgrade, configure, and tune all components of the Oracle technology stack including the Oracle 10g and 11gR2 Database.• Architect and implement High Availability and Disaster Recovery solutions to ensure application availability (RAC/Dataguard)• Architect and implement backup strategies using RMAN and integrate with other industry-standards as needed.• Stay current on Oracle technology, new functionality, and release roadmap.• Provide evaluation, architecture, and integration technical capabilities to implement Oracle database products and features i.e.: Partitioning, Compression, Encryption, Data Guard etc..• Script/design automation of repetitive processes to minimize human error and maximize service delivery.• Research database technology, determine business requirements, propose changes, and develop migration and implementation plans.• Hands-on experience running Oracle's Exadata platform.• Involvement in pre-sales activities including client-facing meetings and presentations. Show less

• 

  Indra

  Feb 2017 - Jun 2018

  Senior Oracle Database Administrator

  • Repaired broken data guard configuration.• Configured automated alert notifications• Resolved existing performance issues encountered by business units• Tuned sub-optimal queries running against the database• Implemented partitioning on relevant tables to minimize database I/O and improve query performance• Ensured high availability and performance• Design and implement backup strategies using RMAN and integrate with other industry-standards as needed.• Maintained 70+ SQL Server instances ensuring backup and recovery as well as resolving performance issues. Show less