SUMMARY

• 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• 8 years of wide experience as Oracle DBA in Linux, Unix and windows environment.
• Experience in installation and maintenance of Oracle 11g & 10g RAC using both ASM and OCFS2 File System.
• Installation, maintenance and tuning of RAC Applications. Used Oracle Application maintenance utilities like OEM.
• Experience in designing and configuring high - availability systems using DATAGUARD with physical standby effectively configured and used DATAGUARD BROKER utility.
• Expertise at installing Oracle 10g features like ASM and Grid monitoring.
• Experienced in Clusterware(GRID Infrastructure)-CRS management and configuration .
• Extensively experienced in Oracle Database monitoring and Tuning using GRID control/Oracle Enterprise Manager (OEM) monitoring.
• Experienced in maintaining and managing Oracle 10g, 11g RAC, and Exadata databases.
• Performed FLASHBACK features to handle efficient database recovery and implementing restore points for testing.
• Experience in backup and cloning using RMAN procedures.
• Designed and implemented Database Backup and Recovery strategies using RMAN, OEM, Veritas Netbackup and TSM (Tivoli storage manager) backup.
• Experienced in fixing the Performance issues in Data guard/RAC/Exadata.
• Experienced in configuring Mail Sessions on Weblogic Servers.
• Experienced in configuration and management of Web Application Servers.
• Experience in Data Migrations using oracle Export/Import, Data Pump, RMAN, SQL*Loader, and Statspack.
• Experienced in Unix Shell scripts for hot backups, export and import of database and Writing Triggers and debugging Stored Procedures, Functions-PL/SQL and SQL scripting.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Resolved Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
• Good at monitoring server performance, database transaction log growth and error logs.
• Experience in configuring and Installing/using various Quest Tools- Foglight, TOAD.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Expertise in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.
• Experienced with hardware sizing and capacity planning .
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like UTLESTAT, AWR, ADDM.
• Expertise at Tuning Database Server at Hardware level,OS Level and Oracle Database Level.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 98/NT/2000/2003

RDBMS: Oracle 11gRAC/10gRAC/9i/8i/7, SQL Server 2005/2008, Weblogic Application Server (8.1 /10/10.3)

Languages: SQL, PL/SQL, J2EE, HTML, XML, Dynamic SQL, C, C++, UNIX Shell Scripting, Perl Script, XML, Visual Basic, SQL Scripting.

DB Management: TOAD, OEM, Grid Control.

Tools: /Utilities: RMAN, OEM Grid Control,GoldenGate,SQL Navigator, SQL* Loader,Oracle SOA, ORACLE WLS,ASM, SQL Server, DBCA,DBUA, Oracle Data Guard, Export/Import, Patch Management, Oracle Warehouse Builder, Tivoli SQLNET,ODBC, Data pump, VERITAS Net Backup, Remedy Ticketing system.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Database Modeling: Erwin 4.X, Navicat.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati OH

Senior Oracle DBA

Responsibilities:

• Installing, Configuring, Updating and Managing Oracle 10g/11g RAC and Single instance Databases on solaris.
• Upgrading the 50 databases from 10g(10.2.0.4) to 11g(11.2.0.3).
• Establish and maintain sound backup and recovery policies and procedures
• Perform Dataguard switch over and upgrades.
• Create indexes, triggers and reorganization of indexes online .
• Write SQL scripts to perform various Database Activities and execute them in Nohup mode.
• Implement and maintain database security setting up auditing and create and maintain users and roles, assign privileges.
• Perform general technical trouble shooting and give consultation to development teams
• Interface with Confidential for technical support
• Evaluate Oracle features and Oracle related products
• Applying patching to Solaris-Aix servers.
• Creating LRC’S for adding space to tablespace’s and forecast the growth of database size.
• Performing periodical Backup, Restoration and Recovery using RMAN (full & incremental)
• Developed RMAN scripts for backup and recovery of databases.
• Setting up Cron jobs to run rman backups and logical backups automatically daily
• Setting up DDL audit on all production databases in order to capture all DDL against objects.
• Ability to perform both Oracle and operating system performance tuning and monitoring
• Schedule restarts of Oracle listeners to prevent Listener log files from getting to large.
• Monitoring Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Implement in code migration, database change management and data management through the various stages of the development life cycle.
• Upgrading the Grid monitoring from 11g to 12c OEM /OMS console.
• Setting up threshold limits and maintain same template,apply it across the similar platforms to maintain consistency
• Monitoring and maintenance of multiple databases for production, development, testing and Staging using utilities like 12c OEM.
• Changing memory parameters to improve performance of database upon suggestions from architecture team.
• Make sure there is no archive Gap between standby and primary Database.
• Tuning the operating system, network, and transaction processors to work with the database.
• Perform Reorganization of indexes semi-monthly and refresh the Databases for every two months.
• Worked on EMC Data Domain Powerful data protection management with automated analysis and alerting across backup.
• Conducting load tests on various applications to improve performance and analyze AWR reports daily.
• Performed database tuning using Explain Plan, AWR, ADM and Oracle Enterprise Manager.
• Perform database tuning and performance monitoring.
• Setup and maintain documentation and standards
• Implementing database security by setting up auditing.
• On call production support daily from 4Pm-1Am.

