SUMMARY

• 7 years of experience as Oracle Database Administrator, provided 24x7 production support as well as for Development databases on 12c/ 11gR2/10gR2/9i/8i databases on different OS Platforms.
• Experience on oracle 12c/ 11g/ASM/RAC and converting of standalone databases to 11g RAC databases.
• Installation, administration and maintenance of Oracle 11g/10g on OEL, RHEL, UNIX and Sun Solaris in OLTP environment.
• Configuration of Automatic Storage Management (ASM) for RAC databases using ASMLib and ASMCMD.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF, AWR, ADDM, ASH, SQL Trace, ORADEBUG, 10g OEM Grid Monitoring, Oracle Diagnostics pack, Oracle Tuning Pack.
• Experience in regular Database Administration activities such as Upgrades, Migration and Patches which are downloaded from oracle metalink.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 12c/11g/10g databases.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial also used Datapump export/import.
• Performance Tuning the database server at Instance, Sql, Memory, Disk I/O and at OS level.
• Capacity planning, scripts development, and documentation.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data guard.
• Skilled in using tools such as SQL Developer and TOAD and loading data from flat files using SQL Loader and External Tables.
• Experience developing and running PL/SQL scripts for Production, Development and Test databases.
• Experience working with Database Resource Management.
• Involved in Replication of data using Streams.
• Writing shell scripts for automating various database activities like backup and recovery, performance tuning and managing archive data and dump and trace files.
• Awareness on Oracle Support processes for technical requests through Oracle Meta link.

TECHNICAL SKILLS

Operating System: Red Hat Linux, Solaris, HP-UX, Windows NT/2003/XP/7.

Databases: Oracle 9i/10g/11g, RAC 10g/11g

Languages: C++, SQL, PL/SQL, JAVA scripting, Shell scripting.

Web Servers: Apache Tomcat, Web logic

Tools: and Utilities(ORACLE): Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF, ASM.

Other Tools: WINSCP, Putty, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Sr Oracle DBA

Responsibilities:

• 24x7 Production on call Database support.
• Installation and configuration of multi node Oracle 12c, Oracle 11g RAC, 10g RAC databases around 10 servers.
• Configuring and implementing Standby databases (Active DataGuard) for high availability and disaster recovery purpose for RAC databases also involved in DR drills.
• Applied patches and patch sets on Oracle database and cluster ware by downloading from metalink and applying using OPatch utility.
• Performed Up gradation of oracle database from Oracle 10g to Oracle11g R1 and Oracle 11gR2, Performed Migration of databases from AIX to Linux environment using transportable tablespaces.
• Configured RMAN backup for RAC databases.
• Good experience of 11g RAC utilities like srvctl, crsctl, ocrdump, ocrcheck and ocrconfig.
• Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Stats pack, ADDM, ASH reports, OEM Grid Control.
• Performance tuning of Queries by maintaining Aggregates, Compression, partitions, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed Data pump operations for 10g and 11g Databases through command line and involved database refreshes using data pump.
• Implementing Database Replication using Oracle 10g Streams and Oracle Golden Gate
• Data loading from flat files and external files activities through SQL loader.
• Implemented Backup & Recovery procedures using level 0/level 1 using RMAN also implemented Hot/Cold Backups using conventional method
• Developed automated maintenance scripts using PL/SQL procedures triggers, functions, packages.
• Written and modified UNIX shell scripts and updated crontab for automating the database activities to manage Oracle environments.
• Working with Oracle support to resolve like ORA errors issues.

Environment: Oracle 11g RAC, 10g, Grid Control 10gR5, ASM, AIX, RHEL 4,5, Shell Scripting, Golden Gate .

Confidential, Irvine, CA

Oracle DBA

Responsibilities:

• 24x7 Production on call Database support.
• Installed, configured and maintained Oracle 12c, Oracle 10g RAC, Oracle 11g RAC with ASM.
• Involved in Migration of Non RAC single instance to Real Application Cluster (RAC) database instances.
• Completely built Oracle standby database (Data Guard) to ensure high availability, data protection and disaster recovery for enterprise data. Automated the tasks to monitor whether primary and standby databases are in sync.
• Performed capacity planning and bench marking.
• Involved in Capacity Planning for databases based on the future business growth requirements.
• Implemented Cumulative, Differential, Incremental backups using RMAN
• Written and modified UNIX shell scripts, to manage Oracle environments and scheduled through Crontab.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and resolving space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Performance tuning of Queries by maintaining Aggregates, Compression, partitions, indexing and use of Hints, Stored outlines, Statistics for the same.
• Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and active session history.
• Cloning & duplicating databases using scripts as well as RMAN for QA and developers.
• Implementing Range, List Partitions, Hash Partitions and Global and Locally partitioned indexes.
• Applied security patches, Patch Set Unit PSU and Performed testing.
• Worked on Oracle Grid control. Maintaining the grid control alerts, configuring the rules, notifications, setting up metric settings, blackouts, advisors (Segment Advisor, SQL Tuning Advisor, Memory Advisor, SQL Access Advisor), and administration and performance tuning of databases and servers.

Environment: Red Hat Linux, AIX, Oracle 10g RAC and 11g RAC, Oracle Enterprise Manager/Grid Control, RMAN, Data Guard, ASM, SCP/SFTP, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, Crontab, PL/SQL, SQL* Loader.

Confidential, Austin,TX

Oracle DBA

Responsibilities:

• Involved in 24x7 support for Production database and applications with on-call pager.
• Installation and creation and maintenance of 10g RAC and 9i databases for Testing, Development and Production.
• Provided support to customers to manage their operational dataranging from GB to TB in Oracle database, solving of space problem, data loading problem and other database maintenance operations.
• Involved in upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from flat files and from text files.
• Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard. Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Implemented OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Oracle Sales Analyzer (OLAP front-end) in Oracle 8i / 9i environment, Data Migration as part of enterprise data warehouse project. Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities.Write UNIX Shell Scripts to schedule these activities.
• Contact oracle metalink to resolve database issues and to raise SR’s

Environment: 10g RAC/9i, ASM, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL*LOADER, Oracle Express..

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Involved in Installation, Upgrade from Oracle 9i to Oracle 10g and Configuration of Oracle NET services.
• Extensive experience in Performance Tuning, Memory Tuning etc.
• Applied patches including both one-off patches using OPatch as well as patch sets.
• Refresh/Cloning of database using data pump and RMAN utility.
• Standby Database setup and configuration.
• Worked alongside programmers and database developers for contributing to the development processes.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required
• Configuration of TNSNAMES.ora, LISTENER.ora for SQL*NET connectivity and resolving connection problems.
• Involved in decision making for the naming convention of datafiles, redolog files, tablespaces and segments.
• Partitioning Tables and indexes by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Written shell scripts and automated nightly jobs using crontab to schedule the backups, exports and refreshing databases from production.
• OS level Tuning and balancing I/O by monitoring file system and tablespace I/O statistics..

Environment: HP-UX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL*LOADER.

Confidential

Jr Oracle DBA

Responsibilities:

• Responsible for maintenance of production.
• Created tables, views, materialized views
• Database administration tasks included performing regular Hot&Cold Backups,Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments
• Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Maintenance & modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL*Loader.
• Develop, document and enforce database standards and procedures.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL*Loader, Data Pump