SUMMARY

• About 10+years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 8i, 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 8i, 9i, 10g and 11g in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• 24*7 production database support with Support to developers & end-users.
• Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11gr2 RAC environment.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Experience working on ORACLE EXADATA Machine for the extreme performance of the database.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Logical and physical modeling using Erwin. And Expertise using tools like Erwin, ER/Studio and Toad.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER.
• Having experience in ODM(oracle data mining).
• Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• 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/7X, Oracle 10g (RAC, Data Guard & Streams),Sybase,SQL Server 2005,2008 and DB2.

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

LANGUAGES: SQL, PL/SQL, T-SQL, MYSQL, C, UNIX Shell 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, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM,OEM12c.

WEB TOOLS: HTML.

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 10g and 11g on Red hat 5.0, Oracle Linux 6.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on Oracle Linux 6.
• Experience in Upgrading 11gR2 Databases to 12c Databases using DBUA.
• Supported databases which include production Databases and Sandbox Databases.
• Installed, configured and managed 5 nodes RAC cluster on Linux Operating System.
• Configured & Installed Oracle RAC One Node databases and have experience working on moving Oracle ONE NODE RAC instance from one node to another (Instance Relocation) Using OMOTION Utility.
• Configured Oracle Restart feature to automatically restart the database, the listener, and other Oracle components for sudden hardware or software failures.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Performed server installation and configurations for SQL Server 2005, 2008 and 2012.
• Performed installation of SQL Server .
• Experience in Installing oracle 11g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.
• Configured high availability services TAF, FAN, Load balancing and SCAN features for clustered databases.
• Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.
• Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.
• Experience in patching RAC databases in rolling fashion to maintain high availability.
• Use of explain plans to tune SQL queries, building indexes to improve performance.
• Gather table/schema stats on regular basis to improve performance.
• Involved in memory tuning, performance tuning and oracle tuning in areas such as SGA, PGA, SQLs, IO, Latches, Lock.
• Hands on Experience in Installing / managing 11g ACTIVE DATAGUARD and Offloading Backups and Reporting queries to Active DR Site.
• Experience in setting up Fast Start Fail over(FSFO) in Dataguard Environment using DGMGRL.

Environment: Oracle Linux 6 & Red Hat Linux 5.0, Oracle 10g and 11g, Golden Gate, Oracle Enterprise Cloud control 12c, RMAN,11g RAC, Active DataGuard, ASM, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Confidential, Lincolnshire IL

Sr. Oracle DBA

Responsibilities:

• Responsible for providing 24*7 support for Critical Databases supporting various applications.
• Configured Broker to manage and administer Databases in a Dataguard Configuration and manage Switchover operations between primary and standby databases.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 11gRAC environment for the Production databases.
• Monitored & performed Exadata Cell storage server administration tasks using Cellcli & Dcli utility.
• Worked on Exadata X4-2 Quarter rack Storage Server I/O Resource Management (IORM) to manage workloads within a database and across multiple databases.
• Implemented and used Exadata Hybrid Columnar Compression (EHCC) for large objects in a Multiterrabyte Databases.
• Improved SQL query performance on database machines by enabling Exadata Smart Scan and Storage index features.
• Applied patches to Exadata cell storage servers using patchmgr utility via rolling fashion method and to compute nodes using dbnodeupdate.
• Monitored Exadata Database machines from OEM12c Cloud control.
• Experienced in the installation of Enterprise Manager Cloud Control (12c) 12.1.0.4 and installing the Agents in all the production, test and development databases and configuring them.
• Experience in configuring OEM 12c cloud control load balancing by adding additional OMS using F5 Service Load Balancer(SLB).
• Experience in upgrading the old OEM agents to the new OEM 12c agents and configuring different targets in 12c cloud control.
• Created and setup rulesets for in OEM12c for user-defined metrics.
• Worked on setting up Active directory based authentication in OEM 12c for determining the User Identity Access to enterprise manager cloud control.
• Worked on SAP BrTools i.e. BRARCHIVE/BRBACKUP to manage backup/restore administration for SAP Databases.
• Worked on instance management with BrTools for SAP Databases.
• Implemented TWO Phase Database backup with BrTools on SAP Databases.
• Well versed with SAP DBA tasks, provided all aspects of DBA support on general support & maintenance, patches, troubleshooting, performance tuning, install, migrations, designing and managing backup/restore, supporting ETL tools.
• Installed and configured Sybase database latest version and performed daily health checkups to support critical applications.
• Successfully configured and installed Oracle Golden Gate for Schema replication.
• Experience in performing GoldenGate Replication with source and target on the same physical host.
• Performed Cross-Platform migration of databases from 10g to 11g using RMAN.
• Writing automated shell scripts to Backup (cold and export) production and RefreshOracle,Sybasetest databases from production data for testing.
• Experience in partition concepts ( Range, List, Interval) of large tables into sub partitions for benefit to a wide variety of applications by improving performance, manageability, and availability.
• Writing and modifying UNIX shell scripts to manage Oracle environments and for Backend Oracle Processes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Experience in troubleshooting the performance issues with the implementation of 11G SQL Baselines.
• Experience in setting up Oracle Database Vault for restricting access to special record for administrative users.
• Experience in Enabling and Disabling Oracle Database Vault.
• Experience in enabling Fine-Grained auditing at the Object level & specific DML Operations.
• Experience in setting up Transparent Data Encryption (TDE) on Tablespaces.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.