Environment: Oracle 11g/10g,RAC, RMAN, PL/SQL, 12c OEM,DML and DDL, Auditing, Data Guard, Solaris-AIX, Remedy Ticketing System, EMC Data Domain,SQL scripting.

Confidential, Newport, NJ

Senior Oracle DBA

Responsibilities:

• Installed Oracle Database 11g with Real Application Cluster (RAC) and ASM in Linux environment.
• Configured RAC Physical standby database using ASM filesystem.
• Worked on creation and deletion of RAC resources like listener/instance. Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Worked on 2 nodes RAC databases.
• Worked on performance issues related to RAC Cluster Interconnect performance.
• Performed DataGuard testing (SwithchOver) on a regular basis to ensure High Availability.
• Upgrading databases from 10.2.0.4 to 11.2.0.1 and 11.2.0.2 using DBUA and manually.
• Cloning of 1TB database to 3 different databases using RMAN for configuration of hierarchical.
• Experienced inOracleSupport (raising SR) processes for technical requests through MetaLink
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall .
• Involved in Data Modeling along with PL/SQL developers to optimize the flow of data.
• Experienced in Installing, configuring and Upgrading Weblogic Application Servers.
• Involved in Deployment with a J2EE, EJB, JSP, HTML, and XML based solutions.
• Set up Application Sever, Apache MS IIS, and HTTP for different application development projects.
• Experienced in Configuration and set up of web and application server instances including Clustered and Non-Clustered environment - Load balancing setup and maintenance.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Monitoring and maintenance of multiple databases for production, development and testing.
• Performed Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• 24 X 7 on call support of all production environments in --group supported by our team.
• Data migration between environments using Export/Import, expdp/impdp, Transportable Tablespace, and Oracle Streams.
• Cloned databases from Production using RMAN Duplicate.
• Enabled data dictionary protection, changed default passwords, restricted operating system access and network access and used database firewalls for security .
• Cleaning the database by killing the sessions, which are affecting the performance of a database.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Maintain data security by creating views, DB owners/users and granting/revoking permissions and roles.
• Implemented security configuration for Oracle software and database instances to comply with existing standards.
• Written Shell scripting which monitors the server’s performance and logs output on periodic basis to database.
• Skilled in Performance Monitoring/ Tuning/ Troubleshooting for Oracle in UNIX, Windows NT/XP/2000 servers using tools like TOAD, EXPLAIN PLAN, SQL Trace, spotlight, TKPROF and SQL Tuning Advisor.
• Monitoring of the queries with high response time and high disk reads per execution and tuning the same using TKPROF.

Environment: Oracle 11g/10g, RAC, RMAN, PL/SQL, Stored procedures, Toad for Oracle, OEM, Auditing, Linux 5.5, Data Guard, weblogic, J2EE, Apache, HTML.

Confidential, St. Louis, MO

Oracle DBA

Responsibilities:

• Installing, Configuring, patching and managing Oracle 10g/11g RAC and Single instance Databases with 100 GB to 2 TB sizes.
• Worked on 2 node RAC performance issues related to RAC Cluster, ASM and Cluster Interconnect issues.
• Provided on-call production database support. Moved database Schema changes to stage or production. Installed and setup replicated instance of Oracle database for supporting Internet application and reporting.
• Expertise at Installing of Oracle10g 2 Nodes RAC with Clusterware and ASM.
• Experienced in the installation of Oracle Grid Control and Implemented datafiles using ASM.
• Experienced in implementing ETL process and Oracle Streams replication.
• Experienced in Installation and configuration Oracle GoldenGate for data integrity and consolidation.
• Performed Schema as well as Table level Replication using Oracle GoldenGate and also did set up Disaster Recovery solution using GoldenGate.
• Experienced in using 11g, 10g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, 10g Grid Monitoring, Recycle Bin.
• Configured ASM disk groups to store Data files, redo log files, and control files.
• Expertise with different Backup and Recovery strategies, Cloning (using Recovery Manager - RMAN), creating RMAN scripts, VERITAS Net Backup, Export / Import, DataPump, TTS, and Hot and Cold back-ups.
• Cloned of 1TB database to 3 different databases using RMAN.
• Performing periodical Backup and Restoration and recovery using RMAN (full & incremental) and RMAN incrementally updated backups.
• Analyzed and monitored wait events on production databases to implement improvements for buffer busy waits/sequential & scattered read contentions.
• Experienced in Bulk Loading of data from flat files using SQL*Loader.
• Expertise at using SQL*Loader Tool.
• Extensively experienced in Oracle Database monitoring and tuning using Oracle Enterprise Manager (OEM) monitoring.
• Created partitions, objects and indexes for tables for a 2 TB database to improve performance.
• Developed advanced shell scripts, SQL and PL/SQL scripts in support of database operations
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Expertise in creating Users, Roles and Profiles and Privilege management with role-based security.
• Applied relevant security patches for both operating systems and oracle.
• Performed database tuning using Explain Plan, Hints, Toad, AWR, ADDM and Enterprise Manager.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc
• Provided advanced technical troubleshooting for applications and database systems with emphasis on root cause analysis.
• Monitored the performance and tuned UNIX Servers using TOP,VMSTAT,IOSTAT,NETSTAT and SAR.
• Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommended solutions for faster execution.

