Sandeep KUMAR

Document Sample
Sandeep KUMAR Powered By Docstoc
                                                                     Oracle Database Administrator


Over 8+ years of IT experience as Senior Oracle Database Administration Ver. 10G/9i/8i/8.0/7.x on a
variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle (7.x, 8.0.5, 8i, 9i, 10g),
Stored Procedures, DB Triggers, Developer 2000, Sql*Plus, Pro*C etc.

   Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and
    migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i to 10g applied oracle patches.
   Installed Oracle 10g RAC software with ASM & OCFS2 File systems
   Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle
    Application maintenance utilities like OEM.
   Created development, testing, staging, production, RAC and standby databases for OLTP, DSS
    and Data Warehousing using customized shell scripts and stepwise.
   Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.
   24*7 production database support with Support to developers & end-users.
   Have implemented ORACLE STREAMS, and two type of standby databases supported by
    DATAGUARD, logical standby and physical standby databases
   Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using
    RMAN with VERITAS Net Backup.
   Have worked on large-scale databases with size of more than 1TB in large system environments.
   Implemented and delivered core edge technologies of Oracle 10g (Streams, EM Grid Control, and
   Logical and physical modeling using Erwin.
   Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete
    recovery and disaster recovery using Standby database or Data Guard.
   Implemented automated backup strategy using the UNIX shell script CRON UTILITY
   Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by
    Using CRONJOB for Day – to – Day activities.)
   Have experience in setting up SQLServer2005, and have done backup, recovery and performance
   Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK,
    TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of
    tables and indexes.
   Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments,
    buffer cache, redo mechanisms
   Installation and Configuration of Oracle Grid Control.
   Strong knowledge of Data Warehousing methodologies and concepts, including star schemas,
    snowflakes, ETL processes, dimensional modeling and reporting tools.
   Extensive experience with designing and implementing Oracle databases, data warehouse design,
    implementation and tuning.
   Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
   Database replication using snapshots, materialized views and advanced Queuing methods.
   Worked on different types of storage structures (SAN/NAS).
   Experience in Upgrading and Oracle database migration of Oracle 10gR2 from Solaris 5 to
    windows server 2003,Solaris 5 to Linux, higher version and other platforms using Oracle Database
    Upgrade Assistant (DBUA), Database Migration Assistant (DBMA) and (TTS) Transportable
   Expert in sizing, capacity planning, backup, and recovery planning with multi-terabyte data
    warehouse solutions in Oracle environments.
   Extensive knowledge in reporting tools like Business Objects and crystal reports
   Good co-ordination and communication with system administrators, business data analysts and
    development teams.


OPERATING SYSTEMS:            HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux
                              RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.
RDBMS:                        Oracle 11g/10g/9i/8.x/7.x, Oracle 10g Real Application Clusters (RAC),
                              SQLServer2005.Oracle Streams
LANGUAGES:                    SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting.
SOFTWARE             /        ORACLE 7.x/8.x/9i/10g,OAS 10g Recovery Manager (RMAN), Real
APPLICATIONS/ TOOLS:          Applications Cluster (RAC), STATSPACK, ERWIN, Teradata, Clusters,
                              Veritas Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise
WEB TOOLS                     HTML, XML


Title           Sr. ORACLE DBA
Client          Luxottica Retail
Work Location   Mason, Ohio
Duration        May 2008 – Till Date
Environment     Windows NT/ 2000, HP-UX, AIX,Solaris and Linux, Oracle 9i and 10g,11g, TOAD
                Space Manager with LiveReorg, Erwin 7.2, Citrix, Oracle Enterprise Manager,
                RMAN, SQL*Plus, PL/SQL, SQL*Loader, Oracle Streams, RAC

