Chronological Summary of Experience

Confidenital

Sr. Oracle DBA

• Migrated 700GB SQL Server 2008 database to Oracle 11g RAC databases on dual Oracle/LINIX T1000 enterprise servers.
• Set-up Oracle OFA Grid Control and CRS , enrolled users configured advanced security access policies on restricted schema objects and DML changes implementing stored procedures, and Oracle Advance Security SSL Secured Socket Layer TDE Transparent Data Encryption.
• Configured and managed RAC environment SSH/CRS/Votingdisks/OCR/SCAN/network on ASM disks groups. Set-up and managed ASM disk groups implementing ASMCA/ASMCMD.
• Configured RMAN catalog, backup/recovery run scripts for Oracle 11g RAC databases, resolved data block corruption implementing data recovery advisor.
• Performance tuned SQL queries implementing AWR, ADDM, SQL, PL/SQL profiling.
• Monitored Oracle 11g 11.2.0.3 RAC implementing Grid Control provided remote log-in support.

Confidenital

Sr. Oracle Development DBA Consultant

• Responsible for development 10g/11g RAC databases, based on Clear Quest ticket system and emails from senior management. Performance tuned SQL queries stored procedures monitored 10g, 11g implementing AWR/ADDM, and Grid Control.
• Implemented stored procedures, packages for data scrubbing of pertinent patient health care record information.
• Refreshed data implementing data pump, resolved job issues implementing TOAD, resolved RMAN backup issues, insured backups completed as scheduled restored databases.
• Provided support on Data Guard/Streams issues on development/production databases.

Confidenital

Sr. Oracle DBA Consultant

• Migrated 1 TB Oracle 10g r2 database to Oracle 11gR1 RAC database on dual RHEL AS 5.0 LINUX T1000 servers.
• Configured Oracle 11g R2 grid control, RMAN catalog, managed backup/recovery/data block corruption issues.
• Performance tuned SQL queries implementing AWR/ADDM/SQL profiling from issues with in house applications.
• Implemented Oracle Data Guard for new 11g environment. Provided production support.

Confidenital

Sr. Oracle DBA Consultant

• Migrated 700GB SQL Server 2005 database to Oracle 10g RAC databases on dual HP Proliant DL 585 G5 servers.
• Set-up Oracle OFA Oracle Flexible Architecture. Enrolled users configured Oracle advanced security TDE schema objects. Performance tuned SQL queries implementing AWR, SQL profiling.
• Configured RMAN catalog backup/recovered Oracle databases.
• Set-up, and managed/resolved Data Guard issues.

Confidenital

Oracle DBA Consultant

• Migrated, 3 TB Oracle 9.2.0.4 to 10.2.0.4 production database using data-pump. Installed Oracle 10g RAC production/development databases on IBM Prower6 servers, worked with system administrators on raw device architecture set up/managed ASM disk groups.
• Installed grid control, CRS , OCR voting disks on two node IBM Power6 RAC cluster. Resolved Oracle 10g RAC tuned SQL quires implementing AWR and user request tickets from IBM Clear Quest based on severity. Provided production support for Oracle 10g 10.2.0.4 RAC , and Oracle data warehouse.
• Architect Mount Sinai 30 TB Data Warehouse Oracle 10.2.0.4 database applied patches. Installed Business Objects Data Integrator, Metadata Manager, First Logic on Microsoft 2003, IBM AIX 5.3 L servers. Created users, security policies for Business Objects tools Webi, Data Integrator and Data Insight.
• Interacted with developers on Business Objects ETL tools scheduling of data loads and Crystal Reports OLAP cube reports.
• Configured RMAN catalog and reedited VERITAS Net backup scripts for RAC 3 TB production databases, Implemented RMAN PL/SQL, KRON Shell scripts for backup/recovery for Oracle 10g RAC production/development databases. Provided full production support.

Confidenital

Oracle DBA Full-Time

