Ability to support UDB running on SP2 and RS/6000 S70 and S80 computers using UNIX. Ability to complete database re-org's and backup plans and jobs. Experienced in developing plans to implement DMS tablespaces on raw devices. Ability to develop new logical and physical models for database applications, and experienced in writing and implementing database backup and space management utilities.
For one of the largest pharmaceutical services companies in the United States, performed data redistribution over 24 database partitions. This process improved data retrieval time from the 280 GB data warehouse database and improved overall system performance. Developed data loading programs and populated the data warehouse (Daily, Weekly, and Monthly) using: Optiload server DB2 autoloader utility DB2 import utility. Created Nodegroups, Tablespaces, and Containers. Enhanced and documented database backup and disaster recovery procedures, migrated remaining Sybase System 10 database data to UDB EEE data warehouse database, and shutdown all Sybase data Servers for Y2K company compliance. Provided primary DBA support. Documented corporate UDB EEE DBA daily routines and responsibilities.
API Consulting, Inc. provides the Highest Level of expertise in the industry. To learn more about how API Consulting, Inc. supports the high technology sector, choose from the following topics.
If you are in need of technology professionals to augment your staff or lead your software development projects, please contact an API staff representative at: info@apiconsulting.com