Project Scope: Luxottica Group is the world’s leading designer, manufacturer and distributor of
prescription frames and sunglasses in the premium and luxury segments. In addition to an extensive
global network, the Group manages leading retail brands such as Lens Crafters and Pearle Vision in
North America, OPSM and Laubman & Pank in Asia-Pacific and Sunglass Hut globally. The goal was
to implement the Streams Replication for store data. Configuration of streams from nine databases to
one target database. And provide the failover through Datagaurd for the target Database.Configured
Grid control to monitor the Streams.And Provide the on call support to Streams related issues. And
also to install and configure RAC.

   Responsible for administration and supporting Oracle 9i and 10g databases.
   Performed upgrades from Oracle to on Intel and HP boxes.
   Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 9i
        over to HP Itanium boxes running Oracle 10g.
   Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g and 11g). Installed and created 10g
    databases and 10g OEM. Installed RAC on Oracle 11g and worked on ASM.
   Installed Oracle Grid Control and monitored Streams Issues using Grid Control.
   Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting
        privileges And user logins
   Configuration, maintenance and tuning of Oracle 9iRAC and 10gRAC.
   Configured Failover Database using Datagaurd for Streams Database.
   Performed Network Traffic Tests for Streams.
   Configured Streams setup from HP-UX boxes to SUSE Linux Boxes.
   Installing and configuring Recovery Manager (RMAN).
   Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF),
    RAID, RAW Devices.
   Cloning databases using scripts as well as RMAN.
   Migrated database Oracle 9i from Solaris 5 to Suse Linux with minimal downtime.
   Data Replication, Event Management and Notification.
   Query optimization for reporting and ETL
   Data Warehouse Loading, Data Protection.
   Extensive UNIX Shell scripting in csh, ksh.
   Data Modeling, Database Design and Creation using Erwin.
   Reverse engineering and forward engineering using Erwin
   Involved in Creating / Renaming the database and implementing SOX policy.
   Downsizing and defragmenting the Very Large Databases by export / import, cloning those using
    RMAN duplicate features and then upgrading them to Oracle 10g.
   Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.
   UNIX shell scripting in csh, ksh to be controlled from Crontab.
   Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
   Extensive Performance Tuning, Memory (SGA) Tuning, etc.
   Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with
    development Team. Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s
    (OEM’s), Oracle cost optimizer, SQL analyzer, top session, top SQL, Performance Manager, etc.,
    Statspack, TOAD. For SQL tuning using “Explain plan”, “TKPROF”, “SQL_TRACE”, Optimizer
    modes, using Optimizer hints, Gathering statistics, Statspack etc.
   Expertise in interpreting EXPLAIN PLAN.
   Made performance improvements to the database by building Partitioned tables, Index Organized
        Tables, Materialized Views and Bitmap Indexes
   Create database maintenance plans, including updating statistics, re indexing, structure
    modifications, Capacity plans, and index analysis.
   Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments &
    Data Dictionary.
   Oracle streams configuration and performance tuning.
   Used Oracle Internet Directory to leverage the scalability, high availability and security features of
    the Oracle Database.
      Taking Hot and Cold Backups, Exports etc.
      Assisting customer setup, tune and maintain Oracle database.
      Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle
       Advanced Queuing feature to set up multi-master replication, dealt with conflict resolution and
       performance issues.
      Data Modeling, Database Design and Creation and creation using Erwin.
      Deciding the naming conventions of data file, redo log files, table spaces, and segments.
      Writing scripts for backup and recovery, Import and export procedure.
      Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts
      Applying patches both Server side and Client side.
      Setting up new environments (Development, Production).

    Title           Sr. ORACLE DBA
    Client          Merrill Lynch
    Work Location   New Jersey
    Duration        March 2007 – Feb 2008
    Environment     Windows NT/2000, HP-UX, AIX,Solaris and Linux, Oracle 9i and 10g, Toad
                    Database Tools/Utilities, Enterprise Manager, Erwin, Aqua Data Studio 3.7,Query
                    Analyzer, Oracle Fail Safe

