Professional Work Summary

• Extensive knowledge of Oracle Architecture and experienced in the technical areas of Oracle Installation, Upgradation, RMAN Recovery/Backup, Database Monitoring, Cloning, Auditing, RAC, PL/SQL and Performance Tuning.
• Expertise in performance tuning, crisis management and high availability to increase reliability, maximize productivity and introduce system efficiencies.
• Administration 11g/10g/9i/8i on UNIX, AIX, SUN Solaris and Windows2000/NT.
• Administration.
• Over 8 years of extensive experience in Oracle and SQL server database
• Worked as a Database Administrator in several Companies ranging from Pharma, Insurance, Banking to Retail.
• Experienced in Full Design Life Cycle of Oracle Databases. Worked both as a Development and Production Support DBA in Oracle.
• Extensively used 11g, 12c Oracle Enterprise Manager OEM for maintaining and monitoring databases.
• Experienced in Installation, Configuration and deployment of Oracle 10g, 11g database and Real Application Clusters RAC on different nodes with Automatic Storage Management ASM .
• Installation of 10g, 11g Real Application Clusters RAC /Clusterware on UNIX.
• Experienced in RAC Upgrades from 10g to 11g.
• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and disaster recovery. Experienced in advanced recovery methods like PITR and TSPITR. Logical backup using and full/ partial export/import and Data Pump.
• Extensive experience in Data Integration and Data Management.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio
• Set up data replication using Oracle Streams and Oracle Golden Gate date replication technologies.
• Extensive Experience with Unix Shell Scripting and Perl Programming
• Extensively used PL/SQL Stored procedures, triggers, packages , SQL PLUS, SQL LOADER, Explain Plan, and SQL tuning of Oracle database.
• Extensive Experience in supporting OLTP, Peoplesoft, Data Warehouse database applications.
• Good experience in working with Oracle, Sybase and SQL server.
• Experienced in Capacity Planning and Forecasting Database growth.
• Expert in Performance Tuning, SQL Tuning and interpreting AWR and ADDM reports.
• Provided Production support to the applications on a 24x7 basis. Ability to work beyond regular hours.
• Excellent communication, interpersonal and business interaction skills.
• Experienced with Oracle security technologies such as Audit Vault, Database Vault and Fine Grained Auditing.

Employment Summary:

Roles and Responsibilities:

• Migrated databases to Exadata RAC platforms.
• Designed Data Center Migration strategy.
• Installed and configured Goldengate Streams to replicate data and to maintain Zero downtime for Data Migration Go Live.
• Set up 8 node Exadata database clusters for DEV, UNT and LOD environments.
• Set up 3 node database clusters for Production environments.
• Worked on Exadata DR Solutions.
• Installed and configured Weblogic Server.
• Set up OEM 12c grid control and monitoring.
• Upgraded databases from 10g to 11g.
• Installed new databases for high security projects.
• Optimized Application performance and tuned long running queries.
• Monitored Load testing for projects and provided suggestions for Performance improvements.
• Supported Peoplesoft, OLTP and Datawarehouse environments.
• Maintained SQL Server 2008/2012 database based applications.
• Set up RMAN backup jobs.
• Refreshed DEV, UNT and LOD from Prod databases using RMAN and export/import.
• Automated day to day database administration jobs.

Oracle MAA: Installed, Configured, Setup, Maintained and Supported Oracle 10gR1, 10gR2, 11gR1, 11gR2 RAC, Physical and Logical Standby database for Test, Development and ProductionRoles and Responsibilities:

• Involved in 24x7 on-call support for 940GB 2 Node production 10g and 11g RAC database using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System
• Install, configure and support Oracle Databases for SAP Applications like MDM, BW, EP
• Upgrade Oracle Databases and Client software for SAP Applications from 9i 10gR2 11gR2, applying SBPs and using BR Tools for administration
• Addressing and supporting both Test and Development tickets in co-ordination with Application Development Team
• Upgrading of Database from 10.2.0.5 and then to 11.2.0.1
• Apply Patchset update to 11.2.0.2
• Install, create, setup and configure MongoDB for an internal application
• Active member in making enterprise hardware infrastructure related decisions with IT management
• Involve in meetings with top IT management to discuss platform migrations
• Installed, Setup, Configured Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11
• Installed, Setup, Configured Oracle version 11g Release2 64 Bit on SLES 10
• Migrating from Oracle 10g Sun Solaris 10 to Oracle 11g SUSE Linux SLES 10
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• Perform planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status