Confidential, Louisville KY

Sr. Oracle DBA

Responsibilities:

• Responsible for providing DBA support for multiple SAP large databases in production, development and test environments.
• Part of a 5-member DBA team managing 450+ production/QA/Development instances with databases sizes varying from few GB's to 75 TB's.
• Developed UNIX shell script to automate the process of RMAN backups using RMAN Catalog.
• Developed SQL Scripts to perform database checks.
• Manage Oracle 11g/10g RAC databases of size 500g to 8TB.
• Installed, configured, add, remove nodes in RAC environment and migrated single instances to RAC environment and performed RAC administration.
• Involved in designing of disaster recovery using Data Guard, High Availability using 10g RAC
• Adjusting Optimizer settings for improve SQL performance.
• Role transition (Switchover/Failover) in Data guard.
• Involved in POC for DB Installation and configuration 11gR2 on Linux VM Environment’s.
• Installing and testing Oracle9i/10g and 11g Transparent Application Failover (TAF)
• Experience with Automatic Storage management implementation and also analyzing different problems including CSS related issues.
• Adding, deleting and creating different ASM disk groups.
• Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
• Manage Oracle 11gR2 RAC database varying from 2-6 nodes.
• Administered 10g/11g Real Application Clusters (RAC) system on Linux x86-64 bit systems on ASM storage environments.
• Involved in maintenance tasks like bouncing production databases and changing log modes of DB.
• Test and Implemented NetApp Snap Manager for Oracle solution for configuring Backup & Restore for DB versions from 10.2.0.4, 11.1.0.7 and 11.2.0.2.
• Installed Oracle 11gR1 & 11gR2 database for developers to test applications.
• Performed regular Database Administration activities which involved - Database
• Upgrades from 10g to 11gR1 and 11gR2. Installation of Oracle Software, Cloning Databases, Database Reorg and Backup and Recovery.
• Performed database Refresh using Oracle RMAN utility from an existing Production database.
• Responsible for storage management - Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Installation of one-off, PSU patches using opatch utility on both Single Instance and RAC environment.
• Implemented DR Test project management / coordination process on yearly basis at Sunguard DR Site.

Environment: Red Hat Linux5, Oracle 10g/11g, DB2, Enterprise Manager GRID, RMAN, SAN/NAS, 10g/11g RAC, Data Guard, SQL*Plus, PL/SQL, ASM

Confidential

Oracle DBA

Responsibilities:

• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Oracle Grid Control Management Server Installation.
• Handling large database environments using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Monitoring and tuning using tools like Enterprise Manager 11G GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
• Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Experience in Installing SQLServer 2008R2 to support certain Applications.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Performed application migrations to non-cluster databases to cluster databases.
• Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Veritas Net Backup-using RMAN (Recovery Manager) as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Worked with production DBA team in perfect coordination with seniors and team members.

Environment: Oracle database 10g (10.2.0.4), Redhat4, HP-UNIX 10.0, RAC, TOAD, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

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.

Confidential

Oracle DBA

Responsibilities:

• Worked with a team of 2 DBA’s, and coordinating with UNIX system administrators for the setup, installations, upgrades of Oracle 9i and 8i databases for test, development, and QA.
• Reconfigured the existing physical database layout, increasing the performance of the complete system by 20%, including better use of the hard disk space.
• Installed, created and maintained new oracle 9i and 8i instances. Upgraded several Oracle 9i instances from 8i.
• Connectivity with different client programs using ODBC.
• Writing scripts to move data files, for monitoring system activities (I/O CPU), memory usage at process level, file growth, user login, and user’s setup.
• Maintained backups for recovery using RMAN in tapes and disks.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
• Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities.
• Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.
• Modified and maintained database structures and views for the core system.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures.
• Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Cloned database for development needs.
• Worked as Production Support for Oracle based systems and Unix based Server environments.
• Creating users and database links, snap shots on production and development servers.
• Solving problems related to extent allocation and database connectivity. Established and maintained sound backup recovery and procedures.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Performed Backup and Recovery using RMAN.
• Involved in coding of data extraction scripts as per technical specifications.
• Analyzed the table structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 8.1.7/9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.