Docstoc

Salina Chugh - Sr Oracle DBA Certified Resume

Document Sample
Salina Chugh - Sr Oracle DBA Certified Resume Powered By Docstoc
					Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



       More then Eight years of experience as Oracle DBA with SAP experience.
       Oracle Certified Professional (OCP 9i, 10g).
       Provided 24 x 7 supports to production databases.
       Managed very large Production databases over 1.5 Terabytes.
       Independently handled large installations and guided other DBAs.
       Provided support to SAP ERP database.
       Managed SOX and Security Program while monitoring multiple databases.
       Migrated Production database from Windows platform to UNIX – AIX.
       Hands on experience with AWR tuning and performance.
       Installed and configured Grid control for managing production databases.
       Configured 10g RAC and installed Oracle Clusters
       Developed fully secured production and standby database by implementing Data
        Guard.
       Replicated data using NetAPP Snap Mirror.
       Worked on RMAN and SQL Backtrack for database backup and recovery.
       Extensively used SQL*Loader for large dataload using direct path and parallel loading.
       Expertise in Database Performance Tuning.
       Performed SQL tuning using Explain Plan and tkprof utility.
       Developed procedures by using PL/SQL.
       Developed various shell scripts for export/import, Table/Index analyze etc with
        ksh/bash.
       Worked on third party software’s – TOAD, Spotlight, EZ SQL
       Performed up gradation from 10.7 to 10.9 and migration from Oracle 9.2.0.5 to
        10.2.0.1
       Self-motivated, hard working, strong communication skills and development
        oriented.

ERP Software                        Oracle E-Business suites

Utilities                            adpatch, adadmin, adctrl, adsplice, admrgpch, rapid clone,
                                     adconfig, Oracle Data Guard, Oracle Replication, Steams

File Systems                         ASM, Raw devices

Oracle DBA                           Administration, Performance Tuning for memory, IO, SQL
                                     tuning, Backup & Recovery, Installed and monitored Oracle
                                     clusters and oracle 10g RAC, Oracle network configuration

Oracle Development Tools             Discoverer 3i/4i/10g, TOAD,SQL* Plus, Quest Central

Database Design                      Oracle 10g/9i/8i, Data design and data modeling

Data Migration Tools                 SQL* Loader, Export /Import, data Pump
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



Data Warehouse Tool               Erwin, MS- Visio, Perl

Programming Languages             SQL, PL/SQL, Unix shell Scripting, vi text editor, CGI scripting

Operating Systems                 Linux (Red Hat) and SuSE, HP Unix, Sun Solaris, AIX,
                                  Windows

Support Tools                     SQL Backtrack (For Database Backup and Recovery)

                                  Quest Central, Tkprof (SQL Tuning), Erwin, SQLT, OSW

                                  ERP/SAP and SOX Compliance.



PROFESSIONAL EXPERIENCE:


MGM MIRAGE, Las Vegas, NV                                      Dec’08 – Present
Sr. Oracle DBA

As an Sr. Oracle DBA in a team of 9 with database size of more than 200 terabyte.
Supporting RAC database on Oracle 10g, and migrating systems from on platform to
another. My key responsibilities:-

      Provided 24*7 Production support and on call.
      Supported more than 80 databases at one go.
      Helped implement changes, while working closely with business process owners
       and management.
      Migrated Production system from Windows platform to Unix – AIX.
      Migrated Dev and test environment from Windows to UNIX – AIX using BCV
       snapshot.
      Installed 10g database and cluster ware on servers.
      Installed OEM grid control with 11 G database repository and 10.2.0.5 OMS on
       server.
      Installed database patches and security patches.
      Administered Oracle databases both on UNIX and Windows Environment.
      Configured and Installed NMON to monitor performance.
      Used AWR reports for performance and tunning.
      Documented database standards and procedures, including software installations,
       backup and maintenance procedures.
      Protecting business critical data on Netapp.
      Replicating critical data using Netapp Snap Mirror.
      Configured hot backups and developed scripts for RMAN.
      Updated Oracle systems with Quarterly CPU Patches and other Bug Fixes.
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



      Used Transparent Application Failover (TAF) to configure type and method of failover
       for each Oracle Net client.
      Monitoring database and troubleshooting connectivity and performance issue.
      Monitored system by using different software – OEM, Spotlight, TOAD, SQLT,
       OSW
      Worked as a part of the team with my team members and lead.


