SUMMARY

• An Astute DBA with over 9+ years of IT experience as an Oracle Database Administrator providing 24/7 production & development support for Oracle 12c, 11g, 10g & 9i.
• Proven experience with database performance and tuning techniques to enhance database optimization plans.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Experience with Oracle 12c/11g/10gRAC/9i/8i in Installation, Administration, Monitoring, Database Backup and Recovery.
• Extensive Experience working with Business users determining data/requirements needs and Data Modelling.
• Experienced with cross site (active - active) data replication using Golden gate.
• Extensive experience in Database Administration activities such as installation, patching, upgrading, migration, backup & recovery, performance tuning and capacity planning.
• Strong experience working in large scale enterprise environment containing OLTP and OLAP systems encompassing many terabytes of data.
• Design, test, implement, maintain, and control the companies physical, relational, and object-oriented databases like Oracle 11g,10g,9i,8i across multiple platforms like HP UNIX, Red hat LINUX, IBM AIX, Sun Solaris, Windows including performance tuning and trouble shooting of the databases.
• Extensive experienced in using Oracle Utilities & functions including RMAN Catalog, Data Guard, AWR, ASH, Statspack, Data Pump, exp/imp, OEM grid controls.
• Exadata X4/X5-2 Full Rack server, ½ Rack and ¼ Rack with ASM as storage management.
• Worked on multiple clients for consulting firm and Involved in managing multiple databases up to 35TB OLTP and 50TB OLAP databases.
• Experience in Real Application Clusters RAC and Standby database.
• Hand on experience in Backup, Recovery and Restoring of databases using RMAN catalog.
• Installation, Configuration of Oracle Data Guard for Physical and Logical mode.
• 5 plus years of experience in Performance Tuning for 10g and 11g (I/O, Memory & SQL Tuning).
• Utilities used include AWR, ASH, ADDM, STATSPACK, TKPROF and Sizing of tables, indexes etc.
• Experienced in using Data pump for exporting and importing schema, objects etc.
• Proficiency in Disk management and problem resolving techniques with a good Understanding of Capacity planning and efficient usage of the disk space.
• SQL Tuning using HINTS and reframe SQL Queries.
• Hands on experience working with Golden Gate Director and configured ODI to use Oracle Golden Gate for Change Data Capture.
• Experience taking Hot/Cold Backup and cloning database from production to test environment.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Experience working on TDE for Data Encryption in Database as well as Backups.
• Experience in PL/SQL, SQL and Shell Scripting.
• Hands on knowledge of CRONJOB.
• Closely worked with Network storage, OS, apps and development teams.
• Good understanding of web services and XML Technologies.
• Proficiency in designing complex ER diagrams, Data Flow Diagrams/Process Diagrams using ERWIN and MS Visio.
• Strong Experience working in ITIL environment.
• Experience working with both onshore and offshore teams and coordinated onshore issues with offshore team.
• 24*7 production database support with Support to developers & end-users.
• A loyal, personable team player and quick learner with strong attention to detail, excellent analytical and multi-tasking skills, and the ability to manage projects, teams, and client relationships as well as work independently.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP/2003.

RDBMS: Oracle 12c/11g/10g/9i/10gRAC.

Languages: MS SQL Server 2000, 2005, PL/SQL, C, C++, C#, APEX, VB.NET, JAVA, XML, UNIX Shell Scripting.

DB Management: Data Mover, Application Designer, TOAD, OEM, DB Artisan, OEM Grid Control

