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:

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).

Cloud: Amazon (AWS) EC2 (virtual server), S3 (Storage Services), Snowball (large scale data transport), RDS, Data Lake, Application and Deployment Services, Networking Services, Enterprise Applications, ASGARD etc.

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.

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:

• 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

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

Responsibilities:

• 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, Performance team

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:

• 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, Malvern, PA

Oracle Solution architect

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:

• 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, New York

Lead Oracle DBA

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:

• 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.

Confidential, Philadelphia

Senior Oracle DBA

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:

• 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).

Confidential, New Jersey

Senior CIM Database Administrator

Technical: Oracle 9i, 10g database, MS SQL Server 2005, OEM, OID, RMAN, Erwin.

Responsibilities:

• Lead Role on Performance Analysis and Tuning.
• Participated on Reverse engineering DB model using Erwin.
• Wrote and modified several database scripts (Perl, Ruby, Shell and combination of Sql). These bundles of scripts are used to monitor general health of DB, OS, Space and trigger maintenance wherever needed.
• Implemented OID by replacing traditional TNS based network connection to the DB.