SUMMARY

• Oracle DBA with 8 plus years of IT experience which includes Application Lifecycle Implementation, Installation, Management, Maintenance and Administration of OracleApplications E - business Suite and Oracle Database11g, 10g, 9i for major clients.
• Experienced in Installation, Configuring, and Maintenance Oracle Enterprise Manager (OEM) Grid Control agents for enterprise database monitoring.
• Involved in Oracle EBS upgrade from R12.1.3 to R12.2.2 and 11i to R12.
• Responsible for installation and configuration of Oracle Demantra, High Availability, PCP, Shared APPL TOP and Load Balancer.
• Well versed in installation ofOracleHRMS for R12.1.1 on Linux and AIX environments withOracle Database 11g as database platform and patching ofOracleHRMS for global legislation.
• Performed database upgrades from Oracle 8.x/9.x/10.x to 11g/12c.
• Managing oracle 12c, 11g RAC (6, 4, 2 node) in production, Development and non-production environments.
• Proven Experience in High Availability like RAC and implemented 11g RAC 2/4 Node with ASM/Non-ASM storage.
• Planned and executed Database Recovery and High Availability solutions using OEL 11g Standby Database using Oracle Data Guard, 11g RAC on Exadata.
• In-depth Core DBA knowledge of Installation, configuration and maintenance of Oracle RAC, ASM 11g, Data Guard (FSFO), DGMGRL and Oracle GoldenGate 11.2.1
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Install/Support/Maintain on SQL Server databases with NoSQL/Mongo database.
• Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database Oracle 11g.
• Strong experience in working with Oracle memory tuning (ASMM, AMM).
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Experience in RMAN managed backup / standby server recovery / Cloning (RAC to Non-RAC), Rapid Clone Utility and Hot/Cold backup - recovery.
• Well versed with SQL and PL/SQL, Strong Unix shell scripting skills for automating theDBAtasks.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Working with SUN, DELL, HP hardware and their storage system with RAID management.
• Well versed in creating and managing of Tables, table spaces, Segments, Extents, and Data Blocks.
• Well experienced in managing data files, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Experienced in Database performance tuning, SQL debugging/tuning, Application server tuning, DB sizing and capacity planning.
• Secured the applications by implementing DMZ, SSL, and SSO.
• Expertise on Installing, maintaining, cloning, upgrading and migration ofFUSION MIDDLE WARE (FMW) like Web logic Server, SOA, OTM & OBIEE.
• Hands on experience in complete recovery, incomplete recovery (PITR), Flashback Recovery, Disaster Recovery, recovering data files, table spaces, and control files.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and Interim patches, Patch sets as per the Oracle recommendations.
• Proved Experience in Maintaining Documentation and Capacity Planning.

TECHNICAL SKILLS

Databases: OracleRDBMS, Oracle11g R2 RAC, 10gR2RAC, 9i, Mongo

Operating Systems: HP-UX, Sun Solaris, RHEL 5.x, RHEL 6,x, Red Hat9,AIX, Linux and Windows, IBM DB2, Informix on IBM

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting

Tools: Rapid Clone, Rapid Install, DBUA, Autoconfig, Adsplice, Adpatch, Adadmin, Adcontroller, Admergepatch, Adutconf, Adrelink, Adident RMAN, OEM, OAM, Toad, Exp/Imp, Smitty, Putty, ADI, Tkprof, ASH, RAC,RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan 4.0, Migration, ASM, Cloning, Replication.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatica 5.1, Share Plex, SSIS, DTS

Data Modeling: Erwin, DB Artisan, Rational Rose, SOX

Other: EMC, Net App, VERITAS, Golden Gate,OracleWallet

GUI Tools: OracleEnterprise manager, TOAD, Data Loader, PLSQL Developer, SQL Developer

Storage/Server: NetApp, HP EVA,OracleVM

Hardware: IBM System x3650 M3 2 x 6C Xeon 1GHz, HP UX 4 x 2C PA-RISC 1GHz, HP UX 4 x 2C iTanium 1GHz, Sun Superdomes with 40 CPUs each, Dell Power Edge 6600, 2200, Sun Ultra E450, E250, Sun Fire 880, IBM RS 6000, SunFire 15K 40 CPUs; EMC SAN storage on DMX3 (1 Petabyte); DMX3000 and 2000 Series, UCS

PROFESSIONAL EXPERIENCE

Confidential, MO

Sr. Oracle DBA

Responsibilities:

• Installed and configured 4 node RAC environments on Oracle 11gR2 with ASM/NON-ASM File system on Linux environments. Experienced with SRVCTL, CRSCTL, OCR and Voting Disk.
• Installation, configuring and maintainingOracle11g databases on ASM.
• Implemented Physical standby for Disaster Recovery using Data Guard on Oracle 11g. And perform Switchover, Failover with and with-out Data Guard Broker (DGMGRL)
• Performed cross platform migrations from Oracle 9i, 10g to 11g.
• Cloning ofOracleApplications 11i with RAC and ASM.
• Build from scratch anOracleEBS 11i environment on 2 and 3 node RAC with 11g Grid & ASM and setup RAC services.
• To tune and configureOracle11g database for optimum performance.
• Installed and configured OEM Grid Control agents 11g and 12c on Solaris, Linux server.
• Installed 11gR1/2 and 10g Oracle RDBMS and provision databases on Linux & Solaris.
• Upgraded and Migrated Databases from 10g to 11g and applying patches as needed.
• Performance monitoring and tuning up of the Database using STATSPACK, AWR, ADDM.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Performed LOGICAL BACKUPS for Database migration using Data Pump, Export/Import and Transportable Table spaces.
• Install/Support NoSQL/Mongo databases.
• Worked closely with developers helping them identify and fix issues. (Eg: User login issues, concurrent managers, OID authentication, and vertex connectivity).
• Within Cloud Services the Customer Management team is focused on operations and account management capabilities for the Cloud Services Customers.
• Worked on SAN / RAID configuration.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL Trace, Tk prof, Analyze, ADDM and Explain Plan Methods
• Installation, configuration, upgrade and maintenance of Oracle databases of Oracle 10g & 11g on RHEL.
• Implemented zero downtime migration and upgrade of 10g to 11gR1 database using Oracle Streams.
• Involved in database Export/Import and performing backups using RMAN.
• Working with Networked Attached Storage (NAS) & Tivoli Storage Management (TSM).
• Involved in the Analyzing and monitoring the system performance and tune accordingly.
• Worked actively in planning for storage space requirements and placing them for optimum I/O performance.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using Golden gate.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Supported SQL server OLAP cubes along with installations and maintenance upgrades.
• Worked intensively on database migrations.
• Maintained 110 Databases, Implemented 30 Production database, 40 Development database, 40 Test database.
• Experience in Managing Process using Change control and Cab process.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Created Users, Roles, Privileges, Profiles and managing security.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*Net connectivity.
• Experiences with OID servers.
• Worked as a SME for Oracle RAC/Exadata/OEM
• Maintenance of the Exadata storage servers in the Database machine including upgrades and patching.
• Oracle Exadata Management was efficiently used in the project.
• 24X7 production support and on call rotation.

Environment: s: Oracle 11g/10g/9i, Mongo, TSQL, SQL, PL/SQL, SQL*PLUS, Korn Shell, Perl Scripting, Sun Solaris and Linux.

Confidential, OH

Senior Oracle DBA

Responsibilities:

• Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.
• Worked on creation and deletion of RAC resources like listener/instance, services, server pool and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizingoracleprocesses and increasing SGA overall.
• Performed 11i to R12 Basic upgrade process involving Rapid Install & Autopatch
• Administer Mongo databases, i.e. install, check alert log, health check of database.
• Coordinate and suggest PM, SA and LOB DBA to allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Implemented Golden Gate Technology onOracle11g/10g.
• Configuration and implementation of Golden Gate based replications through GGSCI.
• Configured SSL, SSO and DR Data guard architecture for effective FSFO.
• Performed extensive support to the AD admin, auto patching and patch merge processes for all the modules inOracleapps.
• Maintained Oracle Apps environments for SOX compliance all along.
• Bi-directional replication and Uni-directional replication in Golden gate.
• Perform Daily Monitoring of Oracle instances usingOracleEnterprise Manager (OEM), monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Create multiple 11g databases on RHEL5 in development.
• Upgraded and configured theOracleDiscover 10G from Discoverer 4i with the EBS applications.
• Supported and admin of printers, accounts, OAM, site and application level profiles.
• Managed users and maintained security, populated databases of Oracle 10g & Oracle 11g on RHEL, Solaris and Windows 2003.
• Used scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache server configuration.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Involved in EDW support for OLTP and OLAP Data warehouse application.
• Rebuilding of Indexes for better performance ofOracledatabase.
• Upgraded Oracle database using DBUA or Data Pump Export/Import.
• Implemented Migration Strategies based on cost, time, and platforms requirements.
• Restore and point-in-time Recovery of database using RMAN techniques.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Experience in using flashback feature oforaclethroughout the project.
• OracleExadata Management was efficiently used in the project.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup that are used for Data Scrubbing before loading the data into the Data warehouse.
• Attend meetings, communicate on technical issues, take input from Product Development, attend seminars, and work directly withOraclesupport on technical database issues

Environment: Oracle11gR2/10g, RHEL, RAC, RMAN, PL/SQL, Stored procedures, SQL*Loader, Toad for Oracle, Golden Gate, OEM, SQL Loader, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential, VA

