SUMMARY

• 8+ years of professional experience as Oracle DBA. Worked extensively on oracle 12c, 11g, 10g and 9i versions involving database administration, Installation, Configuration, Backup and Recovery, Migration, Upgrades, Patches, Cloning, Replication, Database Security, Memory Management, RAC, Data Guard, Performance Monitoring and Tuning, Grid Control, Oracle Streams, Golden Gate, Data Modeling.
• Expertise experience in installation, administration and configuration of Oracle Exa - data,12c, 11g, 10g, 9i on OEL, RHEL, SUN SOLARIS, IBM-AIX, WINDOWS, HP-UX in OLAP and OLTP environment.
• Good Experience in Hot and Cold Backups, and Cloning of Databases.
• Experience in taking the logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP.
• Expertise in installing, configuring and maintaining Standalone as well as RACdatabases on various platforms and responsible for full time availability of the database.
• In depth knowledge of Apache Cassandra (how it works) and experience in installations
• Worked on Oracle Exa-data Backup Configuration utility.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Infrastructure.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 12c/11g/10g/9i.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Upgrading databases by applying patches, patch sets and critical patch updates.
• Management of schemas, objects&Partitioning the tables&indexes, USERS and PRIVILEGES.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control(OEM).
• Migration of databases from one platform to another platform.
• Installation and configurationof Oracle Server 12c, 11g RACwithASMon multi node systems, 11g, 10g and 9i in different operating systems forOLTPenvironment onVery Large Databases(VLDB).
• Supported ASM database and performed migration of normal database to ASM database using RMAN.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Implementation of High Availability Solutions using Oracle 11g RAC, 10g RAC, Physical and logical Standby database (Data Guard).
• Excellent experience in configuring and tuning of Oracle 12c/11g RAC, CRS and ASM for high availability database.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, and ASH.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting GoldenGate issues.
• Experience in Oracle Support (raising process) processes for technical requests through metalink.
• Extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Worked on different types of storage structures(SAN/NAS).
• Experienced in loading data from flat files into database tables using SQL*Loader.
• Experience using Erwin as a Data Modeling tool.
• Proficient in writing PL/SQL procedures, Triggers, Functions, Packages and Cursors and Exceptional handling.
• Assisting in implementation of change control process in production.
• 24*7 on-call production database support and maintenance including remote database support.
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.

TECHNICAL SKILLS

Databases: Exa-data, Oracle 12cRAC/11gRAC/10gRAC/10g/9i, SQL Server 2005/2008/2012.

Operating Systems: X 10.10/10.7 Windows XP, 7, 8 Red Hat Enterprise Linux 4.x, 5.x, 6.x Sun Solaris 5.8/5.9/5.10/5.11 , AIX 5.2/5.3/6.1

Languages: C, C++, SQL, PL/SQL, Unix Shell scripting, Perl.

Tools: and Utilities: Oracle Grid, OEM, TOAD, Putty, Erwin, SQL loader, Export / Import, Expdp / Impdp, AWR, ADDR, STATSPACK, RMAN, Win SCP, JIRA,TKPROF,Cron jobs, Log Miner, SQL Server, Golden gate, Exa-data, Data Guard, VMware.

Protocols: HTTP, TCP/IP, FTP, SFTP, SSH, TELNET

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

• Supporting technically with ongoing 11g relese2 from Solaris to linux12c database migration as a major project.
• Experienced in conducting RAC HA failover testing for various failure scenario’s on Exa-Data platform.
• Extensive experience in AQ/MQ alternative for business requirements on Exa-data 12c platform as part of oracle 12c migration.
• 24x7 on-call production database and applications support
• Created check point table, did Data load using Expdp and Impdp for replication in Golden gate.
• Implemented Oracle Data pump and stream instantiation, created single and multiple source environments, managed LCR s in Oracle Streams.
• Installed and configured Oracle Enterprise Manager Grid control 12c on Windows server 2008.
• Providing full life cycle on DBA/on call support for Production Databases, administering, UAT, Development and QA databases.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Installed & configured Web logic server on UNIX platform and deployed applications.
• Contention and providing centralized management for Disks.
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RACdatabases on ORACLE 11g Clusters.
• Good experience with multi master replication setup & Administer with Golden Gate tool.
• Setup reporting server using ORACLE Streams from various data sources.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Data pump.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
• Exposure to Oracle Utilities and Tools like OEM 12C, Import-Export, Auditing, RMAN.
• Experience with BMC Remedy tool for all change management process.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• Enhancing performance using various components like SQL TUNING ADVISOR, ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
• Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspackand CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Documented the Role Transition method from Primary to Standby and vice versa of Data guard environment.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netback up.
• Used Flashback Technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.
• Performing Database Refreshes using Exp/Imp, Data pump, Sql*Loader and RMAN.
• Writing Triggers and debugging Stored Procedures and Functions-PL/SQL.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.
• Performed Export and Import utilities in SQL SERVER databases.

