SUMMARY

• 10+ years of experience in Oracle databases … administration, Golden gate configuration and maintenance, backup and recovery, performance tuning, performance monitoring, schema maintenance on a various environment like Sun Solaris, Unix, Confidential - UX, AIX, LINUX and Windows sql server … 2012.
• Worked in Installation, Maintenance, Upgradation, Administration, Backup and Recovery of Oracle RAC Databases.
• Experienced in managing very large multi TB OLTP and Datawarehouse databases
• Experienced in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems.
• Experienced in Extensively worked on Upgradation databases from 8i to 9i, 9i to 10g and 10g to 11g.
• Good Knowledge of 11g new features such as Automatic Health Monitoring, security, SQL Performance Analyzer, Real Application Testing and Snapshot physical standby.
• Highly Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Experienced on installation and configuration of Golden Gate.
• Experienced in Ggs Heterogeneous replication using Golden Gate ( Oracle … to SQL Server)
• Highly Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Experienced in installing and managing Oracle Enterprise Manager Grid Control.
• Worked in maintenance, upgrades, administration, backup and recovery of Oracle Exadata systems
• Worked in Performance Tuning by using tools/utilities like Automated Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, sql tuning Advisor, Autotrace, TKPROF and Statspack.
• Experienced in Successfully configured and managed Physical Standby Database using Oracle DATAGUARD for High availability.
• Highly configured and managed Active Standby Database (ActiveDATAGUARD) to make replication of production DB in read only mode.
• Experienced in basic and advance replication usingOracle Streams.
• Experienced on Partitioning tables and creation of the Indexes on large tables to improve the Performance.
• Experienced in in SQL, PLSQL, Stored Procedures, Functions and Database Triggers to implement business logics of oracle database.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, capacity planning and documentation.
• Experienced in debugging deadlocks and other database inefficiencies using SQL Profiler.
• Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• Excellent knowledge interpersonal skills, team player, hard working and result oriented.

TECHNICAL SKILLS

DBMS &RDBMS: Oracle 8i, Oracle 9i, Oracle 10gR2, 11g R2 and SQL server.

High Availability, Tuning: Oracle 10gRAC with ASM, Streams, DataGuard, OEM 9i, 10g, 11g, Golden gate and Monitoring Product LogMiner, Tkprof, Statspack Reports, AWR, ADDM and ASSM

Operating Systems: Solaris (8/9/10), AIX (5.1, 5.2, 5.3), Linux RHEL (3x, 4x, 5x), Confidential -UX (10.x, 11.x) and …

Tools: &Utilities: Toad, RMAN, EXP/IMP, EXPDP/IMPDP and SQL Loader

Data Modeling Tools: Erwin and ODI

ETL & Reporting tools: INFORMATICA

Backup Tools: VERITAS, NetBackup and Confidential OmniBack

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++, HTML and XML

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

Sr. Oracle DBA

Responsibilities:

• Experienced in Senior DBA, Primary point of contact for client for database and configuration management related issues.
• Configured Data Guard to provide high availability by implementing 11g R2 Physical Standby database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Highly Installed and Configured Oracle 10gR2 and 11g two node RAC.
• Experienced in Installing, configured and administered Automatic Storage Management (ASM).
• Experienced in Database cloning from Production to Test and Development environments.
• Good Experienced in Administered and managed Production, Test, and Stage and Development databases involving more than 100 applications.
• Highly Installed and configured Goldengate.
• Experienced in Dealt with Web based OLTP systems.
• Experienced in Review database environments, such as database settings, monitoring oracle user processes.
• Experienced in Installed and configured Data Guard 10g and 11g using physical and logical standby for high availability databases.
• Good Experienced in Adding and deleting nodes using Oracle Universal Installer (OUI).
• Experienced in Created Physical standby database from hot backup of primary database and wrote shell scripts for backup and cloning.
• Worked with a team for replicating databases using Quest Shareplex.
• Worked on Oracle Streams for data replication between oracle databases.
• Highly Responsible for Migrating Oracle database from 9.2.0.7 to 10.2.0.4
• Experienced in Daily database administration tasks including backup and recovery.
• Experienced in Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Developed Backup & Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Highly Performance Tuning by using Oracle utilities like AWR, ADDM, Explain Plan, StatsPack, Tkprof, for addressing performance bottlenecks and issues.
• Experienced in providing all kinds of Production DBA support as well as development team support to various tasks.

