SUMMARY:

• Over 14 years of experience in the IT industry in Design, Development & Production Support. Database Expert with latest skills as highlighted below.
• Production databases (100Gb - 30 Tb) with 24×7 availability. Several dozens of databases supported simultaneously - customized scripts as well as Tools such as OEM Grid, BB, Quest tools - spotlight/Foglight.
• Hardware and O.S on IBM, Oracle Exadata/Big Data, HP, Sun, Dell, and VMware ESX systems, various UNIX and Linux (RedHat, Suse, Oracle) flavors, MS Windows Server
• Oracle 12c features used - Mutlitenant architecture, Table recovery, partition migration.
• Clustering and High Availability solutions from Sun, Symantec/Veritas, HP, IBM and Oracle
• Database Security and Auditing- using VPD, Label Security, TDE and File encryption
• Enterprise Grid Control/Manager 12c, 11g, 10g - installation, configuration and Monitoring - Oracle and third party applications. Failover Functionality/redundant operations, Switchover & Failover and DR techniques.
• SAP-R3, PeopleSoft, Oracle Apps 11i - Supported highly customized modules/components ( Confidential, HR, Supply Chain, BW) with Oracle RDBMS - over 5 years. Middleware expertise.
• Database & Data warehouse administration using Oracle 12c/11g/10g/9i/8i/8.x/7.x on UNIX/Linux Windows platforms - Pro actively fixed several issues
• Data Center failover operations (TAF - app failover, Disaster Recovery, Business continuance) - worked closely with System/Storage/Network/Application Administrators, Operations and higher management.
• Trouble shooting multi vendor issues Oracle/IBM/SUN/HP/RedHat/Veritas/EMC/Egenera
• Knowledge of bugs and patches for Oracle RDBMS and Operating Systems (Unix/Linux/Windows )
• Oracle Queuing, Partitioning, SharePlex, ASM and OCFS (from Oracle), Veritas Cluster, HP Service Guard.
• Performance and Query tuning & troubleshooting - for applications, database and OS. Used variety of Vendor and third party tools (OEM, Spotlight, DBArtisan etc).
• SQL/PL SQL/UNIX Shell (Korn, Bourne, Csh)/PERL/Windows scripting, and C/C++/Pro*C coding - for automating DBA and Development tasks.
• Migrated & upgraded databases to higher versions from Oracle 7, Oracle 8, Oracle 8i, Oracle9i, Oracle 10g (and tested downgrade /back out options).
• Worked on several Operating Systems (Solaris, HP, AIX, Linux, Windows ) with System Administrators, Storage Administrators, Network Administrators as well as vendors
• Worked on 3-tier Client/Server architecture to implement several ERP, in-house and Web/Java applications (BEA Weblogic, Web Sphere, Java/J2EE, Microsoft .Net).
• Extensive experience in data marts, data modeling, and design, data warehousing and distributed databases (used Design tools such as ERWIN, Designer 2000 etc).
• Good communication skills and proven project leadership and teamwork qualities.

TECHNICAL SKILLS:

RDBMS: Oracle RAC 12c, 11gR2 and R1, 10gR2 and R1 Cluster Grid RAC on RHAS 4.0, Egenera,, OEM Grid - Redhat Linux 5.0, Sun Solaris Sparc 10 & 9, HP-UX 9,10, IBM AIX 5.2, 5.3 on LPAR,, RedHat, SuSe, Oracle 10g RAC Cluster, OEM Grid on Windows 2003 Server, Installs, Configurations, Troubleshooting on 32-bit & 64-bit. Oracle 9i RAC/8i/8.x/7.x, MS SQL Server 2000/7

DB Features: >20 Tb, RMAN, RAC, High Availability, GlodenGate, Streams, Adv Replication, Adv Queuing, Data Guard, Physical and Logical Standby, Fail over clusters,

Operating Systems: Linux (RHAS 2.x, 3.0, 4.0) Blades, SUN Solaris 10/9/8/2.x, H.P 9/10/11x, Windows 2003/2000/NT Servers, AIX 5.x

OS Administration: SUN Solaris/HP Unix, Linux, Windows NT/2000 Server, VMWare ESX, ESXi

OS Environment: Symantec SFRAC / VCS Veritas cluster, Veritas File System/Volume Manager, EMC Confidential /BCV, OCFS, HP Volume Manager, VMWare

Hardware: Oracle Exadata, Big Data, SUN E10K/15K, SUN6500 range, Egenera Servers/Blades (RAC cluster), HP Superdome, 9000, IBM p-series/e-series

Storage/File System: EMC - Symmetrix, Clariion, Veritas Cluster File System, Oracle ASM, OCFS, Sun, HP, IBM, Shared or Dedicated storage. Logical Volumes (raw or Cooked) Raw Devices, NetApp Filer, NFS, NAS, SAN

