SUMMARY:

Experienced Oracle DBA and Data Infrastructure & Cloud Architect. Over 18 years of professional experience in business process/system analysis, system architect & engineering, implementation & maintenance of various kinds of Database involving Investment Banking (including NYSE Trading Floor), Securities and Bonds, Search engine, Content management, CRM, Pharmaceuticals, Computer Telephony & Telecommunications and US Govt.

Well Experienced in N - Tier, Grid/Cluster (Oracle RAC, MS sql svr cluster and RedHat Cluster, Solaris VCS), Virtualization architecture, Operational Data Storage, OLTP and Data Warehousing, AWS Cloud, Active/Passive- Active/Active Architecture, Data Guard, Disaster and Granular Recovery.

Enhanced UNIX, SAN and Oracle trouble shooting skills.

Experience in working/leading IT team globally.

TECHNICAL SKILLS:

Technical: software/servers/tools/language

Database: (Primary): Oracle 7, 8i, 9i, 10g, 11g, 11i (11.5.10.2), 12c.

Database: (Secondary): db2 v8.2, Sybase, MySQL, NoSQL, Gupta, idms, IBM IMS-9, Metrica, MS SQL Server (2005, 2008,2012).

Oracle Technologies::

Cloud: :

Tools: 12c OEM, Oracle Weblogic, Toad, Spotlight, Foglight, BMC Patrol, Cognos-8.1.2 (Business Intelligence, Decision Stream), Informatica, Rational Rose (RUP), Erwin (modeler, validator).

Language: (Primary): PL/SQL, SQLJ, Shell Scripting, PERL, RUBYLanguage (Secondary): C, COBOL, Visual Basic 5, ASP, VBScript, Visual Interdev 6, JavaScript, html-dhtml.

Distributed technologies: (Secondary)- COM/DCOM, ActiveX, CORBA, OLE2, EJB, J2EE, .NET

Storage Arrays/ Backup: EMC (Celerra NS40,/60/80G, CLARiiON AX, CX series, EMC Symmetrix DMX-4)), EMC Replication Manager, EMC Recover Point, 3PAR, IBM SAN, Linux Amanda.

Networking, Securities & Protocols, Network Job management (Secondary) - Firewall, Fault tolerance & Raid, TCP/IP, IIOP, GIOP, NET8, Tivoli Maestro, Autosys.

Backup: (Secondary): VERITAS NetBackup, Legato, IBM Tivoli, Oracle RMAN, CommVault, EMC AVAMAR.

Application/Communication Services/LBR: (Secondary): Cisco WAAS, CSS 11501, BlueCoat SG800 Appliance.

File Systems: FAT, NTFS, IFS (oracle content manager-old), ufs, hsfs, ext3, Ext2, xfs, gfs, pcfs, dos, vxfs, zfs.

OS: Solaris 11.3, HPUX 11.31, RHEL, SUSE, CentOS, AIX, Windows.

Linux/Solaris Clusters/VM (rhevm 3.6, Solaris Clusters 4.3)

Servers: - E10K, X21, X42, Sun Blade 8000 Modular System, Sun Fire T1000,T2000, E2900HP 9000 Superdome, Dell 1855, 1955, R900, 2950, IBM p5 560Q, IBM 8286 (v6), SPARK Servers (T5/M6, M7/16 (soket), M7/8), Oracle Exadata Server X5-2L, X6.

Others: (secondary) - Load testing, CVS 1.10, pvcs (Serena). - SAP(ECC 6.0), Moda, Trackwise, Livelink, Aris, Six Sigma, JProbe, Clover, MKST 8.6, CYGWIN, ActivePerl.

PROFESSIONAL EXPERIENCE:

Confidential - Fort Washington, PA

Senior Database Administrator and Oracle Infrastructure Architect.

Technical: Oracle 11g, 12c, RAC, ASM, Exadata (X3, X5, X6), Golden Gate, Data Guard, RAT, OEM 12c, EMC, SRDF, RHEL, RHEVM 3.6, HPUX, Solaris, AWS, MS SQL Svr, NoSQL.

Responsibilities Included:

