Database Administration & Development

Data is becoming more and more an integral part of the technology landscape in nearly every organization.
DataHedron has the expertise of a broad range of relational and non-relational database technologies and can provide everything from a small OLTP design to a large data warehouse architecture.

  • check
    Oracle 9i – 12c
  • check
    Amazon Redshift
  • check
    MS SQL Server 2008 - 2016
  • check
    MySQL
  • check
    MongoDB
  • check
    ElasticSearch
  • check
    PostgreSQL
  • check
    DB2
  • check
    Informix


Data Integration

Extract Transform and Load (ETL) software used for aggregating, synchronizing, centralizing and migrating data across systems and databases has been recognized as a critical business process and has been proven as saving cost and increasing efficiency by eliminating scattered data.

  • check
    Oracle PL/SQL
  • check
    Microsoft T-SQL & SSIS
  • check
    Oracle ODI 11g & 12c
  • check
    Talend Data Integration
  • check
    Informatica PowerCenter 9
  • check
    Amazon Glue
  • check
    Pentaho Data Integration (Kettle)

Data Warehousing

Enterprise Data Warehousing are central repositories of integrated data from the operational data sources with the purpose of storing current and historical data in one single place to be made available for use by managers and other business professionals for data mining, online analytical processing, market research and decision support.

  • check
    Star Schema Modelling
  • check
    3NF
  • check
    Bitemporal Modeling​​​
  • check
    Data Staging and CDC mechanism
  • check
    ACID transactions: Atomicity, Consistency, Isolation, Durability

Business Intelligence

BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies include reporting, online analytical processing, analytics, data mining, text mining, predictive analytics; software which can be used by enterprises to support a wide range of business decisions - ranging from operational to strategic.

  • check
    QlikView
  • check
    OBIEE
  • check
    Oracle Reports
  • check
    Tableau
  • check
    Microsoft:  SSRS, Analysis Services, Power BI

Data Encryption

A custom data encryption process will use an algorithm to transform data stored in a database into "cipher text" that is incomprehensible without first being decrypted.
The process can be applied for the following scenarios:

  • check
    Implementation of VPD policies ( virtual private data )
  • check
    Encrypting PII data (Personally identifiable information )
  • check
    Environment setup for a Non-Production POC (Proof of Concept)

SysAdmin


Department responsible for the upkeep, configuration, and reliable operation of mission critical servers. Technologies ranging from Unix-like family ( RedHat, Solaris & HP-UX ) to Windows.


Get a free review of your data

Get in touch with us and let us know about any data issues your business is facing and we'll offer you a solution for free.

You can choose to work with us or to find someone else after that, no strings attached. We'll be happy to help.