SUMMARY

• Over 7 years of experience in Oracle Database Administration, tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database.
• Oracle Database Administration in a variety of environments like Linux, HP - UX, IBM-AIX, Sun Solaris, RHEL, CentOS and Windows NT/2000/2003.
• Has hands-on experience with designing, building, installing, configuring and supporting database servers using Oracle 11g and Application Servers (Weblogic).
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR, GoldenGate and also Cluster Interconnect Tuning (RAC).
• Experience in installing, maintaining, upgrading, migrating and patching Oracle versions 11g/10g/9i/8i.
• Experience in installing Oracle Retail Applications and database.
• Experience Channel Management, ideally while implementing Oracle Retail.
• Influencing Skills, High confidence, Passion for retail, Empathy for people, Strategic thinking.
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• ATG tool for developing e-commerce applications and PeopleSoft DBA activities.
• Managed Oracle databases in High Availability environments using Failover, Clustering, Mirroring, Dataguard and Cloning technologies.
• Experience in Database problem resolution, dealing with Oracle, creation of SRs.
• Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL.
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.
• Experience in database full Backup (hot and cold), Incomplete Backup, DataPump Export/Import, SQL Backtrack and Restore procedures.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Experience in installs, upgrades, maintains, monitors and optimizes GoldenGate TDM, GoldenGate Veridata and GoldenGate Director to support in data replication.
• Experience in Data Warehouse and Business Intelligence technologies
• Experience in stress testing for Oracle RAC systems and ESP.
• Experience in working with Oracle Fail Safe.
• Working knowledge of Oracle FSFO implementation and supporting.
• Working knowledge Shareplex and E-Business Suite.
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Performed a pivotal role in the project functionally and technically, responsible for analyzing the existing ETL systems and developing a detail road map for integrating both the systems, in multiple phases.
• Designing, developing, testing, performance tuning and scheduling datastage jobs.
• Executing scripts to maintain performance and conduct maintenance activities.
• Installed 10g Grid agent on servers and configure OEM Grid control.
• Tuning with STATSPACK, ADDM, V$ views, ASH, TOP, netstat, vmstat, iostat and prstat.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Used parameters to configure, install and manage ASM instance in 10g RAC.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard for OLTP, Decision Support Systems (DSS) Data Warehouse environments.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Experience in using oracle Streams for replication of database.
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, Recycle Bin.
• Experience in using System Development Life Cycle (SDLC).
• Good Experience in creating and managing schemas, tables, indexes, constraints and materialized views.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Experience in ERWIN Data modeling and MS Visio for E-R diagrams and Logical, Physical layout designs.
• Working Knowledge of EMC.
• 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.
• Experienced in Oracle Support processes for technical requests through Metalink and other support procedures.
• Documented all Oracle database installations and database operations
• 24*7 Production Database Support to ensure availability, efficiency and recoverability.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i/8i, RAC 11g/10g, SQL Server

Operating System: Linux, HP-UX 11/11i, Sun Solaris, DB2 and Windows NT/2000/2003

Languages: SQL, PL/SQL, C++, C, UNIX Shell Scripting.

Tools: /Utilities: SQL*Loader, DataPump (Export/Import), OEM, EMC, RAC, TOP, SQL Developer, RMAN, TOAD, AWR, ADDM, STATSPACK, TKPROF, Crystal, ESP, Reports, Oracle Grid Control, PeopleSoft, Log Miner, ERWIN, GoldenGate, Datastage.

Web Tools: Visual Basic 6.0, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities:

