PROFESSIONAL SUMMARY:

• Oracle DBA ( Apps DBA and CORE DBA ) with 7 years of IT experience which includes Application Lifecycle Implementation, Installation, Management, Maintenance and Administration of Oracle Applications E - business Suite R12.x.x/11i and Oracle Database 11g, 10g, 9i/8i for major clients.
• Design and Implementing the Environments with Oracle Apps Fusion Middleware components including Oracle Weblogic , Oracle Database 11g , Oracle Webtire, Service bus, SOA , PO, Payables and Procurement , Workflow work, GL, more4Apps and Oracle Identity and Access management, OTM, SCM for security stack for next generation requirements.
• 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 with E Business 11.5.10.2 and R12.
• Well versed in installation of Oracle HRMS for R12.1.1 on Linux and AIX environments with Oracle Database 11g as database platform and patching of Oracle HRMS for global legislation.
• Managing oracle 12c, 11g RAC ( 6, 4, 2 node ) in production, Development and non-production environments.
• Experience includes using Golden Gate to support data replication in the Oracle database environment.
• Proven Experience in high Availability like RAC and implemented 11g RAC 2/4 Node with ASM/Non-ASM storage .
• Involved in Database Migration from RHEL 5.7 to Oracle Unbreakable Linux Network (ULN) OEL 5.7 using RMAN .
• Provided 24×7 support of production database environments and worked with OEM 11g Grid Control , Exadata , Discoverer , BI reporting and Hyperion.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Experienced in using 11g features Data Pump , Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring , and Recycle Bin .
• Good experience in applying security patches and migration of Oracle server from 10g to 11g , 9i to 10g & 8i to 9i .
• Configured Automatic storage management (ASM) with EMC storage for managing data in SAN .
• Extensive Experience with Recovery Manager (RMAN), Oracle Automatic Storage Management (ASM), Oracle Data Guard .
• Extensively worked on Oracle 12C , 11g RAC , 10g, 9i , Sql server 2012 , RAC, ASM, OEM , Grid Control , RMAN, Flash Database, Data Guard Standby Database, Database Tuning , Database Security , Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility, Maintaining Backup & RECOVERY in Sun/Linux UNIX systems administration, Shell programming .
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning .
• 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 .
• Experienced in Database performance tuning , SQL debugging/tuning , Application server tuning, DB sizing and capacity planning .
• 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.
• Worked with the following 11g/12c new features.
• Very strong in Oracle PL/SQL, Developer Tools like Forms and Reports and XML Publisher (BI Publisher) Reports.
• Very strong in Oracle Applications Financials and Manufacturing Supply Chain Modules Technical Architectures and Integration of each module.
• Very strong with Oracle Applications Workflow Architecture .
• Hands on Experience with APEX Tool .
• Hands on Experience with UPK/Tutor Installation and Development .
• Familiar with JAVA Programming .
• Experienced in developing scripts using PERL , Python and UNIX Shell Script .
• Expertise in Developing Mobile Apps using Oracle Mobile Apps Framework

TECHNICAL SKILLS:

Databases: Oracle RDBMS, Oracle 11g 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, Amazon AWS

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, Oracle Wallet

GUI Tools: Oracle Enterprise manager, TOAD, Data Loader, PLSQL Developer, SQL Developer

Storage/Server: NetApp, HP EVA, Oracle VM

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, UCSWORK EXPERIENCE:

Confidential, Atlanta

Sr. Database Admin

Responsibilities:

• Designed, document and implement new installation of NoSQL Cassandra 5 Node cluster infrastructure on Linux and CentOS on cloud services which includes Amazon AWS and other vendors.
• Working knowledge of AWS Cloud Watch console
• Implemented backup solutions and database health checks.
• Working on Cassandra schema, CQL query, JSON, XML Cassandra command line utility and Datastax Ops Center .
• Proactively analyzing performance to identify bottlenecks.
• Handling incidents, bugs and providing solutions with root cause analysis.
• Installed, configured the Oracle 11g , Oracle 11i apps tech stacks and R12 tech stacks
• Worked on creation and deletion of RAC resources like listener/instance 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 , prioritizing oracle processes and increasing SGA overall.
• Performed 11i to R12 Basic upgrade process involving Rapid Install & Autopatch
• Administer Cassandra 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 .
• Configured DR Data guard architecture for Oracle and Cassandra effective fast starts of the fail overs .
• Performed extensive support to the AD admin, auto patching and patch merge processes for all the modules in Oracle .
• Bi - directional replication and Uni - directional replication in DATASTAX Cassandra .
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager , monitor users , table spaces , memory structures, rollback segments , logs and alerts .
• Create multiple 11g databases on RHEL5 in development.
• Managed users and maintained security, populated databases of Oracle 10g & Oracle 11g on RHEL , Solaris and Windows .
• 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).
• Upgraded Oracle database using DBUA or Data Pump Export / Import .
• 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.
• Written Shell scripting which monitors the server's performance and logs output on periodic basis to database using Perl Scripting and Python .
• Experienced with methodologies for service delivery such as the IT Infrastructure Library (ITIL).
• Experience in supporting large-scale ETL /data management solutions.
• 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.
• Established, implemented, and maintained appropriate Informatica /ETL administration best practices.
• 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.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Experience in using flashback feature of oracle throughout the project.

Environment: Oracle 11gR2/10g, RHEL, RAC, RMAN, PL/SQL, SQL*Loader, Toad for Oracle, Golden Gate, OEM, SQL Loader, Cassandra DB, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential, MO

Sr. Oracle DBA

Responsibilities:

• Upgrade of Oracle Applications EBS from R12.1.3 to R12.2.2 and 11.5.10.2 to R12.1.3
• Upgraded Grid Infrastructure on Standalone server from 11.2.0.4 to 12.1.0.2
• Prepared Proof of Concept (PoC) for upgrading Oracle EBS from 11i to R12.2.2 .
• Installed and Configured Fusion Middleware , Discoverer , SOA , PO, GL Wand, BPM, OBIEE, APCC, SSO, OIM, Access Manager, Payables and Procurement , Workflow work and OID.
• Configured and maintained data loads in huge Data warehousing systems using the Informatica Power Center ETL tool . Supported data warehousing and databases which includes Complex SQL Quires .
• Upgraded JRE from 1.6 to 1.8 on instance level and deployed JRE 1.8 for Windows Clients in Oracle E-Business Suite Release 12
• Preparing document for Cross Platform migrations from Oracle 9i, 10g to 11g.
• Cloning of Oracle Applications 11i with RAC and ASM .
• Build from scratch an Oracle EBS 11i environment on 2 and 3 node RAC with 11g Grid & ASM and setup RAC services.
• To tune and configure Oracle 11g database for optimum performance .
• Develop, implement and maintain automation efficiencies using scripting languages ( PERL, Python ) in a UNIX environment.
• Upgraded and Migrated Databases from 11g to 12c and applying patches as needed.
• 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 .
• 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 .
• Working with Networked Attached Storage (NAS) & Tivoli Storage Management (TSM).
• Supported SQL server OLAP cubes along with installations and maintenance upgrades.
• 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
• 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.
• Experienced with Operations support within an ITIL Service Operations management framework, including use of Service Now or Remedy service management tools.
• Oracle Exadata Management was efficiently used in the project

Environment: s: Oracle 11g/10g/9i, Oracle Applications 11i, R12.1.3, R12.2.4 RAC, RMAN, Import/Export, Data Guard, Streams, ASM, Performance tuning, Patchset, Upgrade, Migration, SQL, PL/SQL, SQL*PLUS, Korn Shell, Perl Scripting, Sun Solaris and Linux.

Confidential, TN

Senior Oracle DBA

Responsibilities:

• Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS e nvironment.
• Installed, configured the Oracle 9i and 10g , Oracle 11i apps tech stacks and R12 tech stacks
• Planned and prepared the R12 upgrade from 11.5.7 application and database upgrades.
• Performed 11.5.7 to R12.0.6 upgrade process, replaced 11i Tech stack ( 9iAS & 806 ) to Fusion Middleware 10g application server.
• Experienced in designing and building robust and fault-tolerant Oracle APP Fusion Middleware components in ESB and BPEL using the Fault Management Framework and catch/compensate activities.
• Worked on creation and deletion of RAC resources like listener/instance 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 , prioritizing oracle processes and increasing SGA overall.
• Performed 11i to R12 Basic upgrade process involving Rapid Install & Autopatch
• Installed and configured Oracle SOA Suite on 10G Oracle Application server's OC4J for BPEL PM , ESB , OWSM .
• Install/Support/Maintain on SQL Server databases with NoSQL/Mongo 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.
• Configured SSL , SSO and DR Data guard architecture for effective fast starts of the fail overs .
• Bi - directional replication and Uni - directional replication in Golden gate .
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager , monitor users , table spaces , memory structures, rollback segments , logs and alerts .
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC 2 nodes on IBM AIX and debugging Golden Gate issues such as extract and replicate rebuild.
• 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.
• Rebuilding of Indexes for better performance of Oracle database.
• Designed and developed ( MS SQL SERVER ) SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Implement capacity planning methodologies for SQL Server environments
• Setting up configuration parameter of MySQL Database (my.inf).
• Experienced and worked with Unix scripting languages (e.g., Shell, Python, Perl)

Environment: Oracle 11gR2/10g, Mongo, 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.
• 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.
• 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
• 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.
• Troubleshoot /Configuration of tnsnames , listeners setup.
• Create new database users as required. Plans and implements backup and recovery of the Oracle database.
• Performance monitoring, tuning and optimization of current SQL Server environments.
• Implement capacity planning methodologies for SQL Server environments.
• 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.
• Control access to and all other security aspects of enterprise databases.

Confidential

Oracle Applications DBA

Responsibilities:

• I was responsible for the support and maintenance of the company's financial and student databases.
• Involved in the upgrade of the 11.5.5 applications instance to 11.5.8 and the database from 8i to 9.2.0.4 onto RAC nodes.
• Administered and maintained production, development, QA, test and patch instances of the Oracle production databases on a round-the-clock basis.
• Installed and managed the daily business intelligence DBI 6.0.
• Reviewed, explored and applied the Oracle applications patches when the business requirements demanded.
• Oracle 9i Spatial and Locator: for Geographic data processing
• Worked on OLTP and OLAP database systems.
• Developed and implemented the Disaster Recovery (DR) strategy for Oracle E-Business Suites .
• Developed and implemented backup and recovery strategies.
• Checked alert logs and troubleshoot and resolved the database issues, adding data files, resizing data files and analyzing tables, recovering and renamed the databases to create and sink the development data with production data in RAC environments .
• Installed Oracle RAC 9i on Linux Platforms.
• Interacted with the Oracle customer support and logged iTAR when required.
• Patched security vulnerabilities when released by Oracle support.

Environment: Red Hat Linux, HP-Unix, Oracle Applications 11.5.8/11.5.9, (Financials & CRM Modules), Oracle 9i, Oracle Forms 6i, OAM, License Manager, STATSPACK, Rapid wiz, Rapid Clone, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad 7.3, SQLplus, OEM, EMC Storage)

Confidential

DBA

Responsibilities:

• Installed, created and maintained new oracle 9i and 8i instances .
• Created the database, tables, table spaces , data objects, setting privileges, indexes, user logins, and passwords (security).
• Coordinated with Infrastructure and storage teams to resolve performance issues and to improve system response and run times.
• Connectivity with different client programs using ODBC.
• Writing scripts to move data files, for monitoring system activities (I/O CPU), memory usage Confidential process level, file growth, user login, and user's setup.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle file structures.
• Involvement in all phases of the project life cycle.
• Developed and modified PL/SQL code to make new enhancements or resolve problems as per customer requirements.
• Involved in optimizing SQL statements using indexes and hints.
• Setting up configuration parameter of MySQL Database (my.inf).
• Frequent analysis of objects or schemas to improve the speed of the database.
• Analyze SQL statements using Explain plan.

Environment: Oracle 10g, 9i RHEL, UNIX Shell Scripts, TOAD, PL/SQL Developer, SQL Server 2000