SUMMARY

• Over 8 years of experience as Sr Oracle DBA in various domains.
• Worked extensively on oracle 11g, 10g and 9i versions involving database administration, production support, Installation, Configuration, Upgrades, Performance Monitoring and Tuning, Backup and Recovery, Migration, Patches, Cloning, RAC, Data Guard, Grid Control, Golden Gate, Space management, Database security, Troubleshooting database design, Replication, Data Modeling.
• Expert in Installation, Configuration, Cloning, Administration, Trouble shooting and Performance tuning of Oracle 11g/10g/9i/8i databases on AIX, WINDOWS and UNIX platforms.
• Experienced in providing 24/7 on - call support for Oracle production/development databases to ensure maximum availability.
• Worked on configuring SQL Server with minimum privileged access.
• Worked on supporting and managing very large oracle databases up to 10 TB (OLTP) and up to 50 TB (Data-Warehouse Databases)
• Involved in Installation, Configuration and implementation of Oracle database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM)
• Installation and configuration of Oracle 11gR2 RAC with ASM on multi node systems.
• Installed SQL server 2005 and 2007 on windows server 2003 and upgraded SQLserver .
• Configured and Maintained USER security in SQL server environments.
• Experienced in providing support for both production and development databases.
• Worked on DB2 databases on UNIX and windows servers.
• Performed migrations and Disaster recovery on DB2 databases.
• Experienced in setting up Oracle 10g and 11g 2 and 4 Node RAC implementations & administration using CRSCTL, SRVCTL command utilities in LINUX and AIX environments.
• Supported Siebel CRM applications on Oracle10g and 11g databases.
• Implementation of High Availability Solutions using Oracle 11g RAC, 10g RAC, Physical standby using Active Dataguard and Goldengate 10.4 and 11.1.
• Experienced in setting up unidirectional and Bi-directional replication using Goldengate 11.1 for High Availability and reporting projects.
• Experienced in installing and trouble shooting Goldengate issues using command level tools and utilities as well as LOGDUMP utility.
• Experienced in Goldengate upgrades from V10.4 to 11.1 for Oracle 11G databases.
• Experience with working on various UNIX platforms (Solaris (10), HP-UX (RISC and Itanium 11.31, AIX (6.1), Linux), Windows server 2000/2003 with Oracle (9i, 10g, 11g), 10G RAC, 11gRAC, Data Guard and RMAN.
• Experienced in day-to-day DBA activities including schema management and database security(creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Excellent support in providing DBA support for SAP, People-soft, CRM applications also provided support during new code Releases and Application upgrades.
• Worked on maintaining oracle Databases and Exadata X2 with Half Rack.
• Expert in Configuration of 11gRAC &10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Experienced in using Oracle DATA MASKING pack to secure sensitive data.
• Worked on supporting Oracle Database for CURAM Business Intelligence and Analytic Applications.
• Supported testing of applications as a part of team and conducted implementation on oracle Exadata x2.
• Very good experience in doing cross platform migrations using RMAN and Transportable tablespaces.
• Upgraded several databases from Oracle 9i, 10g to 11gR2 using both DBUA and also Manual methods.
• Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Table spaces.
• Monitoring and optimizing the Database Performances through Database Tuning, System Tuning, and Application/SQL Tuning.
• Excellent experience in identifying and resolving data block corruptions using RMAN and DBVERIFY utilities.
• Versed in Loading external data into the database using SQL*Loader, External Tables, etc. and moving data from one database to other using Data Pump and Export/Import.
• Experienced in setting up and configuring 11g OEM Grid control and also OEM Agent Deployments in several hundreds of servers.
• Configured database alerts and reports using OEM grid control for monitoring needs.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, data guard, cloning and relocation activities.
• Worked extensively with configuring database backups in RMAN environments using TSM and Net backup utilities
• Experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM reports, and tuning of SQL’s using EXPLAIN PLAN, Auto Trace and TKProf utilities.
• Good Experience in setting up Hot and Cold Backups for Non-prod databases, and Cloning of Databases using RMAN methodologies for setting up UAT and DEV environments.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN and TOAD Data modeling utilities, Logical and Physical database design.
• Excellent ability to work in a team as well as to take individual responsibility.
• Managed users’ data securely using Oracle Identity Manager (OIM).
• Extensively worked on 12C Oracle Enterprise Manager (OEM) grid control for monitoring needs.
• Expertise in developing various PL/SQL stored Procedures, Packages, Views, and Triggers.
• Experience in Administering Oracle Database using Tools like Oracle Enterprise Manager, Toad, and PL/SQL Developer and also trouble shooting using various Dynamic and data dictionary views.
• Experience in understanding business requirements for analysis, detailed design, database design & development of applications. Worked with various projects in large enterprise projects.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.
• Prepared programming standards documents like “PL/SQL standards” for developers and “Database Standards” for DBAs by including standards recommended by Oracle corp.
• Experienced in setting up jobs to automate many DBA tasks using CRON and dbms scheduler.
• Good experience in applying ONE OFF PATCHES, Critical Patch Update (CPU Patches) and quarterly PSU’s to facilitate security and bug fixes.
• Knowledge on Oracle Support processes for technical requests with Metalink.

TECHNICAL SKILLS

Database: - Oracle 11g, Oracle 10g, Oracle 9i

Languages: - C, C++, SQL, PL/SQL, Unix Shell scripting

Protocols: - HTTP, TCP, IP, FTP, SFTP, SSH, TELNET

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

Tool: and Utilities: - Oracle Grid, OEM 10g,11g &12C, TOAD, Putty, Erwin, SQL loader, Export / ImportExpdp / Impdp, AWR, ADDR, STATSPACK, RMAN, VMware, Win SCP, TKPROFLog Miner

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle DBA

RESPONSIBILITIES:

• Working on SAN migration project, moving storage from Hitachi to EMC using EMC solution and ASM Hostbased migration.
• Installed Automatic Storage Management (ASM) for Stand-alone and RAC cluster databases and performed migration of databases from NON-ASM to ASM.
• Configured and Implemented Oracle 11gR2 Database Two node Real Application Cluster (RAC) using Automatic Storage Management (ASM) and responsible for High Availability.
• Performed ASM rebalance by adding new EMC LUN to the existing DATA and FRA Diskgroups.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Supporting all the Oracle production/development databases to ensure maximum availability.
• Responsible for configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Monitoring databases using 12C Oracle Enterprise Manager (OEM) grid control.
• Handling Day-to-Day DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security(creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space monitoring(table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs etc.

Confidential, Columbus, OH

Sr. Oracle DBA

RESPONSIBILITIES:

• Installation and Maintenance of Oracle 11gR2 on LINUX and IBM-AIX Platforms.
• Worked on DBMS Datapump packages at schema, table and partition level for moving data using network link.
• Supported production, development and testing environment with database ranging from 100GB to 40TB.
• Configured and Implemented Oracle 11gR2 Two node Real Application Cluster (RAC) databases using Automatic Storage Management (ASM).
• Upgrade/Migration of Databases from Oracle 9i to 10g to 11g, Cross platform migration from different platforms.
• Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Migrated two node RAC databases from HP-UX 10.2.0.3 to 11.2.0.3 Red Hat Linux.
• Configured Goldengate in unidirectional replication for Oracle 11gR2 Databases for High Availability.
• Involved in a team migrating 12TB & 40TB production database using Goldengate Zero-down time migration.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN Catalog for the same.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Troubleshooting errors and using the Expdp/Impdp utility on a very regular basis for copying data across schemas.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Performance tuning and Monitoring using Grid Control database & managing instances using OEM
• Used Streams for capturing data changes from source database and propagated them to destination database.
• Simulated copy of Production databases into Test databases for the Application and Upgrade testing.
• Supported off-hour on call support and advised the development teams on database related issues.
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.
• Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.
• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc.,
• Responsible for memory and Application tuning of the databases using the Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan. worked on 12C Oracle Enterprise Manager (OEM) grid control for monitoring needs
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
• Used UNIX shell programs & CRON jobs for automating the process of refresh of data periodically.
• Documentation of Data Base Setup and administration of Server Environment.

Environment: Oracle 10g/11gR2 RAC, Windows 2008, HP-UX, Red Hat Enterprise Linux 5, ASM, RMAN, Goldengate, FTP, putty, Data Guard, OEM11 &12C, TOAD, PL/SQL, SQL*Loader.

Confidential, Columbus, OH

Sr. Oracle DBA

RESPONSIBILITIES:

• Installed and Configured Oracle 11.2.0.3 databases on Linux and also migrated Oracle databases from Solaris to Linux.
• Worked with Infrastructure and Operation Database Engineering Team.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using DG Broker for RAC one Node Databases.
• Configured and installed RAC One Node Production Databases with Automatic Storage Management (ASM).
• Provided 24/7 on-call support for Oracle production/development databases to ensure maximum availability.
• Installed Automatic Storage Management (ASM) for stand-alone and RAC One Node databases and performed migration of databases from file systems to ASM.
• Configured and installed Goldengate in unidirectional and Bi-directional replication for Oracle 11g Databases for High availability and reporting projects
• Upgraded and migrated the database to different version depending on Business requirements. (For Example 10g R2 to 11gR1, 11gR2 to 10gR1 on different OS).
• Configured RAC 11gR2 Data Guard Standby Databases using Data Guard Broker.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Scheduling the backups for the database using EM 12C cloud control.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Configured and Implemented Oracle 11g Database Two node Real Application Cluster (RAC) using Automatic Storage Management (ASM) and responsible for High Availability.
• Extensively worked on 12C Oracle Enterprise Manager (OEM) grid control for monitoring needs.
• Performed various RMAN strategies like RMAN Backup, RMAN Restore and RMAN Recovery etc.
• Configured and Performed Hot and Cold Backups for Non-prod databases, and Cloning of Databases using RMAN methodologies for setting up UAT and DEV environments.
• Excellent experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable tablespaces.

Environment: Oracle 10g/11gR2 RAC, Windows 2008, Sun Solaris 10, Red Hat Enterprise Linux 5, ASM, RMAN, Goldengate, FTP, putty, Data Guard, OEM11 &12C, TOAD, PL/SQL, SQL*Loader.

Confidential, Columbus, OH

Sr. Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g and 11gR2 databases on Linux and also Upgraded Oracle databases from 10g to 11g on various platforms like Linux 5, Solaris10, Aix 6.1.
• Worked as Oracle DBA in a 24x7 Production environment managing several Database instances.
• Maintenance of around 200 databases combined on all the production, development and testing environments with sizes up to 15TB.
• Provided 24/7 on-call support for Oracle production/development databases to ensure maximum availability.
• Managed SQL server databases using management studio and T-SQL.
• Troubleshooting production issues related to Configuration, Infrastructure and User related defects on any version of Siebel application.
• Installation and configuration of Golden gate 11.1 for 11g databases for unidirectional and bidirectional replication for reporting and high availability needs.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Implemented Oracle Database 11g R2 Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Upgraded and migrated the database to different version depending on Business requirements. (For Example 10g R2 to 11gR1, 11gR2 to 10gR1 on different OS).
• Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases.
• Cloned several production instances to Non-prod using RMAN and Datapump utilities.
• Configured mirroring in SQL server 2005 and experience in defining and configuring SSIS packages to move some table from SQL server to oracle databases.
• Implemented and configured many physical Standby Databases using Active Data Guard.
• Worked in configuring and securing confidential data of some important customer tables using Oracle DATA MASKING pack with enterprise manager.
• Proactive monitoring of databases for performance bottle necks and tuning accordingly using AWR, ADDM, Tkprof reports etc...
• Interacting with Functional Consultants to tune the SQL queries in Custom Applications to improve the performance.
• Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM (Oracle Enterprise Manager).
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts.
• Using Oracle Identity Manager (OIM) Provided Accurate services and Data secured.
• Installed and supported Automatic Storage Management (ASM) for stand-alone and RAC databases and performed migration of databases from cooked file systems to ASM.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Providing Support through DR (Demand Request) and CR (Change Request) for Developer & PPM request
• Worked on designing and implementing backup and recovery strategies for many production databases using RMAN incremental backup methods.
• Monitoring of the queries with high response time and high disk reads per execution (Top SQL) and tuning the same using TKPROF, Explain plan, and Auto trace.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Used Automatic Workload Repository (AWR) for analyzing the database performance.
• Used TOAD and OEM grid control to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
• Performed User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Implemented Change Control process for the Production Databases as and when required.
• Excellent experience in creating Service requests with oracle support to resolve critical issues and implemented various security patches and quarterly PSU’s.

Environment: Oracle 10g/11g RAC, Windows 2008, Sun Solaris 10, Red Hat Enterprise Linux 5, ASM, RMAN, Goldengate, FTP, putty, Data Guard, OEM, TOAD, PL/SQL, SQL*Loader.

Confidential, Owings Mills, MD

Oracle DBA

Responsibilities:

• Installed and implemented 2 node RAC on RHEL/UNIX and worked on ASM features of Oracle.
• Worked as a team member to provide 24x7 on call production database support.
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN and Data Guard in RAC environment.
• Installed and configured Golden gate 10.4 for 10g databases for high availability.
• Migration of database objects from oracle 10g to db2 v9.7.
• Team member of Strategic planning team was responsible for Developing backup and recovery strategy, database tuning strategies, capacity planning etc.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Worked on maintaining oracle Databases and Exadata X2 with Half Rack.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Monitored database Performance using AWR, ADDM, SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.
• Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.
• 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 conventional import/export and Data pump utility.
• Supported testing of SAP applications as a part of team and conducted implementation on oracle Exadata x2.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
• Used UNIX shell programs & CRON jobs for automating the process of refresh of data periodically.
• Documentation of Data Base Setup and administration of Server Environment.
• Install, upgrade and maintain database software, included creating user accounts, cloning database systems, ensuring nightly backups are performed, applying software patches.
• Performed data loading from CSV/flat files using scripts and SQL Loader.
• Developed automated scripts for database creation and builds.
• Up gradation of databases applying patches, patch sets and critical patch updates.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Granting roles and privileges to end users as per the requirement.
• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Scheduled various job using UNIX Crontab utility.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
• Performed cloning of the database using the RMAN utility.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML.

Confidential, Dallas, TX

ORACLE DBA

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Provided production support for the 24x7 Oracle database availability.
• Configured Oracle Data guard for Disaster recovery solutions.
• Achieved High Availability, Data protection and Maximum performance by maintaining physical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Implementation and configuration of Oracle golden gate.
• Supported and Worked on CURAM for Oracle Databases.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented and worked on MARKLOGIC for Oracle Databases.
• Experienced in using DATA MASKING pack to secure sensitive data
• Also migrated data from Oracle to SQL SERVER, Sybase, etc., for testing, reporting and analysis requirements.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Involved in designing logical and physical data models using Erwin.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Experienced in performing Point in time recovery using RMAN.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features Applied and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used STATSPACK, PERFSTAT, TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: Oracle 9i, 10g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux.