SUMMARY:

• Complex problem solver and tuning expert for large databases in Unix and Windows environment. Like to work under challenging environment. Best fit for new projects or running projects with problems.
• Expert in Oracle parallel server setup/Real Application Clusters, Oracle replication, Standby Databases/Data Guard/Logical Standby, Data warehousing for financial applications.
• Strong in object modeling, database creation, performance tuning, logical and physical modeling, backup & recovery activities, installation and upgrade of databases, PL/SQL, Server Setup.
• Twelve years of Oracle experience out of which last eight years as Architect/Oracle Database Administrator in Unix and Window environment
• Expert in Modeling. Modeled GIS Database with requirements covering Asset Management
• Three years of warehousing experience including Informatica
• Three Year experience with WebLogic, Tomcat/Apache, Maximo, Lawson Financials, Opentext & GIS Administration
• Comes with development background so excellent for application tuning & PL/SQL Programming

SELECTED SUCCESSFUL PROJECTS IN PRODUCTION/ACHIEVEMENTS:

• Complete functional Redundant data centre for WASA in case disaster happens to production environment
• N-tier Architecture for Maximo Application for WASA consisting of Oracle Real Application Clusters 11g/10g/9i, WebLogic, Actuate Report Server, WebMethods. The database/application has transparent failover capability.
• N-tier Architecture for Lawson Financials for WASA consisting of Oracle Real Application Clusters, Crystal Report Server, Lawson Application. The database/application has transparent failover capability.
• N-tier Architecture for Opentext document management system for WASA consisting of Oracle Real Application Clusters, Crystal Report Server, Weblogic, Opentext application. The database/application has transparent failover capability.
• Architecture/Implemented Enterprise Backup Strategy for databases & applications
• Architect American Express Credit Card System from Logical Model to Production, running 100 transactions per second under Oracle Parallel Server environment. Serving 80 million cards.
• Universe application for Thomson Financial, a Web Based Financial Application under Oracle Parallel Server environment. Team struggled to put project in production for 1.5 Years. The project went into smooth production within three months after my inputs. Changed Application Architect and tuned processes to few minutes from 24 hours.
• TradeWind a web based Financial Warehouse Application of Spectra Securities. 3 DBAs struggled to find the problem of processes taking 40 Hours for nine months. Reduced the processing timing to 40 minutes by changing architecture and tuning.
• Object Oriented High Transaction System for Met Life Corporation, the biggest Insurance Company of U.S.A.
• Setup for Oracle 9IAS (Discoverer, Forms, Reports, Wireless, Portal, Apache) at Bistol Myer Squibb Company
• Clinical Warehouse at Bristol Myer Squibb Company
• Reduced time of Lawson reports from 22 Hours to 2 Hours at WASA. Lawson Company and 3 DBAs struggled for 1.5 years to solve this problem
• Real Application Cluster Setup at WASA

CERTIFICATIONS:
DATABASE ADMINISTRATION:

ORACLE CERTIFIED PROFESSIONAL: Oracle Real Application Cluster 11g & Grid Infrastructure Oracle 10g Release 2 Administering RAC ( Oracle 10g-OCP Oracle 9i-OCP

• Oracle 8i-OCP
• Oracle 8.x-OCP

Oracle 7.x-OCP

• Oracle Database Upgrade 8i to 9i-OCP
• Oracle Database Upgrade 8.x to 8i-OCP

SYBASE 12.5 Adaptive Server Administration
SQL Server 2000 :

• Installing Configuring, and Administering SQL Server 2000 Enterprise Edition [Marks 76%]
• Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Marks 75%]

DB2 UDB:

• DB2 UDB V7.1 Database Administration for Unix, Windows and OS/2 (Mar. 2001)
• DB2 UDB V7.1 Family Fundamentals (Mar. 2001)

DATABASE UPGRADE: Oracle 8i to 9i, 9i to 10g, 10g to 11g DEVELOPMENT: PL/SQL Programming ARCHITECT: Sun Certified Enterprise Architect for Java 2 Platforms, Enterprise Edition (Jan. 2001) [Marks 72%]

• Sun Certified Architect for Java Technology 1.2 (Feb. 2000) [Marks 65%]

WAREHOUSING(ETL):

Informatica Certified Professional: Architecture & Administration WEB APPLICATION HOSTING: Weblogic 7.0 Administrator Maximo 5.1 Certified Administrator Maximo 7.1 Certified Administrator

ITIL certified

SAP Basis

• SAPDBA
• SAP R4.x
• Unix OPERATING SYSTEMS:

Unix: Sun Solaris Unix Administration for 2.6

