SUMMARY

• 7+ years of experience in Oracle Database Administration encompassing Installation, Configuration, Data Guard, Grid Control, Oracle Streams, Patch Installation, Migration, Upgrades, Patches, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance tuning and Data Modelling
• Installation and administration of Oracle 11g/10g/9i on OEL, RHEL, Windows, Unix and Sun Solaris in OLTP environment
• Performed Migration and Upgrade of 30+ databases to 11g and 10g
• Installation and configuration of Oracle Server 11g RAC with ASM & OCFS2 file systems on multi node systems, 11g, 10g and 9i in different operating systems according to OFA for OLTP and Data Warehouse environment on Very Large Databases(VLDB).
• Experience on oracle 11g/ASM/RAC and upgradation of standalone databases to 11g RAC environment
• Configuration of Automatic Storage Management (ASM)
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• 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, datapump export/import.
• Implementation of Flashback Technology Upgradation of databases applying patches, patch sets and critical patch updates downloaded from METALINK
• Experience in implementing replication using Quest Shareplex
• Experience of Oracle GoldenGate installation, configuration and troubleshooting Golden Gate issues.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Experience in web based applications utilizing Java and J2EE
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Implemented Oracle Advanced Security Options such as Data Encryption to ensure data privacy.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Experience on Oracle monitoring tools including Oracle SQL*Forms monitoring, Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Extensive experience in Shell Scripting
• Experience working with Database Resource Management
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• Experience using ERwin as a Data Modelling tool.
• Experience designing the DW model and the physical structure.
• Designing the ETL processes
• 24*7 on-call production database support and maintenance including remote database support
• DBA knowledge on Windows environment
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i, SQL Server 2000, 2005

Oracle Products: Oracle10g (Grid Control), OEM (Oracle Enterprise Manager), Oracle FailSafe (OFS), RMAN, SQL*Loader, Import and Export, DATA PUMP, APEX, ASM

Programming Languages: SQL, PL/SQL, JAVA, C, C++, Perl

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP Professional, Windows 2003 Professional.

Other Tools: Veritas Cluster Manager (Java Console) v3.5, TOAD, Erwin, Putty, Oracle Streams, Quest Shareplex, Rational Suite-Clear Quest, Rational Clear Case Atria, AutoSys, IBM TSM

PROFESSIONAL EXPERIENCE

Confidential, SanRafael

Oracle DBA

Responsibilities:

• Worked in a very high paced environment by providing production support for Tier1, Tier2 and Tier3 database applications, which included Siebel, Tibco, Java, Dataware house, Datamart and SAP related databases with 4 node and 3 node RAC, RON, Stage, Standalone and DR databases
• Monitored all the 11g and 10g databases, their respective organic growth and the performance by using OEM Grid Control 11g and Ignite
• Monitoring the Production and DR databases synchronisation on a daily basis and maintained the Sync report.
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software
• Migration of databases from 11g to 10g with a backward compatibility version option using datapump export/import utility
• Performed bouncing for the databases in a rolling fashion on RAC environment for bug fixing for SIEBEL application
• Weekly Data Refresh from Production to Stage and then to Development and Test environments using datapump export/import utilty
• Daily incremental level0 backup and weekly full backup for DR databases using RMAN
• Extensive experience in capacity planning, worked with storage team in co-ordinating the requirements for the LUNS addition to respective diskgroups in the appropriate ASM instances
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Tablespace monitoring, Performance monitoring and tuning for performance improvement
• Extensive experience in writing Shell scripts
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Interacted and Worked with Oracle Support (SR) whenever we faced production issues by meeting the required SLA’s without any breaches
• Daily health checkup of the database using TKPROF, AWR, ADDM, Explain plan
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Grid Control 11g, Ignite, TOAD, SQL Developer, Red Hat Enterprise Linux 5.5.,5.6 and 5.7, ASM, JAVA, HTML

Confidential, Bethesda, MD

Oracle DBA

Responsibilities:

• Upgradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment
• Oracle Grid Control 11g Installation and Configuration.
• Supported EDGE & EQUITY EDGE APPS
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software
• Migration of databases from 9i, 10g to 11g using export/import and datapump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using datapump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Replicated data using Oracle GoldenGate and import/export.
• Implemented Materialized views, database links
• Regular database management on 9i and 11g OEM
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Tablespace monitoring, Performance monitoring and tuning for performance improvement
• Extensive experience in writing Shell scripts
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Maintenance and setup of Oracle Virtual Directory in various environments including Production
• Managing, troubleshooting and resolving oracle database and application issues.
• Interacted and Worked with Oracle Support (SR) whenever we faced production issues.
• Daily health check up of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, IBM DB2, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM, JAVA, HTML

Confidential, MILWAUKEE

Oracle DBA

Responsibilities:

• Performing day-to-day activities such as creating users, roles, schemas, tables, views, indexes and running scripts given by the clients
• Creating and Maintenance of the Oracle databases on different servers.
• Installed and implemented 2 node 10g RAC on RHEL and worked on ASM features of Oracle.
• Installation, Configuration and Maintenance of Oracle RDBMS software.
• Performed upgradation of Oracle 10g databases to Oracle 11g using patches.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Dataguard.
• Installation, Configuration and Maintenance of Oracle Grid Control.
• Configured VERITAS clustering for the test environment.
• Setup of Jobs using the Oracle Grid.
• Setup of Cold Backup of test/development databases through RMAN for weekly maintenance.
• Data refresh from Production to Test and Development environments using RMAN duplicate database.
• Applied quarterly security patches, as well as patches for fixing bugs
• Migration of databases from MySQL to Oracle 10g using SQL Developer
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health check up of the database using STATSPACK, AWR, ADDM.
• Configured Oracle APEX for J2EE applications.
• Used J2EE components for designing and coding in Oracle 10g
• Involved in migration of applications of the clients.
• Maintenance of database security using Data Vault, VPD and Oracle Label Security
• Automating the routine DBA tasks through cron.
• Worked on uploading large batch of transaction data using batch processing technique.
• Implemented Oracle Streams and GoldenGate for data replication and synchronization.
• Loading the data into database with SQL*Loader and External Tables.
• Supported different databases like Production, Testing, Staging and Training.
• Granted permissions to end users according to their level of access to database objects.
• Performing Maintenance activities like converting Non-Partitioned tables into Partitioned tables.
• Monitoring the database daily activities through the Grid.
• Monitoring alert log/system log.
• Defragmentation of tables and indexes for improved performance and efficiency.
• User access administration
• Mixed NT/Unix environment with integration into Clear Case.
• Used Rational Clear Quest to track and report system defects and bug fixes

Environment: Oracle 10g, 11g, MySQL, SQL, PL/SQL, Oracle Grid Control, TOAD, Oracle Enterprise Manager, SQL*Loader, Cognos, Informatica, Clear Case, Clear Quest, NT, Sun Solaris, Red Hat Enterprise Linux, Unix, AIX.

Confidential, Raleigh, NC

Oracle DBA

Responsibilities:

• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the production database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches
• Responsible for maintaining Oracle 10.1.0.2 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Configured the VERITAS clustering for Oracle on the production and pre-prod databases.
• Migrated databases from 10g to 11g using transportable tablespace and datapump
• Responsible to schedule backups through RMAN.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Used Flashback table to restore tables which is a new feature of Oracle 10g.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
• Implemented scripts to capture high resource utilization queries.
• Implemented scripts for daily monitoring like db status, no of extents, free space etc.
• Implemented Oracle Advanced Security Options
• Maintained multiple terabyte databases on oracle.
• Cloned the production database periodically to the testing databases through SQL backtrack.
• Monitored the Oracle Streams topology and performance.
• Identified the long running transaction through V$session longops and alsofor Rollback monitoring which is an enhanced feature of Oracle 10g.
• Used EM on Oracle 10g for diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.
• On-Call 24x7 DBA support for production databases.
• Re-engineered system to J2EE using Oracle 10g backend database.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
• Tuned the SGA. Monitored the shared Pool, Database buffer cache and Redo log buffers.
• Monitored Tablespaces and Segment fragmentation. Performed trouble shooting activities, created new users and assigned privileges and roles to users.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g/11g, PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Rational Clear Case Atria, Quest Software (5.0), VERITAS Cluster, RMAN.

Confidential

Oracle DBA/Developer

Responsibilities:

• Designing, creating, operating, maintaining and troubleshooting of Oracle databases.
• Implemented 2 node Oracle 10g RAC on RHEL 4.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC
• Responsible for maintaining ORACLE 10.1.0.2 using SRVCTL, OEM, maintaining Oracle Clusterware using CRSCTL.
• Setup standby database via Data Guard for database disaster recovery.
• Installation of Oracle Patches
• Extensive experience on Automatic Workload Repository feature of Oracle Database 10g.
• Writing PL/SQL procedures.
• Backup and recovery utilizing RMAN
• Implemented flashback technology.
• Implemented materialized views.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Responsible for optimizing data access and performance by tuning indexes and Oracle performance tuner/optimizer tools liked Explain Plan, STATSPACK, Sql Trace.
• Creation and maintenance of control files, redo log files and data files.
• Creation and maintenance of table spaces, rollback segments and data objects.
• Worked on Oracle 9i OEM for regular database management.
• Monitoring alert log/system log.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.
• Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.

Environment: UNIX, Oracle 9i/10g, PL/SQL, Maestro, Shell Scripting, Java, HTML, Oracle forms and reports 6i/9i.