구대성 Email & Phone Number

South Korea

2024.09~2024.09 Shinsegae Department Store System Diagnosis Project -. Shinsegae Department Store Architecture Status Diagnosis and Improvement Direction Diagnosis Project -. Role : Diagnose DBMS architecture structure and check improvement plan and suggest direction2024.08~2024.08 CJ Olive Young Project Proposal -. Proposal for building a CJ Olive Young brand integrated management project -. Role : Presentation of to-be DBMS architecture(ORACLE->Open Source DBMS (MySQL, PostgreSQL)Present and suggest data migration methods and their pros and cons 2022.08~2024.07 Shinsegae Department Store Next Project -. Next-generation project to rebuild On-premise(ORACLE) systems into an AWS cloud(Aurora MySQL, PostgreSQL, MariaDB) environment -. Role : Data Architect Part LeaderPre-verification work for the integration of major systems and Cloud environmentsPresenting and verifying migration plans (ORACLE -> Aurora MySQL)AWS Aurora MySQL, PostgreSQL Physical / Logical Architecture Design, Implementation, TuningPerformance Testing and Monitoring (AWS CloudWatch, DataDog)2022.04~2022.08 LG Energy Solution Data Archiving (Google GCP) Project -. LG Energy Solution DFS(Battery) Image and Meta Data Archiving Project (ORACLE -> GCP BigQuery) -. Role : DBMS Selection and Design for Archiving Data in a Large-Capacity Data Cloud Environment Comparative Analysis of Data Migration methods (Commercial Migration Tool, GCP dataflow/Composer, open source Airflow) Create a Python batch programs to transfer data GCP Cloud Composer(Airflow) job schedule and Managment

2021.01~2021.04 LG CNS AI Strategic Task -. Developing Hand-On AI Application Development Methodology (Analysis Methodology, AWS SageMaker Development Environment Implementation) -. Role : AI Application Development Environment Implementation Development of python program to build an AWS SageMaker development environment(scikit-learn, AWS Lambda, AWS CloudFormation)2020.01~2022.12 Shinhan Card DBMS Tuning -. Shinhan Card DBMS System Tuning and Data Purge Work -. Role : DBMS Tuning (ORACLE, MySQL) 2018.10~2020.01 KOREAN AIR DCO AWS CLOUD Migration Project -. A project to transfer all of Korean Air's on-premise systems to the AWS cloud environment. -. Role : Analysis of the impact of migration of DBMS from Unix environment to Linux environment (ORACLE, MySQL, MS-SQL, PostgreSQL) Establishing the plans and methods to migrate on-premise systems to AWS cloud environments (OGG, ORACLE DataGuard, AWS DMS, Export/Import, DataPump) Installable DBMS(On EC2), Cloud Management DBMS Architecture Design, Implementation, Tuning Building Remote Region(USA virginia) DR Center in AWS Cloud Environment (DataGuard, AWS Endure) 2018.06~2018.09 LG U+ MVNO Project Proposal -. Proposal to separate the system for MVNO service from LG U+ CSBS (Customer Billing) system -. Role : Comparative analysis of replication methods for large-capacity ORACLE DB (about 150TB) to provide a test environmentMVNO System Physical/Logical DBMS Architecture DesignEstablishment and verification of large-scale data transfer plan

대한민국 서울 마포구

-. Managing CSBS Database (ORACLE, MS-SQL, MySQL, SYBASE, ALTIBASE, PostgreSQL)(SQL Tuning, Performance Optimization, Monitoring, Event Problem Solving, DB Object management) -. Role : Data Architect Part Leader Managing CSBS DBMS Project Guides and Support Providing a test environment and handing over operations2015.03~2016.01 LG U+ Open Source DBMS Standard Establishment TF-. Establishment and verification of open source DBMS standard policy-. Role : Analysis of the pros and cons of open source DBMS (MySQL, MariaDB, Postgres),ORACLE DBMS Establishing a DBMS selection guide policy when configuring a system Creating and verifying test case scenarios for each DBMS2011.06~2012.03 LG U+ NCSBS Project-. Establishment of a 3-company integrated NCSBS (next-generation customer billing) system (ORACLE)-. Role : Tuning work in the performance part2009.11~2010.02 LG Telecom Upgrade CSBS system (Oracle 10.2.0.3  10.2.0.4) -. Implementing Clone DB to investigate effects of CSBS system upgrade and Tuning DB (SQL statement tuning & db parameter optimization)-. Role : Project Planning, System Implementation, DB Tuning2008.12~2009.05 LG Telecom Encryption of Customer Information-. Encrypting customer information and Tuning related SQL query -. Role : Milestone Plan, Provision of Test Environments, Testing, Tuning2007.04~2008.02 LG Telecom Next CSBS Project-. Customer/Billing System analysis, design, implementation (Single DB  2node RAC) -. Role : Implementing Next CSBS DBMS

대한민국 서울 강남구