SUMMARY

• Oracle DBA with around 8 years of professional experience in large - scale production environments across multiple platforms.
• Over 4 yearsof programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Hands-on experience with Oracle Real Application Clusters (RAC) 11g R2, Golden gate and Data Guard.
• Experience as an Oracle DBA in various domains to deliver new products, upgrades with Oracle 11g R2 on Sun Solaris, Red Hat Linux, SUSE, HP-UX, IBM-AIX and Windows platforms.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to RAC environment.
• 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.
• Experience in upgrading databases 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1.
• Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Experience in building Standby databases, Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard.
• Also proficient with new 11g features such as Active Dataguard and Snapshot standby database.
• Implemented GoldenGate for Standby Configuration and developed procedures for Replication.
• Performed data replication, transformation and delivery of database transaction using GoldenGate replication tool.
• Proficiency with installation and maintenance of replication tool GoldenGate by creating extract process, extract pump and replicate.
• Implemented GoldenGate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging GoldenGate issues such as extract, replicate rebuild and abend.
• Proficiency with creating GoldenGate extracts process, extract pump, fan out pump and replicate.
• 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.
• Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid monitoring and Recycle Bin.
• Experience in using OEM, TOAD and Data Migrations using export/import, ATG, benchmarking using load testing tools
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Implemented best practices for maintenance, monitoring, backup/recovery contention resolution and defrag scenarios across diverse environments.
• Experience in Implementation of High Availability solutions with Oracle 11g RAC, Physical Standby Databases (Data Guard).
• Extensive knowledge in database Cloning using RMAN, VERITAS, Net Backup, IBM Tivoli Storage Manager (TSM).
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Strong experience in Hot/Cold Backups and Point-in-time recovery procedures using RMAN.
• Expert in providing Data Masking and Archiving solutions using IBM optim.
• Very good experience working with onsite/offshore as a lead analyst in IBM optim.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Experience using Explain plan, Tkprof, Events tracking, and Auto trace and identifying the execution plan and tune queries, using indexes, hints etc.
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, data migrations using export/import, benchmarking using load testing tools.
• Good experience with Python, Pig, Sqoop, Oozie, Hadoop Streaming and Hive
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, ROLAP, Logical and Physical Database Design.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM) Grid control, analyzed SQL trace dumps.
• Extensive experience on OEM, TOAD (Tools for Oracle Application Developers), SQL*Plus and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA.
• Worked on POC on OEM 12c Cloud, installed in all our non -prod databases, have good knowledge on 12c.
• Worked on building and rolling out new Oracle 12c databases for test/dev./qa environments.
• Experience in Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Specialized in all aspects of database design and programming with Sybase
• Adaptive Server Enterprise, Replication server and Sybase IQ Server and Oracle
• Documented all Oracle 12c installation/upgradation work and derived KT to all team peers.
• Engineering of the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.
• Experienced with installing, configuring and administering SQL server 2008 databases including migration from MS SQL server to oracle.
• Good experience in MSSQL server 2008, T-SQL with knowledge of Server Clustering, SQL Profiler, Execution plan, Log Shipping and Database Mirroring.
• Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Good knowledge on ITIL processes and concepts for managing incidents, change requests.
• Transferring compressed files on FTP servers, on UNIX platform.

TECHNICAL SKILLS

Oracle Tools: RMAN, OEM Grid Control 11g, 12c, Golden gate, data guard, TOAD, data pump, Import/Export, OPatch, Data guard Broker, NETCA, NETSTAT, DBCA, CRSCTL, OCRCONFIG, SRVCTL, Erwin, putty, Oracle, SQL Developer, Wise

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Enterprise Manager Grid Control.

RDBMS: Oracle 9i, Oracle 10g R2, 11g R1/R2, 12c

SQL Server Languages: SQL, PL/SQL, C, UNIX Shell Scripting, PERL Scripting

Web Tools: HTML, XML, HTTP, TCP/IP, FTP, SFTP, SCP, Metalink.

Operating Systems: Red Hat Enterprise Linux RHEL 4.x, 5.x, 6.x Sun Solaris 8/9/10 and Windows 07/08

PROFESSIONAL EXPERIENCE

Confidential - Cherry Hill, NJ

Sr. Oracle Database Administrator

