SUMMARY

• Over 8 years of IT experience as Senior Oracle Database Administration and Developer Ver11G/10G/9i/8i on a variety of UNIX (Solaris, HP - UX, AIX), Windows NT 4.0/2000/2003 with Oracle ( 8.0.5, 8i, 9i, 10g,11g), Stored Procedures, DB Triggers, Developer 2000, Sql*Plus, Goldengate etc.
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i to 10g, 11g applied oracle patches.
• Expertise in AD Utilities like adadmin, adctrl, ad patch, admrgpch. Worked in 24x7 product environment, provided on-call and day-to-day support.
• Supporting E-business suite applications and people soft CRM applications regarding database activities.
• Installed Oracle 10g, 11g RAC software with ASM & OCFS2 File systems.
• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server
• Installation, maintenance and tuning of RAC Applications. Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Documented the Role Transition method from Primary to Standby and vice versa of Dataguard environment.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Data pump.
• Worked on different technological Platforms, Golden Gate, RAC, ASM, configured Data Guard for Standby Database, GRID Control.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager(12c).
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netbackup.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader, EMC Clone, RMAN.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• 24*7 production database support with Support to developers & end-users.
• Have implemented ORACLE STREAMS, and two type of standby databases supported by DATAGUARD, logical standby and physical standby databases
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN
• Work experience on Oracle back-end programming and Front-end development using tools like SQL*Plus, Toad, SQL*Loader.
• Involved in Configuring and managing the listener files and setting up of multiple listeners using MTS.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability working with Oracle 9i and 10g partitioned tables.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

TECHNICAL SKILLS

Rdbms: Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2005 and DB2, Oracle Applications 11.5.10.2 and R12.1.1,Goldengate

Languages: SQL, PL/SQL, T-SQL,MYSQL,C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

Softwares, applications & tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

Web tools: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle Database administrator

Responsibilities:

• Handling mission critical databases on cluster 24x7 environment within the stringent response/resolution SLA timelines.
• Supporting people soft CRM applications admin regarding database activities and connection issues.
• Building active data guard as high availability disaster recovery solution for Production databases.
• Maintaining unidirectional golden gate replication b/w source and target databases.
• Configuring and troubleshooting cron jobs for RMAN backups, monitoring for alert log errors, batch jobs and export jobs.
• Installed OEM12c and Monitoring mission critical business databases.
• Worked with data stage environment. Knowledge in ETL methods and XML files.
• Administer data on both OLTP and OLAP database on RAC cluster environment.
• Installed Oracle 10g, 11g RAC software with ASM & OCFS2 File systems.
• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server
• Installation, maintenance and tuning of RAC Applications. Performed Table, Index Partitions for increased performance and for better storage management.
• Doing monthly database refresh according to request.
• Providing monthly tenant storage usage reports for various cluster databases and anticipating usage growth.
• Handling Performance issues at application level and database level.
• Applying regular quarterly CPU patches and keeping the databases up to date with the Oracle security updates.
• Providing support to 10g RAC databases.
• Cloning the Oracle home and upgrades.
• Creating health monitoring UNIX shell scripts.
• Trouble shooting the user access issues.
• Developed the applications through using PL/SQL Packages, Triggers, Cursors, Procedures and functions.
• Good knowledge in Exceptions and advanced concepts of PL/SQL.
• Creating User profiles, roles.
• Working closely with the application teams on scheduling the patching windows.
• Cloning the databases regularly for the reporting databases and stage environments.
• Creating Backup schedules and taking periodic backups both offline and online using RMAN.
• Participating in corporate DR drills and ensuring the data protection.
• Creating partitions for partitioned tables periodically.
• Managing materialized views and refreshes.
• Created PL/SQL functions to facilitate business functions and calculations.
• Creating DB links to heterogeneous environments for the data warehouse.
• Periodic index management, index rebuilding.
• Doing code deployments on production according request after approvals.
• Investigating various diagnostic reports like stats pack, Awr repots to improve performance.
• Established master-master replication and master slave replication between various MySQL servers.

Environment: Red Hat Linux, Oracle 9i/10g, Oracle Enterprise Manager,Goldengate, RMAN, 10G, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2005, 2008

Confidential, Atlanta GA

Sr. Oracle Database Administrator Consultant

Responsibilities:

• Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Installation, Upgrade and Configuration of Oracle (8i, 9i, and 10g). Installed and created 10g databases and 10g OEM. Installed RAC on Oracle 10g, 11g and worked on ASM.
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings
• Configuration, maintenance and tuning of Oracle 10gRAC.
• Installing and configuring Recovery Manager (RMAN) and Flash Recovery.
• Performance Tuning, Memory (SGA) Tuning, RMAN backup
• Cloning databases using scripts as well as RMAN.
• Utilized oracle golden gate replication to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Proficient in advance features for PL/SQL programming like Using cursor variables,Ref. cursors, varrays, nested tables and Dynamic SQL.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager.
• Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets.
• Oracle replication using Golden gate and active data guard.
• Partitioning large objects to improve the performance and manageability
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Used Active Data guard makes a read-only replication of a given database.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.
• Create database maintenance plans, including updating statistics, rebuilding indexes, structure modifications, Capacity plans, and index analysis.
• Worked with data stage environment. Knowledge in ETL methods and XML files.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Taking Hot and Cold Backups, Exports and Applying patches both Server side and Client side.
• Writing scripts for backup and recovery, Import and export procedure.

Environment: Red Hat Linux, Windows 2000/2003, Oracle 9i/10g, Oracle Enterprise Manager, RMAN, 10G, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2005, 2008.

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Hired for supporting Mission Critical applications running on Oracle 11g. 10g, oracle 9i databases.
• The environment includes 650 oracle databases running 24 * 7 with FTS support around Singapore, London and NY.
• Monitored VLDB applications running on 2/3 node Veritas clusters for various production and performance issues.
• Extensively involved in migrating databases from oracle 10g to 11.2.0.2, applying required CPU patches and dealing with post upgrade issues.
• Top Notch Application Performance tuning skills along with an out of box approach towards complex issues.
• Supported Mission Critical applications on (10 TB) databases and resolved various bottlenecks.
• Installed, Configured Oracle Gateway for accessing data from Sql Server into Oracle real time.
• Familiar with Oracle Discoverer, App Server, Web Server and other middle tier Components.
• Extensively monitored the database for performance using OEM grid control, AWR reports, Oracle Wait Interface and command line utilities like - Explain Plan, Auto trace, 10046 and 10053 events.
• Extensively configured Data Guard, flashback database and well versed in resolving Data Guard issues, Data Restore scenarios.
• Responsible for end to end analysis of performance analysis (Database, Application Server and Webserver), load estimation and capacity planning.
• Responsible for setting up Rman backups, TSM (Tivoli) backups and scheduling Autosys jobs.
• Responsible for migrating Oracle database from Windows to Linux using Data Pump.
• Involved in the physical design which involves Partitioning, Materialized views and use of Analytical functions.
• Responsible for automating various routine tasks such as verification of TSM database backups, adhoc refresh of dev/uat databases from production (via data pump or rman duplicate).
• Well versed in Disaster Recovery exercises, production issues remediation, escalation procedures and quick resolutions.
• Excellent automation skills using Shell, Awk and other Unix Utilities.

Environment: Oracle 11g/Oracle 10g, Exadata, ASM, Oracle App Ser/Mid Tier, Oracle Gateway, Discoverer, Rman, SQL, PLSQL, Shell, Autosys, Tivoli Storage Manager, Shell, Awk.

Confidential

Oracle DBA/Application DBA consultant

Responsibilities:

• Install Configure and upgrade of Oracle Databases.
• Design and implementation of backup and recovery strategy using RMAN.
• Table space and Storage Management.
• 10g RAC Design/Installation/Configuration/Support.
• Disaster recovery using Standby database and Database cloning.
• Monitoring database health by scheduling shell scripts through cron jobs.
• Creation of Database, Table spaces and Schemas.
• Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases.
• Designing Logical and Physical Layout of the databases.
• Patch application working with AD utilities- ad patch, adadmin, admerge, adctrl, adclone.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using ‘Explain Plan’, SQL Trace and Tkprof.
• Creating snapshots, database links that are required for distributed databases.
• Rebuild index for better performance.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Monitoring Index Usage.
• Administration of 10g Data Guard for high availability.
• Involved in design and implementation of the data warehouse.
• Monitoring daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.
• Involved with installation and maintenance of ORACLE 10g RAC database for high availability.

Environment: Oracle 9i/10G on AIX/Sun Solaris/Linux/Windows

Confidential

Oracle DBA

Responsibilities:

• Handling high availability (24/7) database in onshore-offsite model
• Handling Performance issues.
• Applying regular quarterly CPU patches and keeping the databases upto date with the Oracle security updates
• Creating health monitoring Unix shell scripts
• Scheduling the health scripts using cron tab, mailx.
• Trouble shooting the user access issues.
• Creating User profiles, roles.
• Working with the development team on DBA issues.
• Application support functions
• Application issue trouble shooting,
• Collecting the requirements
• Analyzing the requirements
• Testing the updates.

Environment: Oracle Applications, and Oracle 10g, 9i, Sun OS, IBM-AIX, Linux