Environment: AIX, Oracle 11g, GoldenGate,OEM, Erwin 4.0, RAC, Data Guard, Export/Import, SQL*Loader, RMAN, Linux 5.0, VMware.

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for both production and development databases with on-call.
• Installed 9i and 10g databases for Testing and Development
• Upgradation of Database from 9.2.0.6 to 10.2.0.2 and patching.
• High availability 24/7, Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
• Performed database Cloning to setup test and development database.
• Applying patches using OPATCH and applying patch sets using OUI.
• Implementation and maintenance of read only snapshots and snapshot logs.
• Implemented database security by setting up auditing, roles and privileges.
• Create database schemas, tables, indexes, tablespaces, data objects, packages, procedures and functions.
• Well versed with the usage of Oracle export and import utilities.
• Developed RMAN scripts for database backup and recovery.
• Developed SQL Scripts for maintenance of various Database Activities.
• Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities)
• Tune the SGA components like buffer cache, shared pool to avoid paging & swapping hence reducing I/O bottle-necks in 9i, 10g environment.
• Doing the regular activities like monitoring the alert logs, redolog status, listener, v$session and checking the space for normal segments, rollback segments.
• Provide support to development teams for the conversion like creating database objects, Schemas creation, tables, indexes, constraints etc.
• Tuned SQL Queries using the Tools such as TKPROF and EXPLAIN PLAN
• Experienced with the Unix operating system and command set as well as competence with shell scripting.
• Conducting sizing & capacity planning for Oracle databases.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.

Environment: Oracle 10g,9i and 8i, Linux 5.0, Sun Solaris 9, IBM AIX,Tkprof,OEM,NET8.

Confidential

Oracle DBA/Developer

Responsibilities:

• Database Installation and embedding oracle base software into the product on multiple platforms.
• Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade support for approximately 40 Oracle databases.
• PL/SQL Programming in developing automatic partition management.
• Administer, maintain, develop and implement policies and procedures for Managing DB Security and alert log entries.
• Resolve database performance issues, database capacity issues, and distributed data issues.
• Developed RMAN scripts for backup and recovery of databases.
• Database Design, Schema Design, Performance Monitoring, Tuning.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Created disaster recovery procedures and performed Backup/recovery.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption.
• Safe Guarding Customer Data by ensuring that tables with sensitive and critical data can be accessed by only selected group of users as per client requirement.
• Migration of data from SQL Server 2005 using DTS and loaded into oracle Database.
• Using EXPLAIN plan utility to analyze the cost involved in query processing and tune it for faster retrieval.
• Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc as per the given structures, operations, data in the tables for increased performance. support of database with features like partitioning with PL/SQL calls to collect stats, Index maintenance.
• Implemented database security by setting up auditing, roles and privileges.
• Worked on performance tuning of SQL and Procedures and packages.
• Created Cron jobs in production to automate production tasks.

Environment: Oracle 9i/ 8i, Sun Solaris 9, 10, Red Hat Linux, UNIX Scripting, PL/SQL.

Confidential

Jr. Oracle Developer/ Database Administrator

Responsibilities:

• Planning, Installation and Configuration of Oracle Database on the Server.
• Making changes to the parameter file as requested by the customer and ensuring a clean database startup for the changes to take effect.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Writing SQL DML and DDL scripts for data modification.
• Wrote Stored Procedures for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Used extensive Sub Queries, PL/SQL procedure, DDL functions, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Responsible for physical and logical backups of database.
• Writing PL/Sql procedures and functions. Writing shell scripts to automate the data loading.
• Performed Database Tuning. Performed Database Security and Integrity.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i, UNIX (Sun Solaris), SQL*PLUS, Quest software tools, Export/Import.