SUMMARY

• Accomplished Oracle DBA with 7+ years of experience and having expertise in performance tuning, crisis management, maximize productivity and increase high availability with reliability with a complex problem solving skills and communication skills.
• Designing, modeling, administration, implementation, troubleshooting, and quality management for several production/test systems on Oracle (8i, 9i, 10g, 11g, 12c, RAC) Databases.
• Involved system administrators groups in designing the logical and physical model of the databases.
• Installation, configuration and upgrade of Oracle 10g, 11g RAC.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Virtualization, Installation of 10g/11g on Virtual machine, Extensive Experience of installation, configuring, upgrade and administer Terabyte of Oracle Databases on Oracle RAC/11g/10g.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Expereince with OracleGoldenGate installation, configuration, troubleshooting GG issues
• Pre - patch analysis for the patches and document preparation with pre and post patch installation steps.
• Performed Cross Platform migration of Oracle and Advanced Planning and Scheduling from HP to AIX.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Experience as Oracle DBA providing support to many Production, Development, Test, CRP instances comprising of some of the more complex and challenging environments from versions 9i to 11g releases.
• Good knowledge in working with the tools like OEM, TOAD, QUEST, Export/ Import, Stats pack, SQL* Loader, SQL Analyze, TKPROF, Explain Plan, and Oracle Supplied DBMS PACKAGE.
• Hot and cold Backup and recovery of Oracle 10g, 11g database using tools like RMAN.
• Scripting and scheduling of oracle database backup using RMAN.
• Good experience of Oracle PL/SQL, Procedures, Triggers, Cursors and Functions.
• Cloning of database for development teams, import and export of data.
• Involved in SQL tuning and refreshing statistics of database objects.
• Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Experience in writing complex SQL Queries, created materialized views.
• Developed UNIX shell scripts, Perl Scripts and SQL scripts to carry out routine checks on databases.
• This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Proven ability to adapt to demanding schedules and changing priorities.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Involved and implemented with analysts, developers, programmers and project managers in a project with Agile Methodology.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed

TECHNICAL SKILLS

Programming skills: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl scripting,C++, C#, Html and XML, ASP.NET, PHP, JAVA

Database knowledge: Oracle 9i, 10g, 11g, 12c, RAC, MS Access, File Maker

Database Tools/Utility: ASM, RMAN, GoldenGate, OEM, Data Pump, Data Guard

Performance Tuning: AWR, ADDM, EXPLAIN PLAN, Memory Advisor, Data Dictionary Views, MTTR Advisor, Segment Advisor

Other Tools: Team Track, Magic, BMC Remedy

Storage Technologies: EMC, NetApp, VERITAS Net Backup

Operating System/Server: Linux, Windows, IBM AIX, Sun Solaris, HP-UX

Virtual Machines: VMware, Virtual Box

SDLC Methodologies: Agile, Waterfall, Spiral, RUP Process and Prototyping

Microsoft Skills: MS Word, Power Point, Excel

PROFESSIONAL EXPERIENCE

Confidential, Carlstadt, NJ

Sr. ORACLE DBA

Responsibilities:

• Involved in the installation, configurationof multi node--2, 3, 4NodeOracle10g/11g RACwith ASM.
• Installation and Configuration of RedHat Enterprise Linux on Oracle Virtual Machine (OVM)
• MigratedOracle10g/11g RACandnon-RACSingle instance databases with ASM usingTransportable Tablespaces(TTS), Datapump,SAN Synchronization SRDF.
• Upgradedproduction, Development databases fromOracle9.2.0.8,10.2.0.2, 10.2.0.4 to 11g/11g RAC.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
• Developed and delivered LRT data warehouse classes using ER/Studio data modeling tool.
• Comprehensivedocumentationof all activities
• Applied Bug fixes patches, Quarterly Security PSU Patchesfor RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Setup, reconfigured and monitoredsingle instance and multimode RAC to RACDataguard for DR.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Created Database Clones from to do refresh on prod to dev using NetAppSnapManager Utility
• Performancemonitoring andDatabase/Instance/clusteredApplication tuningusingDictionary views,AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGAparameters, initialization parameters andreorganized physical objects(tables & indexes) and tablespaces to improve the performance.
• Redesignedtable and index partitioning strategies, usingHINTSto improve the query performance.
• Created external table in the database using an excel sheet which I uploaded to the server
• Developed, modified andoptimizedvery complex queriesto data retrievalusingExplain Plan, SQL Trace, TKPROF, parallelprocessingand partitioning techniques.
• Monitoring theCPU, memory usage, I/Ocontentionon servers usingtop, iostat, sar, glance, vmstat, etc.
• Designed daily, weeklyBackup and Recovery proceduresfor production, non- production databases usingRMANbackups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh/Cloningfrom Production environment to setup QA/ DEV usingRMAN Duplicate.
• Intensively used latest 10g/11gAutomatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used thenotificationtool to send the alerts inOEM Grid Control.
• Designed disaster recovery (DR) plan for non RAC production databases.
• Scheduled UNIX scripts in crontab jobs to automate daily taskslike backups, monitoring the alert logs, and backup logs to send notification emails.
• Migrated data to a new ASM Diskgroupto improve the IO performance of the database.
• Export/Import, Datapump, Transportable tablepsacesto migrate databases from one database to another.
• Deployed Monitoring scripts for the databases using Perl Script to notify the team in case of database outages or any bugs.
• Worked with Storage team in integrating the SnapManagersoftware with the oracle servers.
• Recovery of Database(Recovering fromMedia Failure, Recovering the tables dropped accidentally, Recovering data files, recovering fromBlock Corruption) from previous RMAN backups
• Performedcapacity planning, space monitoringliketablespace growth, ASM disk space.
• Resolvecritical issuesby raising SRwithOracleSupportandRoot Cause Analysis (RCA).
• Applied Agile method tobetter adapt to the business requirements changes; quickly designed and coded/implemented applications with scrum teams

ENVIRONMENT: RHEL HP-UX, AIX, Windows Server,VMservers, Oracle11g/10g/9i/12c, RAC, ASM, Dataguard, DGMGRL, RMAN,PL/SQL, UNIX Scripting, Perl, OEM Grid Control, EMC SAN, Toad 9.7, Datapump, SQL*Loader, Putty, NetAppSnapManager

Confidential, Richmond, VA

ORACLE DBA

Responsibilities:

• Involved in the design, review, implementation, testing, and release of databases, design specifications, and application software.
• Installed, up-graded Oracle (9i, 10g, 11g) software in different environments, creating and maintaining Oracle development and test databases.
• Clone the databases using RMAN
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• Installed the Datamart, Siebel, OBIEE applications in the databases based on the requirements
• Work with the application team and the business team in determining the requirements and solving all kinds of database and data issues
• Work closely with the vendor to get the required fixes and patches to the application
• Work closely with the Business Objects and DDE team to get the required reports generated
• Monitor the databases using Sitescope and BAC
• Manage the databases using OEM
• Developed the shell scripts to load the data coming from the vendor into the databases
• Involved in online and offline backups, and recoveries of various oracle databases using export and import utility
• Provide guidance to the Production DBA on how to work on the databases
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Worked with data modelers in modeling the database using CA-ERwin.
• Ensured security of the database by creating profiles for each user and monitored the user sessions.
• Automated the running of jobs through Control M
• Interacted with development team in fine tuning the SQL and PL/SQL code.
• Wrote PL/SQL Scripts for running application specific monitors through Sitescope
• Worked on Oracle External Tables
• Extensively worked with performance tuning and memory (SGA and PGA) tuning, optimizing and troubleshooting of databases.
• Work on and manage the DR tests both from application and database standpoint
• Analyzed tables and indexes of Oracle database periodically for better performance.
• Migrated the code as well as the data from one environment to another depending on the Application team’s request
• Wrote Unix shell scripts and Windows batch scripts required for functioning of the applications
• Maintain the versioning of the code(scripts) by locking them in Clearcase

ENVIRONMENT: Oracle 8i/9i/10g/11g, HP-UX, IBM AIX, SQL, PL/SQL, ERwin, TOAD, OEM, SQL Developer, SQL Loader, RMAN,Statspack, Data Guard, Shell Scripts, BAC, Grid Control, AWR, ADDM, Siebel, OBIEE, Datamart, HTML, DHTML and XML

Confidential, Buffalo, NY

ORACLE DBA

Responsibilities:

• Involved in regular day to day activities for production databases running on RAC and Non RAC.
• Installation of Oracle 11G, 10.2.0.1 and upgrading them to 10.2.0.3 and 10.2.0.4 by applying oracle patch sets.
• Created Quarterly Performance reports for production Databases to find out the bottle necks of performance.
• Created Quarterly Health check reports for production database.
• Upgrade database from 10G to 11G.
• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Applying PSU patches for both RAC and Non RAC databases.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Maintained the RAC set up, Performance Tuning, codingandMonitoring for Oracle Application Clusters
• Installed and configuredOracle Enterprise Manager to monitor the Databases.
• Monitoring the ASM disk groups, add and resize the disk groups.
• Resolving the tickets by meeting the SLA.
• Refresh the Database using RMAN and exports/imports
• Applied BUG patches which are caused by Ora - 600 and Ora - 7445.
• Monitoring and maintain the database using Oracle Schedulers and Cron job scripts for package startup/shutdown and backups
• Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
• Performed switch over and fail over on Standby database.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Monitoring performance using AWR reports and ADDM Reports.
• Used Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

ENVIRONMENT: HP AIX, Solaris, Windows Server 2010,Linux Oracle 9i, 10g, 11g, RAC, ASM, OCFS2, NetAppToad 11.5

Confidential, Reston, VA

ORACLE DBA

Responsibilities:

• Involved in SQL tuning and refreshing statistics of database objects.
• Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Installed and configured Oracle Golden Gate for High Availability
• Used Export/Import and Datapump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Performed backup validations using RMAN, Database monitoring, troubleshoot and resolve the issues.
• Oracle Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Roles, Functions for the user.
• Performance tuning of Oracle Database, applications and queries.
• Experience in testing and validating backups using Recovery Manager.
• 24x7 Production Oracle Administrations.
• Maintaining production, development& test databases and applications.
• Upgraded Oracle server Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
• Upgraded Oracle Database 9.2.0.8 to 11g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Was involved in developing a disaster recovery (DR) plan.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9i.
• Experience in using Flash-Back Recovery, AWR, ASM, ASH and ADDM.

ENVIRONMENT: 11g, 10g, RAC,OEM Grid Control, UNIX Shell Scripting, UNIX Cronjobs, RMAN, TOAD, AIX, Solaris, Windows Server 2003

Confidential

Graduate Engineering Trainee

Responsibilities:

• Installation, maintenance and tuningof Oracle10g,11g,10g RACdatabasesonredhat-4, IBM-AIX 5.3.
• 24x7 production support forOracle10g, 11g,10gRACdatabases.
• Installation and Administration ofOracle11g RACdatabase.
• Configured a test database onoracle11g RACand experimented with loadbalancing.
• Installed and configuredOracle10g RAC(2 node cluster) usingASM.
• Upgradeof database from 10g to 11gon Linux,UNIXandHP Operating Systems.
• Appliedpatchesfor both versions of databases 10g and 11g successfully.
• Install and configure Oracle GoldenGate and Veridata
• Ensured high availability,data protection and disaster recovery usingDataGuard(primary and standby databases).
• Configured, administered, and monitored aStreams environmentusing various tools likeOEM console.
• Usedshell scriptingfor automation of jobScripts, for Startup andShutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Worked onexportdatapump/import datapump,normal import/exportandSQL- loader.
• Setting up and administering Hot and Cold backups.
• Worked onASMinstallation,configurationofASMand using ASM instance.
• ConfiguringRMANand FlashbackRecovery.
• Utilized backup and recovery strategies using RMAN.
• CloningofdatabasesusingRMAN,DBCA andeven manually.
• Created, scheduled db maintenance tasks such as tables/indexes analysis,index rebuild, materialized views refresh, db exports and janitorial day to day tasks.
• Extensive Performance Tuning,Memory (SGA) Tuning, Net backup,RAW Devices.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them toOracle10g.
• Analyzed database performanceusingAWRand ADDM.
• Analyzed query cost using tools likeTKPROF, Explain plan.
• Database Design and CreationusingER-Win, Visio.
• Responsible for Load balancing and Performance testing of the database servers and application servers their analysis and documentation of results.

ENVIRONMENT: Oracle10g,11g, 10gRAC,GoldenGate, Red hat 4,IBM AIX 5.3, Toad, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM,NetApp, Erwin 4.1.2, MS Access