SUMMARY

• 9 years of IT experience as an Oracle database administrator on RAC, streams, data guard, golden gate installation, migration, designing, backup, recovery, scripting, performance tuning etc. spanning in various industries like Banking, Financial sector, Wireless & Telecommunication sector, Medical sector in production as well as development databases.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g on Operating Systems UNIX, Linux and Windows platforms.
• Expertise in implementing EM12C high Availability.
• Implemented Oracle Enterprise Manager 12C using 2 - system upgrade on a 2 node RAC repository with dual OMS and SLB.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g / 11g.
• Knowledge on Golden Gate Installation and Migration.
• Expertise in RAC 11g,10g installation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, UNIX shell scripting and documentation.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin and Visio.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, & IBM TSM Storage Manager.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Expert in SQL* Loader, export/import and data pump to load data in to tables.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Expert in implementing oracle streams, and two types of standby databases supported by dataguard, logical standby and physical standby databases
• Expert in implementing development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Worked on very large database (VLDB) of 2TB with 23 servers including 5 productions, 12 development databases.
• Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
• Implemented development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise
• Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.
• Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and other Support Procedures
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• A very good team player, self motivated, dedicated in any work environment.

TECHNICAL EXPERIENCE

Databases: OLTP, Data warehouse, Oracle Databases11g/10g/9i, SQL Server 2000.

Languages: SQL, PL/SQL, UNIX Shell, Perl, XML

Tools/Utilities: OEM 12C, RMAN, OEM, TOAD, Oracle Management Server, SQL*Loader, SQL Server, Data pump Export/Import, Query builder, Net Backup, Crystal Report, Data Guard.

Tuning Tools: TOAD, OEM, DBArtisan, OEM Grid Control.

Shell Scripting: UNIX Shell Scripts on Sun Solaris, HP-UX and Linux platform

Operating Systems: RHEL 3.0/4.0, HP-UX 10/11.21, 11.31, AIX 4.3, Solaris 8/7,SunOS 5.10,Oracle Linux, Windows 2003/2000/NT

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

ORACLE DBA

Responsibilities:

• Upgraded 10g OEM to 12C using 2 system upgrade on a 2 node RAC repository with dual OMS for high availability.
• Deployed and configured 12c agents.
• Expertise in monitoring, troubleshooting OEM 12C.
• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Supported Oracle 11gR2 RAC databases..
• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on Linux.
• Monitoring and supporting more than 100 database instances using scripts and daily health check like alert logs, invalid objects, tablespaces usage, long running queries, backups, listener up and running, etc.. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send an alerts in email. Also, wrote scripts for monitor Shareplex and migration monitoring and purging.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Involved in building backup and recovery plans for critical databases from failures with minimum downtime.
• Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.
• Provided Assistance to application team at the time of SQL tuning in applications.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc.. .
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Experience in Data modeling using Erwin tool.
• Installed, Configured and Supported application which had 4-way shareplex replication.
• Upgraded databases from 9i, 10.2.0.4 to 11.2.0.2.
• Worked on Table partitioning to increase performance.
• Responsible for network configuration and involved in a Client - Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.
• Created and Managed users, user profiles, tablespaces, datafiles, archive log.
• Monitored and troubleshooted database issues with OEM grid control.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10, HP-UX 11.11,Linux,Db artisan, AIX, Shell Scripting, RMAN, Datapump, OEM Grid Control.

Confidential, wilmington, de

