PROFESSIONAL SUMMARY:

• Around 8 years of experience as Oracle Database Administrator in various domains and on a variety of UNIX and Windows platforms with Oracle (12c/11g/10g/9i/8i) . Highly competent in Administration, Monitoring and specialized in Advanced DBA skills such as Performance Tuning, Database Backup and Recovery, Data guard, Data Pump, RAC, Golden gate.
• Proficient in installation and configuration of Oracle 12c,11g, 10g, 9i, & 8i on SUN SOLARIS, HP - UX, IBM-AIX, WINDOWS, REDHAT-LINUX.
• Managed Databases in the range from 50GB to 3TB.
• Performed Migration and Upgrade of databases 11g to 12c, 10g to 11g and 9i to 10g.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Strong skills in SQL* PLUS, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Applied Patch Set Updates to 10g and 11g oracle databases.
• Experience in Database & Application performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10g OEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Managing rollback segments, redo log files, controlfiles and datafiles.
• Expertise in Performance Tuning of Database, includes memory tuning, application tuning, Buffers Maintenance, Disk I/O Tuning, O.S Tuning, Eliminated Database Contention.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Extensive experience in migration of databases with export/import, expd/impdp, RMAN.
• Implementation of Flashback Technology.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Having experience with Dataguard and DG Broker for creating and maintaining the primary and standby database in 24*7 production environment.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP.
• Expert in Real Application Cluster (RAC) environment with Automatic Storage Management (ASM) on Oracle 10g, 11g and 12c.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Hands on Experience on Triggers, procedures, functions.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g and 10g RAC environment.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Excellent experience in various migration techniques like export/import, data pump cloning, and data guard.
• Scheduled jobs through oracle job scheduler, crontab(Unix), autosysjobs.
• Experience in conversion of Single Node Instance to Multi node RAC with ASM, and adding instance to existing RAC.
• Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Good experience in data migration using export/import and also done data replication/data integration using Golden Gate.
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
• Experience in using Golden Gate to support data replication monitoring, tuning and capacity planning.
• Experience in patching for Golden Gate using Opatch utility.
• Proficient experience on EXPORTDATAPUMP/IMPORTDATAPUMP, performed golden gate initial load with datapump.
• Experience in database backup and recovery using CommVault.
• Work 24 x7, weekends, late hours. Less guidance, documentation of methods, plans & daily work. Work in Team or as stand-alone person. Multi-tasking. Worked at client site. Prepare KT document for role Transition.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 4/5/6, Windows 2003Windows 2000/NT, Windows XP.

Databases: Oracle 12c,11g, 10g, 9i, 8i, Sql Server 2008,2005, Oracle 12c/11g/10g Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, RAC, ASM, OEM, AWR, ADDM, SRVCTLCRSCTL, ASMCMD, DBCA, DBUA, and oracle Golden Gate.

Scripting: Shell Scripting Korn & Bourne, C Shell, OBEY

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, PuttySQL*PLUS, ERWIN, LogMiner and Flashback data Archive, Quest Fog light, VERITAS Net Backup, BMC Remedy, HP Quality Center Dream-weaver, MS Office, Secure Crt.

Languages: SQL,PL/SQL for Oracle, C, C++.

PROFESSIONAL BACKGROUND:

Confidential, Charlotte, NC

Database Analyst

Responsibilities:

• Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 10g/11g/12c including RAC and ASM, Golden gate.
• Installed Oracle 12c GRID software and created upgraded Oracle GRID software and databases from 11g to 12c.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Sized multiple Oracle databases depending on the application requirement with the overhead storage required for the oracle.
• Designed, Configured and maintained backup and recovery policies including RMAN backups and scheduling RMAN full and incremental backups using Autosys.
• Migrated Oracle databases from red hat Linux to Oracle EXADATA using RMAN cloning.
• Used oracle 11g/12c AWR and ADDM to monitor database activities and performance tuning.
• Performed Range partitioning as cause to improve the performance of the database. proactive performance monitoring and capacity planning for further database and server growth.
• Migration and upgradation databases to 11g to 12c.
• Installation, Configuration and Maintenance of Oracle 11g/12c RAC on two node and four node configurations
• Supported SSL enabled database.
• Migrated multi-terabyte databases to Exadata machine using data pump utility.
• By using EXADATA provided support to a combination of database system such as OLTP and OLAP.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Administrating databases across development, QA, UAT and PROD environments via use of command line and Oracle tools Oracle Enterprise Manager Cloud 12c.
• Worked on SQL Tuning and how to use the available tools outside of Oracle Enterprise Manager
• Installed and Administered Oracle 11g RAC software with ASM
• Implemented Managed Physical Standby and even Configured Automatic Storage Management (ASM).
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12c cloud control.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Refresh database using import/export from production to UAT to oracle tables. Used ETL to extract data from database and transform the data to different databases.
• Implemented partitioning on large tables, expertise in using composite partitioning, local indexes and global indexes.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant(ASMCA).
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas,table spaces and other database objects.
• Implemented database monitoring and tuning, application, and queries using ADDM, ASH, AWR, ExplainPlan and OEM.
• Worked with UNIX shell scripts, materialized views, Capacity planning.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions.
• Views, Indexes, user accounts, roles, grants and performing day-to- day operations
• Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager.