Environment: Oracle 11g, 10g, 10g RAC, OLTP, EMC Storage, Windows 2000, LINUX –
Redhat, UNIX – AIX, Grid Control, AWR, Spotlight, TOAD, OSW, SQLT and SQL
Backtrack



Union Switch & Signal, Pittsburgh, PA                             March’08 – Nov’08
Sr. Oracle DBA

As an Oracle DBA in a team size of 8 with database size of 1 terabyte. Supporting RAC
databases, 10g databases and technical support to clients in US. My key responsibilities
includes:-

      Production support 24*7 and on call
      Supported 50 databases at one go
      Provided support to 3.0 terabyte SAP/ERP database implementation.
      Ensured SOX and internal control and process compliance
      Played a key role in the Company’s SOX compliance efforts including process
       documentation
      Installed 10gAS infrastructure on two node RAC with 10gR2 metadata database for High
       Availability and Local Failover
      Extensively used Oracle Grid control to monitor systems.
      Oracle 10g RAC troubleshooting on Redhat and SuSE Linus Enterprise 9
      Participated with various IT teams during internal and external audits.
      Developed the Backup and recovery design and implementation
      Configured and implement RMAN 10g in Linux
      Oracle High availability/ cluster design and implementation
      Installed Data Guard on oracle 10g database
      Developed scripts for partitioning and helped clients in implementation
      Worked on hot box and gateway application server
      Installed and configured Automatic Storage Management(ASM)
      Using OEM to monitor overall performance for database
      Tune instance recovery in RAC
      Import and Export using datapump
      Other DBA activities such as Patching, Cloning and Backup-Restore ,troubleshoot
       developer and users day to day issues
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



Environment: Oracle 10g, ERP/SAP, 10g RAC, LINUX –Redhat and SuSE, UNIX – AIX, Sun
Solaris, BMC – SQL Backtrack, Oracle Grid Conrol.




Belkin Corporation, Compton, CA                                 July’07 – March‘08
Oracle DBA

As an Oracle DBA in a team size of 6 with database size of 1.5 terabyte. Supporting database
server, Oracle 10g RAC and 1500 employees globally. My key responsibilities includes:-

      Provided production as well as development DBA support.
      Upgraded database (9.2.0.5) to 10g (10.2.0.2)
      Technical support to Europe, Asia and USA as DBA.
      Installed oracle clusters and oracle 10g RAC for production environment.
      Monitored RAC for Middle tier, database and end users.
      Conducted oracle 10g RAC testing and hence provided support for oracle cluster ware.
      Developed disaster recovery process, implemented it and hence testing the
       environment.
      Establish and maintain sound manual/RMAN backup, recovery procedures, Oracle
       Standby server for disaster recovery solutions, database security and standard
       guidelines.
      Developed secure database by implementing Data Guard.
      Managing, Monitoring RMAN Backup for PROD DBs and HOT backups for DEV DBs.
       Cloning of the Database from one box to another.
      Provided 24X7 on-call operational supports to maintain Database in Production
       environment
      Perform overall health checks on the database at regular interval by developing Bash
       Shell scripts to automate the job.
      EMC storage area network (SAN) support for 1 terabytes of file system
      Monitoring/Maintaining the Data Mart
      Performance tuning for the Oracle Application concurrent Manager
      Performance tuning/Reorganization for Oracle instance
      Creation of new user, monitoring and maintenance
      Implementing upgrades for the code in QA and Production
      Liaison between QA Team, Development, Management, Order entry etc.
      Solving day-to-day users related problems like maximum extents fill, increasing the
       size of rollback segments.

       Environment: Oracle 10g, 10g RAC, Oracle Clusters, EMC Storage, UNIX - AIX