Project Scope: Merrill Lynch is one of the world's leading wealth management, capital markets and
advisory Companies. There were many development projects which were going on, as a result of ever
growing demand of new databases in the organization, the development projects were more client
based, which included all the client related information as well as investment data, other tasks also
included supporting production databases.

 Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4
 Installed RAC on Oracle 10g and worked on ASM feature of Oracle
 Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and
   Logical IO and Memory Usage.
 Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.
 Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback
   segments, buffer cache, redo mechanisms
 Worked on Automatic Storage Management (ASM) for managing data in SAN.
 Configured Oracle data guard and Streams.
 Oracle streams configuration and performance tuning.
 Data Modeling, Database Design and Creation.
 Reverse engineering and forward engineering using Erwin.
 Migrated database from Oracle 8i to 10g from Solaris 5 to Linux.
 Design, review and maintenance of database structures.
 Query optimization for reporting and ETL.
 Performance assessment, SQL scripts, stored procedures, functions and transactions analysis
 Oracle Grid Control Management Server Installation
 Database backup and Database tuning for real time and batch systems
      Assisting customer setup, tune and maintain Oracle database.
      Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM)
       on daily basis observing the performance of the production database and constantly active
       regarding performance and space management issues and accordingly providing on-fly solutions
       to make database healthy and running.
      Made performance improvements to the database by building Partitioned tables, Index Organized
       Tables, Materialized Views and Bitmap Indexes.
      Data extraction from various sources, transformation and loading into the target Oracle database
       using Informatica Power Mart.
      Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized
      Generated Reports using crystal reports
      Supported development effort by providing SQL statement tuning and optimizing ETL procedures
       and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace,
       TKPROF, TOAD and Oracle Enterprise Manager.
      Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and
       use of Hints, Stored outlines, Statistics for the same.
      Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and
       permissions to appropriate groups.
      Oracle replication (advanced queuing, materialized views etc)
       Devised & Implemented backup strategies using hot, cold, and exports based on the business
      Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
      Installed and configured Oracle 10g database on a test server using Oracle standard procedures and
       OFA, for performance testing and future 10g production implementation.
      Cloned schemas, objects and data on new server using exports from 9i database and imported in
       10g using Oracle data pumps.
      Trouble shooting of various database performances by proper diagnosis at all levels like SQL,
       PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java
      Developed UNIX shell scripts to perform the above tasks efficiently.
      Worked as a member of production DBA team in perfect coordination with seniors and team

    Title           Sr. ORACLE DBA
    Client          Jet Blue Airways
    Work Location   Long Island, NY
    Duration        Sep 2005 – Jan 2007
    Environment      Solaris 8.0/9.0/10.0, OAS 10g, Linux Red Hat, Windows 2000/2003 Oracle 8i
                    (8.1.6/8.1.7), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle Partitioning,
                    Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server
                    2000, Toad, Erwin 7.2.

Project Scope: JetBlue Airways is an American low-cost airline owned by JetBlue Airways Corporation.
Responsibilities include installation, configuration and maintenance of the oracle database. All
administration procedures were automated using ‘cron’ job scheduler. All alerts and errors were
monitored and reported automatically during normal and batch runs and interfaced with pagers and
email system. Involved in the entire development life cycle right from development to production,
other tasks included were supporting and tuning oracle applications.

 Review of Database logical and Physical design.
 Install, upgrade and maintain Oracle software products/versions for on Linux, Sun Solaris and HP-
 Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and
 Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
 Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.
 Worked with ETL tool Data Stage and Ware house tool Business Object.
 Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing
   queries using an optimized path, Creation of Materialized Views and gathering necessary statistics
   on objects etc.
 Implementing Database Security, Management of role-based security
 Database Restore using RMAN, Cold Backup and Export.
 Data Modeling, Database Design and Creation using Erwin.
 Applying Patches and applying Oracle DST Patches on Oracle database.
 Performing day-to-day database administration tasks like Tablespace usage, checking alert log,
   trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
 Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle
 Corporation and installation of patches.
 Write and modify UNIX shell scripts to manage Oracle environment.
 Problem analysis involving interactions/dependencies between UNIX and Oracle.
 Production support for Oracle running on UNIX.
 On-Call 24x7 DBA support for production databases.
 OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator
 Data Migration as part of enterprise data warehouse project.
 Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, Net backup, EMC (Time
   finder and SRDF), RAID, RAW Devices.
 Cloning databases using scripts as well as RMAN. Installation, setup and configuration of DATA
 Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
 Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

 Title              ORACLE DBA
 Client             CVS
 Work Location      Woonsocket, Rhode Island.
 Duration           APR 2004 – Aug 2005
 Environment        Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise
                    Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, Explain plan, STATSPACK,
                    SQL*loader, Windows NT/2000

