
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)