• Oracle Cluster ware installed to provide infrastructure for RAC in production, testing databases and configured 4 node Oracle 11g/10g RAC with ASM.
• Upgrade of database from 10.2.0.4 to 11.2.0.3 by applying patches using Opatch utility.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, Grid Monitoring.
• Executing scripts to maintain performance and conduct maintenance activities.
• Experience in migrating applications in oracle from 10g to 11g upgrades.
• Performed a pivotal role in the project functionally and technically, responsible for analyzing the existing ETL systems and developing a detail road map for integrating both the systems, in multiple phases.
• Designing, developing, testing, performance tuning and scheduling datastage jobs.
• Designing, building, installing, configuring and supporting database servers using Oracle 11g and Application Servers (Weblogic).
• Experience in Database problem resolution, dealing with Oracle, creation of SRs.
• Maintain, support and develop an automated environment.
• Experience in installs, upgrades, maintains, monitors and optimizes GoldenGate TDM, GoldenGate Veridata and GoldenGate Director to support in data replication.
• Experience in working with OEM upgrades from 11g to 12c and design, architect of OEM agent.
• Experience in installation and troubleshooting of OEM.
• Working knowledge of Oracle FSFO implementation and supporting.
• Experience Channel Management, ideally while implementing Oracle Retail.
• Influencing Skills, High confidence, Passion for retail, Empathy for people, Strategic thinking
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH, GoldenGate, Datastage, Dataguard.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Monitoring production performance and support for integrations.
• Experience in working with Oracle Fail Safe.
• Testing and applying data fixes.
• Experience in stress testing for Oracle RAC systems.
• Administering Real Application Cluster (RAC) databases running on Cluster File system.
• Migrated database objects from database to other server by using Export/Import, Datapump and masking for Local/ SNET.
• Working Knowledge of EMC.
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX (Korn / Shell) Scripting, Perl Scripting.
• Responsible for scheduling and holding design reviews as needed to support the development processes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup’s logs and alert logs
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and use datapump jobs for loading the subscriber and history related data at replicated site.
• Configured user log on load balancing and failover on RAC database
• Database Capacity Planning & configuration (redo and stream sizes), design staging schema and use of DBMS STREAM ADM packages.
• Handful of experience with ERWIN tool for data modeling.
• Business intelligence services and data transparency through reports creation, data integration, and application development.
• Working knowledge ILM database partition and maintanence.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, managing user groups and tuning.
• Applied patches and database re-organization using oracle enterprise manager (OEM).
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Experience in Data Warehouse and Business Intelligence technologies
• Assisting developers in getting database connection from the client using SQL *net and Net8.
• System wide tuning using UTLBSTAT and UTLESTAT (stat pack).
• Maintained Very Large Multi Terabyte (VLDB) around 14TB+ in Data Warehouse Environment for DSS.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, roles, user management, and maintenance.
• Load data from OLTP systems into data warehouse databases.
• Documentation of Oracle database operations and training of backup personnel.

Environment: ORACLE 9i/10g/11g, Oracle 10g/11g RAC, ASM, BI, RHEL 4.x, SNET, SUN SOLARIS 10, HP-UX 11, Toad, Weblogic, SQL, PL/SQL, EMC, ERWIN, GoldenGate, Datastage, Dataguard, DataPump, PeopleSoft, OEM, RMAN, BCV, BCM, SQL*Loader, Streams, Shareplex, Shell Scripting, Informatica, SQL Server, Data Warehouse, OLTP, ESP.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Installed, Created and maintained 3 Node 10g RAC and created database for production, development and test environment on HP-UX platform.
• 24 x 7 production support group member supported by our team.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• Migration of Database from 9.2.0.6 to 10.2.0.2 (RAC)
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS), Export/Import and Datapump (expdp/impdp).
• Manage and maintain database and user security using OEM Grid Control
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).
• Worked with IT managers and application developers to ensure the database integrity, high availability and security.
• Writing backend procedures, functions, packages and triggers using PL/SQL.
• Performed performance tuning using Statspack, ASH, GoldenGate, Datastage, Dataguard.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Installed Oracle 11g database in the test environment and tested the upgrade from Oracle 10g to 11g.
• Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on UNIX servers using IOSTAT, NETSTAT, VMSTAT, TOPAS and PRSTAT.
• Applying upgrade patches, maintenance and interim patches on all the databases
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures
• Designed physical and logical database structures and created, managed Tablespaces.
• Applied High priority patches downloaded from Metalink.
• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.
• Gathering schema stats and monitoring the index usage.
• Documented backup and recovery plans and tuning procedures.

