Databases administrator
Oracle
• Maintenance Oracle databases 10 instances and total size around 5 TB
• Create instances, monitoring, data management, backup/restore and performance tuning.
• Respond to resolve database access and performance issues.
• Export/Import schema from Production to Development / UAT server for Application team and Tester
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
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