Environment: Oracle 12c/11g/10g, OEM 11g Grid Control, RMAN, RAC, Streams, Oracle Streams, ASM, Data Guard, Oracle Partitioning, Oracle Replication, Oracle Fusion, Upgrade, Sybase, Exadata, SAN, Migration, Exp/Imp, Performance tuning, Shell Scripting, SQL*Loader, Oracle Spatial, Toad, SQL Navigator, SQL*Loader, SQL Server 2012, Grid Control, PL/SQL, SQL*Plus, Sun Solaris, Linux, UNIX Server.

Responsibilities:

• Oracle 11g R2 RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management (ASM) and Configuration and Tuning.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Setup RMAN solutions for all Oracle Databases created RMAN repository, provided best practices, optimizations and data guard and cloning techniques - restore and recovery.
• Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Implementing 10g Data guard with one physical database.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases)
• Used Golden Date 10g/11g to migrate database inventory from older to newer hardware
• Migrated single instance database to multiple instance databases using export/import, data pump.
• Replaced Streams and Data Guard with Golden Gate 11g to provide a robust and flexible disaster recovery platform
• Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
• Responsible for the installation, configuration and overall up from 10g to 11gr2.
• Involved in configuring two node RAC on 11gR1, oracle clusterware on Redhat Linux AS 5.
• Databases migrated to RAC for improved resiliency and performance.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
• Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
• Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Created indexes to facilitate easy user interface implementation and tuning.
• Involved in construction of DR sites for all the Production and IST environments.
• Performed Database Refresh from Production to IST, UAT and Development databases.
• Installing and configuring Oracle WebLogic 11g application server.
• Hands on experience on installing and upgrading Apex 3.2 to Apex 4.1.
• Experience in installation OWB and OWF.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Installed and tuned oracle spatial needs along with trouble shooting issues.
• Extensive experience in RMAN recovery testing and standalone database.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Worked on different types of storage structures (SAN/NAS).
• Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
• Monitoring Day-Day Backups, Log's & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles, 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.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Leveraged oracle technology and skill investment by enabling oracle spatial.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Confidential - Downey, CA

Sr. Oracle Database Administrator

Environment: Oracle 11g, SQL, PL/SQL, Import/Export, RHEL, Windows NT, Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, Oracle Fusion, Exadata, Sybase, SAN, STATSPACK, Performance tuning, Patchset, Upgrade, Migration, SQL, PL/SQL, SQL*PLUS, Korn Shell, Perl Scripting, Sun Solaris and Linux.

Responsibilities:

• Installed and configured new Quarterly Oracle HOMES for the 10g and 11g versioned servers.
• Primary DBA for all databases in DEV/TEST/PRODUCTION on 10g and 11g (Agents and Databases monitoring).
• Involved in Real Application Cluster (RAC) administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Installation & Configuration of Oracle 11g, 10g on Linux (RHEL 3, 4), upgraded databases to 11gR2.
• Expertise in Data Modeling of Oracle, PL SQL and Business Intelligence data warehousing.
• Managed and reviewed Hadoop log files.
• Shared responsibility for administration of Hadoop, Hive and Pig
• Planned and performed a rollout of AutoSys 11.0 to enterprise along with my team.
• Patching GI & Database to latest PSU patches.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Practical understanding of the Data modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Migrated data successfully from CX600/CX700 to CX4-240 using Mirror View/S and SAN Copy and CX600/CX700 to DMX-3 to DMX-4 using Open Replicator /Open Migrator.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Document and communicate changes to theOLTP, OLAPsystems and data warehouse teams, includingData Modeling, ETLand Database teams.
• Worked on creating real application clusters (Oracle RAC, 3 Node, Size 17T).
• Extensive experience working with Oracle RAC in Installation, configuration, performance tuning and trouble shooting of RAC systems.
• Implementation of RMAN backups, experience in working with scripts.
• Configured Oracle DataGuard, Implementation of physical standby database and Active data guard.
• Implemented pdf conversion of application usingITextAPI’s. Developed customdynamopages for Application, Awards, Peer Reviewer module using standard ATG Taglibraries,CSS and droplets. Configured and installed Websphere server on ATG server instance on local machine to debug the application inRAD.
• Involved in ACFS and ZFS implementation works.
• Worked extensively on Erwin and ER Studio in several projects in bothOLAP and OLTPapplications.
• Assisted in implementation/ Upgrade of AutoSys.
• Performing Backup/Recovery of all the Oracle databases using Recovery Manager (RMAN), also setup Recovery Manager Catalog for the same and hot and cold backups.
• Implemented Golden Gate 10g/11g replication for over 100 databases
• Gather Oracle Database statistics - like Table space sizes, Data files sizes, etc.
• Developing Golden Gate system macros and analyzed applications for Golden Gate suitability.
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r7.1
• Developing OLAP cubes using SSAS 2008 and calculated the metrics that were revealed in the functional analysis.
• Developed ER and data flow diagrams, Performed Data Modeling and Architecture for the database. Generated DDL's to create Database objects.
• Maintained and deployed OLAP Cubes in SSAS.
• Identifies and resolves data synchronization issues on a regular basis
• Planning Backup strategy for all instances and Log Monitoring, Migrating database schemas.
• Recover Database from backup, used Data Pump for bulk data migration.
• Monitor everyday systems and evaluate availability of all server resources and perform all activities for Linux servers
• Improved Performance of database by tuning parameters like library cache, log buffer, missing & rebuilding indexes, buffer cache hit ratio, sorts, reparsing of SQL, free list contention.
• Performed RAC Installation over local file system, voting & SRVM disk are located on RAW partitions and database is on ASM file system.
• Created symbolic links to access these Raw Partitions from the Oracle Database.
• Responsible for database security and patching and Control and monitor user access.
• Performed day to day database administration on existing databases and applying patches (OPATCH) and upgrades as needed.
• Installed, Configured and effectively used Oracle ASM, AWR, ASH, ADDM features.
• Performed day to day database administration on existing databases and applying patches (OPATCH) and upgrades as needed.
• Participated as a member of the engineering teams for database-related tasks like optimizing the SQLs.
• Maintained effective database performance monitoring procedures.
• Control and monitor user access to databases and maintain database security.
• Allocate storage and develop plans for future storage requirements.
• Maintain documentation of systems and standard operating policies and procedures.
• Resolved development and QA database requests.

Confidential

Oracle Database Administrator

Environment: Oracle 11/10g, Capacity Planner, SQL plus, PL/SQL, Standby DB, Dataguard, Solaris, Win NT, SQL Developer, MS-Visio, TOAD, Windows Server 2003, Linux, Java, Tomcat, RMAN, RAC, ASM, Streams, Patchset, Sybase, Upgrade, Migration, Exp/Imp, SQL Server 2008, Performance tuning, Shell Scripting, AIX, Linux, UNIX Server, SAP Clients DEC Unix 4.0 D, AIX 3.0, 4.5B, 4.6C with configuration in 4.5B and 4.6C

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Used Model Mart ofErwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Responsible for working on LUN's, SRVCTL, OCR and Voting Disk of 10g/11g RAC.
• Installing Oracle Database 10g RAC, Upgrading the Database and applying patches as required.
• Installed & Configured Oracle 11g on Linux.
• Install and configure OracleGolden GateandVeridata.
• Coded membership tiersdynamopages using standard ATG taglibraries.
• Database cloning from Production to Test and Development environments.
• Worked on RE-IP VIP for RAC.
• Converted a single instance database to Oracle 10g RAC and migrating database from NON-ASM to ASM
• Used Data Guard for management, monitoring, and automation software infrastructure to create and maintain one or more synchronized standby databases to protect data from failures, disasters, errors, and corruptions.
• Used Data Guard for Data Protection and Disaster Recovery.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage.
• Maintain and monitor all system frameworks and provide after call support to all systems and maintain optimal Linux knowledge.
• Partner with architects of different other engineering / application teams to engineer complex technical product in order to provide palpable business solutions to various business divisions as a part of DBA Engineering project activities.
• Assists in testing the interaction of programs in multi-program systems and coding Shell scripting to initiate and control program execution.
• Worked on creating, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.
• Prepared the MOP's (Method of Procedure) for renaming the Database, Creating and upgrading the DB, RE-IP, Partitioning the Tables etc.
• Supported the upgrade of RHEL and Hard work are diagnostics on various servers.
• Worked in all shifts and 5 days SNAP (production maintenance) at the maximum handovers.
• Documented all the incidents and presented in a form of report.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS and SQL server integration services (SSIS) in the SQL server 2008.

Confidential

Oracle Database Administrator

Environment: Oracle 11g/10g, RAC 11g/10g, RHEL, Sun Solaris 10, IBM-AIX, Windows 2003/NT, OEM, Grid Control, RMAN, ASM, CRS, DATA GUARD, XML, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, AWR, ADDM and DB Artisan

Responsibilities:

• Provided 24×7 Production support for the database and application issues.
• Performed installation, configuration, trouble shooting and support of Oracle 11g R2 RAC databases using Oracle Grid Infrastructure including CRS Management.
• Installed Oracle 10g on production databases and applied Opatch to fix the known bugs.
• Involved in the migration of databases from Oracle 10.2.0.4 RAC to 11.2.0.2 RAC.
• Involved in monitoring the status of the production systems and to conduct proactive maintenance.
• Responsible for problem identification and resolution of troubleshooting issues with applications in AutoSys.
• Writing documentation for Clusterware installation, RAC RDBMS installation, RACDatabase creation, Grid Control installation, Oracle 11g Standby Documentation.
• Implemented ASM on RAC. Managing disks and disk groups with ASM.
• Install and configure Oracle Golden Gate and Veridata.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Monitored and effectively tuned the 11g database instances by utilizing own scripts, precise In depth for Oracle and the Stats pack utilities.
• Involved in Security Management and monitoring all kinds of Privileges to Users, roles.
• Keeping the databases up to date with respect to Latest PSU's and very comfortable in applying patches.
• Worked with SAN admin on EMC SRDF technology to provide replication and disaster recovery solutions for mission critical databases.
• Configuring, automating and implementing physical RMAN full and incremental backups (differential and cumulative) for all databases to recover from failures.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Architecting Oracle Fail safe environments for site critical databases, including configurations, failover testing, tuning, creating standards etc.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, Oracle 10g AWR, ADDM, ASM etc.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.
• Worked on queuing for sending XML data.
• Wrote different levels of Stored Procedures for monitoring tools. Used native as well as custom monitoring tools to monitor servers and users activities.
• Applied high priority, security patches downloaded from Metalink.
• Monitored and troubleshooting database issues with OEM grid control.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Experienced with SRVCTL for monitoring and configuring RAC Environment.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performed the tablespace reorganization which involved renaming datafiles and all system files.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold)

Confidential

Oracle Database Administrator

Environment: Oracle10g, Oracle9i, Solaris 10, windows 2003 Server, AIX, Zlinux, HP-Unix OEM grid, RMAN, SQL, Oracle EE, RAC, PL-SQL, ASM, CRS, XML, TOAD, RMAN, FSFO, People Soft

Responsibilities:

• Installation and configuration of Oracle Database Software 10g on Solari, AIX with 2 nodes RAC with ASM in development, integration, Production Environment.
• Creation and configuration of Oracle database of various sizes 300 GB, 2TB in ITG and Production environments.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Implement DBMS SQLTUNE to fine tune the database.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Created 10g databases using DBCA on HP-UNIX, ZLinux platform.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs. Worked on DBMS SCEDULER.
• Developed PL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Involved in data loading using PL/SQL and SQL*Loadercalling UNIX scripts to download and manipulate files.
• Created standby database and worked with data guard to provide high availability.
• Installation and ConfigurationOracle Golden Gate Veridataand compare the data online.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Migrated databases from Oracle 10.2.0.2 on window 2003 to Oracle 10g on Linux development, integration, production environment using Import/Export.
• Auditing and security with Oracle databases.
• Created and Managed user, tablespaces, datafiles, archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Created PL/SQL scriptsto extract the data from the operational database into simple flat text files using UTL FILE package.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Backup and Recovery using RMAN.
• Worked on queuing for sending XML data to the calling java APIs.
• Written Stored Procedures and Triggers, functions, cursor for database maintenance and management using PL/SQL.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Support application team to solve any issues in Production Environment.
• Resolved daily production problem tickets in Peregrine ticket system.
• Provided 24x7 on-call production supports.
• UNIX Shell scripting for backup and monitoring of databases.