SUMMARY

• Over 8 years of Information Technology experience in Oracle Database Administration (12c/11g/10g/9i/8i) on different operating system environments like Sun Solaris, Linux, IBM AIX, HP UX and Windows 2000/NT with strong domain knowledge in Financial, Banking, Insurance and Healthcare Industries.
• Proficient with special focus on Oracle Database Administration and RAC installation, maintenance and administration.
• Implementation of Oracle Backup and Recovery strategies using RMAN with Data Guard in RAC environment.
• Good Knowledge in Installing, Upgrading and Configuring Oracle Enterprise Edition 8i/9i/10g/11g/12c databases on different operating systems of Production databases for testing and training environments.
• Setup of Oracle Enterprise Manager (Grid Control & Cloud Control) 10g/11g/12c for database monitoring/performance/diagnostics. Complete range of Oracle DBA activities including day - to-day production database monitoring includes alert logs, trace files, archive files, Troubleshooting production issues and Performance Tuning issues.
• Experience in Performance tuning using various aspects of the database utilities like Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Designing Database, tuning Database, Database Security & Assigning the Roles, Profiles and Privileges to the various Users on Objects and Maintaining Integrity by applying server enforced, and Optimization by Explain Plan, TKPROF and SQL TRACE facility.
• Testing and implementing different physical and logical backup and Recovery methods like point in time, media recovery, full/partial and export/import.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQLNet, V$ and DBA views.
• Experience in basic and advanced replication using Materialized Views and experience in using OEM, TOAD, PL/SQL Developer, and SQL Developer.
• Monitored and applied database critical and non critical patches from Metalink.
• Extensive experience with Database Cloning and Refreshing pre-prod/test/dev databases with prod/pre-production databases.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM, Commvault.
• Extensive experience with Oracle Advanced Security Option and Label Security like TDE, Network Encryption and strong authentication.
• L1, L2 and L3 support level technical knowledge for Automation of DBA tasks, troubleshooting of Oracle network and difficult ORA-errors.
• Experience in writing Shell scripts to backup, restore database and automate daily activities.
• Involved in different scenarios of OLTP as well as Data warehousing databases.
• A "hands-on" SQL Server Database Administrator (DBA) with a proven track record of progressive management experience, team leadership and technical skills.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, TypePerf and Windows Performance Monitor.
• Versatile team player with excellent analytical, communication and inter personal skills.
• Provided 24 x 7 support and flexible to work beyond regular hours.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris, AIX 5.1, 5.2, 4.3, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x, SUSE 10, 9 and Windows 95/98/NT/2000/XP

Databases: Oracle 8.x/9.x/10g/11g/12c, Oracle 10g Real Application Clusters(RAC), MS SQL Server 2000/2005, MS-Access

Languages: C, C++, SQL, PL/SQL, Unix Shell Scripting, AWK scripting.

Web Servers: Apache Webserver

High Availability: Oracle 10G RAC, Symmetric Replication, DataGuard/Standby Replication, Shareplex, Veritas Cluster, Oracle E-Business Suite.

ETL Tools: DataStage

Web Tools: HTML, XML

Tools: /Utilities/ETLs Oracle Import/export utility, SQL * Loader, ADDM & SQL Adviser, TKPROF, Oracle Data Pump, SQL diagnostics, EXPLAIN PLAN, AUTOTRACE, RMAN, STATSPACK and AWR, OEM, OWM, TOAD 8/9/10 & SQL Developer, PL/SQL Developer, Datapump, Grid Control, Erwin 4.0, svrmgrl, SQL Trace, Opatch, MS-Office suite, NetApp, Veritas NetBackup, Veritas Clusterware, CommVault

PROFESSIONAL EXPERIENCE

Confidential, MILWAUKEE, WI

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 11gR2 2-node RAC & Oracle Restart on HP-UX/Linux platform.
• Installed and configured 11g OEM grid control with dual OMS on different hosts with a Server Load Balancer.
• Upgraded and configured OEM 12c from 11g with dual OMS and Installed/rolled out OEM agent processes on all database, middleware and application servers.
• Upgraded OEM Cloud Control and all server agents from 12.1.0.2 to 12.1.0.3.
• Configured Server Load Balancer for OEM 12c.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Running Exachecks, Sundaig and Cellcli utility to check physical disks, cell disks, grid disks and the cell information and resolving all Exadata related technical issues with Oracle Support.
• Integrated 3rd party management tools like Apache, Tivoli, Siebel, Remedy, Websphere etc.
• Worked on deploying and upgrading different plugins for OEM 12c.
• Responsible for administration and support of Oracle 11g and 10g databases. Upgraded the databases from Oracle 10.2.0.4 to 11.2 and implemented the dataguard on 11g databases.
• Responsible for installing, maintaining, performance tuning, and monitoring of Oracle database versions 10g and 11g on HP-UX in dev, test and production.
• Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance in a warehouse environment.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• Have setup the cronjobs for runalert, spacewatch monitoring, RMAN backup and recovery (level 0 and level 1), archive log purge, trace purge and AWR reports on HP-UX environment.
• Extensively used Oracle 11g features like Interval Partitioning, SPM, Statistics collection enhancements, AWR Baseline enhancements, RMAN enhancements etc.
• Provided DBA support to the application development and acceptance team, both onsite and offshore for loading and testing data in 10g databases.
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software TSM troubleshoot and backup testing.
• Implemented database refresh with the hot backup using ACTIVE DUPLICATE or full export. Used DATAPUMP to do table level, schema level and full database defragmentation.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Performed database tuning using Explain Plan, Hints, Toad, SQLTXPLAIN, SQL ADVISOR, ADDM & AWR reports, and Enterprise Manager.
• Provided on-call production database support.
• Did POC on 12c standalone and RAC database installations.

Environment: Oracle 10g/11g/12c, HP-UX, TSM, RMAN, RAC, Active Data Guard, Exadata, OEM 11g/12c, OEM Cloud Control, AWR/ADDM, Unix Shell Programming, TOAD 10/11, PL/SQL Developer, SQL Developer

Confidential, MINNEAPOLIS, MN

Oracle DBA

Responsibilities:

• Handled database size of more than 8TB.
• Managed and maintained the Oracle 10g/11gRAC OLTP Production, Pre-Production and Development Databases on Linux Platforms.
• Configured, Maintained and monitored the Physical standby databases, also enabled Active Dataguard for reporting tools.
• Migrated 10g databases from Non-ASM to ASM file system and later upgrading them to 11g.
• Configured and monitored Oracle 10g Grid control.
• Troubleshooting the Tickets for Oracle database related issues.
• Provided full technical support to various application teams before the databases go to Production.
• Experience in interaction with the top management and escalations of the complex issues.
• Performed entries capacity planning required creating and maintaining the databases.
• Used Triggers for database activities, like delete, update and users log on.
• Allocated the system storage and planned future storage requirements for the production database system.
• Done the Migration Review required before the database migration and QA after the database is migrated.
• Maintained the RMAN repository and customized recovery catalog.
• Worked with BI/Cognos team to tune various ad-hoc queries in the data warehouse environment.
• Created Partitions, materialized views, indexes, undo & temp spaces in the ware house environment.
• Creation of Users and Granting them privileges and roles.
• Preparation of design specifications document.
• Maintained table and index Partitions.
• Hands on experience in Data warehouse databases.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization using cost based optimizers.
• Performed sql tuning using EXPLAIN PLAN, SQLTXPLAIN, SQL ADVISOR, ADDM and AWR reports.
• Proactive database monitoring using 11g grid control.
• Performed logical and Physical data modeling using Erwin tool.
• Used different oracle trace events for performance tuning.
• Responsible for conducting weekly meeting, tele/video conference with clients, development teams both onsite as well as offshore.

Environment: Oracle 10g/11g, SUSE 10, RMAN, RAC, Active Data Guard, OEM, AWR/ADDM, Unix Shell Programming, TOAD 10, PL/SQL Developer

Confidential, BLOOMINGTON, IL

Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g (10.2.0.4.0 )/11g Database on Sun Solaris and Linux advance Server for Development, Test and Production Systems.
• Installed and Configured RAC on RedHat Linux Advanced Server with 2 nodes server side with load balancing and using Automatic Storage Management (ASM).
• Configuration of RMAN for the RAC environment for backup and recovery purpose using Enterprise manager.
• Performed database & system level space management and monitoring.
• Involved in replication setup, configuration and maintenance of replication processes.
• Performed Database Cloning to create TEST and DEV instances using Duplicate command and also some manual methods.
• Configuring DataGuard to ensure high availability, data protection and disaster recovery for enterprise data.
• Applied latest releases of the RDBMS Patches from Oracle to the Production and test instances to resolve few technical challenges & issues.
• Migrated oracle databases from 9.2.0.7 to 10.2.0.3.
• Contacted Oracle for Technical Assistance Request to track the problems in the database and resolved accordingly.
• Experience working with Oracle tech support/metalink, user administration.
• Responsible for creating documentation on Oracle security for all the production and preproduction databases.
• Tuned and optimized SQL Queries, SGA, and Disk I/O using Oracle Enterprise Manager and monitoring the AWR, ADDM reports, generated from snapshots taken at the peak business hours.
• Daily Monitoring of alert log files for errors, trace files and archive log destination files.
• Monitored and tuned rollback segment, temporary tablespaces, redo log buffer, sort area size.
• Designed and implemented hot backups using a combination of incremental, differential and full backups using RMAN.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery and Full/partial export/import.
• Designing Database Architecture experience using both logical and physical modeling using ERwin tool.
• Planning and scheduling for the backup of database using Crontab and GRID jobs.
• Performing object level, schema level auditing on the databases for any unauthorized usage.
• Performing Management tasks on Schemas and objects using TOAD and PL/SQL Developer.
• Provided support for changes on any major application or logical Database design.
• Provided 24x7 support. Willingness and flexibility to work beyond regular hours based on business demands.

Environment: Oracle 9i/10g/11g, Sun Solaris, RMAN, RAC, Data Guard, OEM, AWR/ADDM/Statspack, Unix Shell Programming, ERWin, SQL, PL/SQL, Stored Procedures, Functions and Triggers, TOAD9.0, PL/SQL Developer

Confidential

Oracle DBA

Responsibilities:

• Organizing Oracle Database operations like installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Setting init.ora parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and performing management of Undo Data. Maintained Test Database for testing and research work.
• Creating tablespace and planning the location of data, index and rollback tablespace redo log files and control files in adherence to the Optimal Flexible Architecture (OFA).
• Creating users and roles for database and give the privileges to suitable user.
• Monitoring database on a regular basic with the help of Alert logs, Listener log, Redo log status, Fragmentation level of Tablespaces, Rollback segments.
• Working with System/ SQLtuning to resolve the performance issues of oracle database.
• Experience in system tuning with the help of tuning log switches, pga aggregate target, tuning advisors, pinning package in memory, Statspack to ensure good performance of oracle database.
• Using the ADDM to analyze performance problem and with the help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
• Good knowledge of SQL Transformation, Full table scans, Table access by ROWID, Index Scans with the help of Optimizer.
• Working on data profiling tool such as IBM Information Analyzer.
• Working on an Indexing Strategy to create various types of Indexes rebuilding them and monitoring those indexes for better performance of SQL quires.
• Monitoring of the queries with high response time and high disk reads per execution and tuning them with the help of SQL performance tuning tools like Explain Plan, TKPROF, Auto trace, SQL trace, End-to-End Tracing.
• Managing large database objects with the help of DML and DDL languages.
• Installation and configuration of Oracle Database Software 10g on IBM-AIX platform.
• Responsible for taking hot backups and logical backups at schema, tablespace and database level.
• Configure and managing the logical standby database.
• Writing UNIX shell scripts to automate database administration including scripts for database creation, statistics gathering and security administration.
• With help of EXPORT/IMPORT utility of database to do table level and full database Defragmentation.
• Well aware with different recovery phases like Data recovery, Instance recovery, Media recovery.
• Troubleshooting various Database Features like Mean time to recovery (MTTR), Flashback Query, LogMiner, Replication to keep database as available as possible.
• Successfully implemented physical standby databases using Oracle Data Guard feature for High availability configuration.
• With help of Database links provided connectivity to other databases.
• Capacity planning for changes in the size of databases due to business growth.
• Carrying out Problem Management and Change Management activities in Corporate Information Services across the Information Technology stack.
• Triaging issues in Production / Stage /Development with respect to Database Servers, N-Tier Applications, Network Elements, ensure 24x7 uptime and availability.

Environment: Solaris 8.0/9.0/10.0 , OAS 10g, RHEL, Windows 2000 Oracle 8i (8.1.6/8.1.7 ), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad.

Confidential

Oracle DBA/Developer

Responsibilities:

• Part of Migration team to migrate databases from Oracle 8i to Oracle 9i.
• Test the migrated databases in different scenarios with different loads, test different new features of 9i and how we can take advantage of those new features.
• Managing user management (synonyms/privileges, roles, quotas, table partitioning, index, sequence), space management (tablespaces, rollback segment)
• Maintenance of database instances, Managing logical and physical database structures and rollback segments.
• Created different types of Indexes (B tree, reverse key, IOT and function based etc) and partitions on tables.
• Backup and Recovery set up through RMAN and Export / Import utility.
• Applied different recovery procedures for complete and incomplete methodologies depending on the type of failure.
• Performed Backup and Recovery strategies through Cold/Hot Backup and maintained User managed backups using RMAN.
• Optimized Instance parameters settings for Shared Pool, Buffer Pool, Log Buffer, Sort Area and multiplexed control files, log files on multiple disks.
• Configuration of listeners, tnsnames on Linux environment for oracle work group server databases on production sites.
• Used Triggers for database activities, like delete, update and user log on.
• Managed System Users, security and system monitoring for production environment.
• Performed table, schema level, export and import.
• Data loading from flat files to oracle tables using SQL loader utility.
• Monitoring alert log files, network log files and trace files.
• Responsible for administration of Windows NT and UNIX environments.
• Provided System support for both development and 24/7 production environment.

Environment: ORACLE 8i/9i, UNIX, PERL scripting, Windows NT, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Import/Export