Tools: /Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, Oracle Warehouse Builder, Rational Clear Quest, SQLNET, ETL, ODBC, Oracle Streams, Shareplex, Golden Gate Veridata, Data pump, Data Guard, VERITAS Net Backup, VMware

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDR

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr Oracle DBA

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Performed cross platform migrations from Oracle 10g to Oracle 11g.
• Installed OEM agents and monitored them timely.
• Replicated databases using Oracle Streams and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Hands on experience in shell scripting for dataguard monitoring, purge alert logs, trace files,
• Proficient in upgrading data base from 10g to 11g R2 by applying latest patch sets.
• Implemented zero downtime migration and upgrade of 10g to 11gR1 database using Oracle Streams.
• Replicated certain columns from a table and also certain values from columns by using Oracle Streams.
• Used Oracle streams for data migration and data distribution.
• Configured RAC on oracle 11g R2.
• Working on Golden gate issue (Bi Directional issue).
• Hadoop and associated technology experience.
• Working currently as DBA/DMA implementing migration of ECC multi TB 4 node RAC Database to Exadata X4/X5-2 Full Rack server, ½ Rack and ¼ Rack with ASM as storage management. Worked on multiple clients for consulting firm and Involved in managing multiple databases up to 35TB OLTP and 50TB OLAP databases.
• Worked on setting up/installation and configuration of release11g R2 RACwithASMand Raw Devices and11g CRSon IBM AIX 6.1.
• Performed conversion ofSingleNodeInstancetomultinodeRACwith ASM,and adding instance to existingRAC.
• Installed and configured 6 node oracle11gR2 RACfor production environment.
• Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
• Hands on experience of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Installation, configuration, maintenance and tuning of Oracle 10g 11g on RHEL 5.0, 5.5, 5.7 &IBM-AIX 6.1.
• Installed 12C GRIDCONTROL and involved in registering of Databases in GRID.
• Experience in Oracle server administration. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE DB’s.
• Performance tuning and diagnosing DBMS and individual Production databases
• Creating users with restricted access, with default and temporary table spaces. Partitions on tables and indexes. Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing hot and cold backups. Restoration and recovery from backup.
• Oracle, Teradata, SQL, DB2, Hadoop, database configuration and programming on unix and windows systems.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Successfully installed and configured Golden Gate Process like Manager, Extract, Data pump and Replicate on both Stand alone and RAC Production and Standalone databases.
• Installing & configuring Oracle 10g, 10g RAC, 9i on Linux &AIX. Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• SQL issues and Tuning Considerations for Different Applications.
• Influencing Skills, High confidence, Passion for retail, Empathy for people, Strategic thinking
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH and UNIX commands.
• Experience in data based technologies AWS, Hadoop, Cloudera, PostgreSQL, Sybase, MongoDB or MS SQL Servers.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD.
• Experience in Very Large Multi Terabyte Database (VLDB) and also performed migrations in this environment.
• Documented all Oracle database installations and database operations

Environment: DataGuard, GoldenGate, GoldenGate VeriData, Red Hat Linux, Z/OS, Toad, Putty, Oracle 12c/11g/10g RAC, AIX, Oracle Enterprise Manager, SQL* Loader, SQL Server, Oracle Application Server

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Converted Single Instance databases to RAC databases.
• Created databases in RAC environment and involved in moving databases from TEST to Production Environment.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Involved in Tuning the RAC interconnect, Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Maintaining ASM in RAC environment.
• Installed DR for databases using Data Guard for Single instance and also in RAC environment.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Maintained DR server and troubleshooting issues in DATAGUARD environment.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM).
• Configuration and administering the Goldengate between Oracle-Oracle databases. Used Goldengate for schema migration and as a DR solution.
• Proactive database monitoring using 11g grid monitoring tool. Managing the existing the GoldenGate replication process and setting up new GoldenGate replications for ETL process.
• Applied patching on 10g from 10.2.0.1 to 10.2.0.x.
• Involved in Up-gradation of HP- UNIX databases from 10.2.0.x to 11.2.0.x.(11gR2)
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for Migrating Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Export and Import of database objects using EXPDP and IMPDP.
• Cloned schemas, objects and data on new server usingDatapump.
• Experience in backups and recovery using RMAN and Scripts.
• Maintained a Catalog server and involved in backup of Catalog database.
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Block Recovery and Data file recovery using RMAN.
• Involved in Database Security and Auditing to protect databases potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links against compromises of their confidentiality, integrity and availability.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Performed data refresh at Schema level using EXPDP.
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF.
• Tuned the performance of the SQL’s using TKPROF and STATSPACK reports.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Query optimizing using CBO(Cost Based Optimization) and RBO(Rule Based Optimization)
• Performance Tuning for the SQL queries which are Running slow and taking more CPU cost
• Involvement in day to day activities like Space management, rectification of Lock problems, managed quotas, Table partitioning to improve I/O access.
• Alert log Monitoring for critical databases every day in the production environment.

