SUMMARY

• Over 7+ years of experience in Oracle Databases as Administrator in Enterprise level Database Administration, Management and Operations.
• Extensive experience in Installing, Designing and Managing Oracle 12c, ExaData, 11g RAC/10g RAC/9i/8i Databases on Windows, UNIX (HP - UX, IBM AIX, Sun Solaris),
• Installed/configured Oracle 11g/10g Real Application Clusters (RAC).
• Upgraded databases from Oracle 8i, 9i to 10g and Oracle 10g to 11g,
• Experience in a 24*7 Production Database support role.
• Extensive experience in Backup & Recovery (Hot, Cold, Logical and RMAN Incremental Backups)
• Expert in Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform using database tuning, SQL TRACE, TKPROF, Explain Plan, STATSPACK, AWR and ADDM.
• Experience in Table, Index Partitions for increased performance and for better storage management. Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Excellent experience in database cross-platform migration
• Expert in Installation, Configuration and Maintenance of Oracle Standby (Active Data Guard).
• Monitoring databases and setting alerts using Oracle Enterprise Manager/Grid Control
• Experience in database cloning/refresh, tuning, patch
• Experience in Writing Shell scripts.
• Experience in Capacity Planning & Benchmarking
• Excellent SQL and PL/SQL programming and debugging skills - Cursors, Functions, Stored Procedures, Packages and Triggers etc.
• Experience with Data Modeling, Logical and Physical database design.
• Excellent experience in managing Very Large Databases (VLDB).
• Experience in replication using Materialized Views, Oracle Streams and Golden Gate.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Proven ability to adapt to demanding schedules and changing priorities.
• Excellent analytical, interpersonal and communication skills.
• Able to work independently and collaboratively in Team environment.

TECHNICAL SKILLS

Database: Oracle 12c, ExaData, 11g RAC, Oracle 10g RAC, Oracle 9i, Oracle 8i, Oracle 7.3, MySQL, SQL Server 2008

Operating System: Sun Solaris 8, 9, 10, HP-UX 10.x, 11.x, AIX 5.1, 5.2, 5.3, 6.1 Red Hat Linux 4.x, 5.x, 6.x,Windows 95/98/ME/NT/2003/XP

Languages/Tools: Unix Shell Script, SQL*Plus, PL/SQL, C, C++, OEM/Grid Control/Cloud, Golden Gate, dB console, RMAN, AWR, ASM, ADDM, STATSPACK, SQLTRACE, EXPLAIN PLAN, TKPROF, Data Guard, SQL*Loader, OUI, dbca, Logical/ Cold/ Hot backup, Data Pump, SQL*Net, Toad

Ticketing Tools: Bridge Clarify, LEO, Citrix-Xen APP(DWNG),RDI,DB Symphony, DB Unity, GTO Supportal

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Using SRDF Technology for maintaining of one node RAC on Most of the Linux Systems
• Using TSM for backup and archives push(both Disk and Direct)
• Upgrade RAC Databases from 11.2.0.3 to 11.2.0.4
• Adding and deleting of node for the existing Cluster.
• Applied various versions of PSU Patches (recent were - 11.2.0.3.5 and 11.2.0.3.8 ) on the RAC Cluster.
• Install of 32 & 64 bit of 11.2.0.4 Oracle clients
• Re-enable of GG Replication from Source DB and the target DB
• Attending Weekly conference calls for the weekly progress of the upgrade work.
• Checking the logs for the successful backup of the database.
• Handling databases sizes range from 500GB to 2 TB.
• Running RDA tool (Remote Diagnostic Assistant) for checking prerequisites as a part of pre upgrade check on the server.
• Recommending the ASG Team for the sufficient size of the oracle home, swap-space and kernel parameter settings specific to the platform, as a pre-upgrade task.
• Schema Refreshes using expdp and Rman and execution of scripts
• Configure Databases in 10g/11g and 12c OEM
• Creation of RAC Databases of 10g and 11g Versions
• Oracle RAC Dataguard Switchover and Switchback with Broker configuration.
• Oracle RAC Dataguard upgrade from 11.2.0.3 to 11.2.0.4 with physical standby in place.
• RMAN resync implemented on the standalone and RAC Environments.
• RMAN Duplicate for Cloning of the standalone to the RAC cluster.

Environnent: Oracle 12c, ExaData, Oracle 11g Database, Red hat Linux AS4, 12c OEM, 11g Golden-Gate, ASM, RAC Cluster

