KEY SKILLS:

• Oracle Database Administration
• SQL Server Administration
• MySql Administration
• SAP Hana Administration
• SAP Basis Administration
• Oracle Golden Gate
• Oracle DataGuard
• OEM
• Oracle Advanced Replication
• HP - UX, Linux, AIX and Sun Solaris
• RMAN
• RAC
• ASM
• Windows 2000, 2003, 2008

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Sr. SQL Server/Oracle Database Administrator

Technical Environment: SQL Server 2005 - 2008, Oracle (11g,10g, 9i) OEM, RAC, ASM, DataGuard, Golden Gate. Servers running Windows 2003, 2008, HP-UX, AIX, Linux.

Responsibilities:

• Provided Microsoft SQLSERVER and Oracle DBA support.
• Migrated multiple Oracle databases 9i-10g to 11g/12c.
• Update Golden Gate 9 to Golden Gate 11.2
• Update Dataguard 10g to Dataguard 11g
• Administration/configuration/installation Oracle RDBMS 10g/11g/12c
• Performance tuning and optimization
• Oracle RMAN - Integration with Commvault
• Oracle DataGuard Administration
• Oracle Golden Gate 11.2 Installation/Administration
• GoldenGate Active-Active Database Replication
• Oracle RAC/ASM
• Experience Materialized views, Large Data Volumes, Highly Transactional, DB Redefinition Expertise
• Continuous improvement of database schema in conjunction with development
• Recommendations and best practices for table structures, indexing, database sharding to ensure scalability of the platform as the business grows
• Backups, restores and defining recovery models
• Proactively monitor SQL/Oracle platform to ensure stability and uptime against SLA
• Evaluate, test and deploy new releases, patches and upgrades
• Disaster Recover Environment Implementation and Test
• Administration probes Oracle/SqlServer for Nimsoft
• Strong trouble shooting, problem solving, analytical and design skills.
• Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN.
• Install, configure and maintain SQLSERVER database products.
• Created Commvault Integration backup for Oracle and SQLSERVER.
• Manage and monitor database storage.
• Apply latest patches for bug fixes and security vulnerabilities.
• Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning - Tuning Applications, Tuning Memory, Tuning Disk Usage and Tuning OS.
• Experience in capacity planning, space management, database upgrades/migration.
• Implemented and maintained Oracle 10gData Guard/standby databases for fail-over purposes
• Experience with ‘graceful’ switchover and switchback between primary and standby databases.
• Actively working with other teams for Server Consolidation & Database Consolidation.
• Created and maintained batch jobs Control M
• Experience with VMware 4.x, 5.x and Virtualization technology and concepts.
• Worked in 24x7 production environment and provided on-call and day-to-day support.

Confidential, Coral Gables, FL

SAP HANA Administrator

Technical Environment: SAP HANA, Servers running Linux (Amazon)

Responsibilities:

• Responsibilities include Database Performance and Tuning.
• Cloned SAP Hana database using cold backup.
• Defined server Build Requirements for SAP HANA.
• Projects for compared performances with Oracle 11g
• Setup and schedule jobs that perform backups and database structure checks.
• Configure Replication, Log Shipping, and Fail over clustering to meet customer needs for production to development environment.
• Moved, transformed, and load heterogeneous and homogeneous into SAP HANA databases, as well as export SAP HANA data to text file and other database systems.
• Monitor SAP HANA for errors and performance degradation.

Confidential

Sr. Oracle/SQL Server Database Administrator

Technical Environment: Oracle (11g, 10g, 9i and 8i) OEM, SAP, PL/SQL, SQL, Business Object, EBS SQL Server 2000 - 2008 MySql 3.23 - 5.6 Servers running Windows 2000, 2003, 2008, Linux Redhat and Suse

Responsibilities:

• Oracle Sr Database Administrator Consulting as Project Manager and Technical liaison when MAKRO splits in too stores.
• Supervised, trained and mentored upcoming DBAs.
• Prepared labor and equipment cost estimates for new projects.
• As the sole Oracle, I performed Migration, Cloning, Database Consolidation, Upgrades and performance Tuning.
• Created Backup Specifications for all servers including: Windows, UNIX, Oracle
• Upgraded Oracle 8i/9i to 10g/11g.
• Oracle BI 10g
• Established and maintaining Storage Management and Backup/Recovery.
• Provided SAP Basis Administration which involves: Monitoring, Security and Data Transport.
• Installed and configure JAVA for SAP
• Managed Migration projects and making sure projects met time and cost projections.
• Installed MS SQL Servers 2000, configured, applied service packs.
• Upgraded old version of SQL Servers to 2000.
• Monitor and Maintained SQL Server databases via Server Enterprise Manager.
• 24 hour on call support for database related issues.
• Setup Multi-Master Replication to propagate data between the annexes and Headquarter.
• Suspended and resumed replication for schema changes.
• Adding Snapshot sites to the Master database.
• Able to work directly with developers and end users under stressful situations
• Ability to solve complex application problems through research and technical detective work.
• Able to work off hours when required to perform maintenance activities as required and scheduled.

Confidential

Sr Oracle Database Administrator Consulting

Technical Environment: 24x7 Oracle 8i, 9i, 10g, 11g production databases. S, PL/SQL, OEM, RMAN, Advanced Replication, RAC, ASM, Servers running Windows 2000, 2003, Sun Solaris, Linux and HP UNIX.

Responsibilities:

• Restored replication after upgrade.
• Involved in database re-architecture efforts.
• Did a lot of Performance Tuning in 9i, 10g and 11g environment.
• Implemented Oracle’s Advanced Replication.
• Setup replication on mission critical systems.
• Created and maintained 9i standby database.
• Setup CTX server utility.
• Implemented and maintained the “Oracle Text Index”.
• Did a lot of install and upgrades.
• Responsible for applying security patches.
• Cloned Databases using Hot/Cold backup techniques.
• Configured RMAN to automate backup and recovery process across multiple databases.
• Wrote multiple UNIX scripts to automate batch jobs.
• Implemented and enhanced data security.
• Configured OEM to facilitate management of enterprise-wide database resources.
• Provide on-going support to multiple databases including installing/configuring, monitoring, performance tuning, data loading, upgrading.
• Interacted with contractors, vendors and internal management to resolve technical issues
• Configured and sized the Oracle Databases.
• Restored/refreshed databases to various points in time using hot and cold backups.
• Planed and participated in setting up Oracle 8i Parallel Server Database.
• Resolved database Performance problems.
• Monitored Database size and trend analysis data to allow a smooth Growth Path.
• Provided Production Support on a 7x24 for Multiple Oracle servers running Solaris 2.5, 2.6.
• Applied Patches for Third Party Applications software and Oracle Databases.
• Communicated with Oracle Support and used Metalink to research and resolve database Issues.
• Installed/Upgraded Oracle databases from 7.34-8.03-8.03-8 i. 9i,10g and 11g
• Wrote UNIX shell and SQL scripts to assist use of Oracle concurrent manager job scheduler and the automatic deletion of aged database files. Used Cron to automate and execute scripts.
• Wrote Triggers to populate tables of several customers databases.
• Developed Strategy, planed and administered the backup and disaster recovery for the Oracle servers and databases using OEM.
• Created Standby databases for three major Production databases.
• Created database Snapshot.
• Performed Recovery for Corrupted data block, Lost of datafiles and Bad disk.
• Responsible for keeping the application software in sync with the Production, Test and Development databases.
• Loaded text files into tables using SQL Loader.
• Used Import/Export for backups.
• Worked independently and as part of a team, including Cross Functional Teams.