SUMMARY:

• Over 8 years of experience as Oracle DBA, providing 24/7 support of development and production 12c/11g/10g/9i/8i databases on UNIX/LINUX and Windows environments.
• Expert in Cloning of databases from RAC to RAC .
• Experience in Automatic Storage Management (ASM) in 10g & 11g.
• Pre - patch analysis for the patches and document preparation with pre and post patch installation steps.
• Experience in Data Guard and Grid Infrastructure 11GR2 and 12C
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention Resolution, Defrag etc. scenarios for the various Environments.
• Experience working in RAC environments. Worked on 2 nodes and 6 nodes Oracle RAC and ASM
• Experience in using OEM, TOAD, and Data Migrations using export/import
• Database Upgrading from one server to another using Export and Import utility.
• Worked on Oracle Real Application Testing (RAT) with Oracle Database 11g Enterprise Edition.
• Worked extensively with Oracle RDBMS; Comfortable with SQL, PL/SQL, and good knowledge on various database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Installed and Configured Oracle Enterprise Manager 12c.
• Worked on Oracle Applications Cloning and Oracle Database Refreshes
• Knowledge on high availability technology and clustering 10g and 11g RAC.
• Knowledge on Oracle Business Intelligence 11g.
• Strong database Administrative skills and having working experience on oracle RDBMS 9i,10g and 11g.
• Good knowledge on Oracle streams, data guard physical standby databases.
• Proficient in DBA tools like - SQL Developer, Toad, OEM 11g & 12c.
• Excellent analytical, problem-solving and learning skills and ability to quickly embrace and understand new technologies as well as a keen interest in the emerging technologies.
• Worked on Simpana CommVault backup tool.
• Strong communication, motivational and presentation skills.
• Ability to multi-task and work independently.
• Highly motivated, results-oriented, self-driven IT professional; Good team player
• Administration and troubleshooting of RAC instance startups and instance evictions
• Expertise in planning, scheduling and managing Oracle RMAN based backup & recovery strategy.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR support Cloning, Backup and Recovery, Performance Tuning, Data Sharing and Disk Partitioning, capacity planning, script development, and documentation.
• Experience in Data Compression, Table Compression, OLAP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Engineering of the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g/11g/12c RAC environment.
• Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Experience in configuring oracle data guard and streams.
• Installed Golden gate software of versions 12.1.2.1.0 and 11.2.1.0.22 .
• Worked on implementing Golden Gate replication between different environments and in different scenarios
• Worked on Golden gate Initial load
• Worked on Golden gate data filtrations and collision handling.
• Experience in applying oracle database patches using opatch utility.
• Coordinate with System administrator during OS patching

TECHNICAL SKILLS:

RDBMS: ORACLE 12C/11g/10g

Third Party tools: EMC TimeFider, SRDF (disk to disk mirroring), Shareplex (Object level replication) 3.2, 4.1, 5.2, 170 systems (Markview), Noetix, Veritas software, OID, Oracle Portal, Erwin and DBArtisan, SQL* Loader, VMware Workstation, Quest STAT.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

DB Management: TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) /12/13CGrid control (RAC), RAT.

Programming: Unix Shell Scripting PERL, Bourne, Korn, AWK-SED, PHP, JavaScript, SQL, PL/SQL, HTML, DHTMLC, C++, Java, FORTRAN 77/80.

Operating Systems: HP: UX 10.x/11.x, AIX 4.3.x/5.1/5.2,WINDOWS NT/2000/2003 Server, RED HAT LINUX 9/8/7.2/7.1/6.2 , RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10, VMware ESX Server 3.0.x/3.5.0.

Hardware: SunFire 15K with 72 CPUs 144GB Memory, SunFire 6900 with 40 CPUs0 GB Memory, E6900, IBM XSERIES 346 with 4 CPU s 12GB Memory.

Other Applications: Oracle Agile (9.3.3), OBIEE 10g, Orale GTM 7.

Data Migration tools: SQL* Loader, Export /Import, data Pump

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Oracle DBA

Responsibilities:

• Installed and configured 11.2.0.3, 11.2.0.4, 12.1.0.2 RAC on the Linux servers with ASM as a storage for the database files.
• Worked on cluster builds by installing the Grid Infrastructure and RDBMS Homes
• Configured physical standby databases using Oracles Data guard technology for the high availability
• Involved in the BCP (Data guard switchover) testing to see if the application can function on the standby site.
• Worked on 12C OEM by installing agents on the servers. Adding targets to the OEM once the cluster and DB’s are created.
• Extensively involved in the ASM san add, like expanding the diskgroup and removing disks from the disk group and creating new disk groups.
• Upgraded the Grid infrastructure (CRS & ASM ) from lower version (eg: 11.2.0.2) to 11.2.0.3 & 11.2.0.4
• Installed and created the Databases on the clusters and cloning the RDBMS homes across the clusters
• Expanded the clusters from 3 node to 4 node & 2 node to 3 node using Oracle best practices
• Worked on Node deletion from the cluster DB.
• Closely worked with auditors for Compliance and Security issues.
• Installed Goldengate software of versions 12.1.2.1.0 and 11.2.1.0.22
• Worked on Goldengate High availability like installing and configuring DBFS and ACFS.
• Cloning the Prod databases to the SIT & UAT environments for testing using the snapshot backup process.
• Upgraded the databases from lower version to higher version.
• Applied the Oracle quarterly released patches (PSU’s) to the CRS & RDBMS homes which fixes the bugs in the Cluster and database environment in a rolling fashion
• Worked on the compliance management - Set of rules defined to all the databases, which have to be compliant as per the company policies.
• Retiring the database once the application is no longer functioning and reclaiming the space at the OS level and the database level
• Involved in capacity management - Annual growth of databases and estimating the SAN required for the upcoming year with co-ordination with the application team
• Used RMAN for taking the backups of the databases (Full and Incremental)
• Worked on the change management ticketing process to create CR (change request), PT (Problem tickets) to make any configuration changes and issues encountered in the database and cluster.
• Involved in the performance tuning and troubleshooting of the database with lower performance and checking the AWR & ADDM reports and analyze them.
• Worked with My Oracle support (MOS) for various issues across the environment.
• Working with the off shore team and coordinating the work with them
• Responsible for Daily OEM support (14X7)
• Creating user defined metrics, incident rules,all types of target additions in OEM
• Role management, OEM agent installation.
• Worked on monitoring tools like tripwire to check file system level vulnerability.
• Handled the On call support (14 X 7) on a rotation basis

Environment: Oracle 10g/11g/12c, OEM 11g/12c, Red Hat Linux 5.x, Sun Solaris 5.10, Data Guard, Golden Gate, ASM, PL/SQL, RMAN, Shell Script, Toad, SQL Developer.

Confidential, Mentor, OH

Senior Oracle DBA

Responsibilities:

• Installation, configuration and administration of oracle 11GR1/11GR2 RAC.
• Performed Code migrations and Data fixes
• Worked on SEV-1 SRS with Oracle Support.
• Involved in DR and HA activities .
• Upgrade/Migrated the production and development databases from 10g to 11g.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Migrating databases from IBM mainframe based zLINUX servers to Oracle LINUX servers.
• Maintenance of materialized views as part of business requirements and refreshing using different refresh methods such as FAST, COMPLETE, FORCE.
• 24*7 On-Call Production Technical support and Hardware Support.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Monitored data transfer between the Database servers using Goldengate11g/12c.
• Responsible for installing and configuring Golden Gate 9.5 on Oracle Servers
• Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0
• Performance tuning of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor.
• Performed Online Table Redefinition
• Generating AWR reports to analyze the database performance
• Successfully implemented Backup and Recovery using RMAN, which includes hot backups and Cold backups to tape, drives, and disks.
• Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Experience in configuring and maintaining large volume OLAP & OLTP Databases with high volume of transactions.
• PL/SQL, Performance Tuning, Application Tuning and Monitoring
• Implemented 11gR2 Data Guard using RMAN duplicate.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managed Oracle Grid control 11.1.0.1 and configured Data Guard for OMR in Linux environment
• Performed Oracle database upgrade from 11gR1 to 11gR2 in Linux RAC environment
• Experience in managing Oracle databases running on UNIX/Linux, Sun Solaris & AIX and RHEL.
• Extensively used AWR, ADDM for database performance statistics.

Environment: ORACLE,SQL*Plus, OEL 10g/11g, Red Hat Linux 5.x, 6-Node RAC, ERWIN, OEM 12c, IBM AIX 5.3,Data Guard, Golden Gate, ASM, PL/SQL, RMAN, Shell Script, OEM GRID, SQL Developer, NetApp.

