SUMMARY OF EXPERIENCE:

• Over 8 years of IT experience as Oracle DBA, closely working with Business stakeholders and provide consultative and technical support services for all major database development and system integration tasks including test strategy, version upgrade, migration , performance tuning , space management , implementation of backup and recovery strategy 
• Gathering and analyzing customer’s technical requirements, development, management, maintenance and production support projects of Oracle  Database on platforms like UNIX/LINUX ( Sun Solaris, HP - UX, AIX, Red Hat Linux ) and Windows .
• Good experience in administration, installation, configuration and upgrades of Oracle 12C, 11gR2, 10g and 9i databases including applying patches under Linux, HP-Unix, IBM-AIX and Windows platforms.
• In-depth knowledge of Advanced Replication (GoldenGate, Oracle   Stream s ) , High Availability (RAC) and Disaster Recovery (Data Guard) solutions for business critical applications.
• Expert knowledge on Oracle   tools like oracle   migration utility , OEM Grid control ( 11g and 12c ), AWR, Oracle Advisors .
• Expertise in using oracle   Export/import , Data Pump utility to migrate data across schemas.
• Diagnosed and tuned the latest Integrated Extract, available since release 11.2.0.4 of the Oracle RDBMS, and Integrated Replicat, available since release 12c of the Oracle RDBMS.
• System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.
• Extensively managed users, privileges, profiles, schemas using Oracle   Enterprise Manager (OEM).
• Proficient with Tuning , SGA , Buffer Cache , Rollback Segments , and Redo Mechanisms .
• Experience in SQL Tuning, SQL Optimization, cost based optimization and Hints.
• Strong project implementation using the Oracle Spatial technology.
• Monitored and Detected Alert Log Files , Redo Log status , Listener Log , trace files for the database. 
• Experience in Configuring Automatic Storage Management (ASM).
• Experience in Real Application Cluster environment (RAC) on ASM .
• Management of Objects, Schemas, Partitioning the tables and Indexes and administration of RAC and DATA GUARD databases in Oracle   11g.
• 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.
• Daily health checkup of databases.
• Experience with Oracle   in Healthcare , Financial and Banking industries in both Business Intelligence/Data ware house Systems and OLTP Systems.
• 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 . 
• Proficient in raising   Oracle Service Request with Oracle   Support and using Metalink to resolve the bottlenecks in the database environments.
• Participate in planning strategies for future database needs for business needs in perspective of capacity planning , performance and available technology. 
• Migrated databases and upgraded the versions from SQL   Server 2005 to 2008
• Provides ongoing support for My SQL SERVER database servers for systems, which include creation, configuration, maintenance and upgrade. 
• Strong technical and interpersonal skills combined with great commitment towards meeting deadlines.
• Experience working in both team and individual environments. Always eager to learn new technologies and implement them in challenging environment.

TECHNICAL SKILLS

Operating Systems: UNIX, Solaris 9/10, Linux RHEL 4/5/6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows XP/7/8

DBMS & RDBMS: Oracle 9i, 10g, 11g, 12c, MySQL, Sql server

& Monitoring Products: Oracle 10g, 11g RAC, ASM, Exadata, Streams, Data Guard, 10g, 11g, 12c Grid Control (OEM), GoldenGate, RMAN, Cloning, Patching, ADDM, ASSM, ASMM, AMM, Veridata, Tkprof, AWR, Statspack, AWS

Tools/Utilities: OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD,   Data Pump, Query builder, Net Backup, VB, Crystal Report, MS Access, Oracle Streams, Putty, SQL*Plus, Telnet, FTP, Metalink

Languages: SQL, PL/SQL, UNIX Shell Scripting, korn

Terminal Emulation: Putty, Telnet, FTP, TOAD

ETL Tools: Informatica, ODI, Cognos, Pentaho

BI Tools: Tableau, GIS, MS Excel

PROFESSIONAL EXPERIENCE:

Sr Oracle DBA 

• Upgraded 11g to 12c and Installed Oracle software, installed Oracle RAC on 12c clusters in 4-node configurations, created databases. Created database services for different applications and added nodes to the cluster. Applied rolling patches to fix known bugs as well as PSU and Migrated Grid and database software to higher version.
• Pre-Patch analysis, applying patching in test/development instance
• Extensive experience in Patching , applying minimum baseline patches for 12c
• Installed OEM 13c agents and checked database performance and made necessary changes to optimize performance. Install   Oracle Agent for Grid Control Monitoring. Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM  
• Checked health of cell servers, worked with Oracle field engineer to replace failed disks on cell servers.
• 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.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Installed GoldenGate software 11g/12c. Configured extract, data pump and replicat processes for single master and multi-master architectures. Performed initial data load into the target database. Added tables to the replication. Included/excluded DDL statements to be propagated to the target to maintain necessary level of replication. Maintained replication, troubleshoot and fixed problems with abended processes. Configured GoldenGate as CRS resource to provide uninterrupted service in case of RAC instance/ node failure. 
• Monitoring and Performance tuning of GoldenGate sessions at OS level, Database level and GGSCI level and investigate replication failures using ggserr.log, report files and Logdump utility and developed scripts for GoldenGate failover.
• Used GGSCI commands for gathering process evidence. Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC and file maintenance by using tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter and the Logdump utility.
• Diagnosed and tuned the latest Integrated Extract, available since release 11.2.0.4 of the Oracle RDBMS, and Integrated Replicat, available since release 12c of the Oracle RDBMS.
• Configured Data Guard configurations using physical Standby architecture utilizing Data Guard broker with fast-start failover and Observer. Tested different failover scenarios. Troubleshot and resolved issues.
• Worked on Snapshot standby and coordinated Application testing. Involved in converting physical to snapshot standby, and back to physical standby as per business requirement and also Active Data Guard
• Performed Zero Downtime Database Data Center Migration using GoldenGate and Data Guard .
• Configured RMAN backups using Net backup and DDBoost. Restored and recovered databases to resume service as well as to create test environments for dev/app teams.
• Administration of Backup and Recovery using RMAN . Management of backup pieces and backup sets using RMAN .
• Created Oracle   Tables, Table Partitions, Views, and Materialized Views and automated Statspack/AWR reports.
• Implements, administers, manages, monitors, and tunes the assigned application databases in development, pre-production and production environments.
• Worked as a part of AWS team. Launching and configuring of Amazon EC2(AWS) cloud servers using AWI's (Linux/Ubuntu) and configuring the servers for specified applications.
• Administered in Prod, Qual, Test and Development regions. Produced and analyzed performance reports
• Designs and implements performance tuning improvements of oracle   databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor and advises developers on tuning options. Ensures that data integrity and data security is maintained. Demonstrates advanced troubleshooting and analytical skills through problem resolution.

Environment: Sun Solaris, Linux, Oracle 11g and 12c, RAC, Exadata, GoldenGate, Data Guard, OEM, AWS, Oracle Streams, Informatica, Cognos, SQL 2012, PL/SQL, SQL*PLUS, SQL*Loader, Korn, TOAD, Materialized Views  

Senior Oracle DBA