Traco, Inc., Omaha, NE                                                  Aug’06 – Jun’07
Oracle DBA
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



As Oracle DBA in a team size of 4, with database size of 800 gigabyte, supporting Oracle
application servers 11.5.9. and database servers in Production and development environment
on Sun and Windows servers. My responsibilities include:

      Installed Oracle 10g, maintained and provided 24*7 supports.
      Involved in SAP basic implementation and Oracle database administration.
      Worked and monitored database processes by using Sun Solaris platform.
      Installed and configured E-Business suite
      Managed Oracle Datapump. Worked on Oracle Text Indexes. Created Context
       Indexes.
      Applied SAP kernel patches.
      Tuned the Context Indexes built time. Created Local Partitioned Context Indexes on a
       Range Partitioned table. Refreshed DBs from One Box to Another.
       Managed Partitioned Tables, Partitioned Indexes. Created Local Partitioned Context
       Index on Range partitioned table. ASM – Creating ASM Instance, Setting up ASM Init
       Parameter, Managed & Maintenance ASM Disk groups & ASM Disk Strings.
      Set up and Managed Flash Recovery Area. Worked on 10g Flashback Technologies:
       Flashback version query, Flashback Transaction Query, Flashback Table. Configured
       and Enabled Flashback Database.
      Configured iAS and discoverer servers for 11i and provided discoverer admin
       support.
      Administered Forms server, Web Server, and Report server.
      Writing shell scripts for Physical and Logical backup and to automate DBA activities.
      Performance tuning for Application servers.
      Responsible to resolve any issue in PROD, and in pre-prod environments
      Worked with Developments teams for code testing for performance, and then migration
       to PROD.
      Trained, directed, guided and mentored 6 DBAs
      Worked on de-supported version of Oracle RDBMS/Apps and suggested pathway to do
       migration to supported versions.

      Environment: Oracle 10g, SAP, Apps. 11.5.9, E- Business, Sun Solaris, SQL
Backtrack



Beckman Coulter, Inc., Fullerton, California                            Oct’05 – July’06
Consulting Oracle DBA

As an Oracle DBA in team size of 4, with database size of 600 GB, supporting 12 different
databases like Production, Financial and HR environment, test on RedHat platform. My
responsibilities includes:

      Created 10g DBs on RedHat using DBCA.
      Split configuration on RedHat Linux/ EMC DMX 3000
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



      Upgraded database from 9i to 10g
      Upgrade and configure JDK to 1.3.1
      Cloning of database using hot and cold backup.
      Upgraded and managed billing application.
      Scheduled backups by using Shell Scripting.
      Install OEM (Grid control) and scheduling data processing jobs, Backups and Events
       for Mail and Pager.
      Developed a functional area to solve root cause problems.
      Written and maintained Several Monitoring shell scripts to provide and check
       progress of backups, dynamic switching of archive log destination and to check alert log
       files.
      Worked on Applying on DST (Day Light Saving Timing) Patches
      Working with Spotlight
      As a Financial Administrator, performed followings:
            o Setup new user.
            o Setup user profile.
            o Managed concurrent processing.
            o Tuned Oracle Application and Databases.
            o Implemented Security.
            o Provided physical DBA support to Oracle Financials.
      Migrated custom code, cloned, monitored & solved real-time problems.
      Documented 1 global production
      Maintained the Enterprise Data Warehouses (EDW - dev, test, prod) owned by the
       Business Intelligence Group and assisted when data extracts from the Production failed
       to complete.
      Utilized OEM, OAM, ACT, RDA, Oracle Diagnostics, Statspack Reports, etc. on a
       daily basis.
      Supported developers by moving / compiling new code, and generated / tkprof-ed trace
       files.
      Refreshed DBs from One Box to Another. Created DB Link between Oracle and SQL
       Server DBs.
      Extensively used Datapump. Using REMEDY. Backing up and Refreshing SQL
       SERVER DBs.
      User Administration, Creating Tables, Application Specific queries using SQL Analyzer
       in SQL SEVER DBs. Configured the RMAN Backups using HP Omni Data Protector.
      Supported and participated on vendor selection committee selecting Sarbanes-Oxley
       and Archiving/Purging vendors.
      Explored 10g’s improved Automatic Optimizer Statistics Collection using Automatic
       Workload Repository (AWR). Worked with AWR Snapshots, Created Baselines,
       Viewing AWR Reports. ADD on analysis on AWR Snapshots. Explored Automatic
       Shared Memory Management.
      Configured, established, and enabled auditing of Global Production database.
       Provided current 11i information to technical staff and documented all progress.
      Changes password of application users through FNDCPASS
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



   Environment: Oracle 9i, 10g, 10g RAC, SQL Server, Linux – RedHat



