SUMMARY

• 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/10gRAC with ASM and single instance database.
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10gRAC with ASM and single instance database.
• Oracle Database Administration in a variety of environments like Oracle Linux, HP - UX, Confidential -AIX, Sun Solaris, RHEL.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Experience with Toad Data modeler and Generate detailed reports on existing database structure
• Build complex entity relationship models - both logical and physical Database Design
• Proficient in Golden Gate(GGSCI) basic processes validation.
• Proficient in new Install/implementation of GG; Initial load,direct load, exp/imp with SCN.
• Proficient in troubleshooting repcat/extract abendscenarios, post ETrollover, data issues(handling with dev/appteams as necessary), check source from repcat, missing arch filesand so on.
• Good knowledge to use of macros; exception handlers likehandecollissions; ignore; skiptrans.
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Good knowledge to setup or switchover GG process onDR(when switched over from Primary site).
• Good knowledge in GG performance tuning like splitrepcats, use batch sql, server load & underlying object partitions.
• Adequate knowledge upgrade of GG, HA of GG (likeconfiguring VIP), configuring GG on CRS.
• Good knowledge (& hands on exp) in advanced GG conceptslike conflict detection & resolution; multimaster sync.
• Managed Oracle server in high availability environments using Failover, Clustering, Mirroring, Data guard and Cloning technologies.
• 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 Database creation with RMAN jobs and security implementations in Oracle.
• Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Installed 12c Grid agent on servers and configure 12c OEM Grid control.
• 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, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, Recycle Bin.
• 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.
• 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

Operating Systems: OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 11.x, Sun Solaris 9.0/10.0 and AIX 5.1, 5.2

Data Bases: Oracle 11gRAC/10gRAC/10g.

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

Tools: /Utilities RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Dataguard, VMware and CronTab.

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

Terminal Emulation: Putty, Telnet, FTP.

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Oracle Database Administration

Responsibilities:

