BigData Solution (MongoDB) for BlockchainPL/SQL, Query Builder.Working on Amazon RDS & Transparent Data Encryption for MySQL & Oracle 11g with Key Management System.Extract Transform & Load data into main servers (Oracle, Maria-db, MySQL, Aurora Db)Development of Bitcoin and Block Chain.Performance Tuning & Daily maintenance of the Databases.DMS Migration DB's in Amazon RDSReplicationRedShift for encryptionBackup & Recovery of Databases.Performance… Show more BigData Solution (MongoDB) for BlockchainPL/SQL, Query Builder.Working on Amazon RDS & Transparent Data Encryption for MySQL & Oracle 11g with Key Management System.Extract Transform & Load data into main servers (Oracle, Maria-db, MySQL, Aurora Db)Development of Bitcoin and Block Chain.Performance Tuning & Daily maintenance of the Databases.DMS Migration DB's in Amazon RDSReplicationRedShift for encryptionBackup & Recovery of Databases.Performance TuningInstalling & Configuration & Implementation of Galera Cluster.Master / Slave Architecture with Galera ClusterChange data capture solution / Making DR for MariaDB.Business Intelligence Tool (Tableau) Application Development Show less

PL/SQL Query Tool Development. For (Oracle, Tibero, PostGreSQL, Hadoop, MSSQL, DB2) (www.raonsql.com)Development of ETL Tool. (mitsoft.kr)As a Sr. Database Administrator, I am Responsible for administration of 10 Oracle databases.Implementation, Monitoring and configuration of Shareplex CDC.Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment. Ongoing proactive database-level performance tuning… Show more PL/SQL Query Tool Development. For (Oracle, Tibero, PostGreSQL, Hadoop, MSSQL, DB2) (www.raonsql.com)Development of ETL Tool. (mitsoft.kr)As a Sr. Database Administrator, I am Responsible for administration of 10 Oracle databases.Implementation, Monitoring and configuration of Shareplex CDC.Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. Changes were made dynamically whenever possible to fulfill high-availability requirements. Implementation & Configuration and connect MSSQL server with Oracle. Replicated to a disaster recovery site for increased server manageability and availability. Implementing and maintaining database security (create and maintain users, roles and assign privileges) Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed. Monitored the production Oracle alert logs for database errors. Show less

Installation and implementation of the Oracle8.1.5 on Sun Solaris & Windows NT 4.0Manage the database for over 200G size.Implement the automated Hot Backup scripts for the Daily full backup. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. Changes were made dynamically whenever possible to fulfill high-availability requirements. Maintained standby databases, in both local and remote locations, for fail-over purposes… Show more Installation and implementation of the Oracle8.1.5 on Sun Solaris & Windows NT 4.0Manage the database for over 200G size.Implement the automated Hot Backup scripts for the Daily full backup. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. Changes were made dynamically whenever possible to fulfill high-availability requirements. Maintained standby databases, in both local and remote locations, for fail-over purposes. Replicated to a disaster recovery site for increased server manageability and availability. Implementing and maintaining database security (create and maintain users, roles and assign privileges) Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed. Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues. Expert with OEM Event and Job Managers, Change Manager, Diagnostics & Tuning Packs. Show less

Working in 24x7 production environment and provided on-call and day-to-day support.Installation and implementation of the Oracle81 on Linux 5 & Windows 2000 Server.Manage the database for over 75G size.Forms & Reports 6i Development.Requirement & Analysis of the system.Implement the automated Hot Backup scripts for the Daily full. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. Implementing and maintaining… Show more Working in 24x7 production environment and provided on-call and day-to-day support.Installation and implementation of the Oracle81 on Linux 5 & Windows 2000 Server.Manage the database for over 75G size.Forms & Reports 6i Development.Requirement & Analysis of the system.Implement the automated Hot Backup scripts for the Daily full. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. Implementing and maintaining database security (create and maintain users, roles and assign privileges) Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed. Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues. Expert with OEM Event and Job Managers, Change Manager, Diagnostics & uning Packs. Show less

System analysis and database design ERP (HRMS).Create scripts to load the data in to tables using SQL LoaderPopulation of database using SQL*Loader.Oracle SQL Query optimization.Evaluation on packages for higher performance using Explain Plan, sql*plus and tkprofPerformance analysis of different database objectsDevelopment of the front-end functionality Create various Stored Procedures and Database triggers