• Supervised Oracle 10g 10.2.0.5 and 9i 9.2.0.4 production database migration to new LINUX servers for corporate office. Provided full production support for ten Oracle 10g 10.2.0.3 2 3 TB databases and five 800 GB to 1-1/2 TB Oracle 9i R2 databases.
• Updated existing logical/Physical data-model for new Oracle 10g 10.2.0.3 OLTP 2 terabyte database implementing All-fusion Erwin Data Modeler r7.
• Set-up and installed Oracle 10g 10.2.0.3 RAC on Red-Hat Enterprise Linux R4 update Kernel version 2.6.9-34. 64 bit four node cluster. Set-up ASM ASMLIB library drivers CRS OCR voting disks applied patches tuned SGA and partitioned tables. Deployed Oracle Streams on the new Sun/Solaris 9 environment. Managed Streams environment.
• Monitored and troubleshoot capture processes repositories rule based transformations rules. Configured Netbackup backup and restore scripts, for production 10g R2, 9i R2 databases. Reconfigured RMAN catalog on production VMS P, MCEC and CCPROD SSOPROD, databases on three four node clusters. Integrated Oracle RAC databases to Grid control for enterprise monitoring.
• Restored Oracle 9i R2 and 10g R2 two terabyte databases to new four RAC node cluster implementing transportable sets. Wrote backup and restore RMAN PL/SQL, KRON scripts. Managed RMAN recovery catalog backup/recovery issues.

Confidenital

Sr. Oracle DBA Consult

• Migrated Microsoft SQL Server 2005 to Oracle 9i RAC on four node Red Hat AS 4.0 Linux cluster s setup ORS provided full production support.
• Configured Netbackup RMAN backup/recovery scripts for three 1 TB Oracle databases.
• Set-up RMAN catalog configuration parameters, backup/restore procedures applied Oracle patches to 9i, 9.1.0.2 10g 10.1.2.0.1 production databases.
• Configured, managed Data Guard Oracle for 9i RAC production environment.
• Performance tuned SQL, PL/SQL procedures.

Confidenital

Oracle DBA Consultant

• Responsible for DB2 database migration and deployment of Oracle 8.1.7, distributed database system on Sun/Solaris7 E5500 servers. Designed logical and physical data-model for Oracle 8.1.7, using ERwin.
• Developed and deployed embedded SQL statements stored procedures for GTR, SEC financial applications. Worked with system administrators on raw devices, RAID, SUN Storage-edge A5200 disk array storage file system implementing VERITAS. Revised capacity plan for E Commerce in house application. Performance tuned Oracle 8.1.7 production databases and GTR applications.
• Managed Oracle HA using OEM jobs and RMAN for hot/incremental backups, UNIX/OS file system backup scripts and SQL Back - Track. Monitored Oracle environment using BMC Patrol DBx-ray and PL/SQL scripts.
• Worked closely with developers on GTR application Oracle 8.1.7 production/development database data types schema objects and space management.
• Responded to production/development issues provided full production support.

Confidenital

Sr. Oracle DBA Consultant

• Responsible for the Microsoft Access to Oracle8i database migration. Prepared purchase justification reports for software and hardware. Estimated capacity planning using ERwin designed logical and physical data - model for thirty table definitions for Oracle 8.1.7 production/development databases and vendor applications.
• Identified database performance issues preformed tuning and capacity planning, on production databases. Worked closely with the System Administrators on UNIX file system space and hot backup issues.
• Upgraded Oracle 8i 8.1.7 production databases provided full production support. Train staff on backup and recovery procedures documented environment managed two Oracle database administrators and two developers.

Confidenital

Oracle DBA Full-Time

• Provided full production support performance tuning, and troubleshooting database issues. Performed hot and incremental backups on Oracle Parallel Server OPS dedicated databases using RMAN.
• Supported application developer issues on database requirements, sizing tables, schema objects. Resolved replication issues deferred transactions mis-queues pushes created SQL monitoring scripts for master sites snap - shots, used API management tools.
• Worked closely with Allied Consultants dba team to install Oracle Parallel Server OPS and replication on dual Sun/Solaris E5500 servers rebuilt all schema objects after migration. Worked with developers on TCAM foreign exchange application designed foreign exchange database tables. Interacted with NYSE AMEX foreign exchange data center batch processing procedures trading deadlines end of the day batch jobs.
• Supported two 2 terabyte databases implemented security procedures. Built environment Oracle Financial sales and reports applied SQL scripts and patches created concurrent managers for Human Resources employee resources, employee salaries, inventory sales, securities, result sets flex - fields for accounting, and inventory departments. Managed one Oracle database administrator one developer consultants.

Confidenital

HP/UX/Solaris/IBM/AIX Systems Administrator

• Built four HP/UX 9000 K 420, servers. Implemented backup and recovery procedures added users capacity planning. Provided full-time production support for ten IBM R/S 6000 severs applied patches upgrades. Installed network desktop computers, bay network hubs, and routers implemented KRON Shell scripting for various issues.
• Attended training classes for registration applications, attended meetings, capacity planning, documented the environment.