Environment: Oracle 12c, 11gR2, 10g, RAC, ASM, Exadata, Golden Gate, Dataguard, Oracle Enterprise Manager Grid Control(OEM), RDBMS, Explain plan, Statspack, Sun Solaris, Redhat Linux, Windows, SQL*LOADER, PL/SQL, TOAD, SQL Tuning Advisor, SQL Performance Analyzer, SQL server 2008, Shell Scripting.

Confidential, Lansing, MI

Database Analyst

Responsibilities:

• Supported 50+ databases including RAC Production database, a data warehouse database and lot of Development and Test databases.
• Providing DBA support to multiple Cluster, Non-cluster, and ASM Database in production, development and Testing Servers on UNIX, Linux Environments.
• Upgraded GI and RDBMS from 11g to 12c.
• Applied PSU quarterly on 11g/12c GRID & RDBMS homes using opatch utility.
• Planning, analysis, design, implementation, maintenance, and control of RAC databases.
• Responsible for standards and design of physical data storage, maintenance, access and security administration.
• Write SQL scripts, Shell scripts to complete several Production Stability and Automation projects. Co-ordinate with SA and SAN teams for scheduled maintenance activities.
• Responsible for design and correct functioning of backup and recovery of the databases.
• Implemented TDE all over databases, and migrated TDE from ASM to file system.
• Implemented AUDIT on all 11g and 12c databases.
• Exported and imported data using data pump range of 15GB to 2TB.
• Automated Procedure to grant privileges to users using procedures.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Expertise in debugging character set issues on both source and target databases and performing successful data replication.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Gather table/index statistics and histograms and tune optimizer parameters for better SQLperformance. Developed script for index rebuild for large sized database tables. Reorganize tables and rebuild indexes online to reduce block fragmentation. Recommend various partitioning options to achieve better performance.
• Performed disaster database recovery using RMAN catalog.
• Performed Database backup and restore using CommVault agent.
• Applied different performance patches to improve data pump and database performance.
• Installed OEM agent and configured databases to OEM monitoring.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues - helping to transform business requirements into environment specific databases.

Environment: Oracle 12c,11g R1,11g R2, OEM 12c, RHEL6, SQLPLUS, SQL DEVELOPER, PuTTy, ASM, PL/SQL,CommVault.

Confidential, Charlotte, NC

Database Analyst

Responsibilities:

• Installed Oracle 12c GRID software and created upgraded Oracle GRID software and databases from 11g to 12c.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Applied Jan/Oct PSU 2015 across all the databases that I support.
• Sized multiple Oracle databases depending on the application requirements with the overhead storage required for the oracle.
• Designed, configured and maintained backup and recovery policies including RMAN backups and scheduling RMAN full and incremental backup jobs using Autosys.
• Configuring both ACFS/DBFS file systems for storage of trail files for the GoldenGate replication.
• Installed and configured Oracle 12c GoldenGate software for data replication from multiple sources to target databases.
• Installed Golden Gate binaries and supported around 20 RAC db’s.
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Migrated multi-terabyte database(s) to Exadata machine using Datapump utility and also configured dbfs for goldengate trail files.
• Expertise in writing the extract, extract pump and replicat parameter files for multiple data replication requirements.
• Configured both classic/integrated extract and replicat for replication process.
• Performed gg replication with different data purging retention.
• Performed virtual column(s) replication using GoldenGate.
• Automated goldengate reload process for initial load.
• Worked on logdump, keygen and defgen utilities in Golden gate and Configured Golden gate Director for monitoring alerts.
• Patched oracle goldengate using opatch from 12.1.2.1.0 to 12.1.2.1.11.
• Implemented golden gate intial load through Export Data Pump/ Import Data Pump.
• Exported and imported data using data pump range of 15GB to 2TB.
• Replicated 54 tables using single extract/pump/replicate process, performed many to one replication.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Expertise in debugging character set issues on both source and target databases and performing successful data replication.
• Performed a successful BCP switchover that involves Goldengate on both source and target side.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager.

Environment: Oracle 12c,11g R1,11g R2, OEM 12c/11g, RHEL6, AIX6, GG 12c/11g, SQLPLUS, TOAD, SQL DEVELOPER, PuTTy, Secure CRT, ASM, PL/SQL.

Confidential, Virginia Beach, VA

