Singapore
I have 7+ years of experience working as an ORACLE Dba with expertise in database migration projects, I have worked as an applications DBA, in production support and data center operations . I am currently looking forward to taking a challenging role. I am proficient with R, Python, SQL, Big Data, Oracle, oracle RAC, oracle standby, Solaris and Unix.
-Migrated 300+ RDBMS databases to consolidate data-centres. -Provision of new databases as per company policy, and Setting up Backup solutions using RMAN, high availability through data-guard, and high-performance via Real Application Cluster(RAC) -Creating new databases as per company standard policy and enabling monitoring. -Worked with export/import, data pump, RMAN, XTTS for migration. -Working with the application team to set up their application on the new environment and monitor performance and do necessary changes if required to improve performance. -Set up physical standby or use XTTS to minimize migration downtime. -Participated in requirements gathering and analysis meetings with Team Members, Internal Customers, and Stakeholders. -Coordinated migration and rollback strategy with the architect, management, client and vendors & Assisted UAT to resolve post-migration issue. -Manages all aspects of multiple related projects to ensure the overall program is aligned to and directly supported. -Worked creatively and analytically in a problem-solving environment demonstrating teamwork, innovation and excellence
Participated as an Apps DBA in 2 major version upgrade. -Administered CRM and Billing Applications and databases to ensure high performance and availability. -To Monitor databases, this includes basic health checks, growth of objects, and performance of the databases. -Worked with the application team to suggest and review new database changes. -Performance Tuning and database monitoring -RAC Administration -Managed Database Links, Tablespaces and Datafiles, Creation and Rebuilding of Indexes, and Managed Database Security. -Managed database users and their associated roles, and profile. -Gathering Performance information and monitoring/interpreting alert log and trace files. -Use of SQL diagnostic and tuning tools like AUTOTRACE (AWR / ADDM Reports). -Troubleshooting and maintenance of Oracle Database. -Handling Import / Export for schema, table, full database etc. -Attend daily change requests for the production databases. -Supported application team for application upgrade and their new changes in the production environment.