Windows 2000:

• Installing, Configuring and Administering Microsoft Windows 2000 Server (Jan. 2001) [Marks 72%]
• Implementing & Supporting Microsoft Windows NT Server 4.0 (Sep. 1999)

JOB EXPERIENCE:

Oracle DBA, Confidential,NJ (Jan, 2012 – Cont)

• Setup of Fraud Detection System (FDS) application consisting of Oracle RAC 11.2, Dataguard and GoldenGate
• FDS is a three node cluster, using RMAN backups
• Providing support to Bank of America Warehouse Database
• Providing support to Reporting Databases
• Patches/upgrade of databases
• Review of Data Models
• Options to provide better alternate options for database performance
• Database production Support
• Coordination with offshore production teams
• Coordination with offshore Development teams

Technology Environment: Linux, Sun Unix, Veritas Cluster, Veritas Volume Manger, Oracle 11g RAC, Oracle ASM, Oracle 10g Release 2 RAC, PL/SQL, Oracle Grid, Scripting, Perl, Windows Servers, Vault, Apachi/Tomcat, ColdFusion, iPlanet, Visio, Weblogic Server, Grid Control Setup, Real Application Cluster, Golden Gate [8TB], Patrol

Senior Oracle DBA/Architect, Confidential, (March, 2002 – Jan, 2012)
Major Responsibilities:

• Setting RAC under 11g Environment using ASM storage
• Setting Dataguard 11g Environment
• Setting RAC under 10g Environment
• Mysql for Web Applications
• Architect/n-tier-type2 Setup for Maximo 7.1 Server in Real Cluster 9i/10g/11g Release 2 environment, upgraded maximo several versions. This covers transparent failover for Maximo Application/Database in production environment. The manual failover for Maximo application to Redundant Data Centre.
• Setup of Actuate Report Server
• Administrator for WebLogic, Apache/Tomcat
• Architecture/Implemented Enterprise Backup Strategy for databases & applications
• Model GIS Database with requirements covering Asset Management
• Installation/Setup of Oracle Real Clusters 9i Release 2
• Transparent Failover setup for Real Application Clusters
• Development PL/SQL Packages/Procedures/Functions
• Tuned Oracle Databases
• Reduced Lawson reports running time from 12 Hours to 2 Hours
• Unix Shell(Korn) Scripting
• Backup & Recovery Setup using Recovery Manager (RMAN)
• Oracle Replication
• Quality Control of 11 Developers (Maxima Development Team & Lawson Team)
• Setting Standards/Operation Manual for WASA
• Maximo Administration/Setup/Installation/Upgrades several versions
• Financial Warehouse Logical/Physical Modeling
• Upgrade Oracle several versions
• Migrated database storage to NAS
• Converting SQL Server Databases/tables to Oracle
• Agile Development Process
• Knowledge of NoSQL
• WASA Customers Water Usage Warehouse Logical/Physical Modeling
• Migration/upgrade/Patching Oracle 9i/10g/11g
• UML Modeling
• Oracle Enterprise Pack
• Build Report Server using Golden Gate
• Virtual Private Security for tables
• SDLC Development for applications

Technical team: 1 System Administrators, 3 DBAs, 5 Developers
Technology Environment: Sun Fire V880 Machines Clustered, Sun Unix, Veritas Cluster, Veritas Volume Manger, Maximo 7.1, MEA, Oracle 11g RAC, MySQL, Oracle 10g Release 2 RAC, PL/SQL, Oracle Enterprise Manger, Cold Fusion Server, SQL*Net, SQL*Loader, Unix Scripting, Lawson Financials, Perl, Windows Servers, Vault, Redhat Linux, Apachi/Tomcat, ColdFusion, iPlanet, Perl, Coldfusion, Visio, Actuate Report Writer, Weblogic Server, Grid Control Setup, Real Application Cluster, RedHat Linux[2TB]

Oracle DBA, Confidential,NJ (May, 2001 – March, 2002)
Major Responsibilities:

• Support for Development Department developing applications
• Production Support for running Databases World Wide
• Setup for Oracle 9iAS (Discoverer, Forms, Reports, Wireless, Portal, Apache)
• Installation, Tuning of Oracle 8i Databases
• Upgradation to Oracle 9i from 8i
• Tuning of Database Servers
• Supporting Web Logic
• Installation/Maintenance of SQL Server-2000.
• Installation, Maintenance/tuning Informatica 5.1 operations
• Clinical Warehouse in Informatica Power Centre 5.1 (Designer, Repository Manager, Server Manager, Business Objects)
• Studied requirements, model for building Clinical Warehouse Model
• Developed Informatica Mapping, Transformations, Business objects, sessions using Informatica tools
• Installation & Maintenance of Oracle Clinicals 4.0 (SAS 6.0)
• Unix Shell(Korn) Scripting
• Global Search using Intermedia Text
• Oracle Internet Directory(OID) for Centralized LDAP Server

