SUMMARY:

• Senior Oracle DBA with professional Oracle DBA experience. An analytical problem solver with well - developed interpersonal and communication skills and a strong work ethic. An effective team player who is committed to completing projects efficiently.
• Proficient in large RDBMS Administration, Server Installation & Performance Tuning using AWR, ADDM, ASH,, Security Management, RMAN backup and recovery,
• Dataguard Physical standby implementation and Maintenance, Data/Code Migration, Character set Conversion, Client interaction and support in OLTP, OLAP and Data Warehousing environments, and LDAP implementation in the Current versions of Oracle such as 9I, 10g, 11g, 12c in Sun Solaris, AIX, Linux, and windows.
• Excellent working knowledge of Data Guard and Oracle RAC with/without ASM 9i, 10g, 11g, 12c with Oracle Clusterware and Veritas cluster file system, Streams, Data Pump, Grid Control, GoldenGate, Shareplex
• Very strong troubleshooting & problem analysis skills proven under high pressure 24/7 environments. Fully familiar with Oracle Metalink support and oracle diagnosis utilities.
• Efficient and standardizing best database practices, processes and auditing databases for security.
• Knowledge of ERWIN database reverse engineering tool.
• Expert level skill in utilizing third party tools such as TOAD, DBARTISAN, SQL BACKTRACK, TIVOLI, BMC PATROL and others.
• Expert in applying Oracle Patches and Migration from 9i to 10g and from 11g to 12c.
• Adept in creating and maintaining documentation for the systems/databases managed.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, JAVA Programming, C#, Korn Shell Scripting,Perl scripting.

Operating Systems: Sun Solaris, Linux, AIX, Windows, DOS

Databases: Oracle, SQL Server, Oracle Times 10 Attended Seminar, DB2.

Database Tools: OEM, RMAN, TOAD (expert in TOAD SQL tuning component),DBARTISAN, ERWIN, Grid Control

Hardware: Sun Sparc 64bit, EMC SAN Storage, IBM Mainframe, and Wintel Workstations, HA, SRDF

PROFESSIONAL EXPERIENCE:

Confidential, Warren NJ

Sr DBA

Responsibilities:

• Worked in Global Database Migration / Conversion and Upgrades.
• Coordinated Oracle and installations and upgrades according to Enterprise specifications
• Efficiently participated in 24/7 production support team
• Upgraded multiple RAC and non-RAC databases to 12c including configuration of 12c new features and 12c RAC builds; applied latest psu patch levels; some upgrades were done via DataPump export import using parallel option and separate index build jobs to improve performance.
• Worked on HP and Solaris Super Cluster, EXADATA high end servers with large databases.
• Utilized RMAN for all types work such as scheduled incremental backups, high speed transfer of RMAN compressed backups to remote sites, database cloning using RMAN duplicate command, RMAN block recovery command to recover from block corruption.
• Assisted app team with resolution of PL/SQL and JAVA coding issues and SQL tuning.
• Set up restore points and performed flashback recovery after app testing.
• Trained and Assigned work to 3 offshore DBAs. Developed fully automated procedures for offshore staff.

Confidential

Sr Lead Oracle and SQL Server Global Database Solutions Architect

• Worked in Global Database Migration / Conversion and Upgrades at a PepsiCo International as HP Consultant.
• Managed a team of 2 DBAs
• Coordinated Oracle and SQL Server installations and upgrades according to PepsiCo International specifications
• Efficiently participated in 24/7 production support team
• Individually set up dataguard physical standby for 30+ oracle databases
• Upgraded 10+ databases from 8i, 9i and 10g to 11g; applied latest psu patch levels; some upgrades were done via DataPump export import using parallel option
• Worked on HP high end servers with large databases such as SAP ORACLE 16 terabyte database running on an HP Superdome server
• Utilized RMAN for all types work such as scheduled incremental backups, transfer of compressed backups to standby site, database cloning
• Installation, configuration, and troubleshooting of multiple SQL server databases from 2005 thru 2008 and 2012

Confidential, Jersey City, NJ

Sr Oracle DBA / Engineer

