Johnny Kong

Background

About Johnny Kong

Oracle certified DBA and developer with extensive hands-on experience in DB area with Solaris, Linux, HP-UX, AIX, z/OS Mainframe & Windows, including DB configuration & installation, stored procedure, packages, PL/SQL & SQL scripting, RMAN, RAC & ASM, Data Guard (BCP), DB migration/re-building, logic & physical backup/recovery, application/server/DB tuning, etc. Sound practical experience on OLTP, OLAP, and VLDB. Extensive knowledge of DB programming language including SQL, PL/SQL, Perl/C, ETL & tools. Strong knowledge on Hadoop big data analysis including Hadoop HDFS, HCatalog, Hive, Hive query language, Apache Sqoop, Pig scripting. Good documentation skill demonstrated in writing script description, implementation plan, and instruction for other DBAs, developers and end users. Creative, self-starting, strong ability to learn & adapt, with good analytical and problem-solving skills; easily approachable, and contribute with professional courtesy to a positive work environment. Key Strengths & Skills: Oracle RAC and ASM Oracle Data Guard Shell Scripting SQL and PL/SQL Performance Tuning (Once tuned a long batch query from 17 hours to 20 minutes) DB2, SQL server (MSBI, SSIS/SSAS/SSRS), MySQL Application Development Weblogic, SAS, IBM MQ, Oracle EBS, R enterprise scripting Production Support Technical Support