Database Administrator
Current- Solely responsible for develop, maintain and enhance existing ETL application (APEX, PL/SQL, Unix shell script) for full development cycle, provide additional features and reliable functionalities.- Develop, maintain and update data migration tool (spreadsheet, PL/SQL, SQLLDR, Unix shell script) to handle specific customer data - Develop, maintain and update Data Warehouse for existing application, build and enhance Materialize Views and various DWH objects (DB packages, PL/SQL, MVs and Views).- Analysis Clients’ requirements and provide scripts (PL/SQL, Unix Shell script) for maintenance and defect solving purposes.- Create and implement database designs and data models by following Business logic and requirements for existing applications.- Test applications and databases to identify issues and make necessary modifications.- Coordinate with various project members on database/script development to meet timeline and project scope.- Assist with Release management, packaging and documentations.- Deploy Application for testing purpose (WebLogic, TomEE, Flyway)- Provide support and solutions for Client Service, Verification, Development and Technical Support.