Oracle Streams and Shareplex for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases

Extensively used Oracle 10gR2 new features automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others

Monitoring and Troubleshooting of Database Replication issues

• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Resolve lock/latch and resource contention issues during production hours
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Applying Critical Patch Update CPUs every quarter in rolling mode with no downtime
• Data refresh from production to test and development
• Installing and configuring Recovery Manager RMAN efficient backup strategy to disks and tapes using best business practices
• Setting and Installing Oracle Enterprise Manager OEM and Enterprise Backup Utility
• Setting up new Development Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects

Roles and Responsibilities:

• Administering 24x7 RealApplication Cluster RAC databases running on Cluster File system. Worked with senior DBA's for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Installation, Cloning, Configuration and Administration of Oracle 11gR2RAC.
• Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle.
• Set up, configured and maintained oracle data guard primary and standby databases to ensure disaster recovery, high availability and data protection.
• I worked in managing multi-terabyte databases like more than 10 terabytes in this project.
• Upgraded Oracle Database from 10.2.0.4 to 11.2.0.3.
• Data migration from Solaris to Linux.
• With Oracle Enterprise Manager OEM manage users, privileges, profiles, and schemas.
• Extraction of data from different flat files into Oracle Database using SQL Loader and automated the process by using Basic Replication materialized views.
• Created and maintained immediate failover with up to the minute data to minimize the recovery time mission critical systems using oracle GOLDENGATE Testing Purpose .
• Cloning databases using scripts as well as RMAN.
• Set up backup and recovery procedure using RMAN and setup Autosys jobs.
• Installed and Implemented Backup Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Created duplicate databases using RMAN duplicate.
• Worked on TSPITR using RMAN.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces and Packages.
• Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.
• Applied CPU/PSU patches for oracle database version11.2.0.3.
• Utilized SQL loader and data pump import to load data into tables.
• Refresh schema using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user logins.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Performance Tuning use of SQL diagnostic ADDM, SQL Adviser and Oracle utilities like AWR.
• I have very good experience in MySQL.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• 24x7 production database support.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Excellent analytical, interpersonal and communication skills.
• Enthusiasm in learning new technologies.

Role and Responsibilities:

• Installation and Maintenance of Oracle 9i, 10g, 11g on IBM-AIX, LINUX and Windows platforms.
• 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.
• Install and Configure Oracle Apex 4.1 in the RAC environment
• Provided Oracle Application Server and Oracle APEX implementation and support.
• Used Oracle Transparent Data Encryption and Database vault to encrypt some of the data in the database.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server's memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
• Replicated data using GoldenGate.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Designed, developed and maintained UNIX shell scripts and Perl scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Administered 10g RAC environments adding and removing nodes to the cluster and handled performance tuning using AWR and ADDM.
• Documented the Standard Processes for peers to follow

Roles and Responsibilities

• Supported high availability for production databases and development databases by designing and implementing different backup and restore strategies using either OS/UNIX or Oracle Techniques.
• Ensured production database systems performance by monitoring and tuning memory, database and operating system parameters backed up database, restored data as needed.
• Assisted Sr. Oracle DBA in Performing production database health check, performance tuning, operation auditing. Replicated databases for Developer team and QA team by setting up testing database, testing environment, test cases and live/stress tests.
• Implemented database job processing via Oracle and UNIX crontab.
• Maintained Microsoft SQL Database Server 2006.
• Net8 Configuration for Clients Connection.
• Designed, implemented, troubleshoot and maintained database application systems including Payroll, Sales, Account Payables/Receivables, General Leger, Bank Leger, Inventory, and Customer Order.
• Performed data replication between units.
• Created users and set permissions.
• Analysed system requirements for over 10 database Oracle 6, 7, 8 applications, defined user interfaces and system functionalities, implemented systems using Oracle Forms, Reports, wrote SQL, PL/SQL procedures performed database upgrades.
• Assisted team in successfully maintaining, debugging, trouble-shooting 7 huge transaction-intensive enterprise databases achieved excellent performance, least planned down time.
• Managed database security using groups and roles.
• Created database objects and managed the permission access on the objects with necessary security.