Environment: Oracle 10g/9i, Oracle 10g RAC, ASM, Red Hat Linux 4.x, HP-UX 11,Windows 2003, IBM-AIX, Data Warehouse, ERWin, Netbackup, OEM, SQL*Loader, Grid Control, RMAN, ASM, Dataguard, TOAD, Datapump, Streams.

Confidential

Database Engineer

Responsibilities:

• Managed a 24x7 high availability Oracle production site.
• Installed Oracle 10g using OUI on 3 nodes RAC environment with ASM and Oracle cluster ready services.
• Defining and implementing Backup and Recovery Strategies on production, test and development databases using RMAN and RECOVERPOINT, Hot and Cold Backups.
• Performing the oracle 10g DataPump export and import on database, tablespace, and schema.
• Successfully implemented physical standby database using Oracle Dataguard feature for High availability on Sun Solaris.
• Installed and configured 10g Enterprise Manager and Grid Control.
• Performed Database Migrations from 9.0.1.4 to 10.2.0.2.
• Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Maintaining the oracle database security like Users, Privileges, Roles and Profiles Using OEM.
• Partitioned large tables to increase the performance.
• Cloned/ Data Refresh from production to setup test and development environments.
• SQL Query tuning, Database instance tuning, application tuning using SQL trace, explain plan, hints, TKPROF, AWR reports, Statspack reports, ADDM reports, initialization parameters.
• Managed proprietary ER models using Erwin data modeling software.
• Monitoring and Tuning UNIX servers using TOP, PRSTAT, IOSTAT, NETSTAT, VMSTAT.
• Created Big file Table Space creating and maintaining big file Table Spaces.
• Applied patches, patchsets and Critical Patch Update (CPU) using OPatch utility and OUI.
• Created and maintained different database entities included table spaces, data files, redo log files, Rollback segments, Indexes, Undo segments and renaming/relocating of data files on servers.
• Involved in migration of non-ASM database to ASM with the use of OUI/OEM
• Experienced in using utilities like Export/Import and SQL*Loader.
• Documented all Oracle database installations and database operations
• Scheduled jobs and managed resources groups

Environment: Oracle 9i,/10g, Oracle 10g RAC, ASM, Sun Solaris, RHEL, UNIX, OEM Grid Control, RMAN, SQL*PLUS, TOAD, PL/SQL, SQL*Loader, DatapumpB.H.E.L

Confidential

Oracle DBA

Responsibilities:

• Installing Oracle 8i/9i/10g on AIX and RHEL creating database for production, development and test environments.
• Assisting developers and 24*7 production database supports.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN, Complete and incomplete recovery of database
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Migration of database from 8i/9i to 10g in the production and development.
• Performed SQL query optimization by gathering statistics and by using explain plan, STATSPACK, TKPROF and SQL Trace.
• Applied patches for the upgrades, bugs recovery, troubleshooting.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Worked on 10g New Features: Data Pump, Automatic performance and diagnostics, Flash Back Technology, 10g RMAN’s New Features and Data guard(stand by database)
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping.
• Used RMAN for Cloning of the creating database in test and development environment.
• Performed migration of database with Export, Import, Datapump and SQL*Loader jobs.
• Periodically uploading data from flat files using SQL*Loader
• Monitoring production systems to establish status and conduct proactive maintenance
• Ensuring proper online and offline backup and Periodical reading and checking of backups taken.
• Online index rebuilds. Controlling and monitoring user access to the database. Monitoring Rollback Segments.
• Estimation and creation of Control file, Log file (including multiplexing), Data files, Tablespaces and rollback segments.

Environment: Oracle 10g/9i/8i, RHEL, IBM-AIX, Windows NT, RMAN, Datapump, SQL, PL/SQL, exp/imp, TOAD, SQL*Loader.