Sr. Oracle DBA

Responsibilities:

• Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 10g/11g/12c including RAC and ASM, Golden gate.
• Playing vital role in streamlining all the databases on AIX, HP-UX, Linux, Solaris.
• 24*7 Production Technical Support and Hardware Support.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Responsible for Build Work in various servers which has 3 Node RAC & Non - RAC, High Availability, Golden Gate Technologies.
• Implemented Oracle 11g OPS Center and fully integrated hardware and storage Arrays to the Grid Control.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Installed and configured oracle 10g and 11g Management Agent (silent and Agent push) and cloned it to the multiple nodes.
• Installed 12c Databases, and Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Implemented and monitored 10g RAC Logical Standby database for reporting.
• Installed oracle 10g Data Guard Physical Standby at DR site for production nodes.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, sql Tuning Advisor.
• Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.2).
• Upgraded oracle RAC databases from 10g to 11g.
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Mentor SQL, PLSQL and performance tuning to Wide range of audience across the organization.
• Experience on working with Database Monitoring tools like TOAD, BMC PATROL.
• Setup and monitored multi node RAC to RAC Data guard with real time apply for DR and offload backups.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
• Migrated data between databases using Data Pump(Export/Import).
• Exported and imported 10gb to 1tb data using Datapump.
• Worked on oracle 11g New Features for Administration and Tuning.
• Reconfigured and restored OCR and Voting Disks for changing the bonding on 4/6 node RAC.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Patching and Upgrades of Oracle 10g, 11g databases to protect from VTM.
• Worked on 10g and 11g oracle ASM management.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Responsible for managing databases on VCS Cluster and VCFS file systems.
• Configured SNMP Agent on UNIX nodes for monitoring the server health and outages.
• Responsible for monitoring and administering EMC Storage Arrays using Navisphere.
• On call Production Support ON Shift Basis.

Environment: Oracle 12c,11g R1,11g R2, SUN SPARC, Dell Power edge, Sun STOREDGE 6140, 6130, 3500, EMC Storage, VERITAS NetBackup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, 11g OPS center.

Confidential, Louisville, KY

Sr. Oracle DBA

Responsibilities:

• Supported 50+ databases including RAC Production database, a data warehouse database and lot of Development and Test databases.
• Planning, Implementing and Validating various versions of Oracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7) & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades
• Responsible for administration and supporting Oracle 11g, 10g RAC databases in DEV, QA, UAT and Prod environments.
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA.
• Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Proactive database monitoring using 11g grid monitoring tool.
• Experienced in PLSQL programming to resolve various problems.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.
• Upgraded from 10g to 11g.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Monitoring and resolving tickets in different environments.
• Export and Import of database objects to copy from one database to another database between different environments.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Environment: Oracle 11g, 10g, Oracle RAC (11g), Oracle Enterprise Manager (OEM), IBM-AIX, Sun Solaris RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL.

Confidential, Sacramento, CA

SR. Oracle DBA

Responsibilities:

• Installed and configured Oracle databases of sizes 200 GB to 4 TB sizes on Sun Solaris servers.
• Worked as Confidential Oracle DBA consultant supporting Confidential ’s Oracle 10g and 9i databases.
• Patched Production as well as Test RAC environments to fix Oracle bugs.
• Added a new node to an existing 4 node Production RAC Database.
• Patched for Streams on 5 node production RAC database.
• Installed Oracle Cluster ware and RAC databases on 10.2.0.4.0 on Linux and Solaris Platforms with ASM.
• ASM Setup and maintenance on RAC databases.
• Oracle streams setup and performance optimization for replicating data from production RAC databases to reporting databases.
• Implemented Asynchronous Change Data Capture (CDC) on RAC to replace the replication mechanism which used triggers on the RAC.
• Used RMAN for backup and recovery.
• Configured and managed Data Guard for Production databases.
• Grid Control OMS and agent installation and Deployment.
• UNIX Shell scripts for monitoring the processes, sessions, transactions on Production RAC database after migration.
• UNIX shell scripts for partition splitting.
• Documentation for Cluster ware installation, RAC installation, RAC Database creation, Grid Control installation, ASM setup, Agent Deployment and so on.
• Range, Range-Hash, Hash partitioning on Production databases.
• Guided Production support teams while patching Oracle RAC production databases.
• Provided database support to Application team in migrating Lawson Application environment.
• Implemented Live Reorg tool in production environments and mentoring Production support teams.

Environment: Oracle 11g/10g, 10gR2 RAC, Oracle Cluster ware, RMAN, Oracle 10g Grid Control, Oracle 10g Streams, Data Guard, Sun Solaris, NetAPP Filer, Korn Shell scripting, ASM, Quest Spotlight for RAC, Lawson, Oracle Change Data Capture(CDC), Quest Live Reorg Tool, Oracle Partitioning.