Backups: Veritas NetBackup NBU, Legato Networker, NetApp Filer

DBA Tools: Oracle Grid Control 11g, 10g, Oracle Enterprise Manager (OEM), SQL Navigator, SQL Backtrack, CASE, SQL*Loader, Quest - Spotlight, FogLight, SQL Lab, SharePlex, TOAD, DBTUNER, Precise, BMC-Patrol

Development/Design: ERWIN, Designer 2000, Developer 2000 (Forms, Reports), DISCOVERER

Data Warehouse: > 20 TB, operations, maintenance, tuning, COGNOS, Informatica

Data Migrations: SQL Server 7.5, 2000, SYBASE, RedBrick, Netezza, MS-Access.

Applications: SAP R3 Confidential , PeopleSoft, Oracle Apps 11i (Financials, HR, Pay roll, Manufacturing)

Scripting: PL/SQL, SQL, Shell (ksh, sh, csh), PERL, Windows, PVCS, SCCS, Clear Case, CVS

Languages: C, C++, VB, VC++, PL SQL, Pro*C, Java, J2EE

Data Center Tools: Control-M, Autosys, BMC Patrol, ITO/VPO

Industry/Apps: Finance, Mortgage, Telecommunications, Customer Care, Warehouse operations, Government, Auto, Engineering

EXPERIENCE:

Oracle Database Administrator

Confidential

Responsibilities:

• Database replication using Goldengate. DB Migration with zero downtime, data migration/ETL for DSS/DW.
• Install, Configure and Fix replication.
• Multitenant PDB databases - consolidated several 11g db into 12c PDBs working with Application teams and using Oracle RealApplicationTesting, ADDM, AWR analysis from Staging db.

Oracle Database Administrator

Confidential

Responsibilities:

• Worked on Oracle Engineered systems Exadata x2-2 and x2-8 Linux OS with cell cache to migrate Legacy HW running Sun Solaris, IBM z-Linux, Veritas cluster File system and Oracle RDMBS Releases 9i and 10g ( non-RAC, RAC ).
• Used Oracle Goldengate, Streams, Export/Import Datapump and legacy, other home grown ETL tools to migrate, consolidate and re-design application data to suit latest and greatest Enterprise systems.
• Also developed systems for Disaster recovery, failover operations for DB, MiddleTier and application, along with Enterprise monitoring solutions including Oracle cloud/EM/Grid control.
• Worked on a major Confidential applications which are critical in availability - migrating DB from 10g, running on Sun Solaris and Veritas cluster FS to AIX LPARs, Oracle 11gR2 RAC, ASM with Standby Dataguard. Used Primarily Oracle Goldengate and export import tools for data migration.
• Implemented Transparent Data Encryption TDE for securing passport and individual ( PII ) information.

Oracle Database Administrator

Confidential

Responsibilities:

• Installing and Configuring Symantec (Veritas VCS ) SFRAC 5.0 and patch to MP4
• Configure and Administer Cluster Resources ( VCFS, Network, DB ) using GUI and command interface
• Hardware and Software configurations included Sun Sparc V10, Symantec SFRAC 5.0, SAN Storage, Redundant Gigabit network switches, Remote Data Centers (data Replication/redundant operations ), Oracle 11.2.0.2 and Oracle 10.2.0.4 RAC clustering, Oracle Streams and GoldenGate Technologies ( for Oracle 11gR2 and 10gR2 ).
• Evaluated Shareplex vs GoldenGate for new Data Center move.
• VMware environment – Setting up VMware environments for Database and Applications and for End to End testing ( systems, Database, Application Servers and Client connections ) and maximizing resources with High availability and Load Balancing configurations. Setup 6 Node Primary Oracle RAC & 2 Node DataGuard standby.
• Hardware and Software components configured - VMware ESX,, Dell R900 servers, NAS Storage, Redhat Linux RHEL 5.0 (and earlier 4.0), Weblogic Application Server, WebSphere AS, Oracle OEM Grid Control 11g (and earlier 10g). IBM MQ messaging layer, Java Thin Client.
• Setup streams environment - DDL, DB Instantiation, Capture/Propagation and Apply performance analysis for Large/bulk loads. Evaluated GoldenGate for future implementations – scalability and reliability.
• Install, Configure and maintain Oracle 11g clustering (with Symantec SFRAC) and Oracle Databases 11g and 10g.
• Oracle Database Administration tasks include – Performance tuning (code reviews, DB schema design, Statistics, DB parameters), Backup recovery (along with Server Migrations –with using RMAN and Streams), Partition maintenance, User and Security Administration. DataGuard (physical and Logical Standby databases) setup with Switchover and Failover.
• Designing and tuning Pl/SQL packages and triggers for data replication using OLTP applications
• Tuning of data load jobs using SQL Loader and correcting errors on replicated environment.
• Reducing downtime during Systems, DB and Application changes, patching, Code changes and other DB and Data Center maintenance task – using RAC and Streams.
• Reviews for Streams LCRs and recommendations for improving efficiency and data loss.
• Implemented Transparent Data Encryption TDE for securing Confidential and credit card information.

