Managed Oracle database administration assignments on various projects for the Systems and Applications department . Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements. Key projects:• Installed the Oracle software, versions 10g and 11g, and SQL Server 2005 and 2008 on department servers.• Served as DBA in the completion of several medium- to large-scale implementations, managing database.• Backup, disaster recovery. • Restore, import/export and copy data among different databases or servers.• Migrate databases. • Maintained development, testing and production databases, logs and journals. • Performance Tuning and monitor resource use.• Ensured data integrity, availability and confidentiality.• Managed a $9 million data-integration for an electronic medical records project that consolidated information from medical applications, third-party market data and internal applications.• Used MS SSIS package to build data flow jobs. SSRS Package to do report and SSAS. • Database Replication and Mirroring. • Analyzed SQL Server Instances, Databases and Queries.• Developed, tested and managed storage strategies and disaster-recovery plans for applications continuity. • Designed and developed data models as well as moved data models between databases.• Create databases, use the diagramming techniques to design and develop data models.• Setup Database Mail.

Managed database administration assignments on various projects for the Systems and Applications department. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Key Projects:• Installed the Oracle software, versions: 7, 8i, 9i, 10g and 11g; SQL Server versions: 2005 and 2008.• Operating systems: Sun UNIX, Linux Unix, IBM AIX 5L, Window and Window NT.• Backup, disaster recovery. • Upgraded the databases.• Built new Oracle databases.• Migrated the databases between different servers.• Performed database backup using RMAN and natural OS tools. Hot backup and cold backup. Full system files backup. • Restore, import/export and copy data among different databases or servers.• Maintained development, testing and production databases, logs and journals. • Performance Tuning and monitor resource use.• Ensured data integrity, availability and confidentiality.• Used MS SSIS package to build data flow jobs. SSRS Package to do report and SSAS. • Database Replication and Mirroring.• Analyzed SQL Server Instances, Databases and Queries.• Developed, tested and managed storage strategies and disaster-recovery plans for applications continuity. • Designed and developed data models as well as moved data models between databases.• Create databases, use the diagramming techniques to design and develop data models.• Setup Database Mail.• Performed Database Performance Tuning.• Monitored databases. Check Alerts (Job failures, database & server capacity, etc.). Set Cron Job.• Specific NASA support:o Added or deleted user into the database. o Fix the sequence number of users.o Created and updated tables for users.o Created database and table structures.o Managed user privileges to users.• Installed Oracle Critical Patches (such as CPUJan2008, CPUApr2008, CPUJul2008 and CPUOct2008) on Unix Servers• Convert data from Access format to other data format.

Managed database administration assignments on various projects for the Systems and Applications department. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Key Projects:• Installed the Oracle software, versions: 7, 8i, 9i, 10g and 11g; SQL Server versions: 2005 and 2008.• Operating systems: Sun UNIX, Linux Unix, IBM AIX 5L, Window and Window NT.• Backup, disaster recovery. • Upgraded the databases.• Built new Oracle databases.• Migrated the databases between different servers.• Performed database backup using RMAN and natural OS tools. Hot backup and cold backup. Full system files backup. • Restore, import/export and copy data among different databases or servers.• Maintained development, testing and production databases, logs and journals. • Performance Tuning and monitor resource use.• Ensured data integrity, availability and confidentiality.• Used MS SSIS package to build data flow jobs. SSRS Package to do report and SSAS. • Database Replication and Mirroring.• Analyzed SQL Server Instances, Databases and Queries.• Developed, tested and managed storage strategies and disaster-recovery plans for applications continuity. • Designed and developed data models as well as moved data models between databases.• Create databases, use the diagramming techniques to design and develop data models.• Setup Database Mail.• Performed Database Performance Tuning.• Monitored databases. Check Alerts (Job failures, database & server capacity, etc.). Set Cron Job.• Specific NASA support:o Added or deleted user into the database. o Fix the sequence number of users.o Created and updated tables for users.o Created database and table structures.o Managed user privileges to users.• Installed Oracle Critical Patches (such as CPUJan2008, CPUApr2008, CPUJul2008 and CPUOct2008) on Unix Servers