• Involved in administering more than 20 Production databases of size ranging from Up to 10 TB
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 6 nodes per cluster.
• Involved in fresh installation of 11.2.0.1 RAC databases on ASM and NFS file systems
• Applied PSU patches and other database related patches.
• Involved in upgrading Database 11.2.0.1 to 11.2.0.4.
• Involved in exploring 12c (12.1.0.1.0 ) in development environment.
• Configured Data Guard Broker and performed rolling upgrade from 10g to 11gR2 using Rolling Logical Standby database
• Configured SCAN listeners and custom services for load balancing of connections.
• Upgraded RAC cluster from 11.1.0.7 to 11.2.0.4
• Configured 12c grid control and configured alerts for DB monitoring
• Installed agents on database servers and configured enterprise manager.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 30+ production databases.
• Migrated Database between servers using Data pump Export/Import
• Migrated database from ASM to Non-ASM using RMAN
• Recovered data files from block corruption using RMAN.
• Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using dbms stats.
• Proficient in troubleshooting node reboots in Oracle RAC Environment
• Responsible for refreshing Non-prod environment from prod and later automated the process through a script.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the database using AWR, ADDM, Grid Monitoring and Administering RAC databases running on Cluster File system.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, creating database links, managing user groups and tuning.
• Applied patches and database re-organization using oracle enterprise manager (OEM).
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Installed and Configured Oracle 10g databases on Linux.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, user management, and maintenance and solving critical errors like ORA-600, ORA-7445.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Experience with SQL, DDL, DML, DCL, PL/SQL coding, stored procedures, functions, packages, triggers and Periodically uploading data from flat files using SQL*Loader.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Migrated from a 12 box system to 36 box system with pairs of 2 (DEV, IST, UAT, Production, Disaster Recovery)
• Migrated single instance database to multiple instance databases using export/import, data pump.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard.
• Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
• Oracle 9i/10g/11g/12c RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management (ASM) and Configuration and Tuning.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Implementing 10g Data guard with one physical database.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases)
• Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
• Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard)
• Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
• Responsible for the installation, configuration and overall up from 10g/11gr1 to 11gr2 (10.2.0.2 to 11.2.0.2)
• Installation and configuration of Oracle 11gR2 on Red hat Linux AS 5.
• Involved in configuring two node RAC on 11gR1, oracle clusterware on Red hat Linux AS 5.
• Databases migrated to RAC for improved resiliency and performance.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Created indexes to facilitate easy user interface implementation and tuning.
• Involved in construction of DR sites for all the Production and IST environments.
• Performed Database Refresh from Production to IST, UAT and Development databases.
• Installing and configuring Oracle WebLogic 11g application server.
• Hands on experience on installing and upgrading Apex 3.2 to Apex 4.1.
• Experience in installation OWB and OWF.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Extensive experience in RMAN recovery testing and standalone database.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Worked on different types of storage structures (SAN/NAS)
• Monitored data transfer between the Database servers using Data Stage, Oracle Streams/ Confidential
• Monitoring Day-Day Backups, Log's & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Experience in Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 10g and 11g, Red Hat Linux.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Creating databases and logins with proper grants in, loading necessary data in it as per the developer’s request.
• Migration/Upgrade of databases to higher version on cross platform. Patching of different releases and validates objects and components at end of process.
• Cloned (duplicate) Environments to create Patch Test, Development and QA Environments using RMAN.
• Worked with Oracle support to raise SR, report bug and apply patch for new updates.
• Importing and exporting files, databases, schemas and tables using SQL* loader and utilities like Import, Export and Data Pump features of Oracle database 10g.
• Applied Patches, Critical Patch Updates and One-off Patches.
• Involved in designing and creating schema objects like Database tables, indexes, views, and synonyms.
• Partitioning of the database and large tables and creation of indexes on large tables to improve performance.
• Granting and Revoking privileges and roles to the users on different objects depending on their work requirement and providing the necessary security to the database.
• Production Support and Database Monitoring for performance of Databases.
• Monitoring the Alert Logs and User Trace Files for improving database performance and detecting any suspicious activities.
• Generation of the AWR (Automatic Workload Repository), ADDM, ASH Reports and using them for tuning the database.
• Tuning database server and application logic for performance improvement by using Explain Plan and TKPROF.
• Extensive experience using UNIX CRON TAB for automated monitoring, backup and data loading.
• Table Partitioning, Creating Index Organized Tables, Creating locally managed Table spaces to improve the performance.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Interacted with oracle PL/SQL developers in developing efficient applications.
• Hands on experience working with Oracle Grid Control Environment.
• On call 24X7 Production Support.

Environment: Oracle 11g &10gR2, Linux, Solaris, RMAN, Import/Export, Data Pump, SQL* Plus, SQL * Loader, TOAD, Sql Developer, WinScp, Putty, AWR.

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle on UNIX/LINUX and Windows.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Performed Cold Backup, Hot Backup and Logical backups using Export. Testing of Backup’s and Documenting backup strategies. Created scripts for automating online daily backup for eight databases and for automating data loading from flat files.
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation.
• Created users and privilege Management using roles and grants.
• Moved database Schema changes to stage or production.
• Responsible for Oracle 9i logical and physical databases design, implementation and maintenance on UNIX.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Created database objects like tables, views, indexes, partitions.
• Server side tuning included Rebuilding indexes, Analyzing Schemas etc.
• Using SQL Loader for populating static tables and fact tables from CSV Files.
• Worked on providing the backend support for the developers, stored procedures and functions, reporting, SQL query tuning and optimization, performance monitoring, resource usage and profiles.
• Taking backup of database and doing defragmentation with help of Exp/Imp utility of oracle.
• Working with packages like DBMS JOB and DBMS SCHEDULAR to do various jobs like export/import done on specific time interval.

Environment: Oracle 8i, 9i, UNIX, LINUX, Windows, Visual Interdev, HTML, SQL Developer, SQL*Loader.