SUMMARY:

• Accomplished Oracle DBA with 4 years of experience in Oracle Database Administration in large - scale production environments across multiple platforms Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) 10g/11g, Data Guard. Ability to work both as an individual contributor and as a member of a team..
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Experience in configuring Data Guard. Implemented Physical Standby in latest project.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
• Monitoring and Optimising the Database Performances through Database Tuning, System Tuning, Application/SQL Tuning.
• Planning and scheduling Physical Backups (offline/online) and Logical Backups (with Export/Import utilities).
• Expertise in Unix shell Scripting (Bourne).
• Detecting and diagnosing production system performance problem by analyzing Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Experience in working with Large Tables and VLDBs.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Hands on experience working on High Availability Environments.
• Working experience on VMWARE.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone database to RAC environment.
• Experience in configuration and maintaining Oracle Physical Standby Database using Oracle Data Guard 10g and 11g.
• Knowledge in configuring ASM (Automatic Storage Management) for both the standalone database and RAC database environments.
• Plan, Implement and test disaster recovery system, using RMAN and custom written shell scripts.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• I have also successfully upgraded from 11g (11.2.0.3) to 12c (12.1.0.1) using Data Pump Utility.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.
• Extensive work experience in a database migration project team, serving in both an advisory and technical capacity
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Linux, Unix shell scripting, C, C++

RDBMS: Oracle 10g, 11g, 12c

Tools: Oracle Grid control, Oracle Enterprise Manager(OEM), TOAD, PUTTY, SQL Plus, SQL Developer, SQL Access Advisor, SQL Tuning Advisor

Utilities: SQL Loader, Export / Import, Expdp / Impdp, AWR, RMAN

Operating Systems: RHEL 4/5, Sun Solaris 5.8, 5.9, Windows 98/NT/2000/2003/XP/7, AIX: Protocols HTTP, TCP/IP, FTP, SFTP, SSH, Telnet: Office

Packages: Word, Excel, Power point, Access

Web Tools: HTML, XML

Database Modeling: SQL DEVELOPER DATA MODELER

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Oracle Database Administrator

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g and 12c, Sun Solaris

Responsibilities:

• Configured parameters for the Bi-directional replication.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.
• Experienced in Design, implementation and generating documentation of Oracle 10g and 11gData Guard on both physical/logical standby databases in high availability mode.
• Installed Oracle Streams as an enhancement for the Client's DW method and monitored Streams Issues using Grid Control and Implemented Oracle Streams unidirectional on table level.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) and Oracle 11g (11.1.0.7) to Oracle 11g (11.2.0.2 ) on Sun Solaris.
• I have also successfully upgraded from 11g (11.2.0.3) to 12c (12.1.0.1) using Data Pump Utility.
• Writing and modifying UNIX Shell Scripts to manage Oracle environments for Backend Processes.
• Developed SQL*PLUS&PL/SQL scripts for extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
• Replication of tables to cross platform and Creating Materialized Views.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and snapshots reports.
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

Confidential, Las Vegas, NV

Oracle Database Administrator

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g, MK4 Servers, T2K Servers

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Developed generic package for partition maintenance job for multiple environments.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
• Configured RMAN and performed daily backups.
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, tablespace, Control files, log files and user profiles.
• Installed, Configured and Administered Oracle Streams.
• Designed Logical and Physical Data Modelling using Sql Developer Data Modeler.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs in the database.
• Analyze the schema and tables.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 10g versions in RAC.
• Data Refresh from Production to Test and Development/QA environments using RMAN Duplicate Database.
• Responsible for all database activities such as User management, space management, database security management.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and Creating & Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using
• Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

Confidential, CA

Jr Oracle Database Administrator

Environment: RHEL 3.X, 4.X; Windows NT 2000/2003; Oracle 10g; LPARS; VMware ESX Server; Veritas Volume Manager; HP DL320,DL330,DL380; EMC Celerra NS; Hitachi; IBM arrays.

Responsibilities:

• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports.
• Modified Korn shell scripts as per technical specifications.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Involved in coding of data extraction scripts as per technical specifications.
• Analyzed the table structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.
• Maintain & troubleshoot Storage Disks from HITACHI, NetApp and EMC Celerra Storage arrays.