Oracle Sql Server

Ramoncito Sanchez

Princeton, NJ C: 646-***-**** **********@*****.***

Database Administrator

Experienced Oracle database professional with over 15 years experience in end-to-end implementations of Oracle databases and applications; well-rounded analytical and relationship skills enhance hands-on technical expertise to deliver stable Oracle environments with optimum uptime, responsive performance, solid data protection, and high availability.

•Oracle 8i to 12c

•Oracle 11g Grid Enterprise Manager

•SQL Query Tuning and Optimization

•Performance Tuning – Database and OS

•AWR, ASH, and TKProf Analysis

•PL/SQL Programming and SQL scripting

•Partitioning for Multi-Terabyte Databases

•Oracle Data Guard – Setup and Administration

•Oracle Materialized Views

•Oracle Streams - Peoplesoft

•Data Migration

•AIX and Red Hat Linux

•SQL Server 2005, 2008

•Backup and Recovery – RMAN, TSM, OS scripts

•SAP Oracle Tools – brconnect, brbackup, brarchive

•Oracle Install, Upgrades and Patching

•UNIX Scripting

•Disaster Recovery

•Business Objects and IQ Reportwriter Reporting

•Business Basic (BBX) programming language

Summary

•Tested and trusted technologist with over 15 years of hands-on Oracle database and applications implementation experience in very large enterprise environments.

•Lead DBA on SAP AFS, BW, and XI implementation: install and configure SAP databases, perform database refreshes, data migration from legacy systems using staging databases and flat file integration, performance-tuning.

•Extensive experience in design and operational maintenance of very large Oracle databases.

•Solid performance- tuning: os, system and sql optimization including AWR, tkprof, statistics, OEM

•Position of Trust Government security clearance.

•Effective communicator: excellent verbal, superior writing skills

•Backup and Data Protection experience: RMAN, os-scripts, and 3rd party tools as Commvault, Tivoli., and Avamar

•Implementation of JD Edwards OneWorld Financials scoping infrastructure, Oracle database, and the JDE application

EMPLOYMENT HISTORY

•11/20015 – June 2016 – Metlife, Inc., Global Technology Operations, Cary, NC – Senior Oracle Database Administrator

oEnd-To-End implementations of Oracle environments from capacity planning, server specification builds, Oracle Data Guard disaster recovery, security, production readiness, performance tuning, backup and recovery, disaster recovery, high availability, replication, production implementation through decommissioning.

oOversee or complete all Oracle-based application deployments.

oPerform production-readiness such as validation of backups; restore database exercise; test of failover, completion of hardening checklist.

oUpgrade to release 12c and Red Hat from 11g and AIX.

oImplementation of partitioning strategies to tune multi-terabyte data marts.

oConfigure and monitor Oracle streams between Peoplesoft databases.

oPerformance-tuning of SQL Queries

oStandardisation of Oracle Database Administration Procedures.

oResource and Capacity Sizing – CPU, RAM, Disks.

oDevelopment and Oversight of Project Plans in collaboration with Application teams.

oProcess-oriented, standardization of procedures; leveraged corporate tools such as Maestro, BMC Patrol, and BMC Remedy to complete project goals.

oResponsible for several Oracle databases supporting 24/7 critical corporate applications.

oUpgrade planning to Oracle 12c and AIX to Red Hat Linux.

oPosition of Trust Government security clearance.

•9/2015 – 11/2015 – Allergan Pharmaceuticals, PLC, Parsippany, NJ – Enterprise Database Engineer

oPerformed data migrations, refreshes, duplication of large Oracle databases supporting the organization’s SAP Globalization Project.

oBuild, install, and configure databases for new applications.

oCreated unix scripts to supplement database monitoring and alerting.

oWrite Unix scripts for database refreshes using RMAN.

oConfigure RMAN backups; diagnosis and troubleshooting.

oOff-hours support to offices out of the US Time Zone.

•10/2001 – 08/2015: Nine West Group (Formerly The Jones Group, Bristol, PA –DBA

oOverall responsibility over 100 Oracle and Microsoft SQL databases covering installation, configuration, data protection, security, performance optimization, patching and upgrades, provisioning, and cloning.

oExpertise in performance tuning methodologies such as awr, dbms_sqltune, sql profiles, tkprof analysis, index rebuilds, query hinting, table reorganization, and object statistics management, and sql restructuring.

oSupport SAP ERP, BW, AND XI landscapes using brtools, SAP GUI-based transactions and Oracle utilities.

oPerform periodic refreshes for QA/DEV environments of SAP databases.

oImprove run time of several reports by successfully implementing materialized views.

oImprove run time of sql queries through optimizer statistics management, sql plan migrations, and query hinting.

oDevelop security hardening policies for Oracle and SQL Server databases such as password complexity and ageing, accounts and duties segregation, connection tracking, and object-changes monitoring.

oInterface with application teams in design and installation of application databases.

oDeep engagement with development teams providing expert advice on database subject matter, PL/SQL, and job automation.

oDeveloped and implemented data protection strategies using RMAN, os scripts (unix and windows), 3rd party product Commvault Simpana, IBM TSM, and Oracle data pump.

oDisaster Recovery exercises in conjunction with internal teams and Sungard.

oImplement and use Oracle OEM Grid to enhance and centralize DBA administration.

oImplement Confio IGNITE (now known as Solarwinds DPA) for SQL Server to reduce response time and enhance quality of dba solutions.

oSupport several SQL Server databases using SQL Server Management Studio to create, clone, backup, restore and recover, configure space, and run DMLs.

•3/1990 – 9/2001 McNaughton Apparel, New York, NY – Oracle DBA/Systems Administrator

oSuccessfully implemented the JD Edwards OneWorld Financials with responsibility over the infrastructure server, the Oracle database, and the application

oAdministered the JD Edwards Financials from the functional aspect with full responsibility on code transports and version

oDelivered PL/SQL solutions to supplement JD Edwards financial reporting.

oDelivered HP-UX scripts to administer print scheduler.

oPerformed HP-UX user administration using SAM and shell scripts.

oImplemented Microsoft Exchange.

oImplemented Novell networks.

Education

University of Santo Tomas

Bachelor of Arts, Major in Philosophy

Asian Institute of Management - Advanced Marketing Program

SAP Technical Education. SAP America, Newtown Square, PA

Oracle Workshops: Oracle In-Memory 12c Oracle Golden Gate Oracle RAC

Contact this candidate