SUMMARY

• Over 7 years of experience in managing Oracle Databases.
• Managed 8i to 12c standalone and RAC databases.
• Managed databases on Amazon cloud (AWS).
• Migrated databases from standalone to Clusters.
• Tuned SQLs for better performance.
• Performed Instance and database tuning using various tools.
• Analyze ASH and AWR to check the top waits and top SQLs.
• Used ADDM reports to verify oracle recommendation. ‘
• Managed small and big tablespaces
• Clone databases using dbca, scripts and silent installs.
• Create shell scripts to automate tasks.
• Setup cronjob and used 13c OEM.
• Managed databases on Linux, AIX, Solaris and Windows.
• Experience in RMAN backup, restore and point in time recoveries.
• Worked on Upgrade projects to upgrade from 10g to 11g to 12c.
• Build Disaster Recovery sites using Oracle Data Guard.
• Setup Flashback database and Flash Recovery Area.
• Setup and managed ASM Diskgroups.
• Managed Physical standby with Active Data Guard.
• Very well versed with Oracle Patching.
• Experience with Oracle VPD, Data Encryption and Data Redaction.
• Experience in providing security to Oracle Databases with roles and grants.
• Experience with Database Auditing.
• Used TOAD and ERWIN along with SQL Developer as other tools to manage databases.
• Possess good decision making skills and has ability to work under pressure.
• Strong experience in Oracle partitioning.
• Provided 24/7 on call support when needed.
• Worked with onsite and offshore DBA team members.
• Worked with Application team on off - hours releases and deployments.
• Worked with Oracle Engineers on tasks that needed their attention.
• Familiar with CommVault, NetApp and other OS level backups.
• Strong exposure in Linux Operating Systems.
• Familiarity with Oracle Cloud.
• Managed databases on Virtual Environment.
• Experience managing databases on Exadata X6 and X7.
• Good understanding of Oracle Golden Gate replication.
• Expert in Database refreshes using Export Import, Data Pump and RMAN

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• 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
• Migrated databases to AWS.
• Migrated databases on X7 Exadata.
• 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 Golden Gate.
• 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.
• 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.
• 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.
• All work completely documented.
• Perform daily database administration as required.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Participated in code reviews during OLAP projects and prepared ETL designs.
• Extensive knowledge on database administration for ORACLE 12c/11g/10g/ 9i with experience within very large scale database environment and mission critical large OLTP and OLAP systems.

Confidential

Oracle DBA

Responsibilities:

• 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 Data Pump.
• 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.

Confidential

Oracle DBA

Responsibilities:

• 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 OEM
• Database backups using RMAN on Disk and Tape.
• Experience with DB performance tuning tools
• Experience in Upgrading database 10g to 11gR2 and applied patch set 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.
• 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.
• 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