Sybase
-Maintenance Sybase databases more than 20 instances and total size around 10 TB
-Monitoring, data management and backup.
-Respond to resolve database access and performance issues.
-Export database and restore to support Tester and Configuration team
2. Application administrator
-Transfer configurations on Configuration database to Test system
-Upgrade Application.
-Application deployment
Accomplishments.
-Implement Nagios system on Linux platform to monitor and alert for Oracle database.
-Develop dos scripts to perform export/import data and create objects on Sybase for support end of day process
-Develop shell scripts to support daily database maintenance
-Consolidate Database servers with existing server
-Support Storage migration by move all databases to new storage
-Create shell scripts for automatic backup and restore database to support Report system
- Project leader of Oracle upgrade and migration project by upgrade from 9i version on Windows platform to 11gR2 (RAC) on Solaris platform
- Design Infrastructure for Server / Storage / Backup system / Data replication
- Planning and Coordinate with Vendor / System engineer / Application team / Users
- Develop documents to support project as Installation guide / Application flow diagram (server relation) / Control sheet / Instruction sheet / etc.
- Installation and configuration for Solaris / Oracle software (grid / database)
- Storage configuration
- Initial databases and data for Application testing before migration
- Data migration