Mission


DBA Sybase provides help and consulting services considering Sybase ASE issues and provides Sybase ASE solutions, as well as SQL Server, Oracle and MySQL, remotely or on Your site.

Platforms

  1. HP-UX
  2. Tru64
  3. Windows
  4. Solaris 10
  5. Linux

Sybase ASE & RS Servers specialities

  1. Sybase ASE 12.5.1
  2. Sybase ASE 12.5.3
  3. Sybase ASE 15.0
  4. Sybase ASE 15.7 ESD 1
  5. Sybase ASE 15.7 ESD 3
  6. Sybase Replication Server 15.2 ESD 2
  7. Sybase Replication Server 15.7.1

Services

DBA services
  • Sybase ASE server installation
  • Sybase ASE client installation
  • Sybase ASE server configuration
  • Sybase ASE server upgrade
  • backup/restore procedures
  • database creation and configuration
  • user policy management
  • Disaster recovery (DR) and Standby (SBY) procedures, installations and configurations
Migration services
  • planning and migrating databases from one Sybase ASE version to another
  • planning and migrating databases from one platform to another
  • planning and migrating databases between Sybase ASE and other databases, and vice versa
  • designing Extract-Transform-Load (ETL) processes
Database development
  • problem analysis, logical and physical database design
  • writing DML and DDL scripts
  • writing stored procedures, triggers, views
  • T-SQL
Database and server optimization and performance tuning
  • queries optimization
  • indexes optimization
  • detecting deadlock problems
  • detect bottlenecks in all levels (hardware, network, server, database, queries, indexes, locking...)
  • response speed up
  • MDA tables
Teaching and introducing Sybase tools
  • teaching staff for using Sybase tools
  • teaching Sybase ASE basics
  • instructing less experienced staff in installing Sybase clients and servers and helping them learn restore/backup procedure and other daily tasks
Other database consulting services
  • Oracle 7.3, 8i, 10g, 11g, XE, installation, administrarion, PL/SQL development, SQL Loader,
  • Microsoft SQL Server 2008 R2, SQL Server 2012 installation, administration, T-SQL development, assemblies, Microsoft SQL Server Reporting Services(SSRS) installation and development
  • Access, Firebird, SQLite, MySQL
   
  powered by myself. DBA-Sybase 2006