Technical team: 12 System Administrators, 13 DBAs, 22 Developers
Technology Environment: Sun E10000 to Sun 450 machines, Sun Unix 2.6/5.6/8.0, NT4.0/Windows 2000, Oracle 8I with Partitioning, Oracle PL/SQL 8.1.7, Oracle 9i, Oracle 9i Application Server, Oracle Discoverer 6I, Oracle Enterprise Manger(DBA Studio), Java Objects, IBM WebSphere 4.1, Erwin 3.0, SQL Server 2000, Oracle 11.5.5 Applications, Veritas, Informatica 5.1, Oracle Clinical 4.0, SAS 6.0, SQL*Net, SQL*Loader, Toad 6.1, SQL*Navigator, Oracle Discoverer, Performance monitoring and Unix Scripting, Oracle Reports Server, Quest-Toad 7.1, Linux 7.0,ESRI/Oracle Spatial [Databases 10GB to 60GB]

Lead Oracle DBA/Modeler, Confidential,New York (July, 2000 – Apr. 2001)
Major Responsibilities:

• Architect for three running projects: Designed Object Oriented Database Model based on Class Model using Erwin 3.0
• Designed Generalized Interface between Application and Database using PL/SQL
• Project work included conversion from legacy system
• Installation, Maintenance of Oracle 8i, Parallel Server/Replication
• Backup & Recovery Setup using Recovery Manager(RMAN)
• Tuning of Database Servers
• Migration from Sybase 11.5 to Oracle 8i
• Hiring of DBAs
• Solving Technical Problems for 9 DBA’s in the team
• Installation/Maintenance of SQL Server 7.0
• Advance Queuing Setup

Technical team: 1 System Administrators, 9 DBAs, 22 Developers
Technology Environment: Sun 450 machines clustered, Sun Unix 2.6, NT4.0/Windows 2000, Oracle 8I with Partitioning, Oracle PL/SQL 8.1.7, Oracle Parallel Server, RMAN, Replication 8.1.7, Oracle Enterprise Manger(DBA Studio), Java Objects, IBM WebSphere 4.1, Select 6.1, Forte 3.0, Chordiant 2.0, Sybase 11.5, Erwin 3.0, SQL Server 7.0, SQL*Net including Advanced Networking Options, SQL*Loader, Toad 6.1, ftp, Project Manager, Performance monitoring and Unix Scripting, Embarcadero Performance Center 1.7 [Web Based Application 100GB, 52 Tables]

Lead Oracle DBA/Architect, Confidential,New York (Mar, 2000 – June, 2000)
Major Responsibilities:

• Installation, Maintenance of Oracle 8i, Parallel Server, Replication, Standby Databases
• Backup & Recovery Setup using Recovery Manager(RMAN)
• Tuning of Database Servers
• Quality Control
• Application Tuning including PL/SQL
• SQL Server 7.0 Installation & Maintenance
• Unix Shell(Korn) Scripting
• Technical Lead for 3 DBA’s to guide them for project work
• Merging of Data to Universe Database from Source Database
• Materialized Views/Snapshots
• Online Information of Stocks/Trading

Technical team: 1 System Administrators, 3 DBAs, 17 Developers
Technology Environment: HP-9000 machines clustered, HP Unix 11.0, EMC, NT4.0, Oracle 8I with Partitioning, Oracle PL/SQL 8.1.5, Oracle Parallel Server, RMAN, Replication 8.1.5, Oracle Enterprise Manger(DBA Studio), VB 6.0 Based Com Objects, Crystal Reports, SQL Server 7.0, SQL*Net, SQL*Loader, TKPROF, ODBC, Q-Diagnostics, Omni Backup, HP MC Service Guard [Web Based Financial Application 120 GB, 325 Tables]

Senior Oracle DBA/Architect, Confidential,New York (Oct, 1999 – Feb, 2000)
Major Responsibilities:

• Financial Warehouse
• Improved data model with Erwin 3.x
• Online Trading System using Tradewind
• Installation, Maintenance of Oracle 8i, Unix Disk Setup
• Backup & Recovery Setup using Recovery Manager(RMAN)
• Tuning of TradeWind Processes (Time Reduced from 40 Hours to 40 Minutes)
• Wrote Unix Scripts for Installing Oracle 8i, Backup & Recovery along with Tradewing 4.x Installation
• PL/SQL Package for Individual Positions
• Technical Lead of 17 Developers and 1 DBA
• Model in Erwin 3.x
• Hiring of Developers and DBAs
• Merging of Insurance Data to main warehouse database
• Project & Change Management using PVSC

Technical team: 2 DBAs, 1 System Administrators and 17 Developers
Technology Environment: Sun Unix 2.6, NT4.0, Oracle 8i, Oracle PL/SQL 8.1.5, TradeWind 4.x, Legato Storage Manager, RMAN, Java 2.0, Erwin 3.x, PVCS 3.x, SQL*Net, SQL*Loader, Performance monitoring and Unix Scripting, Oracle OLAP Tools [Financial Warehouse 100GB, 800 Tables]

Development Oracle DBA/Architect, Confidential,Canada (Mar. 1999 – Oct. 1999)
Major Responsibilities:

• Installation and Maintenance of Banner Application
• Maintained two production sites of ‘Banner’ billing application
• Database and SQL Tuning
• Setup of Disks and Oracle Database Striping
• Setup of Query Database
• Database Backups and Restore
• Coordinating enhancements with developers
• Installation and Patches for Oracle
• Unix Scripts for Query Database Cloning, Alerts to Check Database Status
• Conversion from 7.x to 8i

Technical team: 5 DBAs, 2 System Administrators and Developers
Technology Environment: IBM AIX 4.3, NT4.0, Oracle 7.3.4, Oracle PL/SQL 3.2, Forms 4.5, Remedy 3.03, Banner 3.0, SQL Back Track, ADSM, SQL*Net, SQL*Loader, Perl, Multi-threaded Server, Oracle Discoverer [Database Sizes 10GB-100GB, 800 Tables]

Senior Oracle DBA/Modeler, Confidential,Canada (Aug. 1998 – Mar. 1999)
Major Responsibilities:

• Tuning & Maintaining SAP R/3, Oracle Financials (Three Tier Application), Tivoli, Remedy applications with Oracle as Database Engine.
• Built Warehouse Database/DataMart Model with Erwin 3.0 based on star schema
• Helped in upgrading PeopleSoft (HR) 5.0 to 7.0.
• Tuning, Backup and Restore of Databases
• Conversion from 7.x to 8.0
• Tuning Lawson Financials, upgraded Oracle versions for Lawson, sorted application problems
• SAP DB Performance Optimization
• SAP DB Database Troubleshooting

Technical team: 2 DBAs and 3 System Administrators.
Technology Environment: HP Unix 10.8, IBM AIX 4.3, NT4.0, SAP R/3, Oracle Financials 10.7, Lawson Financials, Oracle 7.3.4, Oracle PL/SQL 3.2, Tivoli 3.0, Remedy 3.03, SQL*Net, SQL*Loader, Oracle Discoverer [Database Sizes 10GB-100GB]

Oracle DBA/Modeler, Confidential,UT (Feb. 1998 – Aug. 1998)
Project: American Express Stored Value Card Authorization System [SVCAP]
Major Responsibilities:

• Created Parallel Database, Provided Response of 100 Transactions Per Second
• Designed Logical land Physical Model of the Database in Erwin 3.1
• Migration from UDB DB2 to Oracle
• Designed Database
• PL/SQL Package for Processing Transactions & Table Maintenance Screens, ODBC Setup
• Interface with Main System
• Striping for the Disks for Database Setup
• Developed Backup Strategy for the Project
• Understanding of ISO 8583 Messages. Understanding of Bank Credit Card System
• Coordinated programmers

Project Team: Technical Manager, DBA, Unix Administrator, 13 Programmers
Technology Environment: Sun EX10000 machines clustered, Sun Unix 2.5, ErWin 3.5, Oracle Parallel Server, Oracle 7.3.4, Oracle PL/SQL 3.2, IBM DB2 6.x, Change Management using CVS, Visual Basic 5.0 SQL*Net, SQL*Loader, ODBC, BMC-Patrol [Database Size 3 TB, 550 Tables]

TRAININGS:
OpenText Document Management, Oracle Applications Installation & Setup R 11.0[Oracle Financials], SAP DBA, Novel Network, Oracle Database Management System, Systems Analysis & Design, Maximo Administration 5.0, Weblogic Administration 7.0

Pharmaceutical Training:

• Good Laboratory Practices 21 CFR Part 58 Training
• Introduction to Drug Development

EDUCATION:
B. S in Information Systems