• Architected, Designed, Installed and configured a 3-node RAC Database on Solaris 11, and Linux platforms. Ensure technical documentation is kept up to date (architecture/integration diagrams and documentation)
• Maintained OEM 12c by Installing and configuring OEM agents and monitored them timely. Supported production, QA and development databases. Monthly, Weekly and daily report generation using AWR and ADDM . Observed AWR and ADDM reports on regular basis and made necessary changes to database's parameters. Worked with developers to tune SQL queries to optimize performance. Implemented production database security to restrict access thru SQL*Plus and Toad to unprivileged users.
• Extensive experience in Patching, applying minimum baseline patches for 11g and applied Oracle   security patches to Oracle   11GR2 databases.
• Pre-Patch analysis, applying patching in test/development instance
• Participated in re-design of the existing database environment to move database to more powerful servers. Was one of the major database resources during testing and production cutover.
• Setup Data Guard for 11g production databases to provide the DR capability. Performed critical Data Guard Recoveries for VLDB database for missing Archive Logs. Performed Data Guard Role Transition for Switchover and Switchback . Successfully implemented Transparent Application Failover (TAF) For Data Guard Connections using Database Services. 
• Experience on Oracle   GoldenGate for data replication for enterprise data centers including  installation, configuration, administration, performance monitoring. Troubleshot and fixed problems with excessive lagging and abend processes. 
• Configured GoldenGate BI-DIRECTIONAL replication and replicated tables between instances and used CDR parameters to resolve conflicts and applied business rules in environment. GoldenGate Downstream capture setup and Performance tuning of GoldenGate processes to achieve zero lag time. Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM and OEM.
• System administration, Oracle   Problem analysis & resolution and active cloning of databases between servers.
• Utilized Oracle 11g Real Application Testing feature (RAT) to capture application workload in production database, move it to staging environment and replay there. Utilized SQL Performance Analyzer (SPA) to compare database performance before and after changes.
• 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 . 
• Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle  security , Transparent Data Encryption , Oracle  Wallet Management and Oracle  Identity management.
• Worked with Informatica team for performing GoldenGate Initial loads.
• Migrated databases and upgraded the versions from SQL   Server 2005 to 2008
• Worked closely with Operations, Application and Development teams to resolve production issues.
• Created Oracle   Tables, Table Partitions, Views, and Materialized Views
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Proficient in raising Oracle  Service Request with Oracle   Support and using Metalink to resolve the bottlenecks in the database environments.

Environment: Sun Solaris, Linux, Oracle 11g, Data Guard, GoldenGate, OEM, SQL, SQL*Plus, TOAD, Statspack , Metalink, Informatica, ODI, Materialized Views, Python  

Oracle DBA 

• Migrated standalone 10g databases to 11g RAC clusters utilizing different techniques ( expdp , transportable tablespaces ) to minimize downtime for production databases. Worked on resolving problems with materialized views after migration. Utilized hints, tested different scenarios for MV's queries. Used transportable tablespace feature of Export/Import to speed up database migration. Resolved performance issues, provided day-to-day support, monitoring and backups.  
• Installed and configured Data Guard for RAC and non-RAC environments using physical-standby for high availability and reporting. Configuration of Oracle   Standby Databases ( Active Data Guard ) for high availability/Disaster Recovery Solution from Production Server to the DR Server.
• Supported 2 production Data Guard environments consisting of 2 Physical Standby databases respectively. Monitored propagation of the archived logs to the Standby databases. Resolved archive log gaps.
• Build and maintain Disaster Recovery solutions ( Data Guard and 2 standby databases ) for critical environments, confirmed with periodic DR Switchover and Failover.
• Solid experience in disaster recovery , Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies . 
• Worked on Snapshot standby and coordinated Application testing. Involved in converting physical to snapshot standby, and back to physical standby as per business requirement and also Active Data Guard
• Engineering, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions. 
• Daily monitoring like alerts checking, log checking, fixing space issues, fixing application connectivity issues, tuning databases, tuning application related queries, indexing tables, gathering statistics for optimum results, recommend workarounds/changes in application queries, partitioning maintenance
• Used Explain Plan, Oracle  hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Generated and automated Statspack/AWR reports from Oracle   11g/10g/9i database and analyzed the reports for Oracle   wait events, time consuming SQL queries, table space growth, and database growth.
• Sizing the SGA , sizing the db. Buffers, shared SQL area, log buffer based on the requirements. 
• Provides ongoing support for My SQL SERVER database servers for systems, which include creation, configuration, maintenance and upgrade. 
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues - helping to transform business requirements into environment specific database
• Gave 24 x 7 production support to 100+ mission critical databases running either at offshore or at Onsite on high-end server .

