Sign in

Engineer Developer

Alpharetta, GA
February 26, 2020

Contact this candidate


Keuntae Gil (“Justin”) Atlanta, GA *****


• 10+ years of strong SQL & Oracle PL/SQL development experience

• Full-stack development experience with Oracle APEX

• Understanding of Oracle architecture and DBA experience

• Data modeling & schema design practices on database and data warehouse

• Unix Shell scripting experience for batch processing

• Data analysis and visualization using Python


Senior Database Engineer

Elavon, Atlanta, GA Aug 2018 – Current

• Design & implemented archiving process to transfer transactional data in partitioned tables from production to data warehouse system using PL/SQL & Autosys job

• Review code changes, responsible for DB deployment process using CA Harvest SCM, and in migration steps to Git/Bitbucket with Jenkins CI/CD automation

• Involved in database design sessions and responsible for supporting database servers as development DBA for business as usual

Senior Software Engineer, Consultant

ADP, Alpharetta, GA Nov 2016 – Jul 2018

• Developing and supporting ADP Total Source PEO (comprehensive HR outsourcing) solution using Oracle 11g PL/SQL and SQR codes for customized PeopleSoft applications in Agile Scrum/Kanban team

• Debugging and fixing code problems and refactoring codes by modularizing complicated stored procedures

• Resolving performance issues on production by tuning complex SQL queries in PL/SQL stored procedures

• Implementing basic ad-hoc data analysis and visualization independently using Python Pandas

Senior Software Systems Engineer, Consultant

Verizon Wireless, Alpharetta, GA Feb 2016 – Nov 2016

• Performed database stored procedure conversion from Sybase & SQL Server to Oracle 12c for Commission Calculation Reporting System in Agile Kanban team

• Supported, enhanced, and implemented enterprise ETL processes using PL/SQL and CA ESP(D Series) automation tool

• Have worked in development tools – Jira, Git, and Confluence Lead Database Developer

Vanco Payment Solutions, Atlanta, GA Apr 2013 – Nov 2015

• Was responsible for database applications development and maintenance for merchants’ credit cards payment batch processes (clearing, funding, and billing) running on Oracle 11g

• Improved readability and performance of systems by normalizing data model and refactoring codes using advanced PL/SQL features (collections, bulk processing, exception handling, etc.)

• Supported and enhanced complex ETL business processes using Unix Shell scripts, PL/SQL program units, and BMC Control-M scheduling

• Troubleshot application errors through PL/SQL debugger and resolved performance issues on high-load SQLs using Explain Plan and SQL Profiling techniques

• Implemented PL/SQL web service call, introduced SVN version control system, and maintained Oracle APEX financial reports application

• Involved in designing enterprise data warehouse project based on NoSQL MongoDB, applied dimensional data modeling practices on Oracle 12c, and developed dashboards on Sisense

(Tableau) BI tool

• Led a team of three in database application development and mentored the team members for high quality software

Sr. Oracle Database Developer / DBA

Get2Hawaii, Honolulu, HI Feb 2006 – Jan 2013

• Performed overall database administration and development role in support of J2EE online travel packaging and reservation applications, built on Oracle and WebLogic servers

• Designed, developed, and deployed web-based reporting system using ETL processes, PL/SQL and Oracle APEX 4 on Oracle 10g for internal users

• Successfully upgraded Oracle 8i on Sun Solaris to Oracle 10g on Red Hat Linux and collocated to Rackspace hosting dedicated servers

• Administered relevant database security, managed database backups, and prepared recovery plans against failures using RMAN and Flashback database features

• Optimized system configurations & application queries for performance using OEM (ADDM), SQL Profiler, Explain Plan, SQL Tracing with TKPROF

• Automated routine database administration and deployment tasks using Unix Shell scripts, cron jobs, Oracle Data Pump (Export/Import) and SQL*Loader

• Managed tasks to create, maintain and refresh required Oracle instances/databases for development, QA, staging and production environments

• Evaluated and performed a pilot project for Sales data mart using dimensional modeling and Oracle Warehouse Builder

Oracle Database Developer

Get2Hawaii, Honolulu, HI Feb 2001 – Jan 2006

• Analyzed business requirements and designed logical & physical database structures through entity-relationship data modeling with normalization theory techniques and practices

• Implemented all back-end business logic using Oracle 8i PL/SQL stored procedures, functions, packages, and triggers for J2EE web applications

• Designed and configured database replication processes using materialized views for distributed databases

• Developed web reporting applications using ASP and Crystal Reports IX EDUCATION

University of Hawaii at Manoa, Honolulu, HI, B.S. in Computer Science PROFESSIONAL CERTIFICATIONS

Data Analyst with Python career track from DataCamp Oracle PL/SQL Developer Certified Associate

Oracle 10g Certified Professional Database Administrator Sun Certified Programmer for Java2 Platform

Contact this candidate