• All oracle database work is done in ASM cluster file system via Perl, Korn Shell, and Pl/Sql engineering scripts. The scripts go through a very extensive testing procedure by the QA team. Then they are turned over to the lights out operations Data Center. This approach minimizes Production Support problems
• Worked in the design, Installation, customization, and tuning of the Infinity Database. This is a multi terabtyte, two node Oracle 11.2 RAC database. The database runs on Linux 5.4 OS and HP DL385 servers utilizing SSD array storage.
• Designed and Implemented Oracle 11.2 two way Streams replication for the RESET project. This includes setting up and customization of schema level replication and grid control monitoring of the Streams replication environment.
• Worked in the migration of RDB, MRF, and TDW databases from 10.2 to 11.2. 11.2 databases are created via in house developed perl scripts. Data is migrated via Data Pump procedures.
• Worked in the implementation of Oracle 11.2 Radia database with data guard and data guard broker. This is an HP product for centralized software distribution for the company..
• Responsible for the support, maintenance, backup, recovery, and tuning of the FIRP database. This is an Oracle 11.1 two node RAC database with several hundred users.
• Implemented full Oracle 12C Grid Control with agent push for about 30 production servers.
• Successfully Implemented GoldenGate replication between 10g and 11g databases as part of an evaluation project but the company eventually decided to go with Oracle streams due to GoldenGate licensing cost issues.

Confidential, New York City, NY

Sr Oracle DBA

• Migrated Confidential Time Management and Projects Inventory in house developed Oracle 10g databases to Oracle 11g.
• Member of the Corporate Global Trust Migration project - Migrating all Corporate Global Trust Oracle databases from Confidential to the Confidential as part of the Trust merge project.
• Split AFRA application into AFRA UK and AFRA US components. Each application have their own set up DEV, UAT, and PROD databases. Worked with the application in setting up schema exports and imports to separate the components for each application.
• Implemented ARK (Asset Repository and Collateral system). Built DEV, UAT and PROD instances, set up and scheduled regular backup and monitoring jobs. Performed Oracle instance tuning for the increasing user base, 400 at the last count.
• Implemented OFQ (OFAC query engine). Built DEV, UAT and PROD instances, set up and scheduled regular backup and monitoring jobs. Performed Oracle instance tuning for the increasing user base, 200 at the last count. Implemented range partitioning. This is a terabyte size database which is used to collect all the transaction data from the bank and inspect the transactions so that no area of the bank is doing business with illegal entities worldwide . .
• Data Guard implementation with standby database for Mexico City Branch. Configured Maximum Availability Dataguard where the switchover is performed between the primary and the standby. Conducted regular DR testing. Archive ship delay is about 3 mins.
• Daily database administration, performance monitoring, sql tuning, automation scripts, data warehouse for ITM 3Tb database. Implemented range partitioning in 400gb master transaction table which stores monthly data.

Confidential, New York City NY

Sr Oracle DBA

• Team Leader on the implementation of the Global AFRA project for Financial line of business of Corporate Trust Services at Chase Manhattan Bank, including Oracle RAC with ASM software installation; Instance configuration; Database physical implementation; Capacity Planning; Table/Index Partitioning; data load and database administration.
• Application and Database Tuning; Backup and Recovery strategy using RMAN and VERITAS net backup; RMAN repository configuration; Data Guard Disaster Recovery with standby physical database strategy for High Availability configuration; Automation using UNIX shell scripts and Autosys jobs scheduling.
• Team Leader on the implementation of an in-house application, Triparty Payment System, including Oracle software installation; Database creation; Database physical implementation; Capacity Planning; Application backup; RMAN repository configuration; Data Guard Standby Disaster Recovery database strategy configuration and automation using UNIX shell and Database Tuning; Backup strategy using RMAN and VERITAS net scripts and database administration.
• Support the implementation of Sun Hardware Redundancy using Solaris Cluster High Availability for Oracle and VERITAS cluster manager.
• Team Leader of the Global Client Access - Cash Online system version upgrade. Including Oracle software installation; Instance configuration; Database physical implementation; Capacity Planning; data load; Application and Database Tuning; Backup strategy using RMAN and VERITAS net backup; RMAN repository configuration. Data guard physical Standby database strategy setup and maintenance, UNIX shell scripts for automation.
• Team Member of the Oracle 9i Migration project of all TS Finances Line of Business’ instances of Oracle, supporting tests and implementation of High Availability with Oracle RAC with instances: Autosys job schedule. Including Oracle 9i software installation; Instances configuration; migration from 8.0.4 to 9i, Apply patch to 9.6, Database physical implementation; Capacity Planning; Data load; Application Backup strategy using RMAN and VERITAS net backup; RMAN repository configuration; Data Guard physical Standby Data Guard Disaster Recovery database strategy configuration.
• Daily database administration, Tivoli monitoring Production instances of Oracle; Support to developers on Oracle issues and SQL tuning for best performance. Promoting application changes to production.