SUMMARY:

I have more than 7 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.

• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g on a variety of operating systems including UNIX/LINUX, Solaris and Windows environment.
• Experience in Migration Projects. Hands on experience in-migrating from Oracle9i to 10g 10.2.0 , 10g to 11g and applied oracle patches,
• Hands on experience in Cloning, Oracle Streams, Space Management, Database Security, Auditing, Troubleshooting, TAR/SR Support and Documentation. Advanced Queuing. Power Designer for Data Modeling.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms
• Installed Oracle 10g RAC software with ASM OCFS2 File systems
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery RMAN
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Co-ordinate with UNIX administrators for space managements on various servers.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM LEGATO Storage Manager.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planningand efficient usage of the disk space.
• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, datamigration, dataclean-up, copy data archiving, etc.
• Monitoring and management of various database components logical physical like table- spaces, segments and data files.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
• Knowledge on Oracle GoldenGate installation, configuration, troubleshooting GG issues
• Performed cross-platform migrations Oracle 10g - 11g from multiple databases's using Oracle GoldenGate..
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL LOADER.
• Have implemented ORACLE STREAMS.
• Setup, Configured and Maintained Oracle Data Guardto control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps
• Hands on experience using Oracle Enterprise Manager OEM , SQL PLUS, TOAD and Grid Controlling using OEM
• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.
• Object Oriented Design and Programming, proficient in many programming languages as C,C , VB.NET and C multi-platform development, Web development and database design. Provided value added services to the company through thoughtful experience, testing habits, excellent written and verbal communication skills.

TECHNICAL SKILLS:

Work Experience:

Confidential

Role: Sr Oracle DBA

Confidential is one of the nation's largest and leading Pharmacy Benefit Management PBM Company known for its expertise in leveraging their PBM Services and Retail Businesses to deliver innovative solutions to their Clinical Customers and Subscribers, The project involves maintenance and configuration of database for various transactional, OLAP and reporting databases with huge data volumes and to provide the applications support to the development teams and also the user community.

Responsibilities:

• Installed myriad number of 11gR2 RAC databases on physical servers as well as VM's.
• Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments.
• RAC to RAC physical standby configuration of dataguard for Disaster recovery requirement.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site.
• Achieved load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
• Database administration experience using DB2 UDB Version 9 or 10 on Linux.
• Expertise in Coldfusion components, Custom tags, Web services, Administrator, Debugging, performance tuning.
• Installation of 12c OEM and customize it to our needs.
• Installed Oracle GoldenGate on RHEL and setup table level replication as well as DDL replication too.
• Set up GoldenGate replication in Uni-directional and Bi-directional ways for couple of databases.
• Migration of databases from Physical servers to VM's on ESX clusters.
• Expertise in managing very large database with 30TB in size on a 8 node RAC cluster.
• Knowledge on EMC replication technologies like SRDF at database level.
• Schedule quarterly maintenance activity for my primary databases as required and communicate with the app teams as needed
• Expertise in Performance tuning of RAC and standalone databases, configuring initialization parameters, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/Logical IO and Memory Usage.
• Setting up Data guard to ensure the application is highly available, protecting from disaster recovery and for data protection.
• Storage management i.e adding of disks and removing of disks from disk groups and rebalancing of disk groups and analyzing disk stats as well using ASM
• Performed migration activities like Dev to Test and Test to Production for large databases.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Designing and implementing of backup strategy for database like when to perform a full backup, incremental / cumulative and deciding upon timings that doesn't affect normal processing.
• Used shell scripts for monitoring jobs, for startup and shutdown, health check of databases, analyzing stats at different levels, rebuilding indexes and for purging as well.
• Optimizing ETL procedures and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL trace
• Additionally, part of on-call rotation to support databases 24X7

Environment: Oracle RAC 11gR2 11.2.0.3,11.2.0.1,10.2.0.4, RHEL 6.0,RHEL 5.x, AIX 6.1,Solaris, TOAD, DBArtisan, ASM, OLTP, Hybrid environment, OEM

Confidential

Role: Oracle DBA/Database Engineer.

Confidential is the second-largest integrated energy company in the United States. We produce crude oil, natural gas and many other essential products. Worked on SAP Tech on call Team supporting different environments like upstream and downstream databases. Involved in ARIBA,SAP,OEM and many other projects.

Responsibilities:

• Involved in team management, team buildingexercises for the DBA team.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Replicated databases using Oracle Golden Gate for reporting purposes in OLTP environment with minimum lag.
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Oracle databases usingRMAN, also setup RMAN catalog for the same.
• Experience in Oracle server administration. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE DB's.
• 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.
• 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.
• 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.
• Tuning whichinvolved 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: ORACLE 11g, SQL, PL/SQL, Import/Export, UNIX, Windows 8.

Confidential

Role: Senior Oracle Database Administrator.

Confidential insurance is a global diversified products and services and industrial leader serving customers in more countries to create quality products, services and solutions to coverage plans. Confidential provides a full suite of products and value-add services to protect multinational businesses wherever they operate.

Responsibilities:

• Installation and Maintenance of Oracle 11g, on, LINUX, IBM-AIX and Windows platforms.
• Utilized Grid Control to administer multi-node RAC database also managed in the RAC environment. Load balancing of RAC instances.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Implemented the Oracle 10g Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Table spaces.
• Monitored and provided weekly reports on the server's memory, disk and CPU I/O using tools and UNIX command-line utilities.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• 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.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks SAN and Network attached storage NAS .

Environment: IBM-AIX, Windows 2003/NT, Oracle 9i, 10g, RAC, Shareplex, TOAD, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.

Confidential

Role: Oracle DBA

Confidential service is the leading parcel service provider in the world. This project involves international parcel booking, billing and Delivery tracking. Services offered across the globe from different collection points around the world. It is required to maintain the operational data to the end user.

Roles and 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 using OEM.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• 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
• Created database design according to the requirement of Application Software, monitored and configured databases.
• Configured Oracle data guard and Streams.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• 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.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Estimate the size of the database and its objects in large database of 1 to 2 Terabyte .
• 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.
• Used SQL Loader for loading legacy systems database data.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, 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.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Oracle 10g with RAC, ORACLE 9i, Java, J2EE, SQL, PL/SQL, Toad, Pl/SQL Developer, Erwin, And O/S: RHEL 4.2, HPUX, Windows 2003, And OEM.