Oracle Data Replication and availability Administrator

Confidential, Arlington, VA

Responsibilities:

• Oracle Replication architecture Project, Real Application Clusters, High/Maximum Availability, Data Guard, Prod Support - completed POC using Streams and Shareplex ( Oracle 11g ) for remote data synchronization.
• Architected Oracle 10g/11g Database with Data Guard and Streams configuration for application based on Content Management and Document delivery Configured and Installed Oracle RAC 10g & Grid Control 10g on RHAS 4.0 - for applications based on Java OLTP
• Supported Backup Recovery, Data Guard, and Standby, Patches, Upgrades and Critical monthly report processing. Oracle 10g RAC and Data guard project completed 06/2007 – 10/2007.
• Implemented Advanced Security features – TDE and VPD
• Contracting/Consulting - High availability Data replication and Clustering – Oracle DC, 11/05 – 3/09
• Oracle 10gR2 Real Application Cluster (RAC) – supported Installations, Configurations, Backup/Recovery, Performance Diagnostics, Patches, Crashes, Hangs, Lock situations
• OS configuration includes Linux RHAS 4.0, 5.0 – Egenera Blade frames ( over 10 nodes ) and database size exceeds 30 Tb
• Multi-purpose database includes OLTP, Reporting load.
• Performed Oracle 11g RAC upgrade from Oracle 10g RAC database
• Involved in node addition architecture
• Upgrade to 10.2.0.4 - Worked on several upgrade issues with XML types, INVALID products, Objects.
• Oracle patches – Applied for CRS, ASM, and DB for both RAC & non-RAC.
• Performed I/O analysis on all Production database clusters and identified issues.
• Worked on Node Reboots and Hangs during high/low load – with System Administrators and suggested Linux rpms as required
• Worked on DB query performance, CBO optimizer and db statistics.
• Worked on Data Pump issues for Export and Import with complex object types.
• Worked on Grid Control configuration and upgrades to 10.2.0.4 along with agents.
• Database Security and Auditing – Implemented Oracle Advanced Security TDE, VPD
• Application - Geo code, java, Oracle spatial & Topology 10.2.0.4 & 11.1.0.6, Pl/Sql
• Extensive work on spatial data, queries, design, data model, patches/fixes.
• Worked on poor Application Performance/ response issues vis-à-vis new application release with several database changes.
• Identified problems with Table and Index partitioning – considering several techniques Range/List/Hash and combinations.
• Rewrote several pieces of SQL and PL/SQL code to improve query performance and utilizing Optimizer hints and Indexes and eliminating unnecessary Nested Loops.
• Rigorously tested Optimizer parameters in Cluster Database for query response times and reduction in Global cache block transfers and full table / index scans.
• Application – new release performed twice better than previous release.

Confidential, GA

Responsibilities:

• Configuration includes RMAN Catalog db with physical standby at remote site and Tape Media at Primary – for maximum Data Protection
• Active/passive EM Grid Control was setup – with DR solution at remote site.
• Implemented Content Management Application with Load Balancing and Failover options for maximum availability and operations.
• Windows 2003 server (Dell Power edge ) – 2 node RAC with Shared Storage, ASM
• OEM Grid Control has been installed and configured for RAC db
• RAC Performance, Scalability tests were performed for high volume credit card rewards processing and issues have been identified /fixed.
• POC: Oracle 10gR1 RAC on Solaris 10 ( Confidential 900 Prime Power) using SAN, ASM – for credit card rewards program has been demonstrated.
• Database Auditing has been tested in RAC environment for future implementation.
• Worked on Data Migration from 9.2.0.5 RAC with Veritas Cluster FS to 10g (10.2.0.2) Oracle ASM file System, using Oracle Streams. DB size 250 Gb
• Implemented Data Guard/Standby solution for – production RAC (2 node)
• Performed Upgrade of another 9i non-RAC db to 10g RAC ( 4 Node ) Database – with NetApp file system
• Grid Control /OEM setup and configuration to include all Oracle Databases. Change Management and Performance Management Packs implemented.
• Installed, configured Shareplex for Data replication and to replace Materialized views used in Oracle 9i db.
• Patching Oracle Databases and Grid to latest release 10.2.0.3
• Cell phone features and accessories.

Confidential

Responsibilities:

• Customer’s PeopleSoft Financials applications and Month end close process is taking over 8 days and needed large scale improvement.
• Implemented several changes on Database and Application SQL & PL/SQL code, such as: partitioning of large tables, use of Oracle Temp tables, File system/IO (re)configuration, changes to Indexes including dropping unused and creating new ones for ad-hoc SQL
• Tested the application with changes to init parameters, optimizer statistics and SQL profiles.

Confidential, NJ

Responsibilities:

• Implemented a POC for Oracle 10g RAC - 2 node database with ASM on Confidential 900 PrimePower controlled by Confidential PrimePower 200 server. Solaris 10. EMC Symmetrix shared drives.
• Oracle DBA support for new Data warehouse and DB replication project along with DB Security and Auditing features
• Provided implementation support for Oracle Warehouse builder on Oracle 10gR1 running on Sun Solaris.
• POC: Setup database replication in Oracle 9i and 10g environments for clients healthcare application

Confidential, Dulles, VA

DBA Team Lead

Responsibilities:

• Pro actively identified several issues in the ERP (SAP –R3) applications, planned corrective actions and guided DBAs in database re-orgs.
• Planned and implemented backup (and recovery) plan for a large 3Tb database when Tape backups became unreliable.
• Worked on several situations where technical decisions have to be made ahead of time.
• Database Auditing has been implemented along with OS level security features.
• Setting up and maintaining Data warehouse environment (> 20 Terabytes) using Oracle 9.2.0.5/Linux RHAS2.1/RAC (8 node on Egenera Blades).
• Worked on Architecture, Design and Modeling of the project since inception.
• Challenges include monitoring the cluster nodes, investigation of node evictions and crashes.
• Pro-actively applied several patches and packages for Oracle and Linux by constant research and pursuing TARs and issues with Vendors bringing the availability from unpredictable to stable condition.
• Backup and Recovery strategy is being worked out using RMAN and Confidential TimeFinder. Improved the backup times 4 fold by introducing async I/O and multi-node backup strategy – utilizing the latest features from vendors.
• Working on packages for loading /transforming data from another RDBMS to Oracle. Performance tuning the SQL and PL/SQL used in the Loads and management Reports to better than expected duration’s.
• Terabyte Production DB migration to Oracle 10g Grid/RAC Utilizing latest features:
• Table space renaming (to age data and to make read only), Automatic Storage Management (to let Oracle balance I/O and improve file management), new segment management and table re-org.
• Flashback operations with history, table drops/recoveries, improved undo and recovery estimations and parallel operations. Supported Shareplex Data Replication environment for OLTP to prevent online Data loss.s
• Automatic Workload Repository, Automatic Database Diagnostic Monitor and new Web based Enterprise Manager – for improved database monitoring
• Data pump with efficient export and import of data as well as transportable table spaces across platforms.
• Shared Memory management – improve dynamic adjustment of memory based on database operations.
• RMAN improvements – compressible backups, efficient and fast incremental backups (covering NO LOGGING changes), recovery across RESETLOGS.
• Improved Materialized view and use of DBMS ADVISOR package
• Improved statistics collection and automatic management.
• SAP Confidential application - database setup and administration
• Identified several issues with the Operating system setup, backup times and schedules. Resolving the conflicts and setup with Sys administrator improved the times by several hours.
• Identified and corrected several Oracle table space and storage issues – such as Extent, Segment, and Undo Management.
• Also modified the default Oracle tuning parameters laid down by the application to suit the type of RDBMS – OLTP/OLAP/DW – dramatically improving the system response times.

Environment: Egenera Blades running RHAS2.x/3.x Enterprise Linux, EMC Symmetrix storage (with RDF) Oracle 9.2.0.5 RAC, RMAN, Data guard, RHAS 2.1, HP-UX, SAP R3

Confidential

Consultant

Responsibilities:

• Database Administration consultant position in a major project. Challenges/goals include performance, availability, error free operations with maximum security implemented (Fine Grain Access).
• Data replication and fail over is critical part of business functionality with zero tolerance for loss of data or service.
• Working in a small team of DBAs supporting over 20 production size databases with EMC Confidential, BCV operations, and VCS Cluster and File systems for high data availability.
• Database upgrades, Bugs & Patch analysis, TARs, crashes. Database configuration, organization standards, best performance.
• Supporting BEA Web logic and Java front end applications with load balancing.
• Utilizing latest features of Oracle 9i(Storage, cache, RAC, data guard )

Environment: ORACLE 9.2.0.4 RAC, RMAN, Data Guard on Solaris 2.9 24X7 Enterprise production database, (>2 Terabyte) under Veritas Clustering (and Veritas File system)/HA Configuration. Backup & Recovery: EMC Confidential /TimeFinder utilities for BCV copy, RMAN, Veritas NBU (Tape media manager) SAN storage and Tape drives, Autosys.