|
Jul’13 – Feb’16:Q-Mobile Stock Company, Ho Chi Minh City, Vietnam Senior Database Administrator
Key Result Areas:
 Shouldered responsibility of managing ERP Oracle Database along with its subsystem supporting ERP Application
Improved database performance, performed database restores, implemented recovery procedures, managed performance tuning and conducted regular system back-up’s
Scrutinized and tuned ERP database system to adjust in time with issues related to performance getting high, deadlock transactions or bad SQL including optimize memory, sql statement, create index, partitions, sql profile or propose solutions about upgrade database patches, upgrade of hardware server patches/memory on both Linux and Windows Operating System
Enhanced database structure in organization of tables, table space, data file, archive log, redo log, trace file properly
Monitored sizing database parameter such as memory target, sga_target & pga_target to achieve best performance
Performed troubleshooting related to ERP Oracle database, Database and Application Server to ensure ERP system in the most secured and availability
Upgraded database software using patches and interface with Oracle Support Team
Assisted posting data from text file to table in ERP database using Imp/Exp Dump or SQL*loader
Supervised installation and configuration in RAC environment when needed or for production and test system using SAN storage
Devised and deployed the most effective back-up & recovery strategy using RMAN, listed out all scenarios that may occur in making ERP system down and developed detail script in orders to recover EPR system with the shortest downtime
Drafted automatic warning shell script scheduled in crontab to alert critical problems immediately
Ensured technical and functional designs meet business needs
Generate customized reports
Analyzed , evaluated and extracted data for complex reports in order meet with business ( Sale, marketing, accounting , purchasing, inventory, service)
Conducted requirement analysis and performed database design, UI, UX & dataflow to developers to perform coding
Liaised with development team in integration of Q-Mobile management software such as ERP, E-commerce (Web App and Mobile App), Delivery System (Web App and Mobile App), POS (Web App and Mobile App of Point of Sell) system
Supported and trained end *** about business process and ERP Application
Received application error complain, analyzed errors status then delivered to relevant teams to fix problem.
Research database warehouse and BI system, built-up BI system in LAP environment
Accomplishments:
Successfully built-up 3 database system serving for standby site, report system and test environment using physical standby (active dataguard), logical standby together with Goldengate
Played a key role in analyzing and designing database, UI, UX and dataflow for Delivery Management System, POS (Point Of Sale) Management System
Acted as a DBA and ERP Project Lead in completion of 80+ medium to large-scale implementations, managed projects from business requirements analysis to solutions delivery and support
Gained in-depth understanding in SAP system and Oracle EBS through self-study
Enriched end user’s understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials
Performed database tuning to achieve up to 30 *** performance enhancement of the ERP system during peak loads
Enhanced the ERP system to reduce online response time by 25 *** and cut batch-processing windows by 30 ***
Bagged 3 awards for excellent contributions in 7 years
May’09 – Jul’13: MHB Bank, Ho Chi Minh City, Vietnam as Database Administrator
Key Result Areas:
Supervised maintenance of core banking database including DC and DR site
Ensured safety and availability of Core and Card System databases together with other database related to small HRM System and Bank Website Database
Monitored and tuned Oracle Core Banking database to solve issues immediately and ensurecore system work smoothly and enhances performance
Elevated performance including memory, segment & sql statements
Improved performance and decreased running time in sql query by create index, partitions, sql profile or propose solutions about upgrade database patches, gain hardware server on both Linux and Windows Operating System
Troubleshot relating to Core Banking Oracle Database/ Card System SQL Server Database and Database and Application Server to ensure stable, standby databases were synchronous data fully
Scrutinized and tuned SQL Server Card System database to solve issues immediately and ensure database works smoothly and increases performance
Built-up log shipping to clone data between production database and standby database for Card System SQL Server database
Entrusted with the task of supporting:
Bank IT Team to communicate with Vendor Team in order to meet exact understanding about their requirements in updating or changing database or database parameters
Development Team in developing new module by writing functions, procedures, views or packages from requirements of others departments
EOD team working in night shifts to resolve problems of data synchronous or updated changing data to fix errors from Vendor Team
Established DR site using logical standby for failover system, beside report database system
Accomplishments:
Pivotal in offering solution to integrate Card System Database in to Core Banking Database
Played a key role in increasing:
Performance in peak times less than 25 *** (instead of over 60 *** as before) for database system
Database security and cost efficiency by 5 *** for database system
Pivotal in decreasing large report running time to 30 ***
Minimized cost for hiring Business Analyst for in-house software development
|
/ 