Environment: Oracle 11g/10g, HP-UX 7.x/11.x, RHEL 5.x, ASM, OEM, 12C (Grid Control), RAC 11gR2, RMAN and Data Guard, Explain Plan, SQL Developer, PL/SQL Tuning, Data Pump, Informatica, Putty.

Confidential, Phoenix, AZ

Oracle DBA

Responsibilities:

• Database Administration support (24x7) for large mission critical production databases
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recoverypurpose.
• Responsible for Creation and maintenance table space, data files, redo log files and renaming /relocating of data files on servers based on OFA model.
• Oracle 10g & 11g Databases maintenance and troubleshooting.
• Upgraded from 9i to 10g, 10g to 11g database and applied critical patches update (CPU) for latest versions.
• Good experience in managing Very Large OLTP and Data ware housing databases.
• Good knowledge on replication tools like Golden Gate to extract and replicate Databases.
• Involved in setting up, maintenance of Standby Database with Data Guard for Disaster recovery.
• Working knowledge on NETAPP storage from disk to tape to copy the RMAN Backup Data and mirroring of databases (BCV Split backup) from one database to another using NETAPP utility.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
• Designed conceptual schemas using Rational Rose like Entities, Relationships, and Integrity rules.
• Responsible for implementing backup procedures using RMAN.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database.
• Implemented strong backup and recovery strategies and monitored backups.
• SOX verification of spreadsheet formulas and macros to identify mechanical and logic errors.
• Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Working with SAN people for additional storage on disk/mount point if having any space issue.
• Pre-Build checks on UNIX box whether number of LUNS from SAN team allocated perfectly.
• The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users.
• For security administration used oracle Wallet Manager to manage public key security credentials on Oracle clients and servers.
• A batch performance monitor collects application performance data, collates it and produces reports that illustrate application efficiency
• Extensive Conceptual knowledge on designing Data Modeling like Data Models, Conceptual, Logical, Physical Schemes, Data Modeling Process, Modeling Methodologies, Entity Relationship Diagrams, Generic Data modeling, Semantic Data modeling.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• A capacity planning tool outlines how a future application will function and determines whether or not a company will have to upgrade its CPU or add disk storage to keep users happy.
• PL/SQL, Stored Procedures, Packages, Functions, Database Triggers and Shell scripting.

Environment: s: Oracle 9i, 10g RAC& 11g RAC, OEM Grid Control, Sun Solaris, HP-UX, RHELWindows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

Confidential, Madison, WI

ORACLE DATABASE ADMINISTRATOR

Responsibilities:

• Installing, configuring and administering ORACLE 9i/8i on LINUX and Solaris.
• Create oracle databases (single instance) on configured servers using both the DBCA & Database creation scripts.
• Upgraded databases from Oracle 8i to Oracle 9i.
• Used Database export/import using EXP and IMP utilities to take logical backups.
• Performed Data loads using SQL loader utilities.
• Planning Backup and Recovery Strategies for various database environments using Recovery manager (RMAN).
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Experienced with Space Management and Security.
• Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Writing scripts for the system and database for the effective functionality and report generation.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Perform capacity planning required to create and maintain database environments.
• Monitoring Database for fragmentation and correcting them.
• Management of table space growth, monitoring data files additions, extent growth
• Performed Database, OS and application tuning.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Contact to the development team to solve the issues with the new enhancement releases.

Environment: ORACLE 9i/8i, Linux, Sun Solaris 10.0, RMAN, DBCA, EXP/IMP, SQLTRACE, TKPROF, EXPLAIN PLAN.

Confidential, Atlanta, GA

Jr. Oracle DBA

Responsibilities:

• Provided Primary architectural and administrative support for new projects
• Installed Oracle 9i and 10g database on HP-UX 11.0, Red hat 4.x
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Performance Tuning i.e., tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Oracle Grid Control Management Server Installation
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures for performance testing and future 10g production implementation
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same
• Devised & Implemented backup strategies using hot, cold and exports based on the business requirements
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls
• Developed UNIX shell scripts to perform the above tasks efficiently
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.