SUMMARY

• 12+ years of experience as an Oracle Database Administrator having hands on experience in Production Support, Installation, Configuration, Upgrades, Patching, Performance Tuning, RMAN Backup and Recovery, ASM/RAC Administration, Golden Gate Replication,Cloning, Space management, Database Security, Auditing, Shareplex Replication, BCV Splits (EMC Snapshots, Backups & Recovery).
• Progressive experience in Oracle database Design and Architect.
• Proven track record of providing strategic direction while deploying tactical technical solutions.
• Exceptional analytical and problem solving skills.
• Excellent ability to look at problems from a macro level and a detailed level; always keeping the appropriate business prospective.
• Excellent experience in Installation, configuration and cloning of Oracle 8i, 9i, 10g, 11g, 12c and 11g RAC and standalone in UNIX/LINUX and Windows 2008/2012 R2 environment.
• Duties included Installation, Patching, Upgrading, Performance Tuning, Space allocation and MaintainingOracle Server according to Oracle OFA Standards.
• Work with application teams closely to implement the standard and best practices for Netezza database.
• Hands on experience in Node Addition and Deletion on RAC databases
• Experience in implementing Bi - directional data replication configuration usingOracle Golden Gate.
• Expert with Data Guard, creation of Physical standby and resolving the gaps between primary and physical standby databases.
• Good experience in working with Data Replication tools Oracle Streams, Materialized Views, Data Guard, Golden Gate & Shareplex.
• ConfiguredZero-Downtime Migration Replication using Oracle GoldenGate.
• Excellentexperience in executing ETL scripts that populate FACTS databases from external sources.
• Good hands on experience and working on oracle 10g/11g/12c RAC, ASM, Data Guard and Oracle 12c OEM, Oracle 12c Transparent Data Encryption.
• Worked on Data Mapping, Data Selection/Filtering and Data Transformation using Oracle Golden Gate.
• Implemented Advanced Data Conflict Resolution methods using Oracle Golden Gate.
• Worked (VLDB) Very Large Databases such as multi-terabyte Databases.
• Good hands on experience in working onFlashback&Database Optimization techniques.
• Active participation in Data Centre Migration.
• Hands-on experience in Planning & Designing Oracle Backups and Recovery strategies like RMAN, export/import, Data pump, Hot/Cold Backup &Logical &Physical Backup.
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
• Experience on Netezza Mako appliances, Hands-on with Netezza replication 1.6 or later.
• Regularly attendingproject meetings and provide management with statuses and updates on projects and assignments.
• Performed Data file recovery from logical and physical block corruptions
• Good understanding and Implementation expertise in RAC, ASM, Data Guard,Oracle DB security & Data masking like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
• Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
• Good Experience in Monitoring the databases to ensure maximum database availability
• Installing, Configuring, Administering, Cloning, Patching, Upgrading and Migrating the Oracle Technologies Database Products on Unix, AIX, Sun Solaris SPARC, Linux, Cent OS and Windows server family.
• Work with Architect and planning teams to identify right technology investments and technical Architectural upgrades
• Hands on experience with Switchover/Failover activities.
• Expert in Support and Maintenance, Shell scripting, database upgrades and enhancements.
• Hands on experience in migration of databases using Transportable Tablespaces .
• Conducting Knowledge Sharing and Training sessions to Train staff to perform all aspects of on-going support of the databases.
• Proficiency in Analytical, Presentation, written and oral Communication and Interpersonal skills.

TECHNICAL SKILLS

Database Admin: ORACLE 12c,11g,10g/9i

RDBMS: Oracle, Microsoft SQL Server& DB2

High Availability: 10G,11G, RAC, Data Guard, ASM& Oracle Golden Gate

Languages: SQL, PL/SQL, Shell Script, C

Operating System: LINUX (4.x, 5.x, 6.x), Sun Solaris 8/9/10, SuSE Linux Advanced Server, and HP-UX 10/11.x, IBM AIX 5.1, 5.2,5.3 & Windows Server 2003/2008/2012 R2

Development Tools: SQL Developer, Toad, SQL*plus, SQL* Loader, JIRA

Database Tools: SQL*PLUS, TOAD, Putty, OEM (11g& 10g), RMAN, EBU, SQL* LOADER, Export/Import& Data pump (expdp and impdp).

Web Technologies: Html

Ticketing Tools: Remedy, Impact

Tuning Tools: TKPROF,EXPLAINPLAN,STATSPACK,AWR,ADDM, ASH

PROFESSIONAL EXPERIENCE

Confidential - SanFrancisco, CA

Senior Oracle Database Administrator

Responsibilities:

• Working on Pre migration activities for OPS(Online Payment Services) and PYD(Payee Directory) databases migration to Exadata
• Support Online Payment Services for various releases.
• Supporting Various Failover Test plans on newly created 12c RAC Exadata environment.
• Working on creating AQ/MQ's for Transfer Scheduling services.
• Working on replacing the existing CDC streams replication mechanism with Triggers, as it was not supported in Oracle 12c Exadata environment.
• Working on Alternative solution for AQ/MQ's gateway mechanism.
• Providing support for SQL Query Tuning and Database Performance issues.
• Participated in Bill Pay Batch Volume Testing procedures for Batch Services.
• Working on Planning and Prerequisites for Volume Testing.
• Monitor and analyse database activity to proactively identify and prevent Potential Performance problems.
• Monitoring Table space size, resizing Table space, relocating data files for better disk I/O.
• Creating Privileges, Roles and user Profiles. Granting resources to users.
• Maintaining 100% SLA compliance with JIRA tickets.
• Good experience in with the 11g/12c Oracle Enterprise Manager(OEM)
• Taking AWR reports and analysing them periodically for better performance.
• Monitoring the Performance of the system and resolving any issues to ensure stable performance.
• Extensively worked on SQL tuning.
• Good knowledge in working SQL & PL/SQL procedures, functions and triggers.
• Extensively worked on database tuning and strong knowledge on using 11g and 12C Optimizers.
• Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• CapturingPerformance Metrics during Volume test process.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Baseline and new code run-times in the Batch and Database logs
• Server-level statistics on both Batch and Database servers (using iostat, vmstat, etc)
• Process-level statistics on both Batch and Database servers using the ps unix command
• Database-level statistics by enabling a logon trace trigger, which generates the raw database trace files. We use Tkprof to massage the raw db trace files and generate a report that includes Logical I/O's, Comparison of the number of parses to number of executions,SQL statements that do not use bind variables (:variable) & Statements that perform full table scans, multiple disk reads, and exhibit high CPU consumption.
• Monitoring the critical System parameters and analysing and resolving any issues found during the monitoring.
• Working on implementing the OPS Volume Testing framework.
• Monitor the log files on the batch server and the db log table to make sure the jobs within the box progress without any issues

Environment: Oracle 11g&12c, Exadata, Sun OS 5.10, Linux (RHEL 4.x, 5.x 6.x),Toad 10.6,Visio & Shell Scripting.

Confidential - Richardson, TX

Senior Oracle Consultant

Responsibilities:

• 24X7 production support and on call rotation as per the support roster.
• Applying regular quarterly CPU/PSU patches and keeping the databases up to date with the Oracle Security updates.
• Involved in database migrations, cloning production system, for testing and development.
• Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
• Active participation on Node Addition and Deletion on RAC databases
• Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Maximum performance mode.
• Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
• Working on Oracle 12c Installation, configuration and maintaining the databases
• Involved in Implementing Oracle Golden Gate between Production databases Active - Active configuration with CDR implementation.
• Work with application teams closely to implement the standard and best practices for Netezza database.
• Worked on generating the reports using various Reporting tools.
• Worked on Hadoop with Cloudera Manager to add services and nodes to the Hadoop cluster.
• Manually starts and stops the Services in cluster when need.
• Deploy parcels and packages to the Hadoop cluster using Cloudera Manager.
• Took responsible for writing Shell scripts, SQL scripts and implementing auto manageable scripts.
• Working on Space management, User management for smooth running of the databases.
• Creating users, allocation to appropriate table space quotas with necessary Privileges and Roles for all databases.
• Having good experience in Hadoop HDFS, HBASE.
• Restarting and Refreshing the Hadoop cluster using Cloudera Manager.
• Exploring rich, interactive visuals using Data Visualization on Integrated Cloud Applications.
• Performed Switchover/Failover activities.
• Creating the new jobs for report generation, Database monitoring and Alert management.
• Managing archive logs, DB-links, partitions.
• As part of daily activity, moving the TB's of data from production to backup system using Transportable Tablespaces.
• Monitoring Table space size, resizing Table space, relocating data files for better disk I/O.
• Creating Privileges,Roles and user Profiles. Granting resources to users.
• Working on installing Oracle Enterprise Manager (OEM) and maintenance of the entire ORACLE 12c environment
• Extensively worked on RMAN Backup & Recovery scenarios.
• Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
• Conducting Knowledge sharing sessions to Team members
• Regular Team meetings with all the teams to track the progress of the work and issues.
• Track testing and development progress and document the same. This is to ensure highest quality of solution is delivered using Integrated Test Client
• Discussing with business entities and other stakeholders to resolve any issues related to the Project.
• Monitoring the critical System parameters and analysing and resolving any issues found during the monitoring
• Monitoring the Performance of the system and resolving any issues to ensure stable performance.
• Good experience in implementing hot, cold and RMAN scheduled backups and Performance Tuning of SQL statements.

Environment: Oracle 11g&12c, Netezza database, Linux (RHEL 4.x, 5.x 6.x),Hadoop,Sun OS 5.8/5.9/5.10, Toad,Cloudera Manager Shell Scripting.

Confidential, Redwood City, CA

Principle Database Administrator

Responsibilities:

• Involved in 24*7 production support for multiple (1000+) customers Oracle databases.
• Responsible for Installation, Up-gradation, Migration, Applying Patches, Cloning.
• Created new Cluster environments, ASM and databases as per the requirements.
• Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 10g/11gand 12C databases
• Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration.
• Configured and deployed the High Availability, disaster recovery solution Data guard Physical Standby database in max-performance mode.
• Creating Support pages using Oracle Application Express (APEX)
• Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
• Responsible for managing production, development & test databases and applications.
• Extensively worked with export/import and Data Pump utilizes to migrate data from Sun Solaris to AIX
• Working on designing complex spreadsheets in Excel, and experience in Visual Basic for Applications (VBA)
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
• Extensively worked with indexes and table partitioning.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Experience in implementing hot, cold and RMAN scheduled backups and Performance tuning of SQL statements.

Environment: Oracle 10g, 11g, 12C, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux( RHEL 5.x 6.x), Sun OS 5.8/5.9/5.10, Windows 2012 Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential, Webster, NY

Senior Oracle Database Administrator

Responsibilities:

• Handling high availability (24/7) database in onshore-offsite model.
• Applying regular quarterly CPU/PSU patches and keeping the databases up to date with the Oracle security updates.
• Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
• Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration with CDR implementation.
• Migration of around 2000 Schemas across 65 prod databases to New 5 Node PROD RAC database
• Working on Database Optimization techiniques.
• Setup the Data Replication configuration using Shareplex tool.
• Good hands on experience in working with Unified Modelling Language (UML) and Use Cases.
• Preparing the deployment plans with pre and post installation steps
• Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Working on Application Lifecycle Management with Visual Studio Team Foundation Server (TFS)
• Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
• Working on executing ETL scripts that populate FACTS databases from external sources.
• Extensively worked with export/import and data pump utilizes to migrate data from Sun Solaris to AIX
• Working with Data ETL (Extraction, Transformation and Loading) using SSIS (SQL Server Integration Services) in SQL Server 2008 with Import/Export Data, Bulk Insert.
• 24X7 production support and on call rotation
• Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008
• Involved in database migrations, cloning production system, for testing and development.
• Extensively worked with indexes and table partitioning.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.

Environment: Oracle 11g/10g, RAC, ASM, Data Guard, Shareplex,TFS, OEM 10g/11g Grid Control,SQL Server 2008 RMAN, AIX OS 5.1,5.2,5.3, Toad, UML, PL/SQL, SQL*Plus.

Confidential, NJ

SeniorOracle Database Administrator

Responsibilities:

• Handling high availability (24/7) database in onshore-offsite model
• Handling Performance issues at application level and database level
• Applying regular quarterly CPU patches and keeping the databases upto date with the Oracle security updates
• Providing support to the data warehouse jobs and tuning queries.
• Upgrading the databases from 9i to 10g and 11g
• Installation, configuration and maintenance of standby databases using Dataguard
• Cloning the Oracle home and upgrades.
• Creating health monitoring Unix shell scripts
• Scheduling the health scripts using cron tab, mailx.
• Working with DB2 utilities for maintenance (Reorgchk/Reorg/Runstats), data movement (Export/Import/Load/Move/Look)
• Troubleshooting DB2 database issues using db2diag, db2pd, db2dart, db2inspect, db2trace, db2support, db2top, explain plan, db2exfmt and snapshots. Partitioning of huge tables.
• Working closely with the application teams on scheduling the patching windows.
• Cloning the databases regularly for the reporting databases and stage environments.
• Tuning the database level performance issues.
• Taking AWR reports and analyzing them periodically for better performance.
• Creating SOX level auditing scripts and making the validations and changes as required.
• Creating Backup schedules and taking periodic backups both offline and online using RMAN
• Participating in corporate DR drills and ensuring the data protection.
• Trouble shooting the application server issues.
• Defragmentation of the tables using exp/imp, Reorg and shrink
• Creating process documents for the DBA activities and making sure that team adhere to the process outlined.
• Creating shift schedules
• Maintaining stringent response / resolution SLAs.
• Creating partitions for partitioned tables periodically
• Managing materialized views and refreshes
• Creating DB links to heterogeneous environments for the data warehouse
• Periodic index management, index rebuilding.

Environment: Oracle 11g/10g/9i,DB2 V9.7 RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux(RHEL 4.x,5.x),Sun OS 5.9/5.10,AIX OS 5.1,5.2,5.3, Toad, Performance Tuning Shell Scripting, PL/SQL, SQL*Plus.

Confidential, New York, NY

Senior Oracle Database Administrator

Responsibilities:

• Creating New RAC database as per the requirement.
• Working on Space management, User management for smooth running of the databases.
• Refreshing data from prod to lower environments for testing
• Creating the new jobs for report generation, Database monitoring and alert management.
• Creating RMAN backup strategies as per the requirements.
• Creating, adding new disk groups and members to ASM for new databases
• Resolving user issues immediately and closing the issues on timely manner
• Monitoring jobs, troubleshooting on failure and addressing alerts
• Performed heavy data loads using SQL *Loader, Export, Import for backing certain tables.
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table space size, resizing table space, relocating data files for better disk I/O.
• Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
• Performed large data loads through SQL*Loader.
• Managing archive logs, DB-links, partitions.
• Involved in database schema creations
• Monitoring the growth of the database to ensure the smooth functionality of daily activities.
• Performing logical and online backups.
• Monitor and resize Oracle database objects (table spaces, tables, and indexes).
• Creating privileges, roles and user profiles. Granting resources to users.
• Importing of schemas and tables.
• Plan and implement appropriate backup and recovery strategies for the database.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Observing Logs generated every day.

Environment: Oracle 9i/10G/11G, MS SQL Server 2000/2005, Oracle Enterprise Manager (OEM), OEM 10g Grid Control, RMAN, RAC, ASM, DBArtisan, DataGuard, AIX OS 5.1,5.2,5.3,Linux( RHEL 4.x, 5.x),Sun OS 5.8/5.9/5.10, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential

Oracle Database Administrator

Responsibilities:

• Checking health systems of Oracle Database.
• Installed Oracle10g RAC with ASM on Raw devices
• Handling different database issue and resolving those within SLA.
• Installed Grid control and maintaining the databases through the Enterprise Grid Control
• Implemented RMAN backup and tested various recovery scenarios
• Implemented Backup Policy and Move the backups to the Tape drives at regular intervals
• Generated the Entity-Relationship diagrams using ERWIN tool
• User Administration & Security Implementation (Role Based and / Privilege Based)
• Schema refreshment & Database Up gradation
• Used Data pump utility
• Backup & Recovery of database
• Linux & HP-UX System administration like installing Operating System Patches, Job scheduling, Space management etc
• Oracle10g Application Server administration
• Creating shell scripts for automating manual jobs
• Creating and Maintaining the Database & Tuning the database for optimal performance
• Involved in Oracle database logical and physical Backups
• Ensure the completion of all daily backups.
• Monitoring database growth and space management.
• Checking the alert logs regularly
• Configuring the database to archive mode
• Maintaining database security by creating users and profiles
• Resolving user process error
• Monitoring Database Performance by Dynamic Performance views.

Environment: Oracle 10g/9i, Toad, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Suse Linux Advanced Server and AIX 5.1/5.2/5.3, TOAD, Performance Tuning, Shell Scripting, PL/SQL, SQL*Plus