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.