Austin Jeon

Experience

• 

  Health Care Service Corporation

  Jun 2019 - Dec 2022

  Oracle Database Administrator/PLSQL Developer

  At HCSC, I engineered innovative solutions to optimize data processes, automate systems, and resolve complex issues, resulting in significant time savings, bottleneck elimination, and enhanced efficiency across multiple projects in Linux/Unix environment. Examples include:• Demonstrated leadership by spearheading the resolution of a complex data transfer issue. Implemented an innovative CFTP solution, automated the process using Zena, and set a new standard for efficient database server connectivity. Initiated meetings, actively sought solutions, and diligently worked to gain approval from all stakeholders.• Engineered an optimized Stored Procedure for the Production Support Refresh job, reducing data population time from 75 hours to 5 hours, eliminating the data masking bottleneck, and reducing DBA work hours by 93%.• Collaborated with front-end web developers, demonstrating strong teamwork, to develop an automated NPID and role request system. Utilized stored procedures to streamline communications, eliminate bottlenecks, and reduce daily processing time by 88%.• Created a script troubleshooting golden gate errors and collaborated with DevOps to resolve tool parameter issues, reducing DBA work time to near zero and optimizing script runtime by 60%.• Engineered a shell script to automate the creation of scripts for cron jobs for RMAN commands and PL/SQL packages, reducing scripting work for new database deployments from 15 minutes per database to near zero, while enabling seamless script recovery and customization using parameters. Show less

• 

  BNY

  Aug 2024 - now

  Database Administrator