PROFESSIONAL SUMMARY:

• An Oracle professional, self - motivated with strong problem solving and outstanding communication skills with around 10 years of IT experience as an Oracle DBA (versions 12c/11g/10g/ 9i).
• Installation, upgrade, maintenance, administration of multi-terabyte standalone and RAC on multiple platforms like IBM-AIX, Sun-Solaris, UNIX, Linux, Windows.
• Production support and day-to-day activity to ensure zero alert thresholds is met 24x7.
• Experience with installation of Grid Infrastructure for ASM, RAC. Very good understanding of GpnP (Grid Plug n Play).
• Administered Oracle clusterware and resources on 11g and 12c using CRSCTL/SRVCTL.
• Migrated OS file system storage to ASM with minimal downtime and administered ASM disk groups and instance.
• Server side and Client-side fault tolerance achieved by configuring SERVICES and TAF (Transparent Application Failover).
• Proactively monitored and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success of production db and application.
• SQL Tuning, End-user tuning and troubleshooting using various tools like EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, v$ performance views.
• Good experience with Data Modeling to translate logical data elements into the physical database design.
• Experience with Toad Data Modeler using Erwin.
• Build complex entity relationship models - both logical and physical database design.
• Experience in resolving complex restore and recovery issues using RMAN.
• Experience in UNIX Shell Scripting for automating the DBA tasks like User maintenance, Performance Monitoring of CPU, Disk and Memory usage, and File system monitoring.
• Good Experience in Hot/Cold Backups, and Cloning of Databases.
• Good Knowledge of RMAN backups.
• Proficient in Performance Tuning the applications and database proactively using STATSPACK, AWR, ADDM.
• Experience in Database Security and Auditing.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Solid skills to configure Exadata to meet company internal security requirement.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Worked with the following 11g/12c new features.
• SQL Access Advisor
• SQL Performance Analyzer
• SQL Plan Manager
• Table compression enhancement
• Active Data Guard
• Upgraded from 10g to 11g R2, 10g to 12c, 11g to 12c.
• Query Result Caching
• Invisible Indexes.
• Database Replay.
• AWR Baseline Enhancements
• Automatic Memory Management.
• Automatic SQL Tuning.
• Data Recovery Advisor.
• Read-Only Tables
• Flashback Enhancements
• RMAN Enhancements
• Table Compression Enhancements.
• Silent Installation of RAC
• Worked with Oracle Engineers in troubleshooting issues.

Databases: Oracle 12c, 11g, Exadata,10g, 9i, 8i, 8.x, 7.x, 6.0 MS SQL Server 2005 and 2008, Amazon AWS

Languages: C, C++, Java and J2EE, PL/SQL, Shell Script

Application server: Oracle 9iAS Release 2, Websphere MQ, Web logic, iPlanet

Tools and Utilities: OEM 13c, Forms6i, Reports6i, SQL*Loader, Oracle Workflow, Oracle PL/SQL, Designer 6i,Developer/2000,Discoverer 3.1(Administration & User) Visual Basic 5.0, Oracle Business Intelligence 12c

ERP Applications & Tools: Oracle Applications - 11i, 11.0.3, 12.0.6, 12.1.1

ETL Tools: Informatica (Power Mart & Power Center)

Decision Support Tools: Business Objects, Brio, Web Intelligence and Apache

Web Technologies: Weblogic, IBM Websphere MQ, Middleware(WAS/IHS)

Fusion Middleware: IDM, OIM, OAM, SOA, OBIEE and SSO

Replication: Golden Gate, Streams and Oracle Advanced Replication

Hardware: Sun Fire V880, Sun Ultra Enterprise 3500, Sun Ultra Enterprise 250/450, Acer Altros19000 DDE Org Supermax RISC Plus IBM, Dell 6600, Compaq Proliants, Compaq DL580, IBM Netfinity, Exadata x2 to x6

Operating Systems: Sun SPARC Solaris 2.x, Linux Red Hat Advanced server, HP-UNIX, IBM AIX Unix Windows 2000 advanced server, Windows XP, Windows 2003 and Windows 2008

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Oracle DBA/ Exadata DBA

Responsibilities:

• Worked as a Core DBA/ Exadata DBA at Confidential as migration specialist on Oracle 12cR1, 11gR2, Exadata X2, X3 & X6,, OEM 13c, RAC, Data Guard, Linux.
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack
• Migrating 50+ databases from Exadata X2 and X3 machines to Exadata x6 machines
• Managing database on 12c RAC and 11g R2 RAC
• Created OEDA requirement document for Oracle to setup the new Exadata X6 machines
• Worked with network and linux teams to configure the network on the Exadata x6 machines so Oracle ACS can install Grid infrastructure 12cR2 and Databases 11g R2 and 12cR1
• Configured and modified Exadata x6 machines as per Confidential requirement and specifications after Oracle handed over the standard Exadata machines.
• Installation of OJVM patch on 11gR2 databases on Exadata X2 and X3 environments before migrating it to Exadata X6 machines to match with Bundle patch version.
• Worked with Storage team in configuring Netbackup and Datadomain on Exadata X6 machines.
• Migrated using Datapump Export/Import for small databases and non-critical databases and used DataGuard to Migrate huge and critical databases with 99% uptime.
• Setup DataGuard between multiple datacenters for 12 production databases.
• Planed and documented all migration steps and coordinated with different teams during the deployments.
• Tested Switchover and failover between data centers before migration of production databases using Dataguard
• Efficient in using Dataguard Broker for all DataGuard tasks.
• Migrated multiple databases upto 10TB of size with minimal to no downtime using dataguard.
• Configured databases with 2 node and 4 node RAC clusters
• Migrated databases for applications like Peoplesoft, Automic UC4, GitHUB, Stibo STEP, Atlassian Jira, Arlassian Confluence, BuildForge, DataStage, Oracle WebCenter Sites and Confidential website.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Working on Installation of Oracle Enterprise Manager Cloud Control 13c.
• Worked with linux team to setup VM’s for Oracle Management Repository database server and Oracle Management Service (OMS) web-based application server.
• Working on setting up agents on Exadata x6 machines for monitoring.
• Setup and configure RMAN jobs for daily full backups, incremental backups and archive log backups and are scheduled using Cron.
• Setup scripts to monitor dataguard health on all datacenter apart from OEM monitoring.
• Monitoring for 24x7 Production environment, resolution of severe performance and user access issues
• Worked with tuning tools like DBArtisian, TOAD and Solarwinds Database Performance Analyzer.
• Worked on building and rolling out new 12c databases for TEST/DEV/QA/PROD environments.
• Migrated databases from 11gR2 to 12cR1.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.

Environment: Oracle 12c/11g 2-node/4-node RAC, RHEL 6.8/6.9, Grid Infrastructure, CRSCTL, SRVCTL, RMAN, ASM, Physical Standby DB, Data Guard, OEM Cloud Control 13c/12c, Datapump, TOAD, SQL* Plus, Putty, SSH, TOAD, Solarwinds Database Performance Analyzer, Exadata X2, X3 and X6

Confidential, Chicago, IL

Sr. Oracle DBA/Engineer

Responsibilities:

• Worked as a member of TCS's core infrastructure team as Oracle Engineer/DBA at CNA Insurance on Oracle 12c,11g R2,10g, Exadata 5, OVM, OEM 12c, RAC, Data Guard, Golden Gate, Linux, Aix, Solaris, HP/UX.
• Managed database on 12c RAC, 11g R2 RAC and 10g.
• Managed everything from planning to deployment for multiple projects.
• Setup Data Guard between multiple data centers
• Update existing 10.2.0.4 to 11.2.0.3 then to 12.1.0.2
• Migrated exiting 10g database to new 11g for application conversion then migrating 11g databases to 12c database and migrating 10g database to 12c database.
• Supported development team for a successful character set conversion from US7ASCII on 10g to AL32UTF8 on 11g and 12c.
• Installation of Oracle Database Vault in 12c.
• Upgraded more than 40 databases from 10.2.0.1 to 11.2.0.1 and then 11.2.0.1 to 11.2.0.2 including patchset updates using opatch.
• Installation & configure of Oracle Enterprise Manager 12c and Oracle Enterprise Manager Cloud Control 13c.
• Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.
• Managing more than 250 databases on each Oracle server on 10g,11g and 12c environments.
• Configured and managing ASM storage for databases.
• Migrated databases from Non-ASM to ASM.
• Configuration and Administration of Active Data Guard environments
• Stabilized Oracle Grid Control environment.
• Configured Oracle Dataguard and Active Dataguard
• Installation and configuration of Golden Gate
• Duplicated all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC Hybrid Columnar Compression techniques.
• Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• Migrating databases to Oracle Exadata Database Machine for different clients.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT) .
• Implemented Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Zero Downtime Migration to Oracle Exadata with Oracle Dataguard and Oracle GoldenGate.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Comprehensive documentation of all activities
• Configure, manages and monitor oracle databases on Amazon Web Services(AWS)
• Knowledge transfer to new staff
• Monitoring for 24x7 Production environment, resolution of severe performance and user access issues
• Effectively used tuning packs like ADDM, AWR, ASH, Tuning Advisors to troubleshoot resource-intensive SQL, enqueues, locks.
• Using all RMAN and datapump functionalities.

