SUMMARY:

• Around 8 years of experience as Oracle DBA, providing 24/7 support for both Production and Development databases on Various Platforms like Red hat Linux, AIX, HP - UX and Windows.
• Hands on experience in Grid control, Streams, ODI, GoldenGate Replication, ASM, Confidential .
• Extensively worked on Installations, Database Creation, configuration, maintaining, Upgradation, Migration, applying patches, Backup/Recovery & Performance Tuning of Oracle Databases.
• Exceptional Database performance monitoring and tuning which includes Instance tuning, Query (SQL) Tuning using TKPROF, AWR, ADDM and ASH, extensive troubleshooting, firefighting, script development, documentation.
• Hands on Experience in Oracle EXADATA .
• Auditing past transactions with Oracle Log Miner, diagnosing the efficiency of Disk Striping and Load Balancing, Data E Confidential yption Management, diagnosing Oracle Replication Timings and Replication Management.
• Good experience in setting Weblogic clusters, configuring datasources and application deployment.
• Implemented Recovery Manager (RMAN) for easier and well-managed recovery procedures.
• Experienced in taking the logical backups using EXP/EXPDP utility and restoring using IMP/IMPDP utility at various levels full db export, user level export, table level export and tablespace level export.
• Experience administering and configuring NoSQL Databases like Cassandra, MongoDB etc
• Extensive experience in Dataguard configuration, implementing and maintaining standby.
• Expertise in developing reports in OBIEE analytics and BI Publisher
• Planning and scheduling backup, checking logs for errors, ensuring maximum uptime of 24x7 databases, database recovery if needed.
• Performed Oracle HTTP server installation and Configured and integrated with oracle fusion components, oracle application server and Weblogic server.
• Strong experience in Installation and configuration of OBIEE, Business Objects.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK.
• Worked with Automatic Storage Management (ASM) Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Experience in Database Administration in SQL Server 2008, IDMS and Sybase SQL.
• Familiarity with automated system builds and configuration management tools including HP Server Automation, HP Operations Orchestration
• Design ORACLE ASM Disk and Disk group layout in collaboration with system administrators.
• Hands on Experience in Administration of Amazon Web Services (AWS).
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.
• Operational experience with MySQL, postgres, and MongoDB, including clustering.
• Managing large databases (VLDB) which includes OLTP as well as Data Warehouse databases
• Experience implementing Oracle High Availability and Disaster Rcovery solutions.
• Identified Top SQL’s and tuned them using OEM (Diagnostic and Tuning Pack) and Spotlight.

TECHNICAL SKILLS:

Databases: Oracle 12c,11g,10g,9i, Oracle 11g(RAC & Data Guard), SQL Server 2008, MongoDB, Cassandra, IDMS, Sybase

OPERATING SYSTEMS: Sun Solaris 5.8, 9, 10, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP, IBM AIX.

Languages: SQL, PL/SQL, Shell Scripting, MySQL, HTML, .NET

Oracle Utilities: RMAN, OEM, SQL*Loader, Export/Import, Data pump, ASM, AWR, ADDM, TKPROF, STATSPACK, Weblogic, EMC Documentum.

Environment: UNIX (Sun Solaris, HP-UX AIX) WINDOWS 98/2000/2003/ XPLinux (Red hat enterprise).

Replication: Oracle Streams, GoldenGate, SharePlex.

Tools: SQL*Plus, SQL Developer, HP Operations Orchestration, Crystal Reports, TOAD, OBIEE, SVN, AWS, Mobaxtrem, Cognos, ODI, VMWare.

Ticketing Tools: BMC Tool(Remedy), JIRA.

BI Tool: Qlikview, Advanced ETL Enterprise.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SENIOR ORACLE DBA

RESPONSIBILITIES:

• Installing Oracle software and creating the databases on UNIX and Windows environment.
• Provide production support for the 24x7 Oracle database availability.
• Install and implement 11g RAC configuration spanning across 4 nodes.
• Configure and administration of Data guard, ASM and Golden Gate.
• Installing and troubleshooting Agent on servers and Configuring & Monitoring database from 11g grid control.
• Performing logical backups using the conventional exports & imports and data pump jobs at various levels like schema level, database level and tablespace level.
• Perform daily maintenance tasks like space management, rectifying locking problems and managing quotas.
• OEM 10g Grid Installation and Oracle Application Server installation, maintenance, performance tuning (JVM Sizing, HTTP tuning, Report tuning etc.) and WebLogic Server Administration.
• Experience in Migrating databases from file systems to ASM, Data from Non-production to production databases.
• Generating stats pack/AWR reports on basis to identify the database bottlenecks at peak load.
• Oracle DB Health checks (Table space/DB statistics/Archives monitoring).
• Clone databases from production to create test, development and UAT environments.
• Upgraded all Production and Non Production systems to Weblogic 8.1 SP3 from Weblogic 8.1 SP2 successfully and installed DST patches. Applied patches to the Weblogic servers.
• Performing user manager backups like hot backups for daily backups and Cold backups for weekly and monthly.
• Hands on experience in cross platform migration of single instance databases to RAC using RMAN
• Troubleshoot frequent ORA errors, database alerts, space management notifications, instance availability, OEM agent failure, data loads issues, backup failures and job failures.
• Experience in 3 node RAC with ASM implementation with EBS.
• Maintenance and monitoring of oracle 10g, 11gand 12c database instances hosted on Linux and Sun platform
• Identified Top SQL’s and tuned them using OEM (Diagnostic and Tuning Pack) and Spotlight.
• Wrote shell scripts for backups and provided alert notification through mail and text messages for database unavailability.
• Worked with more complex database with analyzing, designing, creating and implementing.
• Experience in Configuring Golden Gate-Oracle Data Integrator.
• Experience in installing, configuring, administering and troubleshooting Golden Gate replication.
• Effectively use Oracle Golden Gate for configuring new data replication methodologies, modifying the existing replication as per the project requirements and for data capturing.
• Monitoring the alert log for the database performance and resolving the performance issues.
• Monitored Weblogic server resources using Wily 7.x Introscope.
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Involved in performance tuning of the OBIEE reports at query level and report level.
• Oracle APPS Rel 11.5.9 production support, applications & database upgrading, performance tuning & optimization, DR and Business continuity design/implementation.
• Creating Service requests with Oracle support, updating and get resolve them.
• Upgrade the databases from 11g to 12c and apply patch sets using OEM.
• Network trouble shooting by checking the listener status, starting/stopping listeners.
• Database cloning using snapshot backups and creating Physical Standby databases
• RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery.
• Generating AWR, ADDM reports and analyzing for the database performance issues.
• Tuning the Production & Development databases by altering system and session parameters for optimization of performance.
• Enabling Change Data Capture( Confidential ) on one or more Database Tables.
• Well versed with ITIL process using Incident management, Change management and Problem management.
• Upgrade the databases from 11g to 12c and apply patch sets using OEM.
• Extensive knowledge on Oracle Data Integrator versions 11G and 12C.

ENVIRONMENT: Linux, Exadata, Oracle 11gR2, Oracle 12cRAC, Golden Gate, Weblogic, OEM, MongoDB, Data Guard, RMAN, ASM, AWR, ADDM, ODI, Toad.

Confidential, NY

SR. ORACLE DBA

RESPONSIBILITIES:

• Installed and configured Oracle 10g and 11g Databases for Production, Development and Testing.
• Upgraded the database from lower versions to 12c.
• Designed, planned and implemented Oracle backup/recovery solution using RMAN.
• Expertise in handling various security aspects of the database including VPD (virtual private Database).
• Maintained multiple instance databases for cutting edge web based e-commerce applications.
• Experience in installing, configuring, administering ASM.
• High speed data transfer between one databases to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Managing large Oracle databases (VLDB) which includes OLTP as well as Data Warehouse databases.
• Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM.
• Worked on Singe Instance RAC with ASM and migrated databases across.
• Created Backup plans for production, Test and Development Databases. Configured and managed RMAN.
• Effectively use Oracle GoldenGate for configuring new data replication methodologies, modifying the existing replication as per the project requirements and for data capturing.
• Experience in pushing data from MongoDB to MySQL Database.
• Improved query performance using better joins appropriately.
• Lead the performance tuning effort for the existing and future Application modules.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• Good Understanding and basic management skills of other RDBMS products like MySQL, SQL Server and DB2 on UNIX.
• Upgrading the existing Golden Gate setup from 10, 11 versions to Golden Gate 12.1
• Worked with development team in creating DBA best practice methodologies, creating uniform database development standards, guidelines, procedures, and processes.
• Monitored all database objects, including tables, clusters, indexes, views, sequences packages and procedures.
• Experience with GoldenGate replication in heterogeneous environment (EXADATA).
• Wrote SQL queries and PL/SQL procedures, functions, packages and triggers
• Configure and monitor numerous MongoDB instances and replica sets
• Controlled database changes and ensuring synchronization amongst different environments.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Maintained database security and adhere to security policies designed by the corporate IT governance.
• Replicated tables to different database locations by Snapshots on master tables at master site.
• Technical troubleshooting and consultation to database development teams.

