SUMMARY

• Over Nine (9+) years of experience as an Oracle DBA.
• Worked as a production support DBA - supported fairly large production instances requiring 24 x 7 support.
• Versatile team player with excellent presentation, communication and inter personal skills.
• Worked on regular day to day DBA activities which includes installation, database tuning, creating objects, implementing backup strategies, crash recovery, space management, logical backup and database security etc
• Worked independently as the LEAD DBA to support and maintain all the databases in the organization.
• Worked on Oracle 10g RAC & 11g RAC Design and Implementation.
• Worked on Installing RAC and troubleshooting performance on RAC.
• Experienced in Golden Gate install, configuration, maintenance and trouble shooting.
• Worked on managing and troubleshooting ASM.
• Have knowledge on the EMC storage.
• Have Knowledge on EMC related SAN storage replication technologies.
• Resolved the issues with CRS (Cluster ware).
• Worked on Installation and managing OEM 11g.
• Worked on resolving the issues on Data guard.
• Implementation and support of 10g and 11g Migrations.
• Planning and Implementing Upgrades to 10g and 11g.
• Have experience on installation and troubleshooting on Oracle 12c database.
• RMAN Backup and Recovery including cloning strategies.
• Worked on database monitoring and SQL performance tuning.
• Implemented backup and recovery strategies using RMAN and have scheduled RMAN SCRIPTS through OEM.
• Performed and tuned Oracle Databases using AWR, OEM Grid and Tkprof etc.
• Worked on implementation of Data pump and Export/Import.
• Experienced in capacity planning and space management. Extensively used SQL*Loader for data loading from flat files and other databases.
• Automated several jobs using CRON.
• Configuration of listeners, tnsnames on UNIX environment for oracle databases.

TECHNICAL SKILLS

Database Installation/Management: Oracle 11g/RAC, 10g/RAC,9i 8i, MS Access, SQL Server.

Tools: Toad 7.6, ERWIN 4.x, Developer 2000, SQL Navigator, Remedy, Red mine.

Operating Systems: Red Hat Linux, Sun Solaris, HP-UX, Windows 2000, AIX.

Programming Languages: SQL, PL/SQL, Java, C, C++, Shell Scripting, JDBC, ODBC, OCI.

Documentation Tools: MS Visio, MS Word. by Savings Sidekick">Data modeling tools Erwin, ORACLE Designer.

Backup/Recovery: RMAN, User Managed Backup/Recovery.

High Availability: RAC, CRS, Grid Infrastructure, GoldenGate, Data Guard, Replication, Automatic Storage Management (ASM).

Tuning: operating system, network, database parameters, SQL and PL/SQL.

Tools: Oracle Enterprise Manager (OEM), DBVerify, LogMiner, SQL*Plus, Tkprof, SQL*Loader, Import/Export, Data Pump, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).

Planning: logical and physical data modeling, normalization, replication, integrity and security.

Capacity Planning: performance analysis of database servers and storages in standalone and clustered environment.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Oracle DBA

Responsibilities:

• Build RAC cluster both primary and standby using BBDA Tool.
• Worked on tickets assigned to the team.
• Worked on resolving the issues on Standby databases.
• Sync primary and the standby RAC databases.
• Provided solutions for various Cluster related issues.
• Upgraded Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4.3
• Worked on resolving ASM and LISTENER issues.
• Fix performance related issues at the OS level.

Environment: Oracle 10g,11g, RAC, CRS, Grid Control, ASM, OEM 11g, Toad, RHEL 6.4, UNIX, EMC, RMAN, Data guard.

Confidential, Newyork City

Sr. Oracle DBA

Responsibilities:

• Setup 6 node standby RAC cluster for 6 node primary RAC cluster.
• Setup Dataguard broker for the newly created standby RAC cluster and performed switchovers based on the business need.
• Worked on resolving the issues on Standby databases.
• Created scripts to verify the Dataguard synchronization.
• Created and cloned databases on RAC.
• Provided solutions for various RAC and SCAN related issues.
• Upgraded Grid Infrastructure from 11.2.0.1 to 11.2.0.3.8.
• Created and managed services to provide server side load balancing.
• Worked on troubleshooting issues related to ASM and disks.
• Worked on Maintaining and troubleshooting Golden Gate.
• Worked on adding additional Disks and Disk groups to the ASM.
• Worked on resolving Oracle alerts from OEM.
• Worked on Oracle 12c database.
• Worked on database BACKUP and RECOVERY using RMAN.