Environment: Oracle 12c/11g/10g/2-node RAC, OEL 5.8, IBM AIX, RHEL 6.5, Grid Infrastructure, CRSCTL, SRVCTL, RMAN, ASM, Physical Standby DB, Data Guard, Oracle Fusion Middleware Flashback, OEM Grid Control, Datapump, TOAD, SQL* Plus, Putty, Golden Gate SecureCRT, SSH

Confidential, Chicago, IL

Sr. Oracle DBA

Responsibilities:

• Managed database on 11g R2 RAC
• Setup Data Guard between multiple data centers
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Administered GI resources like ASM, SCAN Listener, node listener, OCR, Vote files using CRSCTL and SRVCTL utility.
• Followed Oracle best practice by moving password file and OCR and Votedisks on ASM in 12c by setting compatibility.asm = 12.1.0.1.0
• Successfully added nodes to the existing RAC cluster by extending GI and Oracle binaries.
• Troubleshooted Node eviction (split brain syndrome) issue due to flooded interconnect traffic.
• High availability and load balancing achieved with Services which was fully integrated with 11g/12c Grid Infrastructure.
• Client-side fault tolerance achieved by configuring TAF (Transparent Application Failover) in RAC as well as Data Guard env.
• Upgraded more than 15 db from 10.2.0.1 to 11.2.0.1 and then 11.2.0.1 to 11.2.0.2 including patchset updates using opatch.
• Successful installation/maintenance of 11.2.0.2/12.1.0.1 Physical Standby and Logical Standby db in Data Guard env for zero data loss.
• Effective use of tuning packs like ADDM, AWR, ASH, Tuning Advisors to troubleshoot resource-intensive SQL, enqueues, locks.
• 50% improved Performance of fetching LOB data by creating partitions. Data footprint reduced by purging older partitions to lowered operational cost.
• Load Tested DB workload with > 2000+ concurrent user accessing Banking application.
• Data migration using Data Pump export/import to bring historical data from application so to analyze the growth of db over a period.
• Installing ASM environment and migrating database from NON-ASM to ASM
• Cloned databases using Export Import, Data Pump and RMAN Duplicated Databases.
• Migrated database from non-ASM to ASM
• Clone databases using RMAN duplicated
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Applied High priority, security patches downloaded from Meta link
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes
• Manage production Oracle Business Intelligence Platform in addition to the analysis, development, deployment of customizations and extensions to the Oracle BI Platform.
• Data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs.
• Monitor data warehouse performance, reliability, availability, and recoverability and ensure data warehouse standards are consistent with long-term infrastructure plans.
• Used Oracle Enterprise Manager to monitor database health and check log files for errors.
• Installed operating systems, patching, upgrading managing configurations  
• Managed User accounts and granted directory permissions to secure UNIX systems in meeting industry practices 

Environment: Oracle 12c/11g/10g/3-node RAC, OEL 5.8, IBM AIX, Grid Infrastructure, CRSCTL, SRVCTL, RMAN, ASM, Oracle Business Intelligence, Physical Standby db, Data Guard Broker, Flashback, OEM Grid Control, Data pump,TOAD, SQL* Plus, Putty, SSH

Confidential, Canton, MI

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Installation, configuration and maintenance of 11.2.0.3 Oracle Data Guard as a high availability solution.
• Installing and configuring physical standby database using RMAN duplicate from active database on RHEL 6.3.
• Worked on Oracle 11g GoldenGate Database Servers.
• Familiar with conflict detection, uni-directional, bi-directional GoldenGate Environments.
• Build RAC from scratch
• Maintaining Oracle Data Guard and ensuring that the physical standby is always in sync with primary database.
• Possess strong RHEL and Solaris skills.
• Experienced in Oracle Golden Gate installation, configuration and troubleshooting the gg issues.
• Experienced in Oracle Golden Gate Veridata and Director Installation and configuration.
• Create and maintain oracle Dataguard database with physical standby using RMAN for the critical and production database. Monitor and manage effectively the Dataguard, RAC and ASM databases.
• Perform switchover or failover for Dataguard database whenever is required. Troubleshoot dataguard database related issues/failures.
• Clone/Duplicate production database into Test/Development database using RMAN including Dataguard, RAC and ASM databases.
• Installing & configuring 11.2.0.3 RAC database on RHEL 6.3
• Applying one off patches using OPATCH utility.
• Creating and managing application schemas with appropriate table spaces and Indexes.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
• Manage users, privileges and profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager (OEM) and SQL.
• Refreshing application schemas using data pump export/import
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Used RMAN to cloned and duplicated databases.
• Migrated databases from Windows to Linux using transportable tablespaces.
• Oracle 10g & 11g RAC, ASM, Stream, Data Guard (Physical, Logical standby), Enterprise Manager (EM) Grid Control, RMAN, Installation, Upgrades, Migrations, Performance Tuning Recent Experience.
• Highly Experience in Tuning database in RAC / Non-RAC environment for better Performance.
• Creating and managing application schemas with appropriate table spaces and Indexes,
• Create public and private database links.
• Migrating databases to Oracle Exadata Database Machine for different clients.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT) .
• Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Zero Downtime Migration to Oracle Exadata with Oracle Dataguard and Oracle GoldenGate.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.