Environment: Oracle Exa-data,12C,11g RAC, 10g, SQL Server, Red Hat Linux, IBM AIX, Data Guard, ASM, PL/SQL, RMAN, Golden Gate.

Confidential -Roseville CA

Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Oracle 11g/10g/9i installation and Configuration.
• Creation of the Oracle 11g physical standby database. Implement switch the
• Stand by to read only mode for reporting purposes during business hours and switch to recovery mode at night to apply the logs.
• Design, document, implement and maintain all Disaster Recovery procedures.
• Load extensive experiment data to the database via SQL Loader.
• Migrating Oracle 9i to 10g and 10g to 11g.
• Installing Oracle Patch
• Migrating production database to new server.
• Migrate databases into dev., test, and/or production environments
• Plan and build database instances and objects
• Designing the security and database access strategies.
• Performing backup, restore and recovery using RMAN/ conventional hot backups.
• Cloning databases for development and testing.
• Performance tuning Using TKPROF, EXPLAIN PLAN, STATSPACK, AWR and
• ADDM reports for the Better performance.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Partitioning strategies for very large tables.
• Create scripts for hot backup on a daily basis scheduled with cron jobs and Autosys
• Install, configure and maintain Oracle 11g Real ApplicationCluster (RAC).
• Set up and maintain oracle disaster recovery site usingDataGuard.
• Perform user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Provide technical assistance and guidance to application support staff and project teams.
• Implement Oracle Enterprise Security Manager (ESM).
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of databases and viewing Alert log files & Trace files.
• Monitoring growth of tables and undertaking necessary re-organization of tables and indexes as and when required.

Environment: Oracle Server 11g/10G/9i/8i, OEM (Oracle Enterprise Manager), SQL*Plus, PL/SQL, Sun Solaris5.8, Linux Red Hat, Windows

Confidential -Ridgeland MS

Oracle DBA

Responsibilities:

• 24X7 Production support of Oracle databases and administration.
• Supported OLTP and Data Warehouse Environments ranging from 500GB to 20TB.
• Managed Production, Development and Test environment databases running on 10g and 11gR1/11gR2 both RAC and single instance.
• Involved in architectural discussions for documenting the database requirements for new application deployments.
• Implementation and support of Oracle Streams and Golden gate replication technologies.
• Used Golden gate technology to perform minimal downtime database upgrades and platform migrations.
• Troubleshooting and documentation of 11g RAC installation issues, performance issues.
• Upgraded the databases from 10.2.0.4 to 11.2.0.X involving both single instance and RAC databases and documented the upgrade process.
• Upgraded the databases from 11.2.0.1 to 11.2.0.X involving both single instance and RAC databases and documented the upgrade process.
• Implemented HA solutions using Physical Standby Data Guard and Flashbacktechnologies.
• Setup 11gR2 Active Data guard physical standby database for both Single instance and RAC primary databases.
• Worked on issues with cluster performance and node evictions and provided remediation to fix the issue.
• Worked with application teams in identifying the performance bottleneck and provided solutions to fix the issues.
• Oracle database tuning and SQL tuning using Statspack, AWR reports, SQL trace, TKPROF, Grid Control.
• Cloned/Refreshed Development environment from production using RMAN in support of the testing efforts and code drop validations.
• Created partition tables and created jobs to automate the partition maintenance.
• Backup and Recovery using RMAN with external tape backup system and Data Domain.
• Provided support for the application releases on production databases.
• Involved in the recovery drill to restore the backups from tape to check the validity of the tape backups.
• Other activities like applying RDBMS patches, PSU, proactive monitoring of databases and applications.

Environment: Oracle 9i, 10g/11g/11gR2 RAC, Sun Solaris, AIX, RHEL.

Confidential -Los Angles, Ca

