Posted by on September 16, 19101 at 23:59:41:
Sybase Job Description
q Installation of Sybase ASE on to UNIX system
o Design and setup Sybase ASE Environment for UNIX
o Understand Sybase System Databases
o Concern and setup Sybase Devices
o Update User / Group Account for Sybase ASE Users
o Control Start / Stop Sybase ASE server processes
o Installation of Sybase ASE EBF Patches
o Setup Character Set and Languages
q Analyse Sybase Problems
o Understand which log files should be checked
o Analyse the Sybase Problems by Error Number and Messages
o Investigate Blocking processes
o Investigate Query Plan for SQL Sentences
q Configure Sybase Servers’ Parameters for Performance Tuning
o Understand to setup Memory Size for the Sybase ASE server
o Understand to setup Data Cache and Memory Pool for the Sybase ASE server
o Understand to setup Number of User Connections, Number of Locks, Worker Processes
o Understand to setup for the Multi Processor system
o Monitor the Sybase ASE with sp_sysmon
q Maintenance for User Database
o Estimate Sybase User Database size
o Arrangement for the transaction log devices
o Create Database / Alter Database / Drop Database
o Understand the system tables for Database Allocation
o Understand and Setup Database Options
o Management Database Segments, and Setup Database Threshold
o Check the Database Consistency and Object / Index Allocation
q Dump Database / Load Database
o Understand to use Dump and Load Database Command
o Schedule for the User Database Backup
o Plan to take the Transaction dump for User database
o Recovery of Database
o Understand Start / Stop Backup Server
o Understand Remote Backup and Remote Restore
o Dump / Load for Huge database
o Log Truncation for User Database
o Understand Cache bind for User Database
q Installation of Sybase async Replication
o Understand ID Server and Replica Servers
o Understand how to use rs_init and resource files
o Understand Start / Stop Replication Servers
o Start / Stop Replication Agents for each databases
o Management for RSSD database
o Understand Quiesce of Replication
o Setup Route between Replication Servers
q Database Connections
o Setup Maintenance user login for User Database
o Create / Drop Database Connection
o Setup Database Agent on each User Databases
o Check DSI Thread for each User Databases
q Replication Definition
o Create /Update / Delete Replication Definition for each User tables
o Setup Mark for replication to each user tables
o Setup Publication
q Replication Subscription
o Understand Materialization (Atomic, Non Atomic, Non, Bulk )
o Create / Update / Delete Subscriptions for each Replication Definitions
o Setup Publication Subscription
q Replication Function
o Create / Update / Delete User Function
o Understand Function Class
q Setup Replication Warm Standby
o Understand and Setup Logical Connection and Physical Connection for database
o Understand and Setup Active database and Standby Database
o Understand dump marker for Setting up Warm Standby Replication
o Understand how to Monitor Warm Standby Replication
q Performance Tuning for Replication
o Management of Stable Queue
o Management of DSI Thread
q Error and Exception
o Setup Exception function in the errorlog file
o Management for Server Error
q UNIX User Skill
o Understand and Write UNIX Shell Scripts
o Understand and Write Perl Scripts