Database Management and Data Cleansing

• Task Automation - Scripting of database tasks & jobs, such as export/import and database duplication.

• Performance Optimization - Instance efficiency, resource utilization, load distribution, wait statistics, SQL optimization.

• Change Management - Task requests, detailed planning, scheduling, testing and rollback procedures.

• Object Management - Creating, modifying and removing of objects, and other object-level tasks

• Backup & Disaster Recovery - Configuration of backups, regularly scheduled recovery testing and verification.

• High Availability - Maintenance of database clusters, log shipping, standby database & replication.

• Capacity Planning - Statistics gathering, trend analysis & detailed status reporting.

• Data Protection - Management of backups, block-level replication and standby database for disaster recovery to private or public Cloud hosting.

• Software Management - Application of minor and major release upgrades and patches to the database software.

• Data Conversion - Convert existing data in different database format including embedded logic like stored procedures, triggers, etc.

• Database formats supported:

      Oracle RDBMS

      IBM DB2

      Altibase

      Microsoft SQL Server

      SAP Sybase ASE

      Teradata 

      ADABAS

      MySQL

      Microsoft Access

      Informix

      SQLite

      PostgresSQL

      AmazonRDS

      MongoDB

      Redis

      CouchDB

      Neo4j

      OrientDB

      Couchbase

      phpMyAdmin

      Seqel PRO

      Robomongo

      DbVisualizer

      Hadoop HDFS

      Cloudera

      MariaDB

      Informix Dynamic Server

      4D (4th Dimension)