01/28/2023 updated


100 % available
I'm a Qualified IT Professional willing to provide solutions for business needs.
Indonesia
Indonesia
BEC (Programming Language)Java (Programming Language)Amazon Web ServicesAmazon S3Data AnalysisBig DataBusiness RequirementsUnixC++ (Programming Language)Cloud ComputingComputer ProgrammingDatabasesData ArchitectureExtract Transform Load (ETL)Oracle Data Guard
S3, AWS, BIG Data, C, C++, Cloud, Cloud Technologies, Programming Skills, Data Analyst, Data Architect, Database, Disaster Recovery, Distributed Computing, ETL, Git, Datastage, Information Technology industry, Java, Jenkins, Linux, Netezza, NoSQL, Oracle, OBIEE, Data Guard, Oracle 9i, Oracle DBA, Oracle Discoverer, Oracle EBS, Oracle Forms, Oracle DB, PL/SQL, PLSQL, Performance Tuning, PostgreSQL, Python, R, RMAN, SQL, test case, Reporting Tools, UNIX, UNIX Shell Scripting
Experience
Professional experience0 - 5 years
Languages
GermanBasic knowledgeEnglishFluentJapaneseBasic knowledge
Project history
* As a coordinator find out root cause for any defects/bugs reported by client on Singlestore DB
and suggest solutions on the same to the product team.
* Prepare test case for the Beta releases and provide workaround for bugs till the release.
and suggest solutions on the same to the product team.
* Prepare test case for the Beta releases and provide workaround for bugs till the release.
Managed many clients in Healthcare, Insurance & Life science Projects.
Roles & Responsibilities -
* Prepared Runbook for entire scope of project after getting KT from client SME's.
* Identified challenges, load and then generated Data points to predict the trend.
Technical Solution Offered / Cost Savings -
* Migrated Data from Oracle DB to AWS/PostgreSQL by creating home-based scripts.
* Removed Golden Gate for HA and replaced with DG catering to business needs thus saving $.
* Removed Partitions, Compression & many other features that was licensed and saved $.
* Identified DB parameters and Customized DB objects before migrating from Exadata.
Roles & Responsibilities -
* Prepared Runbook for entire scope of project after getting KT from client SME's.
* Identified challenges, load and then generated Data points to predict the trend.
Technical Solution Offered / Cost Savings -
* Migrated Data from Oracle DB to AWS/PostgreSQL by creating home-based scripts.
* Removed Golden Gate for HA and replaced with DG catering to business needs thus saving $.
* Removed Partitions, Compression & many other features that was licensed and saved $.
* Identified DB parameters and Customized DB objects before migrating from Exadata.
Worked as Onsite DBA Support coordinator for XEROX at Rochester, US.
Roles & Responsibilities -
* Reviewed and customized all UNIX scripts related to the project developed by Oracle.
* Designed & worked on a module to move data from Warehouse to Mart using Python/PLSQL.
* Migrated data from Netezza, NOSQL to Oracle also created scripts for day to day DBA activities.
Technical Solution Offered / Key Contribution -
* Tune top queries publish before/after results from AWR/ASH/ADDM & eDB360.
* Monitor throughput from Informatica/OBIEE and then work on the DB parameters.
* Revised and reviewed all Oracle Supported UNIX scripts.
* Implemented Flash Cache to reduce the reads from the disk and capture ageing block from BC.
Roles & Responsibilities -
* Reviewed and customized all UNIX scripts related to the project developed by Oracle.
* Designed & worked on a module to move data from Warehouse to Mart using Python/PLSQL.
* Migrated data from Netezza, NOSQL to Oracle also created scripts for day to day DBA activities.
Technical Solution Offered / Key Contribution -
* Tune top queries publish before/after results from AWR/ASH/ADDM & eDB360.
* Monitor throughput from Informatica/OBIEE and then work on the DB parameters.
* Revised and reviewed all Oracle Supported UNIX scripts.
* Implemented Flash Cache to reduce the reads from the disk and capture ageing block from BC.