Environment: Oracle 10g,11g, RAC, CRS, Grid Control, ASM, OEM 11g, Toad, RHEL 5.5, UNIX, PL/SQL, EMC, Netapp, Golden Gate, RMAN, Data guard.

Confidential, Washington DC

Sr. Oracle DBA

Responsibilities:

• Supported a 2 Node cluster.
• Created databases on RAC cluster.
• Experience in the installation & resolution of RAC related issues.
• Experience in managing Clusterware (GRID Infrastructure) - CRS management and configuration.
• Worked on Cloning databases on RAC.
• Setup the Backup strategy for all the databases on RAC.
• Implemented strategy for partitioning and management of historical data tables in RAC.
• Carried out a strategy to direct OLTP transactions and ad-hoc queries to separate RAC nodes using database service name. This helped system to manage workload effectively.
• Worked closely with the EMC storage vendor and resolved storage related issues.
• Worked on troubleshooting ASM.
• Worked on adding additional Disks and Disk groups to the ASM.
• Installed OEM 11g on Web logic server 10.3.2.
• Applied patches on Repository database, OMS and installed agents on RAC database to monitor through grid control.
• Responsible for the evaluation and implementation of Oracle alerts using oracle OEM.
• Performed backup and restore using OEM.
• Installed Peoplesoft plugin on OEM for the Peoplesoft tool 8.2.
• Worked on Peoplesoft Application Management suite on OEM.
• Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Provide technical support for database maintenance and disaster recovery.
• Worked on database BACKUP and RECOVERY using RMAN.
• Worked on Managing the Data guard for switch over and fail over tasks.
• Experience in managing Data warehouse applications that are based on the control center, OWB mappings using the ETL tools etc.
• Worked on installing OWB on RAC.
• Setup and maintained Golden Gate replication on 11g RAC.
• Setup Bi-directional and Multitarget replication using GoldenGate.
• Upgraded Oracle Databases from 9i to 10g and from 10g to 11g.
• Experience on Oracle Database Tuning.
• Worked on SQL performance tuning using SQLT tool and Oracle SQL optimizer tool.
• Worked on generating Explain plan and TKprof to tune the Sql’s.
• Copy databases on different servers using tools like Export/Import, SQL Loader etc.
• Writing & managing triggers and stored procedures, write scripts for ad hoc queries and modifications.

Environment: Oracle 10g,11g, RAC, CRS, Grid Control, ASM, OEM 11g,12c, Toad, RHEL 5.5, UNIX, Windows 2003, PL/SQL, EMC, RMAN, Data guard, Golden Gate.

Confidential, Columbia, MD

Sr. Oracle DBA

Responsibilities:

• Setup Oracle 2 node RAC cluster. Installed Cluster ware, configured ASM storage, tuned application for Partitioning and Parallelism.
• Supported RAC and DATAGUARD environments.
• Designed and implemented Oracle Real Application Clusters (RAC) on unix for an OLTP application with Transaction Application Failover and high transaction volume.
• Implemented strategy for partitioning and management of historical data tables in RAC.
• Created Dataguard physical standby database as DR Solution for production database using RMAN.
• Carried out a strategy to direct OLTP transactions and ad-hoc queries to separate RAC nodes using database service name. This helped system to manage workload effectively.
• Maintain the Oracle 10g RAC environment and troubleshoot performance problems.
• Responsible for the evaluation and implementation of Oracle alerts using oracle OEM.
• Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Provide technical support for database maintenance and disaster recovery.
• Involved in the creation, installation, configuration of the Oracle Databases.
• Upgrading Oracle Databases from 9i to 10g and from 10g to 11g.
• Worked on backup and recovery procedures.
• Created backup plan design and implementation using cold/hot backups, Flashback and RMAN backup technology.
• Reorganized the database architecture to work efficiently and for better performance.
• Troubleshooting and performing RE-ORG of tables, archive logs and data files etc.

Environment: Oracle 9i, 10g,11g, RAC, Grid Control, SQL Loader, Toad, Linux, UNIX, Windows 2003, PL/SQL, RMAN, CRS, Shell scripting, Data guard.

Confidential, Indianapolis, IN

Sr. Oracle DBA

Responsibilities:

• Experience in transactional databases (OLTP) active 24/7 with high availability configuration RAC and Data Guard.
• Documented and supported the builds of new clusters to use Oracle 10g RAC on HP-UX and Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Experience of using Oracle Enterprise Manager (OEM), Grid Control.
• Co-ordinated with development teams to understand requirement and transform into data models.
• Worked on Conventional Hot backup, Cold Backup. Implemented the backups using RMAN.
• Responsible for database backup strategies, database recovery and validation & reporting database statistics.
• Setting Oracle Streams for bi-directional replication between two databases.
• Regular Security patching on oracle products and interim patching for various bug fixes on database products.
• Export and import of database objects.
• Expertise in monitoring databases activities, maintaining the load for the production environment and collecting database statistics, creating users, groups and profiles for users.
• Monitored the growth of the database objects for capacity planning.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Experienced in both application and query tuning, using AWR, ADDM, TKPROF and STATSPACK.
• Worked with both cost based and rule based optimization techniques.
• Worked on the Performance Tuning of database servers and storages in standalone and clustered environment.

Environment: RHEL, Oracle 8.1/ 9.2.0/ 10.1/11 g, SOLARIS 8/9, SQL, PL/SQL, Putty, TKPROF, Oracle Designer 2000/6i,Tools 4.5,windows,AIX,DB2, TOAD 7.6, SQL*Loader, Oracle Designer, Remedy.

Confidential, Jersey city, NJ

Sr. Oracle DBA

Responsibilities:

• Worked on the Database Migration from Solaris to Linux databases.
• Applied Patches to Database servers.
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Cloned production database to the test environment using Recovery Manager (RMAN).
• Worked on installing and configuring the database.
• Configured the new database to monitor through 10g Grid upon installation.
• Setup RMAN for backups according to company's backup standards.
• Worked on UNIX shell programming & CRON jobs for automating the process to refresh the data periodically.
• Recovered databases upon user request or when crashed.
• Worked on Setting up streams for one way replication between production databases.
• Designed a secure data transfer system between Windows and UNIX to replace legacy scheme with daily DBA activities like tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Export and Import of database objects to copy from one database to another database as well as copy the export dump file to tape that can act as a backup.
• Worked on DATAPUMP in exporting and importing the large databases.

Environment: Sun Solaris 7, Windows NT, PL/SQL, RAC 10g,Shell Scripts, Oracle 10g, 9i,8i, 10g, Solaris 2.9, OEM, TOAD, Sql * plus, imp/exp data pump, RMAN with catalog, DB2,stats pack, pl/sql, SQL, Sun Solaris, AIX, HPUX, Linux, windows 2000, ASM, Erwin, Veritas.

Confidential, Denver, CO

Oracle DBA

Responsibilities:

• Monitored the daily Hot and Cold Backups.
• Team member in the setting up and managing Oracle database replication among development and production databases.
• Writing UNIX shell scripts to automate database administration including scripts for database creation, statistics gathering and security administration.
• Analyzing tables and indexes to generate statistics used for tuning.
• Configuration of listeners, Tnsnames on UNIX environment for oracle work group server databases on production sites.
• Responsible for regular database activities including performance tuning, support, logical & physical design and managing Oracle utilities (SQL Loader, Export, Import).
• Query optimization through the use of diagnostic tools like Explain Plan & STATSPACK.

Environment: HP-UX 10.2, Oracle 10g, Sun Solaris 5, Oracle 8.1.7, TOAD, SQL, PL/SQL, Shell Scripts, Oracle 10g, 9i, Solaris 2.9, OEM, sql * plus, imp/exp, data pump, rman with catalog, stats pack, windows 2000,AIX.

Confidential, Coppell, TX

Oracle DBA

Responsibilities:

• Implementation of daily, weekly, and monthly DBA checklists for each environment.
• Responsible for maintenance, tuning and 24x7 support of Production, Development and Staging instances of Oracle Version 8i, 9i, 10g in HP-UX Unix environments.
• Excellent skills in troubleshooting Oracle Database and query issues.
• Worked on oracle security documents required for auditing.
• Performed export and import at schema, tablespace level.
• Worked with tier1 team on Backup, Restoration & Tuning of databases.
• Write PL/SQL and UNIX shell scripts to automate database functions,
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
• Works directly with software developers to develop and enhance applications and data conversions.
• Provided on-call support in adherence to specific business and customer Service Level Agreements

Environment: Oracle 9i, Erwin, SQL * Plus, Imp/Exp, RMAN, IBM AIX 5L, Linux, Sun Solaris, Tkprof, Stats Pack, SQL, SQL LOADER, OEM, RMAN.