Oracle DBA

Responsibilities:

• Part of core Development DBA team maintaining Development databases.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Export and Import of User, Tables and Data files using exp/imp and Data Pump.
• Tuning of the database using TKPROF utility, tuned the Shared pool and buffer cache to have better performance. Point in time recovery for recovering the master data when the tables are dropped by user errors.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL Trace, Tk prof, Analyze, ADDM and Explain Plan methods.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log Miner, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Supported SAN Migration and ASM migration, allotted new candidate disks.
• Installation and configuration of Oracle databases on LINUX platforms.
• Administering the physical aspects of the databases such as creation of Table spaces, Users, Rollback segments, creating data files, helping users in creating database objects.
• Configured and maintained data loads in huge Data warehousing systems using the Informatica Power Center ETL tool. Supported data warehousing and databases.
• Advanced troubleshooting using trace files, alert log, and external links (Meta link or Oracle Support).
• Analyzing performance issues and providing recommendation based on testing results using Oracle's tools like AWR, ASH& Data Recovery advisor.
• Configured Standby database for production database.
• Oracle Database Performance Tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.
• Involved in EDW support for OLTP and OLAP Data warehouse application
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Configured Standby database for production database.
• Participate in establishing and involving database standards within the company.
• Preparing cluster, configuring and Installation of cluster ware and Oracle RAC on RHEL.
• Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack.
• Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.
• Monitoring Database Activities, Checking for Table space Availability, Checking the Alert Log File for errors.
• Troubleshoot /Configuration of tnsnames, listeners setup.
• Responsible for online and offline backups and recoveries of the oracle database.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Create new database users as required. Plans and implements backup and recovery of the Oracle database.

Confidential, NJ

Oracle Applications DBA

Responsibilities:

• Served as Oracle Application DBA. Supporting environment: Oracle 9i & Oracle10g under SunOS & HP-Ux, total 30 instances, with 6 instances running under RAC. Total database size 9.2 Terabytes ( Largest single database 2.6 Terabyte)
• Installation and configuration setup of Oracle applications 11i, tech stacks through Rapid install and ADI. Configuration of Multiple JServ and JVM for Load balancing and enhanced performance.
• Analysis, design and upgrade to OATM - Oracle Applications Tablespace Model for 11i instance.
• Oracle applications and database instance cloning multimode to single and vice-versa. Merging and configuration of Shared APPL TOP and later entire application tier.
• Developed extensive list of Performance Tuning recommendations, including histograms, bitmap indexes, Parallel Query Option (PQO), Cost-based Optimization (CBO) enhancements, space management improvements, and assorted INIT.ORA changes.
• Provided staff augmentation services as an Oracle DBA. Handled prime responsibilities for all DBA activities - Logical/ physical design of databases, defining of roles, profiles etc., backups, performance issues, connectivity to database, creation of database links, upgrade strategies, capacity planning & tuning of ORACLE parameters.
• Installation and configuration of Oracle 10g RAC on SunOS platform with ASM and 2 node cluster.
• Reducing contention for rollback segments, multi-threaded server and dispatcher processes.
• Implementation and monitoring of Archive log.
• Mentored local Oracle DBA in the intricacies of being an Oracle Applications DBA.
• Development environment includes Solaris UNIX (2.5,2.6 & 8), Windows NT/98,2000, Oracle9i, PL/SQL, SQLPLUS, SQL*Loader, Legato Storage Manager, RMAN, Export/Import
• Modifying the database structures as and when required due to the growth in the volume.
• Monitoring users and attending the code review to optimize the Queries.
• Backup the Database and maintaining the Databases

Environment: Oracle 10g/9i, Oracle Applications 11i, RMAN, Developer6I, SunOS, OEL.

Confidential, OH

DBA

Responsibilities:

• Provide support to development & testing teams
• Installation & Configuration of database 9i and 10g.
• Cloning databases.
• Applying Patches on the recommendation oforacleand tech teams
• Tuning the database to optimize the performance.
• Planning, Scheduling & Implementation of Backup strategies
• Maintenance of alert logs, trace files and users.
• Monitoring Disk space, Table spaces
• Creating and maintaining DB Objects like Views, Tables, Constraints, Indexes, Sequence, Synonyms, Database links, Stored Procedures, Roles/Privileges and creating kornshell.
• Developing SQL scripts to automate regular monitoring tasks
• Developing UNIX scripts to automate regular monitoring tasks
• Checking the status of imp services to make sure databases are available
• Monitoring OS resources and working with N&S teams
• Filing and Supporting TARs withOracleCorp
• User Support, User Training and Trouble Shooting.

Environment: Oracle9i, 10g Forms 4.5 Reports 4.5, PL/SQL, Crystal Reports, RHEL,Sun Solaris 2.6, and Sun Ultra E-250