ORACLE dBA

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and productionsupport of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Sun Solaris, Red Hat Linux.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Performed 24/7 on call pager support.
• Installed and administered Real Application Cluster (10g, 11g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility. Wrote Shell scripts for Alerts for ORA-errors, backup and recovery, Import and export procedures
• Upgrade/Migration of Databases from Oracle 10g to 11g.
• Creating new user accounts, profiles, and roles and assigning them to users.
• Assigning users to groups and granted privileges and permissions to appropriate groups.
• Worked closely with developers in schema design and SQL tuning, performed database capacity planning, performance tuning at system level, database level, and SQL level.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
• Designed and built an additional system / database monitoring system to proactively detect potential performance problems and provide early warning.
• Reporting and resolving all serious Oracle alert log messages.
• Installed and Implemented Backup & Recovery procedures. Implemented Hot and Cold Backups, Exports, Imports, Data Guard, Flashbacks.
• Successfully developed and implemented monitoring scripts, health check scripts, Database backup scripts.
• Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, LOGICAL STANDBY and PHYSICAL STANDBY databases.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.
• Ensured availability and performance of the databases.
• Proactively monitored the database systems to ensure secure services with minimum downtime.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.
• Conducted impact analysis on upgrades, security.
• Rollout database builds in various production and non production environments.
• Designing and managing logs, back-ups and recovery procedures using RMAN.
• Writing PL/SQL triggers, procedures, and functions.
• Creating and Managing Table Spaces, Tables, Views, Indexes, and Partitions.
• Optimized the query result cache for best performance.
• Perform logical and physical database design to support client customers.
• Ability to manage multiple instances in Dev/QA/Stage/Production.
• Prepare current database structure and configuration for high-performance/high-availability through analysis and optimization.
• Perform database monitoring utilizing a combination of Oracle Grid Control and UNIX shell scripts.
• Provided 24*7 Production Support.

Environment: HP-UX 11.11, Oracle 11g, 10g and 11g RAC, Sun Solaris, Red Hat Linux, TOAD, ERWIN, RMAN, Data pump, SQL server, OEM, Grid Control, Data Guard, STREAMS, TKPROF, STATSPACK, Diagnostic and Tuning Advisors.

Confidential, raleigh, NC

oracle database adminstartor

Responsibilities:

• Good experience working in Data Center applications for several mission critical systems which utilize multiple Oracle databases.
• Actively involved in Production Server Migration and successfully deployed databases on to new servers.
• System Study & Analysis, Design &Development.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Performed Oracle RDBMS Installation, administration, configuration, troubleshooting and performance tuning.
• Installed Oracle 10g database on Sun Solaris, Red Hat Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Installation of ASM into various storage parameters like SAN and NAS.
• Thoroughly performing patch analysis and applying RDBMS patches and Oracle Apps Patches using Opatch and adpatch.
• Creating and managing tablespaces, adding and resizing datafiles, and performing disk space management.
• Creating new user accounts, profiles, and roles and assigning them to users.
• Assigning users to groups and granted privileges and permissions to appropriate groups.
• Reporting and resolving all serious Oracle alert log messages.
• Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans.
• Successfully developed and implemented monitoring scripts, health check scripts, Database backup scripts.
• Worked on Data pump import/export and SQL- loader.
• Setup backup and recovery procedures using RMAN.
• Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, LOGICAL STANDBY and PHYSICAL STANDBY databases.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.

Environment: AIX 5.3, Sun Solaris 10 and Red Hat Linux, 9i, 10g, SQL*Plus, PHP, MYSQL and HP QC tool.

Confidential, San Jose, CA

oracle database adminstartor

Responsibilities:

• Performing 9i and 10g Oracle Databases Administration, Monitoring and Patch application.
• Installation, Configuration, Designing and Maintaining of Oracle 10g on AIX 5.3, HP-UX 11.11.1, Sun Solaris 10 and Red Hat Linux.
• Installed and Configured Oracle 10g RAC (2 node cluster), CRS using ASM.
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g.
• Experience in Upgrading database 10.1 to 10.2 and applied patch set 10.2.0.2 to multiple databases.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintain primary and standby databases.
• Monitoring servers, reports generation and administrating physical Standby database.
• Configuring and troubleshooting RMAN backup & recovery issues.
• Worked on 24X7 critical Data Center applications.
• Recovered successfully two production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors and loss of control files.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
• Extensively used Oracle utilities -Export, Import, data pump and Sql loader etc.
• Creating physical databases, as well as the schemas and objects within the database.
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.
• Monitoring the database, Managing sessions, listeners, underlying physical components against performance and availability thresholds.
• Creating user accounts within the database and granting roles and privileges as requested, in accordance within the security compliances.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, AWR, Explain Plans, ADDM and monitor the database performance on daily basis.

Environment: Sun Solaris, SUN SPARC, HP-UX, Windows 98/NT/2000, IBM X Series Server, Oracle 9i, Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN

Confidential, va

Responsibilities:

• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Logical and Physical Modeling using ERWIN Data Modeler.
• Management of tablespaces for different users by granting quota on Default & Temporary tablespaces.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects UNIX Shell scripting. Implemented for capacity planning.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
• Implemented and maintained streams for synchronization of data at various sites.
• Utilized SQL*loader and data pump import to load data into tables.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Took a logical backup of the entire database using import/export utility.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.

Environment: Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TPROF, Explain plan, STATSPACK, SQL* Loader, Windows NT/2000.