Environment: Oracle 10g, 11g, RAC, Dataguard, Oracle Streams, UNIX, Linux, AIX and Sun Solaris, ODI, SQL, PL/SQL and Unix Shell Scripting.

Confidential

Oracle DBA

• Created new and modified existing database objects. Checked for available space, added new or resized existing datafiles. Worked with UNIX and SAN teams to expand existing file systems or to create new ones. Based on Segment Advisor recommendations shrank indexes and tables to eliminate fragmentation and improve queries performance.
• Supported 2-node RAC database. Created database services. Provided support for ASM as database storage. Used SQL tracing, AWR reports to diagnose contention problems and bottlenecks, performed performance analysis and resolved issues.
• Shell Scripting for monitoring System Synchronization, Database growth size, monitoring free space availability at Database level and at Disk Level, Backups, and Performance and Log rotations. 
• Configured GoldenGate High Availability using Oracle   DBFS and Active Data Guard . 
• Created physical standby databases.
• Configuration of Oracle  Disaster Recovery Solution (DR) from Production Server to the DR Server
• Supported production databases. Duplicated databases on the different servers during production cutovers. Backed up databases utilizing RMAN . Worked with Operations to resolve problems with the media servers. Participated in yearly DR testing.  
• Setup and maintained GoldenGate for Oracle   replication. Cross platform Migration of databases using export/import and data pump .
• Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle   GoldenGate and Data Guard .
• Set up auditing in production databases to be compliant with SOX requirements. Created SOX audit reports for company's internal auditors. Was responsible for Company's database security. Created approved Oracle   accounts, assigned roles/privileges and proper profiles. Maintained users' password.
• Recovering Databases when there is any Physical or Logical Corruption.
• Generated and automated Statspack/AWR reports from Oracle   10g/9i database and analyzed the reports for Oracle   wait events, time consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Participated in On-Call rotation providing 24x7 support for the databases. Resolved assigned emergency tickets.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Used Tableau for visualizing and to generate reports.

Environment: Oracle 9i, 10g, RHEL 5, Solaris 10, RAC, GoldenGate, Data Guard, Exadata, Tableau, Statspack, SQL.

DBA 

• Wrote procedure to extract XML data into regular text files and load it into the database utilizing SQL*Loader. Transformed loaded data to make it uniform. Wrote 10 reports (utilizing SQL and PL/SQL). Optimized queries for performance.
• Actively participated in design, test and production implementation of new Data Mart application. Worked with Informatica team to create ETL process and Cognos developers for the creation of reports. Wrote stored procedures to support ETL's workflow.
• Supported Data Warehouse applications. Refreshed data in test databases to provide developers with environment to investigate and resolve problems. Made changes to production in accordance to Change Control Management process
• Migrated databases from Oracle   9i to 10g . Designed the logical and phcysical data model, generated DDL scripts, and wrote DML scripts for Oracle 10g database and applying patches whenever required . 
• Supported advanced replication ( Oracle Streams ) to replicate data between production databases for local and downstream capture architectures. Troubleshot problems with capture, propagation and apply processes.
• Worked on the Payroll Processing System using MySQL. This project was created to keep a record of employee data including employee id, employee name, designation, HRA, gross pay, deduction and net pay.
• Responsible for managing and handling data processing functions regularly. Prepared functional test cases by referring FSD (Functional Specifications Document).
• Tested application and verified data table content by using SQL quires. My contribution in this project was to design the form and to handle the database entries.
• Synchronized distributed databases for development and system test .  Maintained Database security. Created new roles and users. Monitored and optimized production database performance.
• Resolution of day to day related issues, documentation of Oracle DBA   routine tasks

Environment: HP-UX, Linux, Oracle   9i and 10g, Oracle   Streams, Informatica and Cognos, SQL, PL/SQL, MySQL.