• Database Build, Patching, Cloning, Migration, Upgrade and Install etc.
• Worked with 12c features such as Multi-Tenant, In-Memory (Aggregation, Column Store), Index Compression, Big table caching, RAT etc.
• RAC infrastructure build and upgrade: Built and upgraded several RAC. Configured Voltaire’s InfiniBand I/O fabric switch for interconnect.
• RAC Physical Standby and Active Data guard build.
• ASM: Solid understanding of new features such as Filter Driver, Flex ASM, AU SIZE etc.
• Implemented TDE (Transparent Data Encryption) Hardware Security Modules (HSM) on RAC.
• Cluster monitoring and maintenance: Cluster Latency, Cluster Overhead, Global Cache, Instance Balance
• Exadata: Configuration, Administration and Migrating DB to Exadata Machines.
• Troubleshoot DB performance issues: Expert level.
• OEM 12c Install and Configuration, Documentation. Upgrade to two node RAC for HA.
• Set up Golden Gate: Basic Install and Configuration (Secondary Level).
• Set up Real Application Testing (RAT).
• Amazon Cloud (AWS): Worked on Data Lake. Porting client database to cloud (RDS). Data transport with Snowball. Configured DR. EC2 virtual server. Configured and managed S3 storage. Configured Enterprise Applications (Managed Desktop Service and Services for Sharing and storing documents), Used ASGARD for automation and management of large AWS resource pools. Project Lead for Cloud Computing.
• DR exercise (Standby and Active Dataguard).

Confidential . NJ

Senior Oracle DBA - Consulting for PVSIR application. (Re-engagement)

Technical - HPUX, RHEL, Oracle 10g,11g RAC, EMC, Streams, Data Guard.

Responsibilities Included:

• Oracle build, upgrade and Patching. Oracle/RAC Install & Configure.
• Oracle Grid Control - Install/Configure (Install Server/Push client etc).
• Performance monitoring and troubleshoot Performance bottleneck of Oracle Infrastructure.
• Reverse modeling of existing Objects as part of reorg (partitions, cluster index etc)
• Developed a wrapper scripts package (shell,perl,ruby) for CR executions.
• On call support.

Confidential, New Jersey

Senior DBA

Technical - HP9000 superdome, Dell Poweredge Servers, EMC (Clariion CX), RHEL 5, Oracle 10g,11g database, 10g RAC, ASM, Data Guard, Oracle Streams, Oracle Golden Gate 10.4, Grid Control, Toad, Spotlight.

Responsibilities Included:

• Reconfigure Streams (RAC to RAC),
• RAC performance tuning and patching.
• POC for RMAN backup and recovery, Reconfigured RMAN (with Commvault) for DR exercise.
• On call support.

Confidential

Oracle Solution architect - Consulting.

Technical:, Dell Poweredge Servers, EMC (Clariion CX40/60, Celerra, Centera), RHEL 5, Oracle 10g,11g database, 10g/11g RAC, Data Guard, 10g Grid Control, 10g OAS, Appex, Toad, Spotlight, SAP ECC6.0, Streams.

Responsibilities Included:

• Built a 2 node Oracle 10g RAC, a 2 node 11gR1 RAC.
• Installed and upgraded several Linux machines and Oracle (Database, OAS, Grid Control, Appex etc).
• Oracle implementation on SAP (New SAP system Install with Oracle 10.2.0.4).
• Configured DataGuard & RMAN, EMC Recovery Manager and AVAMAR backups for Oracle and Linux.
• EMC - SAN Fabric Administration including zoning, Storage Group/LUN creation, HBA configuration.

Confidential

Lead Oracle DBA - Equity Linked Trading (GTI) - Consulting.

Technical - Sun Fire E2900, V490, T5220, Sun Blade 8000 Modular System, Dell Poweredge Servers, EMC (Symmetrix, Clariion), RHEL 4, SOLARIS 10, Oracle 9i, 10g, 11g, 10g RAC, ASM, Data Guard, 10g Grid Control, BMC Patrol, Precise, Team quest, Toad, Autosys, Solaris Golden Gate.

Responsibilities Included:

• Performance Monitoring, Analysis and troubleshoot for Equity Linked Trading (NYSC floor) databases (RAM).
• EMC Replication Manager Admin for Oracle Backup, RMAN and Data Guard.
• Co Build Oracle 10g RAC Infrastructure and Configured Solaris9 Golden Gate to replicate database.
• On call support.

City Of Philadelphia - Philadelphia

Senior Oracle DBA (Oracle/IT Auditing, RAC Performance Tuning - Consulting)

Technical - IBM System p5 560Q, Dell 1955 Blade, Sun X42, IBM SAN, RHEL 3,4, Solaris 10, SUSE10, Oracle 10g RAC, Oracle 9i, 10g database, Data Guard, RMAN, OAS, OEM Grid Control, OID, Erwin.

Responsibilities Included:

• Audit Oracle RAC and its underlying infrastructure. General Diagnosis of the Database Environment.
• Conducted independent checks of the system configuration and current health, using custom diagnostic utilities (Shell script written in combination of Perl, Ruby, Sql and Shell).
• Worked extensively on RAC Performance Tuning (RAC Cache Fusion), Oracle Connection Pooling.
• Upgrade Oracle RAC (From RHEL4.1+Ora10.1.0.5+ASM 2.6.9-11 TO RHEL4.3+Ora10.2.0.3+ASM-2.6.9-34).