Confidential, Herndon, VA

Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Part of a 4 member Oracle Database Administrator team from Herndon.
• Provided on call DBA support for Oracle 10g/11g Production, QA, DEV databases on RHEL and Solaris for OLTP and Data Warehouse Environments.
• Applied RDBMS and Interoperation patches for upgrading the database from 10g to 11g.
• Performed the Pre Patch analysis and post patch support for the baseline patches.
• Backup and Recovery procedures for production, non- production databases using RMAN in conjunction with periodic Complete and Incremental Backup.
• Data Refresh/Cloning Oracle Applications from Production environment to setup Test/Development Environments.
• Performed capacity planning and reorganization of the various tablespace for efficient use of the storage.
• Tuning various queries using the HINTS or creating indexes.
• Applied critical patch updates (CPU) released by oracle quarterly.
• Extensive experience in implementation, maintenance, installation, administration of Oracle databases 11g/10g/9i/8i running on various operating systems UNIX, Sun Solaris, AIX, RedHat Linux and Windows
• Performed advanced replication using Oracle Streams
• Installed Red Hat Enterprise Linux (RHEL-5) on VMWARE console.
• Performed export/import utility using oracle datapump from production to test/dev/QA environments.
• Closely worked with auditors on providing the User/Oracle/UNIX level password policies.
• Performing daily Archive log file backup and checking Alert Log files.
• Review alert logs and dump files to check for any problems related to the database/user.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• On call Production Support ON Shift Basis.
• Perform database capacity planning and growth projection by monitoring the tablespace space requirements and ensuring that there is enough disk space available to support the various end-user applications that access the databases.
• Performance tuning of corporate databases, using tools like sql trace, tkprof, AWR, ADDM, SQL Tuning.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and analyze command.
• Logical backups are scheduled for Development, QA, Help Desk and UAT databases using export/import and Data Pump.
• Extensive Hand on experience in handling Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Implemented and managed optimum physical database design (tablespace, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Tuning the initialization parameters as per the needs by analyzing the AWR reports.
• Creating private and public Database links between various databases residing on different host as the project requirements.
• Involved in data replication through creating materialized views and developing database triggers to keep track of the historical data.
• Involved in identifying the performance issues of the database and suggesting creating Indexes on different columns depending on the size and the dependencies of the database tables.
• Managing the database objects through OEM grid control and also monitoring various databases and tuning them through running Explain plan or SQL Advisor for various performance related issues.
• Scheduled shell scripts for running daily jobs using CRONTAB.
• Involved in creating stored procedures for using BULK INSERT feature for inserting huge data into the database tables which had improved the performance by huge amount.
• Creating table spaces and adding data files to the existing table spaces and resizing them as per the requirement and monitoring their growth in a timely manner

Environment: Oracle 8i, Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1), Oracle Enterprise Manager (OEM), AIX 5.2, 5.3 RS6000, SQL*LOADER, Solaris 3500, Solaris 10k .

Confidential, Southborough, MA

Oracle DBA

Responsibilities:

• Performed the Pre Patch analysis and post patch support for the baseline patches.
• Upgraded the database and clusterware from 10.2.0.4 to 11.2.0.2.
• Backup and Recovery procedures for production, non- production databases using RMAN in conjunction with periodic Complete and Incremental Backups, BCV backups.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Bash Shells
• Installed and upgraded the DNB Integration Manager application which is used by the Oracle 11i Application for creating new customers.
• Troubleshoot the various performance issues for the mission critical RQF project.
• Data Refresh/Cloning Oracle Applications from Production environment to setup Test/Development Environments.
• Performed capacity planning and reorganization of the various tablespace for efficient use of the storage.
• Tuning various queries using the HINTS or creating indexes.
• Writing various shell and Perl scripts for the database and application monitoring.
• Worked with Shareplex support for the various issues related to critical Reporting data based on Shareplex.
• Replatform a large 8TB database from Solaris to Linux using the complex Transportable Tablespace and RMAN Convert.
• Experience with Database reorganization, collecting statistics and monitoring database performance using STATSPACK, OEM, and TOAD.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Experienced in developing automated Jobs using Shell Scripting, PL/SQL.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Devised and Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation

Environment: Oracle 8i/10g/11g, RHEL4.x/5.x, Solaris 10, OEM, TOAD

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Responsible for both creation and manage Production, Development, Unit and Test instances of Oracle Version 9.2.0.6,10g.
• Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT
• Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log monitoring and many other maintenance activities.
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Experience in taking Export, Import and Loading data using SQL*Loader, Punchout and Bulk Loader.
• To Review the team members weekly status reports, preparing Customers Monthly status Report.
• Database health check, pinning of objects, Monitoring the Database Growth and increasing the tablespace sizes, Reorg of Tablespaces, Identifying and Recompiling invalid schema objects and Building Schema Index bugs.
• Migrating Portal from Solaris to Linux with integration of Portal OID with Microsoft Active Directory.
• Configured Oracle 10G Data Guard for disaster recovery. Implemented Oracle 10G Flashback feature for recovery operations.
• Data export/import using Data pump an oracle 10g feature. Data movement using Transportable Tablespace.

Environment: Oracle 9i OEM, Linux, HP-UX, TOAD, Database Tools/Utilities, STATSPACK, TKPROF, UTL SMTP, SQL*LOADER