SUMMARY:

• 7 plus years of experience in Oracle Database Administration, Database Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions.
• Good analytical and planning skills.
• Strong verbal and personal communication skills.
• Have worked with global clients while supporting offshore teams.
• Extensive experience in deployments while working with developers
• Provided production system support to customers with critical issues.
• Provided 24x7 critical production support on large databases using Oracle 11g, 10g
• Worked with Oracle 12c cloud control.
• Performed RAC build from scratch.
• Strong experience in supporting development and production databases.
• Have worked on all Windows, AIX, Sun Solaris, HPUX and different flavors of Linux.
• Implemented High Availability solutions with Oracle 10g/11g R2 RAC, Standby Database Data Guard, Replication.
• Good decision making skills.
• Self - motivated and initiator.
• Ability to work under pressure.
• Good presentation skills.
• Experience in Managing/working with RAC databases
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g
• Expertise in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and performance tuning.
• Experience in Upgrading database instances to 10g R2 to 11g R1 to 11g R2
• Experience in apply PSU patches.
• Worked on different backup methods using RMAN.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Expertise in maintaining Database Security using auditing.
• Working experience in both OLTP, DW and DSS environments
• Extensive Knowledge on Flashback
• Extensive experience in Data Guard physical standby databases
• Good knowledge on partitions and clustering of tables
• Worked with different performance utilities like Statspack, ASH, AWR, ADDM, ORADEBUG, HANGANALYZE etc. to troubleshoot performance issues.
• Extensive experience with designing and implementing Oracle databases, cloning of databases and setting up RAC database
• Worked with several Multi node and multi-tier environments.
• Excellent experience in writing SQL
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Good working knowledge in tuning the oracle databases.
• In-depth knowledge of SQL (DDL, DML, and DCL)
• Working knowledge on PL/SQL.
• Used TOAD and ERWIN.
• Extensive knowledge on Oracle Support processes for technical requests with Metalink.

TECHNICAL SKILLS:

Operating Systems: HP-UX, AIX, Windows, Linux, SUN Solaris

Languages: SQL, PL/SQL, BASH shell.

Oracle Tools: TOAD, RMAN, OEM, TOAD, SQL*Loader, DATAPUMP, Export/Import

Hardware/Storage: HP MSA 5000, EMC,VERITAS Net Backup, Tivoli Storage Manager

Tuning Tools: TKPROOF,EXPLAIN PLAN,STATSPACK

PROFESSIONAL EXPERIENCE:

Confidential, Downers Grove, IL

Oracle DBA

Responsibilities:

• Build and supported RAC
• Build Data Guard Servers
• Configured ASM
• Worked with different teams
• Provided 24/7 Production support.
• Worked on projects.
• Migration
• Automating
• Upgradations.
• Setting up new database environment.
• Build Oracle DBA in the Database Management Services group (DMS), which supports and maintains the database infrastructure
• Worked on project to move from standalone servers to RAC
• Build physical Standby Data Guard.
• Practiced DR by performing switchover and failover using data broker.
• Supporting Production and Development databases in 24x7 Environments
• Database environments Installation, upgradation, Migration, Patching, Maintaining of all Oracle versions 8i, 9i, 10g and Oracle 11r2 and
• Operating systems on clustered/shared HP-UX UNIX, Linux and Windows servers
• 200 corporate databases in production, acceptance, development and training environments.
• Work in conjunction with application DBAs to develop and maintain the application database.
• Configuration of Oracle Data guard in Oracle 10g environment, using 11g/12c Grid Control.
• Migration of Oracle database 10g to 11R2.
• Configuration and testing of RMAN, with implementation to production.
• Migration includes the migration from Windows to Linux using Transportable tablespaces.
• Provided test plan documentation for uni-directional GoldenGate.
• Performance tuning and reorganization of Oracle Financials database.
• Use of AWR and Statspack tools to diagnose performance issues with Oracle Application
• Provided Automated Storage Management (ASM) technical assessment document.
• Provided architecture document for the ASM including for Oracle and HP-UX Unix physical and logical layout.
• Installation, configuration and migration of Oracle Financials database warehouse to Oracle ASM.
• Extensive experience with RAID and ASM configuration.
• Administered ASM from command line and grid control.
• Upgrade of ASM from Oracle 11.2.0.2 to Oracle 11.2.0.3
• Configuration of security settings for Oracle Financials involved reconfigurations of Oracle roles, users, creation of triggers, procedures, synonyms and table constraints.
• Responsible for the creation of the ASM Operation( Confidential ) Manual and Quick Reference documentation for use of other team members.
• Automation of Oracle Restart Configuration for the instances under the ASM configuration, part of the Oracle High Availability Services configuration.
• Configuration and installation of VM Ware in Oracle 10g and Oracle 11gR2 environment.
• Worked on SQL Server 2005 and SQL Server 2008
• Configuration and troubleshooting of Oracle Agents connections to Oracles OEM Grid Control.
• Daily use of Oracle Grid Control.
• Installation and configuration of Oracle 10gR1, 10gR2, 11016, 11R2 on HP Itanium HP-UX UNIX servers.
• All work completely documented.
• Perform daily database administration as required.

