Support Install Oracle Database Ha Services Your Remote Dba

About:

Hi

Be peace upon you brother.

I am Offering the following viable Oracle DBA support and services having 10+ years of experience.

Database installation:

• Both in Windows and LINUX
• PFILE/SPFILE file tuning
• User creation, privilege assigning, role segregation
• Automated solution with script to perform scheduled tasks using BATCH/BASH, SHELL With SQL File using crontab & oracle schedule job.
• Binary Version: 11g/12c/19c

High Availability (HA) services:

• Oracle Active Data Guard (ADG) RAC to Single Instance or RAC to RAC with automatic Storage Management (ASM)
• Physical Standby for data integrity, availability and replica purpose
• Logical Standby for reporting purpose
• Snapshot Standby for RND and UAT purpose
• Real Application Clustering (RAC)
• Oracle ASM Cluster File System (ACFS) feature.
• Two nodes/Three Nodes

Backup & Recovery:

• RMAN & Logical DUMP backup
• Exp Impdp Expdp backup
• RMAN complete recovery
• Setting up Backup and Disaster Recovery policies
• Point in recovery
• Recovery from SCN

Oracle Golden Gate (OGG)

• Replication for (Business Intelligence) BI, Machine Learning, MIS reporting Purpose.

Security Services:

• DV, AVDF, TDE, OKV, OEM configuration

Diagnostic Services:

• ADDM AWR Report Analyze

Reviews

: : : : :

Design Database, Data Mining, Data Warehouse And Sql Queries

About:

I will provide the dimensional model for DWH as per provided requirements, and also initial draft of ETL / ELT process for loading the data from source systems to DWH. 

I will provide Data Mining and Visualization on any data or data connected to Data Warehouse.

I will also provide ERD and normalization for databases and work on queries with MySQL ,MS SQL, MongoDB, Oracle and PostegreSQL.

Reviews

: : : : :

Build Your Ssis Packages, Etl And Complex Tsql Query

About:

I will provide a complete solution for developing a SSIS ETL package in Visual Studio which will include:

Data integration from different sources (Excel, CSV, SQL Database etc.)

Data transformation steps (Joins, Lookups, Aggregation, Condition Split, Union All, Sorting, Data Capture etc.)

Loading /Movement/Storage of data at different sources (Databases, CSV, Excel etc.)

Furthermore, I'll also help to improve ETL performance and write SQL queries.

I have experience of working on the implementation of the architecture of data warehouses and the development of Power BI Dashboards using the existing architecture

The solution will be complete and final according to the client's requirement which will be helpful in creating a data warehouse.

Being punctual and honest, are one of my most priorities. I assure to deliver with the given time.

Reviews

: : : : :