Environment: Oracle 11g, Oracle 10g RAC, Oracle 9i, RHEL 4.x, IBM AIX 5.3, Confidential -UX 11, Goldengate.

Confidential, Southfield, MI

Sr. Oracle DBA

Responsibilities:

• Developer for the core modules such as WWVenus and FEP and worked on major enhancements and bug fixes.
• Highly involved in requirements gathering from business users, analysis, design activities, Code construction and project planning.
• Highly Proficient in SQL and PL/SQL programming. Design complex queries based on the requirements and perform tuning of application code for better performance and efficiency.
• Worked on Service requests in other modules such as Server and GMPWeb and delivered patches for the same.
• Analyzed SQL statements, Tables and Indexes using Explain Plan.
• Experienced in Schedule, monitor, restart and request jobs using APPWORX tool.
• Experienced in Update ticket status and creation of new tickets through Remedy tool.
• Good Experienced in Porting database objects across different platforms using Export/Import, Sql*Loader Utilities of Oracle.
• Experienced in Prepared User Requirement specification, Software Design Documents, Test cases document for the assigned enhancements.
• Highly involved in the preparation of test cases based on the business rules for the system and performed Unit Testing, System Testing and Integration Testing.
• Highly Performed Code reviews and testing IQA (internal quality assurance) for the team members.
• Experienced in Support the software developers in scripting with PL/SQL & take ownership in developing Complex and critical PL/SQL scripts.
• Highly Involved in Data Extraction, Transformation and Loading (ETL Process) from Source to target systems; design mappings as per the requirements specified in SRS using Informatica Power Center. Also worked on the Error handling phase of the project which captures database and XML errors that occurs during data transfer.

Environment: Oracle 8i/9i, Informatica 7.1.3, UNIX, Appworx, Remedy tool, TOAD, PL/SQL

Confidential, Raleigh, NC

Sr. Oracle DBA

Responsibilities:

• Experienced in Upgraded multi terabyte databases from 9i to 10g, Configured disaster recovery site with physical standby database for high availability.
• Highly performer capacity planning required to creating and maintaining database environments.
• Experienced in Created RMAN database backup and used OEM to manage the data, accounts and tuning. Used data pump technology to take the backups.
• Highly Configured Enterprise manager for centralized database monitoring and maintenance.
• Experienced in Cloning of databases from production to Dev& QA Databases using RMAN utility.
• Good Experienced in Partitioning of the large tables to reduce the access time and easier management.
• Highly Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Worked on ERWIN for Logical Data modeling and creating physical database designs.
• Experienced in Replicated materialized views with fast refreshes for table replication.
• Worked on STATSPACK, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Experienced in Installation of SQL Server 2005.
• Good Experienced in Troubleshooting oracle errors fine-tune database parameters and analyze STATPACK reports.
• Experienced in Installation and creation of 9i and 8i databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
• Experienced in Applied High priority, security patches downloaded from Metalink
• Highly performing periodic backups, recoveries using RMAN, conventional hot and cold backups.
• Experienced in Optimization and Tuning SQL queries using SQL Trace, TKPROF, EXPLAIN PLAN.
• Experienced in Administered all database objects, including tables, clusters, indexes, views, sequences, functions, packages, triggers and procedures (with PL/SQL hands on experience).
• Experienced in Created UNIX Shell scripts for different database tasks and export/import for data transfer.
• Good Experienced in Enabled security in creation of Database users, roles, privileges, profiles.
• Highly Creating primary database storage structures (tablespaces) once developers have designed an application.
• Excellent performing other regular DBA activities including schema management, space management and performance monitoring.
• Experienced in To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Experienced in monitoring the database daily activities.
• Experienced in Database maintaining including backups, recovery, imports/exports.
• Highly Created materialized views, table partition for Tuned databases.
• Highly Involved In query optimization and using rule based optimizers and cost based optimizers.

Environment: IBM-AIX, Sun Solaris, Oracle 8i, 9i, RMAN, ASM, SQL, PL/SQL, UNIX Shell scripting.

Confidential, Milwaukee, WI

Sr. Oracle DBA

Responsibilities:

• Experienced in Installation and Configuration of Oracle 10g, 11g and 12c databases.
• Experienced in Installation and Configuration of Oracle Golden Gate one-way and Bi-Directional.
• Experienced in Installation and Configuration of Oracle Golden Gate for Heterogeneous replication.
• Highly Configuring Disaster Recovery Site (Physical Standby).
• Highly Configuring Logical Standby.
• Experienced in Installation and Configuration of Oracle 11gR2 RAC.
• Experienced in Configuration of EXP and EXPDP backups.
• Good Experienced in Configuration of RMAN backups - Incremental, Differential and Full backups.
• Experienced in Managing ASM Instances.
• Experienced in Migration database files from File System to ASM (Automatic Storage Management).
• Experienced in Up gradation of Oracle database server from Oracle 10gR2 to Oracle 11gR2.
• Experienced in Migration of data from Microsoft SQL Server 2008 to Oracle 11gR2 using Oracle Golden Gate.
• Experienced in Database Cloning - RMAN Active Duplication.
• Good Experienced in Recovery of Databases, Tablespace, Datafiles and Controlfile.
• Experienced in Defragmentation of Tables.
• Experienced in Performing DR-Drills between Production Site and DR Site.
• Experienced in Taking AWR and analyzing the performance of the database.
• Experienced in Scheduling plans and Applying SPU patches to the databases.
• Experienced in Scheduling Logical (Exp & Expdp) and RMAN backup in Windows and Unix Operating Systems.
• Good Experienced in Data Upload using Sql * loader Utility.
• Writing Shell Scripts to automate backups (logical and RMAN), analyze tables, analyze indexes, rebuild indexes etc.,
• Highly Supporting Application Developers.
• Experienced in Production Database Support.
• Experienced in Interacting with Development team for Database related issues and Requirements.
• Experienced in Installing and configuring Jboss in RHEL5.5.
• Highly Installation and Configuration of Oracle Weblogic 11gR1 on Windows and Unix Environments.
• Experienced in Installation and Configuration of Microsoft SQL Server 2008.
• Highly Configuration of Backups and Recovery in Microsoft SQL Server 2008.
• Experienced in Creation and Management of Database, Schemas, Users, Tablespace in Microsoft SQL Server 2008.

Environment: s. Oracle 10g, Oracle 11g, Oracle 12c, Oracle GoldenGate, Microsoft SQL Server 2008

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

• Experienced in Administrate and support 8i, 9i database systems which house Confidential 's product and pricing data
• Highly Experienced in Co-ordinate various database setup routines to handle changes and application patches
• Worked on resolving Level-2 service calls on databases & applications.
• Experienced in Deploy backup & restore methodologies to satiate the application's dynamically changing needs.
• Experienced in Primarily performed Database Administration & Maintenance, Application Maintenance & Enhancement, and Design activities
• Highly performed different aspects of database administration tasks such as installs, upgrades, backup/recovery, monitoring and optimizing the performance of the database.
• Experienced in Done Upgrade & Migration of databases from Lower versions of oracle database to the latest version.
• Involved in creation and maintenance of Oracle Databases as per Clients requirements.
• Experienced in Have proficiency in creating *clone database* for test and training purpose.
• Experienced in Applied CPU Patch and version Upgrade Patch sets.
• Good Experienced in Managed undo segments, redo logs, check alert log and trace files for errors.
• Experienced in Gathered Statistics and tuned application code for better performance and efficiency.
• Highly Performed loading of bulk data from flat files using SQL*Loader and performed Logical backup using Export/Import and Datapump utilities.
• Experienced in Monitoring the database by collecting statistics of instance and files by querying data dictionary views, SQL trace files and TKPROF, STATSPACK to find ways to improve the database's performance.
• Highly Proficient in SQL and PL/SQL programming that includes creating different database objects.
• Experienced in Design database backups and Recovery strategies using RMAN, Hot and Cold backups.
• Experienced in implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Highly Configured & worked in ASM With Single Instance & RAC Instances
• Experienced in Work as part of a team and provide 7x24 supports when required.
• Highly Performed general technical troubleshooting (Trouble ticket handling)

Environment: Oracle 9i/10g, Confidential -Unix 11.11, Windows 2000 and 2003

Confidential, San Francisco, CA

DBA

Responsibilities:

• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setupidentical databases in the production and development environments.
• Create and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Upgrading OEMRepository and InstallingOEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
• Generated ASH, AWR, ADDM reports from Grid Control and command line.