Confidential, Seattle, WA

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installation, Configuration and Maintenance of Oracle 12c, 11g RAC/10g RAC, Standby database (Service Guard) for High Availability and Disaster Recovery
• Database upgrades from Oracle 11g to 12c, 10g to 11g.
• Database migrations from windows to Linux
• Worked with EMC on migrating SAN/NAS storage.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Worked on migrating VLDB, over 20TB of size.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication materialized views.
• Cloning databases using scripts as well as RMAN.
• Set up backup and recovery procedure using RMAN and setup Autosys jobs.
• Installed and Implemented Backup & Recovery procedures.
• Implemented Hot, Cold and Logical backup plans.
• Created duplicate databases using RMAN duplicate.
• Worked on TSPITR using RMAN.
• Installed and configured bi-directional Golden Gate for High data availability and Operational reporting.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces and Packages.
• Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.
• Applied CPU/PSU patches for oracle database version 11.2.0.3.
• Utilized SQL*loader and data pump import to load data into tables.
• Refresh schema-using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user logins.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
• Worked with Oracle support on different types of ORA-600 errors.
• 24x7 production database support during and after migration, till handoff to the BAU team.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Excellent analytical, interpersonal and communication skills.
• Enthusiasm in learning new technologies.

Environment: Oracle 12c, ExaData, 11g RAC/10g RAC, Sun Solaris, Red Hat Linux, Windows, OEM (Grid Control), RMAN, ASM, Golden Gate, SQL*Loader, Oracle Data guard, Streams, TOAD

Confidential

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installation, Configuration and Maintenance of Oracle 10g RAC/11g RAC, Standby database (Service Guard) for High Availability and Disaster Recovery
• Upgraded databases from Oracle 8i, 9i to 10g and Oracle 10g to 11g
• Migrated Databases from Linux to HP-UX, Windows to LINUX
• Allocating system storage and planning future storage requirements for the database
• Oracle Grid control installation and configuration for database monitoring
• Oracle RMAN configuration for backups to disk and tape. Implemented Backup & Recovery strategies and performed Disaster & Recovery drills
• Backup & Recovery (Hot, Cold, Logical and RMAN Incremental Backups)
• Planning and implementing Backup and Recovery procedures, scheduling daily backups and performed periodic recovery tests
• Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform using database tuning, SQL TRACE, TKPROF, Explain Plan, STATSPACK, AWR and ADDM
• Partitioned large tables for better performance and manageability
• Installed, Configures and Monitored OEM 12c
• Database Design (Conceptual Design, Logical Database Design, Physical Database Design)
• Capacity Planning & Benchmarking
• Data Loading using SQL*Loader, External Tables. Writing PL/SQL procedures for Extraction Transformation and Loading (ETL) data
• User roles and profile management for enforcing password complexity and securing databases
• Database security and auditing
• Applied CPU patches
• Creating Database objects like (Tables, Indexes, Views, Synonyms, Database Links, Materialized Views, PL/SQL Functions, Procedures, Packages, Triggers etc)
• Refreshing of database from production to development & test environments
• Optimizing the SQL’s for maximum performance EXPLAIN PLAN
• Daily databases Health check monitoring and troubleshooting if required
• Creating SR (Oracle Support request), follow up with Oracle support, running diagnostic scripts and upload output files to oracle support

Environment: Oracle 11g RAC/10g RAC/9i, Sun Solaris, HP-UX, Red Hat Linux, Windows, OEM 12c, RMAN, ASM, SQL*Loader, Oracle Data guard, Streams, Golden Gate, TOAD

Confidential

Oracle DBA

Responsibilities:

• 24x7 Production database and applications support
• Managing multiple production, development, test databases
• Administering Oracle 9i, 10g, 11g databases
• Setup Oracle10g RAC, 11g RAC
• Setup Standby databases for disaster recovery and reporting
• Upgrade database from 9i to 10g, 9i & 10g databases to 11g
• Cloned/Refreshed databases from production database to test and development
• Creating database objects like Tables, Indexes, views, Materialized Views and synonyms
• Adding tablespaces, data files to the databases
• Performing Hot Backup, Cold Backup, RMAN Incremental Backups, Maintaining High database availability for supporting non-stop Business Operations
• Implement and Maintain Database Security. Creating / Altering / Dropping Users as and when required and administer their respective quotas
• Monitoring the status of databases, logs, archived redo logs etc.
• Oracle User creation and Responsibility assignment
• Object maintenance e.g. Storage Parameters and rebuilding indexes
• UNIX Shell scripting for the automation of backups, cloning/refresh, monitoring file system utilizations, status of various oracle and UNIX processes etc.
• Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform using database tuning, SQL TRACE, TKPROF, Explain Plan, STATSPACK, AWR and ADDM
• Partitioned large tables for better performance and manageability
• Writing PL/SQL procedures for Extraction Transformation and Loading of data
• Setup monitoring OEM/Grid Control
• Worked on the tickets assigned to perform certain tasks such as taking export and Import, adding and dropping database users, granting and revoking the roles and privileges, database structure modifications etc.
• Applied CPU patches
• Creating Database objects like (Tables, Indexes, Views, Synonyms, Database Links, Materialized Views, PL/SQL Functions, Procedures, Packages, and Triggers etc.)

Environment: Oracle 11g RAC/10g RAC/9i/8i, HP-UX, IBM AIX, Red Hat Linux, Windows, OEM (Grid Control), RMAN, ASM, SQL*Loader, Oracle Data guard, Streams, TOAD