Wyman-Gordon Forging - Houston, TX                                      Nov’04 –Sept’05
Oracle DBA


As Oracle DBA I a team size of 3, with database size of 400 GB, supporting Oracle database on
Linux platform. My responsibilities include:

      Installation of Oracle Server 8i/9i. Database migrations/upgrades (8i and 9i)
      Upgrade of Oracle Application Database from 8.7.1 to 8.7.2 (ADPATCH)
      Acting as configuration controller.
      Performance Tuning the database using TKPROF, STATSPACK for optimum
       performance and to meet users requirement. Assisting Developers in writing and tuning
       their queries.
      Writing Pl/Sql programs, Database Triggers, Sequences, and Packages for different
       applications.
      Used Db partition, OEM and QUEST TOAD tool for handling multiple databases.
      Implemented UNIX, database and application security features to pass critical Sarbains-
       Oxley audit requirements
      Performed RMAN backups and recoveries using the HP Data Storage
      Created the database using Oracle Managed Files. Administered and Managed OMFs
       Configured the Instance for Automated UNDO Management by creating UNDO table
       spaces.
      Implemented Memory Management new feature: Automatic and dynamic sizing of
       SQL working areas, Buffer Cache Advisory.
      Created Materialized Views.
      Implemented Resumable Space Management features by using dbms_resumable
       package.
      Configuring TNSNAMES.ORA and LISTENER.ORA for Client Server Connections
      Performed data migrations to build/upgrade 9i databases on NT servers.
      Project lead for the Oracle Discoverer implementation
      Performed the responsibilities of the Oracle Discoverer 3.1 and 4.1 Administrator
      Rolled out the Discoverer 4.1.46 client to user PCs.
      Writing ksh scripts for monitoring database environment.
      Designing of customized databases using ERWIN

   Environment: Oracle Server 8i/9i, Linux - SUSE 10, Sun Solaris Servers, HP Servers



First American Res, Santa Ana, CA                                       Feb’04 –Oct’04
Senior Oracle DBA
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



