SUMMARY

• Over 8 years of working experience in database administration, design, development, performance tuning, and high availability solutions. Database management skills with extensive experience in managing Oracle implementations, upgrades, data replication, database security, PL/SQL development, backup and recovery, space management, disaster recovery solutions, and patch management in a UNIX/Linux and Windows environment. Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two - node and four-node on Linux with ASM).
• Managed Databases in the range from 50GB to 3TB.
• Extensive Experience in Installing and Upgrading Oracle 9i/10g/11g databases on production, test and development environments on Solaris, AIX and Linux boxes.
• Proficient Experience with Standby Database, Data Guard, Replication.
• Experience in Installation and Involved in Implementing RAC Database with 2 and 4 nodes on Linux/Aix/Solaris.
• Experience in Installing, Implementing, Configuring and Running Oracle 11g RAC.
• Experience in Implementing Streams, Data Pump, Export and Import utilities.
• Deploying RMAN Backups and Reconfiguring when Needed.
• Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Proficient experience in Database performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan.
• Experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Korn Shell Scripting, Partitioning, Oracle Data Dictionary - Meta data, Logical and Physical Database Design, Backup and Recovery procedures.
• Experience in using OEM, TOAD.
• Experience in Implementing and configuring 11g OEM Grid Control.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, UNIX shell scripting, korn shell scripting and documentation.
• Strong experience with Oracle Databases (11g/10g/9i/8i), RAC on Unix/Linux/Windows/VMware platforms.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.etc.
• Experience with SQL turning, AWR reports, Wait events and also Performance issues of long running jobs.
• Strong Experience in Cloning of databases using RMAN.
• Experience in Golden Gate to support Data Replication in the database Environment.
• Experience in Adminstration Of oracle OLTP in theUnix Environment.
• Strong skills in shell, perl and korn shell scripting to Automate jobs.
• Experience in Troubleshooting oracle databases using sqltrace utilities.
• Exprience in Grid Administrating -Cloud Control on 12c.
• Upgraded Oracle Databases From 11g/11gr2 to 12c.
• Extensive knowledge in reporting tools like Business Objects, Crystal Reports and ETL Tools.
• Excellent Knowledge on Oracle Support processes for technical requests with Metalink.
• Migration between ASCII-based characters.
• Experience in basic and advanced replication.
• Proven ability to adapt to demanding schedules and changing priorities
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating Systems: MS Windows, Solaris,SUSE Linux, Hp Unix, Red Hat Linux

Database Technologies: Oracle9i, Oracle10g, Oracle11g, 10g RAC, 11g RAC,11g/12C OEM.

High Availability: Oracle Data-Guard and Real Application Cluster.

Database Tools and Utilities: Oracle 11g Enterprise Manager, AWR Report, Statspack Utility, Putty, SQL Developer, SQL Plus and TOAD, Fog light,GOLDEN Gate.

Backup Tools: RMAN, Import/Export, Data pump.

Programming Tools: SQL, PL/SQL

Development Methodology: Software Engineering, System Analysis and Design, Data and File Structures and Information Security.

PROFESSIONAL EXPERIENCE

Confidential, Fremont, CA

Sr Oracle DBA

Environment: Oracle Database 11g/12C, UNIX, PL/SQL, SQL* Loader, SQL* PLUS, TOAD, Golden Gate.

Responsibilities:

• Primarily responsible for administering and monitoring 150+ mission critical Oracle 12c/11g/10g OLTP production databases.
• Installed and configured Oracle (10g&11gr1/r2) databases on Linux 5, HP-Unix 11.X..
• Migrated the database from existing Oracle 10g to Oracle 11g and Upgradation of database (from 10.2.0.3 to 11.2.0.2).
• Upgraded Oracle databases from 11g/11gr2 to 12c.
• Performed Cloning, Export/import and Patching.
• Designed the logical and physical database structure and the security and database access strategies.
• Took Backups on scheduled time and monitoring scheduled Backups.
• Monitoring and deploying the TNS and LISTENERS for RAC database
• Performed backups and recoveries using RMAN conventional hot backups.
• Established and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Implemented Data Guard with maximum protection and maximum performance configurations and worked with Data Guard fail over and switch over cases.
• Installed, Configured and Managed11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases.
• Successfully maintained multiple databases.
• Participated in planning and implementation ofGoldenGate.
• Successfully installed and configured Oracle GoldenGate for Replication in Development and Test environment.
• Remodeling the existing system using ER/Studio for logical/Physical data modeling.
• Worked on SQL, PL/SQL Programming and SQL tuning.
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, PowerExplain, and Enterprise Manager.
• Experience AWR reports, Wait events and also Performance issues of long running jobs.
• Created and dropped of users, granting and revoking rights as and when required.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Used TKPROF, EXPLAIN PLAN and AWR for the Better performance.
• Monitered of database for growth and performance.
• Monitered Database for fragmentation and correcting them.
• Customization and development of Unix shell scripts, Korn and Perl scripts.
• Good Experience tranfering files by using scp, sftp, ftp and pscp.
• Partitioning strategies for very large tables.
• Extensively used Export /Import utilities for selective backup and defragmentation.
• Diagnose and troubleshoot Database problems and failures.
• Hands on experience in Switch-over and Fail-over process.
• Implementing range, list partitions, hash sub partitions.
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Performed and Monitored Database using tools TOAD and OEM 10g.
• Monitoring of database for growth and performance.
• Supported OPNET Drag and Drop Features and User Interface for real-world Network Infrastructures.
• Tuning the databases for Optimal Performance.
• Responsible for managing databases on VCS Cluster and VCFS file systems.
• Configured SNMP Agent on UNIX nodes for monitoring the server health and outages.
• Designing and managing backup strategies, disaster recovery solutions, Log shipping.
• Responsible for creating and scheduling and troubleshooting of SQL Server jobs.

