SUMMARY

• An accomplished Database Administrator with extensive experience with success in designing and implementing database solutions.
• Possess diversified technical background with both Stand Alone and Enterprise System.
• Especially effective in setting up and configuration and monitoring of Oracle databases and SQL server databases.
• Have strengths in large scale Oracle and SQL Server database implementation and support

TECHNICAL SKILLS

HARDWARE: IBM (P60, P90), (Sun v210, v220, v440), Dell Server

SOFTWARE: Oracle (7/ 9/ 8/ 10/ 11/ 12), Oracle 10g RAC, Oracle Exadata 11g, SQL Server (7/ 2000/ 2008/ 2008 R2), Oracle RMAN backup/recovery, Oracle SQL Developer, SQL Server Console

OPERATING SYSTEMS: Red Hat, SUSE, Oracle Linux, Sun OS/x86, Windows (2000/ 2003/ 2008 ) Windows (XP/ Vista/ 7/ 8/ 10)

LANGUAGES: C/C++, PL/SQL, Transact/SQL. Java/ JSP, Unix/ Linux Scripting, ISQL, PowerShell

PROFESSIONAL EXPERIENCE

Confidential

Oracle Develoer

Responsibilities:

• Upgrade Oracle databases from Oracle 11g to 12cR2.
• Help with the upgrade of SAP database from 11g to12cR2 this included moving the databases from file base to ASM
• Managed Database system user security users.
• Review and upgraded shell scripts for rman, re - indexing, monitoring. Help developed upgrade scripts for SAP oracle database.
• Installed and Configured Oracle GRID on 12c2 and intergraded it with on call paging. .
• Install and set up the Oracle database on Red Hat.
• Help migrate the SAP database from one data center to a new datacenter using stand by databases with manual log shipping. This was due to the network traffic and size of the database. 100gig up to 35trb
• Help to create a Perl script to install oracle SAP image on new VM for the migrations. This script verifies all the perquisite needed and security setting where set. It also check and verify that ASM disks where created and the user was able to access it. It applied SAP patching and also register the new server in OEM13c. This system also created a empty database ready to be set up for backups and migration. This script took a half a day process down to 2hrs and able to do multiple servers at one time.
• Microsoft SQL:
• Managed Database Users and Security.
• Import of data from several data sources, using DTS, BCP, and ETL.
• Created several SQL Alerts/Monitor T-SQL scripts and Procedures to send out emails and or beeper messages in case of sever/database errors. Upgraded scripts to use powers shell
• Executed SQL statements using profiler to make sure the SQL was as efficient as possible.
• Reviewed the database system resource usage and design to see if any object could be causing performance issues and correct the problems.
• Configured and manager several virtual servers using Windows 2008 for use with SQL Server 2008.
• Support:
• Database Disaster Recovery
• Database SQL scripts checked in to Version Control for recovery.
• Database server conversion from SQL to Oracle.
• Performance tune SQL statement for Oracle/SQL.
• Reviewed the database design to see if any normalization errors which might be causing performance issues and correct the problems
• Created backup daily backup reports with OEM 13c

Confidential

Oracle Develoer

Responsibilities:

• Upgrade Oracle databases from Oracle 8i, and Oracle 9i to Oracle 10g and to 11gR2.
• Help with the upgrade of SAP database from 9i to 11gr2
• Managed Database Users and Security.
• Import of data from several data sources, using imp/exp and Datapump.
• Converted Oracle databases to us netback and rman scripts so that there was a standard backup policy for the databases.
• Created several shell scripts to execute maintenance scripts for rman, re-indexing, monitoring.
• Installed and Configured Oracle GRID on 11gr2 and intergraded it with alarm point for on call paging. .
• Install and set up the Oracle database on Red Hat and SUSE Linux environment.
• Help setup and administrate a 4 node Exadata server on Red Hat Linux
• Microsoft SQL:
• Managed Database Users and Security.
• Import of data from several data sources, using DTS, BCP, and ETL.
• Created several SQL Alerts/Monitor T-SQL scripts and Procedures to send out emails and or beeper messages in case of sever/database errors. Upgraded scripts to use powers shell
• Executed SQL statements using profiler to make sure the SQL was as efficient as possible.
• Reviewed the database system resource usage and design to see if any object could be causing performance issues and correct the problems.
• Configured and manager several virtual servers using Windows 2008 for use with SQL Server 2008.
• Upgraded several database from SQS 7 SQL2000 to SQL 2008 and SQL 2008r2, also created several linked servers to talk to Oracle databases from 8i to 11gr2
• Help Move the backup from Redgate to use NetBackup
• Support:
• Database Disaster Recovery
• Database SQL scripts checked in to Version Control for recovery.
• Database server conversion from SQL to Oracle.
• Performance tune SQL statement for Oracle/SQL.
• Reviewed the database design to see if any normalization errors which might be causing performance issues and correct the problems