DATABASE SERVICES - SQL & ORACLE

---

• Migrate older version database to Newer version
• Do in-place upgrade database without affecting the existing harware resources
• Move Databases from old server to new server setup
• Move Database Servers from old data centre to new datacentre
• Personalized Customer Requests also will be dealt in efficient manner

• Configure and Setup High Availability using one of the options -
• 2 node/3 node cluster setup
• Database Mirroring
• Transactional Replication
• Always ON
• SRM setup
• SAN Replication setup
• DATA GUARD
• GOLDEN GATE
• RAC
• SAN REPLICATION
• Customized User Request/Setup

Resolve day to day performance issues-

• Top 10 expensive queries
• Identify long running queries
• Dead lock queries
• Analyse existing stored procedures and resolve any bottle necks
• Implement best practices
• Personalized Customer Requests also will be dealt in efficient manner

• Identify and close any open ports
• Close all the loop holes to prevent database being hacked and protect any data
• Implement best industry standard and procedures to safe guard the database

• Perform regular health checks
• Verify Data, Log, Temp drive sizing
• Database growth allocation
• Verify daily/weekly backups

• Migrate local databases to cloud services
• Keep your historical data in Cloud for Global access