Transformational Minds

Pythagoras

Pythagoras

Pythagoras believed that mathematics was the root of all truth and the ultimate reality. Iamblicus, a later Pythagorean follower, quoted the master as saying “number is the ruler of forms and ideas and the cause of gods and demons.”

 

Numbers don’t lie. To understand and control your IT environment, you have to have measurable, accurate, reliable information.

Services
Database Support

IPsoft's supports the following major database platforms:

  • DB2
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • Sybase
Capabilities

Install and Upgrade Database Server

  • Configuration and maintenance of production database servers.
  • Coordination and implementation of database server upgrades and service packs. (Major Releases / Patches)
Configuration, Setup and Script Management
  • Setup, configure and write scripts/programs for all Database Server-related maintenance.
  • Monitor and preserve Database and Server health.

Analyze, Identify and Troubleshoot Issues in Production Databases

  • Investigation and in-depth research based on the type of issues.
  • Categorization of issues that pertain to known DB errors and bugs, or a newly encountered database problems related to any kind of processes that are running in production that require immediate resolution.
  • Provide immediate fixes for complex problem such as database corruption. Work closely with the database users, application developers and network administrators/engineers to provide direction in identifying and resolving production database issues.
Backup and Recovery Strategy
  • Implement backup and recovery strategy to support data replication and to provide high availability databases.
  • Perform continuous evaluation on other backup tools/methods to improve database availability.

Code Build and Release

  • Build and complete production code release and 2nd tier on call duties.

Replication Monitoring

  • Configure and monitor database replication on production servers to provide up-to-date data between servers.
Performance Monitoring
  • Analyze and monitor the performance statistics of production databases.
  • Review thresholds and capacity planning.
  • Perform trend analysis to end-up with the best forecast to prevent customer/user problems related to hardware, software and network functions.
Performance Tuning and Optimization
  • Perform all database related performance tuning and optimization as necessary.
  • Performing database cleanups and archives, reconfiguring DB’s default configuration, and other database tuning processes that help to improve the performance of the system.
Database Security Management
  • Manage database users and security by granting/revoking appropriate logins and permissions for individual users.
DB Disaster Recovery
  • Prepare code and document the step-by-step procedures on database Disaster Recovery in preparation for any catastrophic events.
  • Apply modifications from time-to-time in accordance to the changes that promoted in production through a release process on weekly basis.
  • Test the DR plan periodically on the Disaster Recovery Hotsite.
Third Party Tool Installation, Configuration and Evaluation
  • Evaluate, setup and configure third-party tools such as Database Scanner, CAST Application, Erwin/ModelMart, Veritas Backup.
  • Researching and testing new database-related products, tools and methodologies.
Security Auditing
  • Perform periodical audits on production databases of user rights.
  • Comply with named regulatory requirements.
Application Production Release and Staging
  • Perform DB portion of production and staging releases.