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
• Expert in Modeling. Modeled GIS Database with requirements covering Asset Management
• Warehousing experience including Informatica, Netezza, Exadata
• Comes with development background so excellent for application tuning & PL/SQL Programming

DOD CLEARANCE – Security

CERTIFICATIONS

• Database Administration: Oracle(11g,10g,9i,8,7), Oracle 10/11g Grid & Infrastructure, Oracle Exadata 11g, DB2, Sql Server, Sybase, SQL Server
• Replication: Oracle GoldenGate 10
• WareHousing: Oracle Exadata, Netezza, Informatica
• Data Modeling: Training Dimension Modeling in Debth by Ralph Kimball
• NoSql/Bigdata: Hadoop, HDFS, MapReduce, Pig, Hive*
• Cloud Computing Architecture
• Enterprise Architecture for Java Platforms, Architecture for Java Technology
• IT Service Management: ITIL
• Technology: Unix, Windows
• Development: PL/SQL Programming, Unix Scripting

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 24x7
• Coordination with offshore production teams
• Coordination with offshore Development teams
• PL/SQL Development and Developers Support for SQL Tuning
• Testing Nosql(Hadoop, HDFS, MapReduce, Pig, Hive)
• Warehouse in Netezza, Exadata

Technology Environment: Linux, Sun Unix, Veritas Cluster, Veritas Volume Manger, Oracle 11g R2 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, EMC SRDF, NoSql(Hadoop, HDFS, MapReduce, Pig, Hive), Netezza

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]

EDUCATION:

• B. S in Information Systems, Toronto University, Canada