Confidential, Plano, TX

Sr Oracle DBA

Environment: Oracle Database 11g, 10g, UNIX, SQL*Loader, RMAN, Data guard.

Responsibilities:

• Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 10g/11g/12c including RAC and ASM, Golden gate.
• Playing vital role in streamlining all the databases on AIX, HP-UX, Linux, Solaris.
• Strong working experience in 24 X 7 Production database administration, data warehouse systems and monitoring to ensure a proactive problem recognition and resolution of very large database issues.
• Installed and Upgraded Oracle 11g database from Oracle 10g database on test and development environments.
• Installation, Configuration and Administration of 4 node Oracle 10g RAC.
• ASM installation and new database creation for 10g RAC.
• Implemented Streams on both 9i and 10g Databases, Export & Import on 9i Database, DataPump in 10g Database.
• Performed Database Administration activities such as Upgrades, Patches, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented and Involved in Hot, Cold and Logical backup plans
• Oracle 9i & 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Proactive database monitoring using 10g grid monitoring tool.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures.
• Written Korn, Perl, shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Database dot release upgrades using oracle universal installer and catpatch.sql
• Upgrading of Database from 9.2.0.6 and to 10.2.0.2.
• Developing a disaster recovery (DR) plan and Stand by Database
• Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Conducting sizing & capacity planning for Oracle databases.
• Upgraded Discoverer Administrator from older version to new for administrative tasks and also applied most recent OLAP patches.
• Reading Alert, Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the Problem Faced by end Users Or Programmers
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Used TOAD tool for querying and troubleshooting PL/SQL queries and codes.
• Checking the maintenance plans on all the servers on a daily basis. These plans used to create backups on a daily basis and used to check optimization and integrity on a weekly basis.
• Maintaining the database consistency with dbcc commands.
• Creating of logins, Roles and granting rights, Assigning permissions and mapping user databases as per the client's requirements.
• Planning and implementing disaster recovery procedure to ensure minimal downtime and data loss.
• Remove any unneeded space from the transaction log and data files by shrinking the databases.

Confidential, Twinsburg, OH

Oracle DBA

Environment: UNIX, SQL* LOADER, SQL* PLUS, ORACLE 10g, RMAN

Responsibilities:

• Supported 50+ databases including RAC Production database, a data warehouse database and lot of Development and Test databases.
• Involved in installation and configuration of Oracle 9i databases on Linux and Window.
• Involved in Creating and Managing Users and Objects.
• Involved in Assigning roles and Privileges to Different users.
• Applied the Oracle security patches and application patches using the Opatch Utility.
• Involved in managing physical/logical standby databases using Data Guard.
• Involved in Database replication using Oracle streams in schema level and table level.
• Responsible for cloning and refreshing of databases per customer requirements using RMAN, Data Pump, export/import.
• Implement database backups using RMAN, VERITAS Net Backup.
• Involved in Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views.
• Tuning and diagnosing of database performance by query optimization and trace facility using Explain plan, STATSPACK, AWR reports, SQL trace and Tkprof.
• Worked on PL/SQL, UNIX Korn Shell scripting, AWK scripting and PERL Scripting.
• Developed stored program units in the form of packages, functions, triggers and procedures for implementing the database intensive business rules.
• Involved in logical backup using full/ partial export/import and Data Pump.
• Supported and troubleshoot databases on VERITAS Cluster on top of Solaris 8.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Modified and debugged stored procedures and triggers.
• Created Schema (Tables, Indexes, views, sequences, synonyms, roles, and packages) and granted roles to users.
• Rewrote several SQL and PL/SQL code to improve query optimization and control program flow.
• Scheduled jobs using Crontab Utility at OS level to automate the routine DBA tasks.
• Hot, Cold and RMAN backup's and Performance Tuning of SQL statements.
• Supported SQL Server 2000 Database Administration.
• Worked with senior oracle DBA to understand business and technical requirements.

Confidential

Oracle DBA

ENVIRONMENT: ORACLE 9i, PL/SQL, OEM 10g, OEM Tuning Packs, RMAN.

Responsibilities:

• Advised and made recommendations to improve the overall database design.
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN).
• Was involved in developing a disaster recovery (DR) plan.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication).
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9iAS
• Automation of tasks like backup/refresh and other jobs using.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one of Patches etc).
• Oracle Applications Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Installed and Configured Single Sign On and Implemented SSL Security.
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Planning and Administration of backup and recovery strategies.
• Oracle 10g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle OID Implementation and Support.
• Oracle DataGuard Implementation for HA and remote DR site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Creating of databases for Testing, Development and Production.
• Taking periodic backup of the database and the software.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF and Statspack.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Written shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Installation of Oracle version 10g on Solaris, HP-UX.
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• Migration of Database from 9i and to 10g.
• Developing a Disaster Recovery plan. Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
• Monitoring Alert. Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.