ENVIRONMENT: Linux, IBM AIX, HP-UX 11,Solaris, Oracle 11gR2, RAC, RMAN, MongoDB, Streams, Data Guard, ASM, Golden Gate, Toad, Forms 5.0, Reports 3.0.

Confidential, MA

Oracle DBA

Responsibilities:

• Provided production support for the 24x7Oracle database availability.
• Worked on Implementation of Oracle10gRAC (Real Application Cluster) on Linux.
• Oracle RAC Planning & Implementation including Servers, Storage, Network and Management tiers.
• Setup of High Availability of the database using RAC, Standby, Data guard.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• Maintenance and Support for RAC Infrastructure components and Database.
• Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.4.
• Configured Physical Standby database (Data Guard) using RMAN backup.
• Used Oracle 10g Grid control for Monitoring and Managing at enterprise level.
• Setup schemas using export and import utilities. Create users, roles and grant privileges based on the user requirements.
• Hands on Experience on Forms and Reports 6i.
• Worked extensively on Performance Tuning using AWR and ADDM Reports.
• Worked on database migration (10g-11i) Database Patching and Cloning.
• Manage ASM disk groups via ASMCMD and database control.
• Setting up of regular backup (Hot, Cold), recovery and regular testing of recovery in test environment.
• Created public synonyms on the database links for easy reuse.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Managed and resolved design issues during development.
• Customization and automation of regular DBA activities and operating system specific tasks using shell scripts.
• Setting up Oracle Golden Gate for real time replication, monitor and troubleshoot Golden Gate sync issues.
• Generated regular Stats-Pack reports for the performance tuning of the databases.
• Performed Replication of the Production database for setting up instances for the QA and Testing teams.
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.
• Expertise in Unix Korn Shell scripting, and good knowledge in Perl scripting.
• Experience in Oracle Streams.
• Worked with Golden Gate Software for providing a innovative product for replication purpose.
• Worked with Oracle Cluster ware software for the node connections.
• Transferred data using export/import and data pump utility.
• Partitioned very large database tables and indexes and placed them in separate table spaces.
• Working as a member of production DBA team in perfect coordination with Managers and team members.

Environment: Linux, Solaris, Oracle 10g, 11g, Data guard, RAC, Golden Gate, SQL*Loader, Streams.

Confidential

ORACLE DBA

RESPONSIBILITIES:

• Analyzed business requirements to design Entity relational Diagrams (ERD) and prepared
• HLD and LLD documents including impact analysis, requirements traceability matrix.
• Wrote DDL scripts for generating tables, views and indexes.
• Developed PL/SQL procedures, functions, packages and triggers.
• Prepared Unit Test Specifications and performed unit testing.
• Maintenance of Scheduler and adding new jobs.
• Wrote complex SQL queries to generate views for the purpose of the administrative department.
• Monitored database performance using Explain plan and SQL trace.
• Managing tables and storage structures within a table.
• Created indexes for faster retrieval of data and better performance tuning.
• Generated crystal reports for billing information.
• Converted Pro*C programs to PL/SQL procedures. Built packages for data storage and retrieval.
• Developed and modified reports using Forms and Reports.
• Experience developing SQL and PL/SQL procedures
• Maintained the data integrity and security using integrity constraints and database triggers.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Worked on logical and physical data modeling and created Materialized views.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Participated in performance tuning, unit test case preparation and execution.
• Utilized tools like TOAD during development of the application
• Performed Unit Testing and data validation.

ENVIRONMENT: Oracle 9i, Red Hat Enterprise Linux 3, Crystal reports, SQL Plus, PL/SQL.