SUMMARY

• Over 8 years of experience as an Oracle DBA in Production, Development and Test environments, and transforming business strategies of various Fortune 500 and MNC organizations into efficient and integrated global business solutions. Proficient in an assortment of technologies, including Oracle 9i/10g/11g, MS SQL Server 2008, JDBC, Visio, VB.NET C#, Windows and Linux, Unix Environment.
• Oracle 11g/10g/9i Database Administration.
• Performance Tuning & Capacity Monitoring.
• RMAN, Data Security, Backup & Recovery.
• Standby/Failover Administration, Data guard.
• Replication tools like Golden Gate and Oracle Streams.
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard.
• Oracle RAC & ASM Admin/Installation, OEM.SQL Tuning in an Oracle Environment.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Configured and supported GoldenGate 11.2 & 12c versions for unidirectional Replication and on heterogeneous platforms (Tandem to Oracle & Oracle to Tandem).
• Migrating existing replication from STREAMS to GoldenGate.
• Integrated OEM with third party tools.
• Experience in using Tools like OEM, TOAD, Data Migrations & export/import.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM, TKPROF, STATSPACK, and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
• Skilled in developing RAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Excellent experience in applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS - DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.

Databases: Oracle 11gR3, Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2008.

Oracle Database Tools: TKPROF, Toad, OEM, SQL Developer, Grid Control.

Tools: & Utilities: Export/Import, RMAN, Data Pump.

Languages: C, VB.NET C#, Unix shell scripts, PL/SQL, Perl.

Web Tools: HTML, SQL NET, ODBC, TCP/IP.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington DE

Sr. Oracle Database Administrator

Responsibilities:

• Designed, installed and configured Oracle GoldenGate on both Unix and windows platform
• Designed, implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle GoldenGate product suite.
• Wrote several PL/SQL procedures and SQL scripts, used by golden gate processes for data filtering, computation and transformation.
• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 11g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 11g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.

Environment: Operating Systems: SunSparcSolaris64bit, Red Hat Linux. Oracle Database Server 10g/11g, Golden Gate, Programming Language/Tools: TOAD, PL/SQL Developer, OEM 12 C

Confidential, SC

Sr. Oracle Database Administrator

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Create & Managing Database Structure, Storage Allocation.
• Used RMAN for backup and recovery jobs.
• Replicated some of the MSSQL databases to Oracle 11g using Golden Gate.
• Tuned extract and replicate lags and implemented golden gate monitoring scripts to monitor Golden Gate and report issues proactively.
• Worked extensively on Performance Tuning. Traced the frequently called procedures/packages and pinning them to improve the performance.
• Cloned databases using scripts-setup and configuration of Data guard.
• Installed and configured Oracle Database on Red Hat Linux advance Server on Development Involved in performance monitoring and tuning of the database.
• Involved in backup and recovery tasks using RMAN.
• Involved in disaster recovery planning.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Implemented database backups and disaster recovery strategies using RMAN. Developed technical documentation for disaster recovery.
• Work Confidential regular hours based on business demands. Provided 24x7 on-call production supports.

Environment: Operating Systems: SunSparcSolaris64bit, Red Hat Linux Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, OEM 12 C

Confidential, RTP NC

Oracle Database Administrator

Responsibilities:

• 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.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Haveworked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used impdp /expdp and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Optimize JDBC and java stored procedure code. Provide stress testing and scalable using thin vs OCI driver. Web Logic EJB performance tuning.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris, Windows XP, Oracle 9i/ 10g RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1,UNIX, Linux 4.0.

Confidential, Littlerock AR

Oracle DBA

Responsibilities:

• Involved in performing migration from Oracle 10g to Oracle 10g RAC database.
• Supported Remote DBA Support for Oracle 9i/10g.
• Involved in Large data conversion project (Wachovia - wells) converting sql-server, Seibel and Oracle data to Oracle.
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS and Sql server integration services (SSIS) in the Sql server 2005.
• Involved in NDM (Network Data Mover) and secure plus setup for file transmission between wells and Wachovia.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Used Oracle Retek Extract, Transform and Load supporting replication and de-normalization for OLAP.
• Monitoring experience includes Oracle Enterprise Manager Grid Control and Quest Fog light.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used ERWIN for logical and Physical database modeling.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Developed Perl Scripts in order to provide reports.
• Involved in Peoplesoft Project Migrations and responsible for configuring and running applications servers and Process Schedulers.
• Used Oracle Audit vault for generating reports of the databases, User privileges and permissions.
• Created Heterogeneous services for accessing the database links from an Oracle database to SQL server database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using statspack, AWR, ADDM.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.
• Perl Scripting, Shell Scripting, bash scripting and PL/SQL Programming to resolve business problems of various natures.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Created scripts for data migration from flat files and MS Access to Oracle.
• Optimizing Oracle RMAN and ASM environment.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: Oracle 11g/10gRAC/10g/9i, Sun Solaris 9.0/10.0, IBM-AIX, SQL Server 2005, Oracle Streams, Toad, SQL*Loader, Network Data Mover (NDM), ASM, PL/SQL, OEM Grid, RMAN, Erwin 4.1.2.

Confidential, Urbandale, IA

Jr. Database Administrator

Responsibilities:

• Installing and configuring Oracle 10gRAC database on Windows Platform.
• Installation and configuration of 9i/10g on Linux.
• Used SSIS to migrate data from Sql-server 2000 and 2005 to Oracle.
• Installation of Oracle 9i Data Guard.
• Implemented Oracle Streams for setting up reporting server.
• Involved in database design using Erwin and Relational/OLTP Modeling.
• Worked with DBA Team of 8 members and 24*7 Support.
• Maintained instances of around 1.5TB having around 3500 Users and 80 Production/ Development instances.
• Use of Oracle Advanced Security for Data Protection.
• Involved in Oracle Golden Gate Installation for replication.
• Monitoring includes Oracle Enterprise Manager, Grid Control, and Quest Fog light.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Database move from one node to other and Reorganize.
• Database Schemas Creation based on the logical models.
• 24 X 7 on call support of all production environments in --group supported by our team.
• Used Oracle Audit vault to manage audit policies across Oracle Databases.
• Utilized Various Raid levels such as mirroring and stripping with parity.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Fetching, Analyzing and Loading data into the tables using Perl Scripts.
• Developed Extensive sub queries, PL/SQL procedures, Dynamic SQL, DML AND DDL functions, database triggers and Packages.
• Written Shell Scripts for the digitization of the Process
• Wrote Perl Script and ksh script to schedule multiple load tests during off-peak hours.
• Primarily responsible for 12 applications databases and for all applications supported by the team While in on call.
• Develops and executes a backup / disaster recovery plan for all databases and performance tuning of the database as and when required.
• Taken Backup and Recovery using RMAN.
• Involved to review and improve a VERITAS Net backup system.
• Controlling database changes and ensuring synchronization amongst different environments.
• Maintain database security and adhere to security policies designed by the client.
• Develop and Implement robust backup and recovery strategies for production as well as Development databases, which includes hot backup, cold backup, and export backup.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
• Tuning the database performance through STATSPACK/AWR/ADDM report.
• Guiding the application team to understand how the database works with their application.

Environment: Oracle 10gRAC/10g/9i, Red hat Linux 4.x, Windows 2003, SQL-Server 2000 & 2005, Oracle Streams, Data Guard, Toad 7.6, GoldenGate 9.5, RMAN, OEM Grid Control, and ERWIN.