Har Jay Email & Phone Number

Shanghai

OceanBase DBA

Shanghai City, China

First three years I took the responsibility for a DBA team to deliver daily maintenance of Shanghai Real-Estate production environment. I'm familiar with ORACLE 9i, 10g, 11g. I'm skilled in backup and recovery, RAC, DATAGUARD, GOLDENGATE and SQL tuning. During work i've done a good job at performing high availability task. Besides oracle database, I'm also familiar with redhat linux, vmware virtual machine, EMC CLARIION serial storage prod. Since 2011, I also acted as technical manager. I… Show more First three years I took the responsibility for a DBA team to deliver daily maintenance of Shanghai Real-Estate production environment. I'm familiar with ORACLE 9i, 10g, 11g. I'm skilled in backup and recovery, RAC, DATAGUARD, GOLDENGATE and SQL tuning. During work i've done a good job at performing high availability task. Besides oracle database, I'm also familiar with redhat linux, vmware virtual machine, EMC CLARIION serial storage prod. Since 2011, I also acted as technical manager. I managed infrastructure daily operation. During the work I have a good opportunity to communicate with developers, PMs from partners and customers. I followed ISO20000 to receive and assign task. I use PMP theory to accomplish project implementation(eg. database migration from 9i to 11g including characterset conversion). Show less

Shanghai City, China

Primarily manage the production box of Shanghai Medical Bureau, Ningbo Medical Bureau and Shanghai Real-Estate Bureau. Designing and performing the production box's data migration. Using dynamic performance view and STATSPACK to tune the DB effectively. Writing SHELL scripts to monitor the DB's health. Restore and recover the incorrect file from the valid backup. Involving devploper's coding phase to tune the ineffective SQL statement and data structure. Familiar with some advanced features… Show more Primarily manage the production box of Shanghai Medical Bureau, Ningbo Medical Bureau and Shanghai Real-Estate Bureau. Designing and performing the production box's data migration. Using dynamic performance view and STATSPACK to tune the DB effectively. Writing SHELL scripts to monitor the DB's health. Restore and recover the incorrect file from the valid backup. Involving devploper's coding phase to tune the ineffective SQL statement and data structure. Familiar with some advanced features e.g. RAC and DATAGUARD. Show less

Shanghai City, China

Working in the the project site of Shanghai Medical Bureau. Primarily manage the medical finance system project and take part in other large OLTP system’s designment and development phase. Communication with customers. Using PowerDesigner to design the data structure. Writing design documents. Coding by Delphi, PRO*C, SQL SERVER and ORACLE. Testing and Debugging. Training the developers in the team to supply effective SQL statement and readable code and data structure.