Environment: Oracle 11g/10g, RHEL 6, AIX 5.X, OEM grid control, TOAD, Data Pump, RMAN, AWR, ASM, Oracle Exadata Database Machine.

Confidential, Indianapolis, IN

Sr. Oracle DBA

Responsibilities:

• Migration of 20TB database from existing 4-node RAC cluster (having 4 nodes DR) to new 4 node Cluster having its 4 node DR.
• Writing PL/SQL code, having procedures function to migrate WAMU (Washington Mutual) data into JPMorgan Chase databases.
• Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installed, Configured, Upgraded and Performed Trouble shooting for oracle Golden Gate 10g/11g Version.
• Proactively monitored the database and database access, and maintained the database security.
• Extensively worked under UNIX environment to provide DBA support.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Tuning of the queries in PL/SQL procedure to run efficiently
• Migrated datafiles from one server to another using DBMS FILE transfer package.
• Configured Streams on 2 node RAC cluster using Local capture and downstream capture.
• Extensively worked on Streams environments, fixing day to day streams related errors, synchronizing table, restarting capture and apply process, monitoring streams lag and many other streams related activity.
• Configured Table level and Schema level streams replication.
• Worked on Table partitions tasks such as exchange partition, split partition etc.
• Creating local and Global indexes and rebuilding indexes on table partitions.
• Written shell scripts for archivelog destination monitoring, alert log monitoring for specific ORA errors, scheduling jobs using crontabs and DBMS scheduler.
• Upgradation of databases from 9i to 10g.
• Generating AWR reports to deal with performance issue.
• Written scripts to monitor tablespaces, file systems.
• Applied CPU patches and other patches for bug fixing.
• Providing on-call support for database monitoring
• Loading data from flat file to tables using SQL loader.
• Transferring data using DB-Links, SQL Loader, import-export and datapump.
• Creating SR with Oracle Support.
• Scheduling backups using RMAN and creation of catalog databases.
• Installed OS watcher on new servers.
• Installed grid control Agents on new servers.
• Provided 24X7 on call support having pager.

Environment: Oracle 10g,11g, Sun Solaris 5.9/5.10, AIX 5.3, RAC and Data Guard, Streams, OEM (Grid Control), RMAN, AWR, ADDM, ASM, PL/SQL, TOAD, SQL *PLUS, WinScp, F-secure.

Confidential, Omaha, NE

Oracle DBA 

Responsibilities:

• Installation, up gradation and Maintenances of Oracle Databases on Linux & Windows platforms. 
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN. 
• Perform database monitoring, capacity planning and performance tuning.  
• Provided System support for both development and 24/7 production environment. 
• Prepared plans for up gradation of all critical Production Databases from 9i to 10g on Linux and DATAGUARD implementation.   
• Performed capacity planning and sizing of databases based on input from business. 
• Taking care of all alerts for space issues and user requests. 
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity. 
• Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after upgrading databases. 
• Performed database cloning from old system to new system. 
• Used EXPORT/IMPORT for table level and full database de-fragmentation. 
• Transported tablespaces between production and development databases. 
• Running scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc. 

Environment: Oracle 10g, 9i RAC, Oracle 10g Inter Media, Red Hat Enterprise Linux Advanced Server/Enterprise 2.1/3.0, AIX, HP-UX, Solaris Windows Server 2000, VERITAS Net backup, UNIX Shell Scripts, TOAD, TKPROF and SQL*Net

Confidential

Database Developer /Admin

Responsibilities :

• Involved in gathering requirement, Analysis, Design.
• Created database objects including tables, views, synonyms, sequences, constraints, indexes.
• Created Pl/SQL Stored Procedures, Functions, Packages, Triggers, Cursors.
• Prepared migration documents & other documentations. Monitored db performance via STATSPACK.
• Participated in design reviews for upcoming application enhancements.
• Performed data extracts/loads in the testing environment using SQL*Loader.
• Assisted developers to troubleshoot SQL and PL/SQL code and increase the efficiency of execution.
• Created daily, weekly, and monthly DBA checklists for each environment.
• Documented database/server configuration for production, test, and development databases.
• Setup Crontab jobs to automate the routine tasks.

Environment: Oracle 9i, SQL*Plus, Pl/SQL, TOAD, SQL*Loader, SQL*PLUS, UNIX, VSS, OEM, Stats pack, QC