Oracle DBA

Responsibilities:

• Database Administration support (24x7) for large mission critical production databases
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recoverypurpose.
• Responsible for Creation and maintenance tablespace, datafiles, redo log files and renaming /relocating of data files on servers based on OFA model.
• Oracle 10g & 11g Databases maintenance and troubleshooting.
• Upgraded from 9i to 10g, 10g to 11g database and applied critical patches update (CPU) for latest versions. Good experience in managing Very Large OLTP and Data ware housing databases.
• Good knowledge on replication tools like Golden Gate to extract and replicate Databases.
• Installing Golden Gate from scratch as per the business requirement to replicate large and mission critical tables for the production/testing/development environments.
• Migrated applications to the HDS (Hosted Database Services) environment using Golden Gate 10.4.0
• Involved in setting up, maintenance of Standby Database with Data Guard for Disaster recovery.
• Working knowledge on NETAPP storage from disk to tape to copy the RMAN Backup Data and mirroring of databases (BCV Split backup) from one database to another using NETAPP utility.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
• Designed conceptual schemas using Rational Rose like Entities, Relationships, and Integrity rules.
• Responsible for implementing backup procedures using RMAN. Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database. Implemented strong backup and recovery strategies and monitored backups.
• Korn shell/ Bourne Shell scripting for tablespace monitoring. Scripting for RMAN backups to connect to the catalog and run the backup as per the scheduled job in crontab.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Pre-Build checks on UNIX box whether number of LUNS from SAN team allocated perfectly.
• The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users.
• For security administration used oracle Wallet Manager to manage public key security credentials on Oracle clients and servers
• DB2supports both SQL. DB2 has native implementation of XML data storage, where XML data is stored as XML (not as relational data or CLOB data) for faster access using XQuery.
• Worked on Amdocs billing system to generate PO for rental changes and usage charges. These are the charges taken from the customers on monthly based and charges taken from the customers based on the service utilization.
• Billing system as accounts payable (for inter-carrier settlements) as customers often use services from other companies such as wireless roaming, long distance and call completion through other networks.
• A capacity planning tool outlines how a future application will function and determines whether or not a company will have to upgrade its CPU or add disk storage to keep users happy.
• PL/SQL, Stored Procedures, Packages, Functions, Database Triggers and Shell scripting.

Environment: Oracle 9i, 10g RAC& 11g RAC, OEM Grid Control, Sun Solaris, HP-UX, RHEL, Windows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

Confidential -Woonsocket, RI.

Oracle DBA

Responsibilities:

• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Oracle EBS Administration, Production support, Development and test instances.
• Table space monitoring and management & resizing.
• Maintaining databases by Managing alerts and Cron jobs.
• User management & Security.
• Monitoring of databases, Performance tuning.
• Patch analysis, applying application patches
• Applying Product specific patches and fixes.in development, test & PROD Instances.
• Working with AD utilities, patching techniques and cloning tools in various Oracle applications environments.
• Using OEM tool to manage Alerts& Maintain database sessions, Killing inactive Sessions.
• Refreshing development & Test instances, Running Auto configuration.
• Working with Oracle support: opening, managing, and resolving Oracle SR's
• Monitoring & Debugging concurrent manager’s issues, concurrent processing; and requests.
• Applying Patches in APPS and Databases, maintenance Production support.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Environment: Oracle 11g/10g, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, DBArtisan, Toad, VERITAS Net Backup, OTM.

Confidential

Oracle Software Consultant

Responsibilities:

• Involved in the requirement capturing
• Design & coding of transaction & master forms
• Handled Data Base creation & Back up Management activity of Oracle.
• Preparing Functional and design documents & participation in project review
• Involved in designing data base Including triggers & indexes
• Coordination between development team in project assignment
• Extensively used of PL/SQL Stored Procedures, Functions, Form Triggers and Packages.
• Developed web based front-end screens using Forms 6.0
• Creating SQL, PL/SQL database objects.
• Written the Interface Stored Procedures for Data Transformation
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL
• Involved in Testing (Both Unit and Integration Level) and Implementation.
• Tested the entire application in testing environment and exported to Production.
• Done the documentation and provided on-site production support.

Environment: Windows 2003 server, ASP 3.0, PHP2, XML, MS SQL Server 2000 (Enterprise Manager, Query Analyzer), TSQL, Erwin 4.0.