• Database Design :
  • Schema design.
  • ERD - entity relationship diagram.
  • Logical design and Physical design.
  • Normalization of Tables.
  • Escorting programers team and systems analyst.

Top

• Tuning :
  • Designing Locking and Concurrency strategy.
  • Snapshot Monitoring and Event Monitoring Techniques.
  • Tuning Database Parameters.
  • Server Performance Monitoring.
  • SQL Monitoring & Tuning .
  • Explaining different logs.

Top

• Installation and Configuration :
  • Installation of Databases on different platforms.
  • Resolving the Installation issues for better performance.
  • Capacity Planing.
  • RAC installation.
  • Upgrades.

Top

• Backups and Recovery :
  • Proven backup strategies.
  • Proven recovery strategies.
  • Automated scripts for all backups and recoveries.

Top

• Analysis Report :
  • Through automated scripts, we will maintain a close watch on all aspects of database functionalities like Bufferpool Monitoring, Tablespace monitoring, on different configuration parameters, hit ratios...etc.
  • Automated Reports will be generated and sent to concerned people

Top