Over *+ years of experience as an Oracle Database Administrator and performed tasks like Oracledatabase administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security etc. in production as well as development database on different platforms.

Excellent experience in Installation, configuration and cloning of Oracle 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 Maintaining Oracle Server according to Oracle OFA Standards.

Expertise in proactive patch management, cloning, code migrations, release management.

Worked with customer for different RAC related issue:[ hang check timer, split brain, RAC recovery, ASM, OCR corruptions, voting disk loss & so on ]

Experienced with tools/utilities: OEM, RMAN, TOAD, Embarcadero DB Artisan, SQL* Loader & Data Pump and Strong understanding in Oracle Architecture.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases usingRMAN with TSM Backup.

Proficient in Database administration activities such as user management, space management, monitoring, creating Database, Managing Oracle Instance and Database security and materialized views.

Proficient in Oracle High Availability features likeRAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.

Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle Networking. Configured Listener for external procedure calls.

Good system administration skill on RHEL 5/6, AIX, Solaris 10 and windows including storage administration.

Deployed Oracle 11g RAC on AWS EC2.

Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc.

Hands on Experience on Implementing Streams, Data Pump, Export and Import utilities.

Worked with Oracle to resolve Ora-00600, Ora-07445 issues and resolutions.

Management of 200+ database with sizes ranging from 20GB to 500GB and a mix of singleInstance/RAC Environments.

Hands on experience with Switchover/Failover activities.

Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.

Developed UNIX Shell scripts to automate repetitive databaseprocesses.

Responsible for Administering Automatic Storage Management (ASM) by adding Disks to the Disk Groups when needed.

Expertise in administeringMicrosoft SQL Server 2005, 2008 and 2012.

Setup Oracle Enterprise Manager (OEM) 11g in windows server 2012 for database Monitoring/performance/diagnostics.

24X7 production Database on Call support.

Installed Cassandra for POC.

Responsible for 24X7 on call support and monitoring and production deployments.

Goal Oriented, Good Co-Ordination and co-operation with the Team and Management adapt at learning and adaptable to complex work environment.

Expertise on PCP and middle tier Load balancer setup / troubleshooting.

Hands on experience working on High Availability Environments.

TECHNICAL SKILLS

OS: Solaris 10, Windows 95/98/NT/2000/XP, IBM AIX6.1, 5.3 RHEL Linux 6,5

Software: Oracle 8i/9i/10g/11g/12c, Oracle 9iAS

Language/Front End: C, Java, Shell Scripting, MY SQL, SQL, PL/SQL, and PHP

Tools: SQL*PLUS, SQL Developer, TOAD, SQL Navigator, PUTTY, OEM, RMAN, SQL*

LOADER, Imp/Exp and Data pump

Oracle EBS/Middle Tier: 11i, R12 / Oracle 9iAS, 10gAS, Apache

RDBMA: Oracle [8.x, 9.x, 10.1.0.2, 10.2.0.3 – 10g], 11g [11.1.0.6, 11.2.0.3], 12c

Tools /Utilities: OEM, TOAD, Export/Import, Data Pump, AWR, Stats pack, TKPROF, Spot light, RMAN, SQL expert, OBIEE, RAC, opatch, Oracle Reports 10g and Oracle Forms 10g.

WORK EXPERIENCE

Canon Usa,Houston Tx Aug 2016 -- Till Date

Database Administrator

24x7 L3 and L4 production support of Oracle and MSSQL databases.

Upgraded oracle database from 11g to 12c and 10g to 11g RHEL6.

Expert in Cloning and patching of oracle databases 11g and 12c.

Develop centralized monitor database activities, scripts such as space management, alert Log, cleanup, RMAN Backup Jobs, Gather stats for Schemas, Table space monitoring,Disk monitoring, etc.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Provided Database Administration support (24x7) for 2TB production oracle 11g Databases.

Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.

Responsible for undo rollback management. Created database objects, users, roles and profiles

Server-level statistics on both Batch and Database servers (using iostat, vmstat, etc)

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 analyzing and resolving any issues found during the monitoring.

Installed Oracle RAC on AWS EC2.

Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.

Excellent in depth understanding of Oracle automatic Undo Management.

Refresh/Cloning of Database and application from production environment to test environment and application of patches..

Updated development databases by using import/export and SQL loader utilities.

Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.

Responsible for configuration and implementation of backup and recovery using RMAN.

Installed and configured Recovery Manager Catalog Database.

Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.

Installed Cassandrafor POC

Setup and configured network TCP/IP on LINUX and AIX servers including RPC connectivity for NFS. Created mount points for Server directories, and mounted these directories on the Servers.

Environment: Oracle 11g/12c, MS SQL Server 2008 R2/2012, OEM Cloud Control 12c, RMAN, ASM, IBM AIX 6.x, Linux RHEL 5.x/6.x, Windows, Sun Solaris, TOAD 11.6, Shell Scripting, SRDF, PL/SQL, Microsoft Ignite.

Dc Water, Washington DC Aug 2015 – July 2016

Oracle DBA

24x7 L4 production supportand administeringof Oracle and MSSQL databases.

Develop centralized monitor database activities, scripts such as space management, alertLog, cleanup, RMAN Backup Jobs, Gather stats for Schemas, Table space monitoring,Disk monitoring, etc.

Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Provided Database Administration support (24x7) for 2TB production oracle 11g Databases.

Responsible for Upgrading the Database from 10g to 11g.Configured ASM file system and administering ASM Instances and Disk Groups in RAC.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.

Responsible for undo rollback management. Created database objects, users, roles and profiles.

Responsible for implementing Load Balancing in RAC Database.

Responsible for Administering Automatic Storage Management (ASM) by adding Disks to the Disk Groups when needed.

Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.

Excellent in depth understanding of Oracle automatic Undo Management.

Refresh/Cloning of Databaseand application from production environment to test environment and application of patches.

Performed maintenance tasks like Purging log files, Gather schema statistics, Purging Runtime Data.

Updated development databases by using import/export and SQL loader utilities.

Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.

Responsible for configuration and implementation of backup and recovery using RMAN.

Installed and configured Recovery Manager Catalog Database.

Responsible for automation of startup and shutdown on all production and development databases.

Involved in scheduling transaction log backups and notifications.

Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.

Worked on SQL explain plans query performance, session tracing.

Environment: Oracle 11g/12c, MS SQL Server 2008 R2/2012, OEM Cloud Control 12c, RMAN, ASM, IBM AIX 6.x, Linux RHEL 5.x/6.x, Windows, Sun Solaris, TOAD 11.6, Shell Scripting, SRDF, PL/SQL developer, Microsoft Ignite

Oracle Corporation, Richmond CAFeb 2013 – June 2015

Database Administrator

Provided L3 database support for 100+ production Oracle 11g databases.

Upgraded oracle database from 11g to 12c and 10g to 11g on RHEL5.

Involved in Cloning and patching of oracle databases10g, 11g and 12c.

Develop centralized monitor database activities, scripts such as space management, alertLog, cleanup, RMAN Backup Jobs, Gather stats for Schemas, Table space monitoring,Disk monitoring, etc.

Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.

Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.

Provided Database Administration support (24x7) for production oracle 11g Databases.

Responsible for Upgrading the Database from 10g to 11g and Configured ASM file system and administering ASM Instances and Disk Groups in RAC.

Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.

Responsible for undo rollback management. Created database objects, users, roles and profiles.

Responsible for implementing Load Balancing in RAC Database.

Responsible for Administering Automatic Storage Management (ASM) by adding Disks to the Disk Groups when needed.

Excellent in depth understanding of Oracle automatic Undo Management.

Refresh/Cloning of Database from production environment to test environment and application of patches.

Updated development databases by using import/export and SQL loader utilities.

Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.

Responsible for configuration and implementation of backup and recovery using RMAN.

Installed and configured Recovery Manager Catalog Database.

Responsible for automation of startup and shutdown on all production and development databases.

Involved in scheduling transaction log backups and notifications.

Worked on SQL explain plans query performance, session tracing.

Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.

Environment: Oracle 10g/11g/12c, Oracle Enterprise Cloud 12c,SuSe Linux Enterprise Edition 11SP3, SQL Server 2008/2012,Windows Server 2008/2012,SQL Developer 4.1

Tata Consultancy Services, Hyderabad India Nov 2009 – Jan 2013

Systems Engineer

Primary production support administrator for Oracle Database 11g and 12c

Work with Oracle support in resolving bugs, bug fix patches, multiple severity 1 SRs etc.

Worked as Primary team member to provide 24/7 on all production database support

Installation configuration and administration of Oracle 11g RAC and Oracle 10g.

Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, PhysicalStand by Database Replication.

Refresh of Database or Schema and applications fordevelopment and testing purpose.

Maintained Data Guard to ensure high availability, data protection and disaster recovery forenterprise data.

Upgrade and Migration of Database from 10g to 11g and applying patcheswhenever required.

Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups and

Performed backup validations using RMAN.

Installation and configuration of Golden Gate.

Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).

Worked on Instance Tuning, memory Tuning and SQL Tuning.

Written Shell scripts to monitor activities like availability of database & listeners, space utilization; gathering statistics for the cost base optimizer, index rebuilding.

Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export.

Setup Golden Gate parameter files for extracting and replication.

Installed and configured OEM Grid control and intensively used Diagnostic & tuning

Packs along with AWR & ADDM reports.

Partitioning of large tables for better performance and manageability.

Performance tuning of database, oracle instances and applications. Finding performance bottlenecks using Explain plan, SQL trace, TKPROF, AWR and ADDM.

Created users, roles and granted privileges according to the business requirements

Experience in Configurations, logical models, operational management models and business continuity plan for systems under management.

Excellent day-to-day administration in every means and monitoring alert log files and trace files.

Environment: Oracle 9i/10g, Oracle Enterprise Manager (OEM), Linux 10, PL/SQL, Microsoft Server 2003, Toad 7.0.

Contact this candidate