SUMMARY

• Extensive IT Experience in Oracle Database Administration for 7+ years on various Oracle versions
• Have comprehensive knowledge and experience in Creating, Installing, Managing, Upgrading, Patching Oracle RDBMS, Backup and Recovery Strategies, Managing Security, Users, Disk Space, Oracle File System Management, Task Scheduling, Oracle DATAGUARD, Performance Monitoring and Tuning, Real Application Clusters (RAC) and Oracle Flashback Technology and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g & 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 9i, 10g and 11g in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Hands on experience in configuring, managing and troubleshooting Oracle RAC (2, 3, 4 node) databases on various flavors of UNIX systems.
• Proven experience in high availability technologies such as RAC, ORACLE CLUSTERWARE, ASM, DATAGUARD, GOLDEN GATE and RMAN.
• Expertise in upgrading the databases from Oracle 9.2.0.8 to Oracle 10.2.0.4 and Oracle 10.2.0.5 to Oracle 11.2.0.1 and Oracle 11.2.0.1 to 11.2.0.3/11.2.0.4.
• Expert in implementing and GOLDEN GATE 11x (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up RAC Physical Standby Database 10g and 11g Active DATAGUARD using RMAN utility tool, activating Standby database for testing purpose and Re-building Standby Databases supported by DATAGUARD.
• Successfully completed annual DR exercise for Tier1/2/3 applications.
• Managed very large database (VLDB) of maximum size 5TB with 24 servers including 6 Productions, 6 testing, 6 Development and 6 Standby databases. Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing.
• Having hands on experience with Traditional Hot/Cold Backup and Recovery techniques. Experience with RMAN Backup, Recovery and cloning techniques.
• Experience handling RMAN disk and Tape based backup/recovery operations. Experience in handing RMAN with Media Management Library Software for backups to Tape storage such as VERITAS, TIVOLI and NETBACKUP Clients.
• Implemented “RECOVERY CATALOG” for all production Databases. Experience with Recovery techniques such as “PITR”, “TSPITR”, “DUPLICATE”,”ACTIVE DUPLICATE” and “Active DUPLICATE FOR STANDBY”.
• Used Oracle Datapump Extensively for Table level and schema level refresh of data from Production to lower environments efficiently. Experienced in using Oracle's Transportable Table space (TTS) feature which allows users to quickly move application Table spaces across Oracle databases.
• Implemented replication using snapshots, materialized views. Refreshed data “ON DEMAND”, “FAST” and “FORCE” Refresh methods.
• Experience in applying Quarterly security patches (SPU & PSU), On-off patches (Bug Fixes), Merge Patch, INTERIM patches To Oracle and grid binaries and dictionary patching.
• Effective troubleshooting of database and Performance problems.
• Database Tuning, Database Security, Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility, Proved Experience in Maintaining Documentation and Capacity Planning.
• Strong experience in working with Oracle memory tuning (ASMM, AMM).
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM), ASH report, SQL tuning advisor, SQL access advisor, Segment advisor, SQL profiles, SQL baselines, SQLT reports, TOP, SAR, VMSTAT, IOSTAT, GLANCE for Performance tuning
• Well versed in creating and managing of Tables, table spaces, Segments, Extents, and Data Blocks.
• Well experienced in managing data files, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Experienced in Database links and Materialized Views.
• Strong skills in SQL* PLUS, PL/SQL, UNIX Shell scripts (KSH and CSH).
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Exposure to process oriented methods such as ticketing system (remedy), CAB (change advisor board) process for production deployments, incident management and problem management.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, Oracle 10g (RAC, Data Guard & Streams, GOLDEN GATE)

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 4.x, 5.x and Windows NT/2000/2003/XP.

LANGUAGES: SQL, PL/SQL, C, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS: HTML.

PROFESSIONAL EXPERIENCE

Confidential, SC

Oracle DBA

Responsibilities:

• Installed Oracle 11g and RAC (2-node) systems using ASM file system on Linux 5.5 with 1GE interconnect for Cluster communication between the nodes for HA environment.
• Implemented “JUMBO FRAMES” on Private Interconnect VLAN.
• Implemented “Huge Pages” for RAC databases on Linux 5.5
• Installed OSWATCHER & PROCWATCHER for monitoring OS resources on RAC nodes.
• Hands-on experience with managing RAC databases, GRID infrastructure and ASM using SRVCTL, CRSCTL, ASMCMD, SQLPLUS and OLSNODES commands.
• Moved database files from one disk group to another using RMAN.
• Added Disks to Disk group to increase storage on ASM disk group
• Implemented Data guard Physical Standby databases on 10g &11g RAC environment for the Production databases.
• Successfully implemented 2014 annual DR testing for TIER1/2/3 applications.
• Installed GOLDEN GATE and demonstrated the GOLDEN GATE Unidirectional Table/Schema functionality and provided architecture documentation with the steps of implementation.
• Maintained the Heart beat tables to check the lag between the sites.
• Successfully Upgraded Oracle 10g databases to Oracle 11.2.0.4 and Oracle 11g (11.2.0.1) to Oracle 11g R2 (11.2.0.3) and Oracle 11.2.0.3 to 11.2.0.4 using “OUT PLACE” upgrade method.
• Applied January and April 2015 PSU & CPU patches for Oracle database servers in rolling fashion on RAC databases.
• Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
• Installation and configuration of Oracle Grid Control and installing OEM agents on all the database server hosts.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Monitoring production databases through Oracle Enterprise Manager (12c) to troubleshoot and diagnose database problems.
• Cloning databases for development/testing environments using RMAN.
• Setting up and monitoring RMAN backups that include archive log backups, full database backups, and incremental backups and troubleshooting ORA errors for backup issues.
• Scheduled various maintenance jobs using DBMS SCHEDULER.
• Involved in Implementation of Oracle 11g Active Data guard.
• Experience in troubleshooting Performance issues on RAC Instances.
• Provided support on Performance issues during project development resulting in improved response times and reduced contention.
• SQL tuning and Database Performance tuning has been done based on reports generated by SQL Trace, TKPROF, Explain Plan, AWR, ADDM and monitor the database Performance on daily basis.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, and availability Based on Access Controls for Access to Data at the database level.
• Automated the nightly RMAN backups for the Production, Test, Development Databases in crontab.
• Creating and Scheduling Oracle Backend Process Jobs using UNIX crontab.
• Cloning & duplicating databases using manual scripts as well as RMAN.
• Expertise in RMAN restore/recover process of the database.
• Experienced in Database Security User Management, Privileges, Roles, Profiling, Authentication.
• Loading data using SQL Loader and Data Pump utilities.
• Good experience in schema management, objects & Partitioning of tables & indexes.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Monitoring table space usage and adding space, adding disks to ASM disk groups and performing ASM disk group rebalance when required.
• Experience in documenting and knowledge transfer sessions to the team.

Environment: Oracle 11g, RAC (2-node) systems, JUMBO FRAMES, Huge Pages, GOLDEN GATE, RMAN, ASM, DBMS SCHEDULER, RAC, UNIX, Linux 5.5

Confidential, Detroit, MI

Oracle DBA

Responsibilities:

• Installed Oracle 10g/11g standalone and RAC (2-node) systems in HA environment on different OS platforms (AIX, Linux & Solaris) using ASM file system.
• Implemented “JUMBO FRAMES” on Private Interconnect VLAN.
• Implemented “Huge Pages” for RAC databases on Linux 5.5
• Installed OSWATCHER & PROCWATCHER for monitoring OS resources on RAC nodes.
• Hands-on experience with managing RAC databases, GRID infrastructure and ASM using SRVCTL, CRSCTL, ASMCMD, SQLPLUS and OLSNODES commands.
• Upgraded 11gR2 (11.2.0.3) to (11.2.0.4) in rolling fashion.
• Extract, pump, Replicate Apply using GOLDEN GATE and enable real time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization.
• Worked on storage migration with EMC SAN team to create ASM file system with normal redundancy disk groups.
• Experience in Managing Applications on Oracle 11g / 10g RAC databases using ASM.
• Implemented Oracle 11g Active Data guard, created standby redo logs for real time apply.
• Offloaded RMAN backups and reporting applications to physical standby for better Performance.
• Responsible for finding Performance problems in production databases by identifying issues using AWR, ASH, ADDM and SQL TUNING reports.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Implemented table partitioning using range and list type.
• Upgraded Oracle 10g databases to Oracle 11.2.0.4.
• Applied PSU & CPU patches for the Oracle enterprise database servers.
• Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
• Installation and configuration of Oracle Grid Control and installing OEM agents on all the database server hosts.
• Provided support on Performance issues during project development resulting in improved response times and reduced contention.
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP.
• Used Stored Outlines, SQL Profiling, SQL Plan Baselines, SQL Trace, ADDM, AWR, ASH and Explain Plan tools to diagnose Performance issues.
• Monitoring production databases through Oracle Enterprise Manager (12c) to troubleshoot and diagnose database problems.
• Cloning databases for development/testing environments using RMAN.
• Setting up and monitoring RMAN backups that include archive log backups, full database backups, and incremental backups and troubleshooting ORA errors for backup issues.
• Scheduled various maintenance jobs using DBMS SCHEDULER.
• Loading data using SQL Loader and Data Pump utilities.
• Good experience in schema management, objects & Partitioning of tables & indexes.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Monitoring table space usage and adding space, adding disks to ASM disk groups and performing ASM disk group rebalance when required.
• Closely monitored and administrated log transport services and log apply services in Physical/Logical databases.
• Apply database schema changes in Production, Development& UAT & SIT Environments.
• Worked as a primary for weekly and monthly releases and coordinated with application teams and development teams in release window times.
• Daily automation/maintenance/ monitoring activities using shell scripts and PL/SQL scripting.

Environment: Oracle 10g/11g, JUMBO FRAMES, DBMS SCHEDULER, PSU & CPU patches, ADDM, AWR, ASH, RMAN, PL/SQL scripting, OSWATCHER & PROCWATCHER, Data Pump utilities, Oracle Enterprise Manager(12c), Data Guard

Confidential, Orlando, FL

Oracle DBA

Responsibilities:

• InstalledOracleDatabase 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizingOracleprocesses and increasing SGA overall.
• Coordinate and suggest PM, SA and LOB DBA to allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Perform Daily Monitoring ofOracleinstances usingOracleEnterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Create multiple 11g databases on RHEL5 in development.
• Managed users and maintained security, populated databases of Oracle 10g & Oracle 11g on RHEL, Solaris and Windows 2003.
• Created Oracle package for Cartographic Generalization using Oracle Topology and Spatial that produces smoother map borders that corrects data errors.
• Used scripts to query Performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache server configuration.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Involved in EDW support for OLTP and OLAP Data warehouse application.
• Rebuilding of Indexes for better Performance ofOracledatabase.
• Upgraded Oracle database using DBUA or Data Pump Export/Import.
• Implemented Migration Strategies based on cost, time, and platforms requirements.
• Restore and point-in-time Recovery of database using RMAN techniques.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Written Shell scripting which monitors the server's Performance and logs output on periodic basis to database using Perl Scripting.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Experience in using flashback feature ofOraclethroughout the project.
• OracleExadata Management was efficiently used in the project.

Environment: Oracle11gR2/10g, RHEL, RAC, RMAN, PL/SQL, Stored procedures, SQL*Loader, Toad for Oracle, GOLDEN GATE, OEM, SQL Loader, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential, KY

Oracle DBA

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used Statspack, Perfstat, and TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: Oracle 9i, SQL, PL/SQL, PL/SQL Developer, Cronjob, Erwin, Import/Export, UNIX AIX 5.1

Confidential

Oracle DBA

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Migration of Oracle databases from windows to Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgrading development and production databases to Oracle 10g.
• Proactive database monitoring using 10g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
• Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Performed other DBA activities like including space management and Performance monitoring.
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Environment: Oracle 10g/9i, SQL Server 2000, Sun Solaris 8.0, SUN SPARC, HP UNIX, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.