SUMMARY

• Sr. Oracle DBA wif 15+ yrs of experience supporting, analyzing, and maintaining mission critical database systems in various industries in various platforms. Proven record of (a) leading wifin domain of responsibility, (b) working successfully wif minimal guidance in highly demanding environments, and (c) liaising effectively wif customer business units and external vendors.
• Installation, upgrades, patching, administration, and performance tuning of Oracle 12c,11g and 10g (RAC, ASM, and standalone) databases in Exadata (X4 - X7), Solaris, AIX and Linux platforms.
• 24/7 support for mission critical databases in validated (FDA, SOX compliant) environments.
• DataGuard (DGMGRL) configuration for production, standby databases for Disaster Recovery, and snapshot standby databases for testers and developers.
• Oracle Glodengate experience
• Experience using data modelling tools (ERWIN, ALLFusion)
• D isaster recovery planning and execution.
• Planning, testing and deployment of backup plans (RMAN, Netbackup, Tivoli TSM).
• Oracle security implementation wif audit facility (OAF and TDE)
• Databases and system monitoring (Oracle GRID, OEM, HP OPENVIEW, BMC Patrol, TOAD, DBArtisan).
• Database and SQL performance tuning (EXPLAIN PLAN, DBMS XPLAN, SQL Tracing, TKPROF, SQL profiles)
• SQL Plus and PL/SQL programming, SQL*Loader, Export/Import, expdp/impdp utilities
• Database migration across platforms, Oracle ODI (ETL)
• Support for JD Edwards, SAP, PeopleSoft, Documentum, INFORMATICA, SIEBEL, MICROSTRATEGY databases
• Shell programming (Ksh, bash, sed, awk).
• AUTOSYS, CYBERMATION tools for enterprise job scheduling and Oracle OEM (13c, 12c, 11g) for monitoring databases.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Oracle DBA

Responsibilities:

• Infrastructure and application support for Oracle 12c, 11g databases in exadata wif ZFS, linux environments.
• Multilevel Dataguard setup and switchover/failover methods client and batch testing .
• RMAN backups and recovery from ZFS, ZDLRA (Zero Data Loss Recovery Applicance), and Tivoli
• Performance tuning.
• Oracle 13c OEM monitoring
• Primary DBA for Enterprise Risk Management, Broker dealer Clearance and capital analysis databases of size 10TB to 22TB

Confidential, Jersey City, NJ

Sr. Oracle DBA

Responsibilities:

• 11g, 12c Oracle RAC, ASM, Standby wif DataGuard Broker on Exadata, Solais, AIX and Linux Platforms
• Provided L3 Support for Confidential Oracle databases located across all continents.
• Implemented backup configurations, DR solutions (SRDF, EMC DataDomain, Tivoli, VTL) .
• Implemented TSM configuration, upgrades for Oracle Databases.
• Performed installation, upgrades, maintenance and tuning of databases wif periodic PSU patching.
• Managed RAC and standalone databases on Solaris, AIX and Linux Virtualized platforms.
• Managed multi Terabyte (10-60TB) databases and Database Hosting services on Oracle clustered environments.
• Limited support for GlodenGate replication operations.

Confidential, Princeton, NJ

Sr. Oracle DBA / SQL server Support DBA

Responsibilities:

• Performed installation, configuration, and upgrades of multi node Oracle RAC databases.
• Migrated databases from Solaris to Linux platforms.
• Implemented Oracle TDE.
• Configured Oracle OEM for monitoring databases and job scheduling.
• Supported Oracle OEM for SQL server databases.

Confidential, New York, NY

Project Lead/ Infrastructure DBA / Application DBA

Responsibilities:

• M aintained Oracle RAC, RAC standby, snapshot standby databases, and RMAN backups.
• Managed Oracle and Sql server databases and provided 24/7 support.
• Project lead: Converted 2TB SQL server Financial Database to Oracle 11gR2.
• Converted and tuned 300+ TSQL procedures to Oracle PLSQL.
• Designed ODI (Oracle Data Integrator) packages for loading SQL server (Bloomberg, Factset) data into Oracle.
• Glodengate 11g configuration

Confidential , Princeton, NJ

S r. Oracle DBA / SQL server DBA

Responsibilities:

• Primary DBA for the ROTC (Regional Order To Cash) project using MODELN software.
• Implemented HA solutions using Linux Clusters, RAC, and Standby Databases.
• Planned/ implemented backup and recovery (RMAN) and disaster recovery procedures.
• Standardized databases (SOP, WI and change management procedures) for FDA and SOX compliance.
• Tuned databases and SQL statements for performance.
• Supported SQL server.

Confidential, Weehawken, NJ

Senior Oracle DBA

Responsibilities:

• Database migration from 8i and 9i and security patch #68 for more TEMPthan 100 servers
• Development and testing databases wif Oracle 10g and RAC
• Disaster recovery solutions wif DataGuard Standby Databases Management
• User and developer support and schema management wif data architects
• Database and SQL performance tuning

Confidential, Somerset, NJ

Senior Data Warehouse Application DBA

Responsibilities:

• Managing multiple DW databases (ADS, INFORMATICA, SIEBEL, and PeopleSoft) of sizes up to 8 TB
• Managing table/index partitions/subpartitions and materialized views and refreshes
• User and developers support (development, testing, staging and production)
• Data model changes to database and reverse enginnering databases

Confidential, New York, NY

Lead Oracle Prod/Dev DBA

Responsibilities:

• Lead development DBA to redesign of incentive compensation program for the Chase employees
• Consultations wif business managers and data architects
• Data analysis, data (re)modeling, performance tuning, AUTOSYS/Korn scripts job scheduling
• Development and testing of PLSQL stored procedures and packages