Confidential Chicago, IL

Oracle DBA

Responsibilities:

• Provided 24/7 suppoHP PA-RISC, HP-UX Itanium, Linux, Windows 2003, Windows 2008.rt.
• Worked on Clustered databases.
• Installed standalone Databases.
• Helped other teams with client installation.
• Installed databases using scripts
• Worked with oracle on ongoing issues.
• Configured Flash Recovery area.
• Written shell scripts.
• Applied patches.
• Worked with developers
• Supporting Production and Development databases in 24x7 Environments.
• Tuning by Statspack/Awr collecting various hourly Snapshots statistics and differentiating
• Monitoring Alert log files to know types of bottlenecks recorded during the day if any, and rising to counter them.
• Responsible for database administration for a large and complex database system using Oracle9i/10g/11g
• Applying CPU (Critical Patch update) Patches and Upgrading Patches on 10g and 11g releases (10.2.0.1.0-10.2.4.0 & 11.2.0.1.0 - 11.2.0.7.0 ).
• Creating Tar with oracle support for Internal Errors Ora-600/7445.
• Refresh of development/test/QA databases from Production backup using Datapumps.
• Rebuilding standby database using production backup and making sure DR and PROD are in sync after change.
• Periodically monitoring Problem management queue and working on problem tickets or sharing across team members.
• Proactively Monitoring alerts, assigning to right queues, Resolving in time based on SLA.
• Identifying issues and resolutions, providing feedback to other team members, and offering any information uncovered throughout daily operations that could benefit other team members.
• Written RMAN shell scripts to purge out old archivelogs and backups.
• Creating Performance Reports using AWR and ADDM
• Cloning and managing Duplicate/Standby on databases using RMAN.
• Recovering the databases using RMAN. Scheduling and managing crontabs Jobs.
• Managing Physical structure of Oracle database like Data files, Redo log files, Control files.
• Monitoring the growth of Tablespaces and taking proper actions
• Doing Trend Analysis of Database for future need of space and capacity planning on disks.
• Maintaining security and integrity of database systems.
• Monitoring and maintaining database availability and resources.
• Planning and managing database backup and recovery.
• Taking Backups of databases using Logical (Export & Import) and Physical (Offline and Online) backups.
• Managing User Level Control Access with Roles and profiles.
• Installing, maintaining and monitoring the database software products, including technical advice and support to the applications Development and Maintenance staffs if required.

Environment: Oracle 8i/9i/10g/11g, RAC, Toad for Oracle v.9.0.1.8 PL/SQL, Oracle SQL Developer, Data Pump, SQL*Loader, Windows/RHEL

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Support of OLTP database to support e-commerce
• Supported 9i and 10g databases.
• Upgrade from 9i to 10g R2.
• Build Materialize Views
• Worked on various networking issues.
• Cloning of databases.
• Documenting new procedures.
• Applied patches.
• Install VMWare.
• Experience in supporting databases under all flavors of UNIX (Sun Solaris,, HP UX Red Hat).
• Installing & configuring Oracle 10g, 11g,10g RAC,9i on Linux, AIX, Sun Solaris
• Performance tuning and Monitoring using Grid Control database & managing instances using OEM
• Database backups using RMAN on Disk and Tape.
• Designing the security and database access strategies & cloning databases and partitioning tables.
• Experience with DB performance tuning tools
• Experience in Upgrading database 10g to 11gR2 and applied patchset 10.2.0.2 to 10.2.0.4 and on 10.2.0.4 to 11.1.0.7 and also working with upgrading with 11gR2 for multiple database
• Technical lead for a large number of tuning projects. Performed application, SQL, and database instance tuning using a wide range of technologies including ADDM, AWR, Statspack, extended SQL trace (event 10046 trace files), OEM Performance Manager, and custom scripts.
• Installed databases using VMWare
• Administering ORACLE Databases 10g (10.2.0.4), 11g over 10 TB in size.
• Refresh/Cloning of Database for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g.
• Worked with Standby Database (Data Guard) setup and configuration using data broker.
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Provided DBA and programming support for all internal and client based Oracle implementations.
• Good working experience of setup managing (Oracle 10g RAC two-nodes/ ASM /Grid Control /Automation/Database Flashback/RMAN) implementation, management, monitoring & troubleshooting.
• Expertise in performance monitoring and performance tuning
• Defining and Setting backup and recovery procedures, Configuration of backup.
• Tuning the database using statspack and custom scripts
• Experience in creating different kinds of partitions on tables and indexes for managing large tables
• Worked with daily refresh activities using EXPDP/IMPDP & Exp/Imp and as well as also using RMAN
• Worked with Streams and also supported large number of databases on streams.
• Applied Security VTM Patches which have been suggested by oracle for number of databases according to the risk level
• Enabling and disabling the Flashback, create restore point, restore point restoration at table and database level
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Oracle Export, Import, SQL*Loader and data pump utilities
• Worked with moving database from Solaris to AIX and Linux to AIX p6 Servers