As an Oracle DBA in the team size of 4, with database size of 1.3 terabyte, supporting Oracle
database 10g on solaris platform. My responsibilities includes:

      Created 10g DBs on Solaris using DBCA. Worked on Large Database of size 1.3
       Terabyte.
      Developed and maintained scripts for Flash Recovery Area.
      Upgraded the DB from 9.2.6 to 10.2.2. Managing, Monitoring RMAN Backup for PROD
       DBs and HOT backups for DEV DBs. Cloning of the Database from one box to another.
      Managed Oracle Datapump. Worked on Oracle Text Indexes. Created Context Indexes.
      Tuned the Context Indexes built time. Created Local Partitioned Context Indexes on a
       Range Partitioned table. Refreshed DBs from One Box to Another.
      Managed Partitioned Tables, Partitioned Indexes. Created Local Partitioned Context
       Indexed on Range partitioned table. ASM – Creating ASM Instance, Setting up ASM Init
       Parameter, Managed & Maintenance ASM Disk groups & ASM Disk Strings.
      Setting up and Managing Flash Recovery Area. Worked on 10g Flashback
       Technologies: Flashback version query, Flashback Transaction Query, Flashback
       Table. Configured and Enabled Flashback Database.
      Day to Day General Administration (Tickets by PVCS Tracker):- Table-pace
       Management, Undo Management, Managing Users, Resources, Managing User
       Privileges and Roles.
      Configured network for Oracle database with Tnsnames.ora and Listener.ora.
      Implemented Auditing the Database. Tuned the Slow SQL queries.
       Monitored DB Performance using STATPACK, TKPROF, SQLTrace, and Explain
       Plan.
      Configured RMAN. Exposure to Basic SQL SERVER ADMINISTRATION.
      Created Users, Implementing Backups, refreshed the Databases.

   Environment: Oracle 9.2, Oracle 10g, SQL Server, UNIX- Solaris Platform


CresTech Noida, India                                               May’03 – Jan’04
Oracle DBA

CrescoTech is a software development company and about 120 Developers working on
different international clients. Worked as Database Administrator coordinated and managed
tasks and worked with developers to identify database requirements needed to build instances
interfaces or customized code.

Responsibilities:

      Installation, configuration, and maintenance of Oracle 8i and 9i on Linux - RedHat
       environment.
      Create and Maintain Roles and assign necessary privileges to users according to
       business rules.
      Implemented Database Backup (Physical and Logical) and Recovery strategy
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



      Configuring TNSNAMES.ORA and LISTENER.ORA for Client-Server connections
      Monitoring Alert Logs
      Creating & Maintaining Tablespaces.
      Choosing different types of data storages (Locally Managed Tablespaces, IOT and
       partition tables) and indexes in order to have good performance for SQL and DML.
      Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack,
       Utlbstat, Utlestat, Diagnostic and tuning packages
      Created & Configured RMAN recovery.
      Backing up the production database, synchronizing the standby database by responding
       to any physical changes in the primary database.
      Work as part of a team and provide 24*7 support when required

   Environment: Oracle 8i, Oracle 9i, Linux - RedHat Platform




Dayanand Medical College & Hospital, Ludhiana, India                     Dec’ 00 – May’ 03
Oracle DBA

DMCH is a leading hospital of North India and 1000 bedded hospital. It provides the finest and
latest health technologies with 24*7 working strategy.

Responsibilities:

      Form the Logical and Physical Backup Strategy and Documentation
      24x7 support for Oracle Databases on Windows 2000, Win – NT, UNIX platform.
      Migration of Database from 8.0.4 to 8.1.6.
      Writing shell scripts for Physical and Logical backup and to automate DBA activities.
      Install OEM and scheduling data processing jobs, Backups and Events for Mail and
       Pager.
      Calculate and Set optimization parameters of Table and Block like PCTFREE,
       PCTUSED, INITIAL, NEXT, PCTINCREASE, MINEXTENTS and MAXEXTENTS
      Database backup and Recovery
      Performance Tuning of Oracle Application Database
      SQL Tuning using TKPROF and Explain Plan
      Creation of new tablespaces and adding and resizing the datafiles
      Creating new users and grants them required privileges and roles, intermedia indexes.
      Solving day-to-day users related problems
      Creation of Tablespaces based upon application and workload, Adding Data files and
       maintained documentation.
Salina Chugh
Oracle DBA
Email- salinachugh4@yahoo.com
Phone: 404-424-3480



      Writing PL/SQL programs

   Environment: Oracle 8i, Windows 2000, Windows NT, UNIX- AIX Platform

EDUCATION:

      Master of Computer Application, Punjab Technical Education, Jallandhar
      Bachelor of Arts, Punjab University, Chandigarh
      Post Graduate diploma in Computer Software, ET&T, New Delhi

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:125
posted:9/12/2012
language:English
pages:10