Project Scope: CVS Caremark is the nation's premier integrated pharmacy services provider, combining one of
the nation's leading pharmaceutical services companies with the country’s largest pharmacy chain. The company
fills or manages more than one billion prescriptions per year, more than any other pharmacy services provider.
CVS Caremark drives value for pharmacy services customers by effectively managing pharmaceutical costs and
improving healthcare outcomes through its 6,200 CVS/pharmacy stores; its pharmacy benefit management, mail
order and specialty pharmacy division, Caremark Pharmacy Services; its retail-based health clinic subsidiary,
Minute Clinic; and its online pharmacy,


      Performed day-to-day DBA jobs for managing Production/Development databases.
      Provided 24X7 supports for production problems.
      Logical and Physical Modeling using ERWIN Data Modeler.
      Management of tablespaces for different users by granting quota on Default & Temporary
      Estimated Storage capacity for database objects.
      Monitored the growth of the database objects UNIX Shell scripting. Implemented for capacity
      Created UNIX shell scripts to automate batch jobs through Cron.
      Extraction of data from different flat files into Oracle Database using SQL*Loader and automated
       the process by using Basic Replication using materialized views.
      In-depth experience in Data Warehousing using Informatica and Oracle.
      Utilized SQL*loader and data pump import to load data into tables.
      Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, and schemas.
      Database Administration and Planning including logical design, physical design, backup &
      Took a logical backup of the entire database using import/export utility.
      Created and implemented Oracle database backup and recovery strategies using RMAN.
      Monitored the various database activities such as backup, error logs, space, object, performance,
       user and session monitoring to ensure proper capacity and availability
      Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN
       PLAN, optimizer hints and SQL tuning advisor.
      Tuning test and production database by altering the parameters.
      Export and Import of database objects to copy from one database to another database.
      Investigating suspicious database activity using Auditing.

    Title           ORACLE DBA
    Client          Canara Bank
    Work Location   India
    Duration        Nov 2002 – Feb 2004
    Environment     Oracle 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Erwin, Import/Export,
                    UNIX AIX 5.1,Windows NT.

Project Scope: Canara Bank provides a full range of commercial banking products and services to
individuals, corporations, institutions and governments, through its personal financial services, private
banking, commercial banking and corporate investment banking and markets segments. This project is
developed as a process of automation for insurance policy management by using centralized data
warehouse and Data Mart.

 Involved in production support activities 24/7 during on call and resolved database issues.
 Backup Script creation and Standardization. Performed Database Installation and up gradation.
 Created materialized views, table partition for Tuned databases.
 Created indexes, rebuild indexes and maintained indexes.
 Involved in user creation and user access control. Involved in Schema creation and management.
 Implemented Oracle security features and audit mechanisms for Fine grained access control.
 Maintained the RMAN repository and customized recovery catalog.
 Customized Data Guard as a tool for Disaster Planning and implementation.
 Created Logical and Physical standby Databases to ascertain high availability of database during
   system crashes.
 Performed database tuning for daily loads and slow response issues.
 Used Triggers for database activities, like delete, update triggers.
 Used Statspack, Perfstat, and TKPROF utilities for Tuning and analysis.
 Involved in session management and monitored the critical wait events in the database.
 Involved In query optimization and using rule based optimizers and cost based optimizers.
 Used SQL* Loader for data import from remote databases
 Written the control files in SQL*Loader to load the files in database tables.

    Title           ORACLE DBA
    Client          Fenner India
    Work Location   India
    Duration        Mar 2001 – Sep 2002
    Environment     Windows 98/NT/2000, HP-UX, Oracle 8i/7,TOAD,Database Tools/Utilities

Project Scope: Project’s included building; maintaining and testing databases, involved in the entire
development life cycle right from development to production, other tasks included were supporting
and tuning oracle applications.


      Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
      Analyzed the structures using Analyze command.
      Involvement in all phases of the project life cycle
   Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse
    of the database and system
   Assuring appropriate backup and recovery procedures to be in place to meet the Company’s
   Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
   Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo
    log tuning, Rollback tuning.
   Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Shared By: