Saturday, May 13, 2023

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


: : : : :


Thursday, May 11, 2023

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


: : : : :


Tuesday, May 9, 2023

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


: : : : :


Monday, April 24, 2023

Make Access Databases Perfectly With Optimized Forms And Reports With Vba











About:

Hello there, this is Techmasteroj.



I will design the perfect access database for you with the capability of using custom VBA to enhance the functionality of your database. Long story short, whatever you imagine, I will make it possible for you with VBA.



My services include:

  • Access Database Design
  • Access Database Optimization
  • Schema Design
  • Access CRUD Operations
  • Access UI/UX Design
  • Creating user-friendly interfaces
  • Reports and Dashboard
  • Custom VBA integration



These are just some of the services I can offer. Any other idea or problem that comes into your mind. I will help you in solving the problem with patience and determination.



Now, what are you waiting for? Come into my inbox and let's talk about your project and find the fairest price point for it.



Don't hesitate to contact me. I won't bite. :D



Have a great day.



Best Regards,

TechmasterOJ

Reviews


: : : : :


Friday, April 21, 2023

Erd, Er Diagram, Sql, Mysql, Oracle Queries And Database Tasks, Projects











About:

Greeting,

If you are looking for an expert on Database design and queries, then you are in the right place. Please contact me to get the best deal at a reasonable price. i can do erd, er diagram, sql, mysql, oracle queries and database tasks, projects



My Services :

  • Write New Query
  • Database Optimization
  • Database Normalization
  • Database Design & Development
  • The physical implementation of the database.
  • Query Optimization
  • SQL, MYSQL, SQL lite queries
  • Database or Schema Designing
  • Database Programming
  • tables creation
  • All Database queries
  • functions 
  • triggers
  • procedures
  • Normalization
  • SQL, MYSQL injections
  • SQL, MYSQL complex queries
  • ER diagrams and Schemas
  • SQL, MYSQL Database Development 
  • Relational Algebra queries



I like to work in the following databases:

  • Microsoft SQL server
  • MySQL
  • Oracle
  • MS Access

Client satisfaction is my 1st priority, without hesitation please contact me we will sort out any type of problem.



IF you need any help, please inbox me before order, so we can negotiate a valuable work for you.



Thanks

Reviews


: : : : :


Wednesday, April 19, 2023

Merge Excel Tables From Multiple Files By Vlookup











About:

Hi,

In this gig i will provide a VLOOKUP service using excel formulas.



Buyer/Client must provide me with the source files in which atleast one column matches exactly.



Buyer/Client shall ask for a single matching column or multiple columns.



Buyer/Client do consult me before purchasing the gig so we can discuss about the project and get the desired results in an accurate fashion.



Many Thanks, Looking forward to working together.

Reviews


: : : : :


Tuesday, April 18, 2023

Mongodb, Neo4J, Sql Tasks











About:

I will do your all tasks related to databases Neo4j,Mongodb and Sql

which includes:



MongoDB:

  • Design json schema for mongodb according to your requirements.
  • Design complex queries for mongodb, aggregation pipeline and map reduce functions.
  • Triggers and joins for mongodb tables.
  • importing data into mongodb clusters.
  • Crud operation for mongodb
  • mongodb Integrations with python, node.js, java , .net platforms

Neo4j:

  • Import csv, xlsx, json and other formats to Neo4j.
  • Write Cypher queries for you.
  • Crud Operations for Neo4j
  • data science and visualization of neo4j data
  • migration from and to neo4j to sql, mongodb and others.
  • Neo4j integration with python, nodejs, java , .net



SQL:

  • Design erd of database according to your requirements.
  • Design sql queries for you
  • write sql triggers and procedures of sql database
  • migrate sql database to others



I will do all these tasks according to your requirements in minimum time

feel free to contact in case of any question or query. I will be glad to answer your queries

.



  • PLEASE CONTACT ME BEFORE PLACING ORDER.

Reviews


: : : : :