SUMMARY

• Enterprise DBA support utilising around 8+ years of Experience in Oracle Database Administrator, providing 24X7 production and development support 11g/10g/9i/8i databases on different platforms like Confidential - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
• Best practices for Oracle Database Infrastructure, Standards and Implementation.
• Implementation of best case scenarios for enterprise wide Database backup/recovery solution analyzing the specific business needs and optimizing the use of existing infrastructure
• Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise
• Implement enterprise wide Database Development standards to eliminate time on Database tuning.
• Database Installation and maintenance.
• Installation of Oracle Databases 8i/9i/10g RAC/11g RAC.
• Data Guard setup with Primary and Standby Databases.
• Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.
• Implementation of Grid Control.
• Monitoring extract process, replicat, manager processes.
• Knowledge in OID, OVD, LDAP.
• Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
• Configuration of RMAN Backup using VERITAS Net backup.
• Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).
• Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
• Physical database design, Logical database desin, normalization, de-normalization
• Capacity planning and bench marking
• Database security and auditing
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Collections of performance data for specific time range using STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL Trace.
• Analysis of Database Wait Events.
• Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.
• Plan optimization applying corrective measures including code restructuring, identifying potential index issues and effective implementation of uniform coding structure to avoid optimizer re-parsing.
• Managed extract, replicat, manager processes.
• Setup tnsnames in OVD,OID.
• Setting up Enterprise Manager notification procedures, who gets what notification, monitoring frequency, threshold limits for process memory, disk usages etc.
• Database trigger, stored procedure & packages PL/SQL coding.
• Multiple upgrades of Sun Solaris and Linux servers from 8i,9i to Oracle 10g, Oracle 10g to Oracle 11g.
• Excellent problem solving skills.
• Excellent written and verbal communication skills.
• Result oriented, self motivated, Team Player, Ability to work independently.

TECHNICAL SKILLS

Databases: Oracle 11g RAC, 10g RAC, 9i, 8i, 7.x, MS SQL Server 2005/2008

DBA: Oracle 11g, 10g, Oracle Enterprise Manager, TOAD

System Administration: Red Hat Linux, Confidential -UX, Sun-Solaris, IBM-AIX Windows 95/98/ME/NT/2003/XP

Backend Scripting: SQL*Plus, PL/Sql, UNIX Shell Script, Perl Scripting.

Network and Connectivity: Windows TCP/IP, VPN Connectivity, Oracle TNS Listener

Development Tool: Visual Studio, Visual C++, Windows/SDK, Visual Basic

Oracle Tools: RMAN, OEM/Grid Control, SQL*Loader, SQL ServerOracle Warehouse Builder, SQL*Plus, DBCA, Import/ExportData Pump, Streams, Golden Gate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWRADDM

PROFESSIONAL EXPERIENCE

Confidential, IL

Oracle Database Administrator L3

Responsibilities:

• 24x7 Production Database administration, support and monitoring to ensure a proactive problem recognition and resolution of Database issues
• Installations of Oracle Databases and clients.
• Supporting Oracle 11g RAC/10g RAC/9i Databases
• Responsible for upgrade and migration of data from 9i to 10g, 9i,10g to 11g and applying patches whenever required.
• Created extract initial load with setting by rmthost, mgrport, sourceistable, specialrun commands.
• Configuring an Online Extract and Replicat Group.
• Configured online change synchronization using chechpointtable command.
• Configured data pump process, ddl synchronization (marker setup, ddl setup, role setup) in golden gate.
• Installed and configured Oracle 11g RAC high availability, Standby Database 9Active DataGuard) for disaster recovery and reporting purpose.
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Developing and Implementing Disaster Recovery (DR) Plan
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Analyze SQL statements, reorganize Database objects and design indexes to improve response of queries.
• Knowledge install, configure the LDAP central grid.
• Creating Oracle virtual Directory.
• Creating Oracle Internet Directory.
• Creating indexes, views, synonyms, materialized views
• Creating database triggers, stored procedures.
• Creating views, sequence, functions.
• Creation of Database maintenance plans, rebuild indexes and integrity checks.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Cloning of production Database to the test environment using Recovery Manager (RMAN).
• Monitoring Enterprise Manager Alert Logs for taking corrective actions including table space sizing.
• Performed full and incremental backups using RMAN.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database and managing user groups, Database security, OS space monitoring etc.
• Export and Import of Database objects to copy from one Database to another Database as well as copy the export dump file to tape that can act as a backup.

Environment: Oracle Database Oracle 11g RAC/10g RAC/9i/8i, Sun Solaris, Confidential -UX, RHEL

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• On call 24x7 production support
• Installations of Oracle Databases and clients.
• Supported different Databases like Production Development Testing UAT and Training.
• Installation and configuration of Oracle 10g RAC, Oracle 11g RAC, Standby Databases for high availability, disaster recovery and reporting purpose.
• Creating functions, procedures.
• Creating indexes, view, and sequence.
• Form creation, use of built in packages.
• Responsible for upgrade and migration of data from 9g RAC to 10g RAC.
• Cron job to monitor the replication between primary and standby every 15mins.
• Monitoring Table spaces and extent Growth.
• Configured Databases for online backups and manage the complete Database recovery.
• Cloning of production Databases to the test environment using Recovery Manager (RMAN).
• Rebuilding indexes, dropping, creating.
• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management.
• Created Users, Roles and Managing Security & Concurrent Managers administration.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Optimize and Tune Database /Application. Provide solutions and enhancements for existing and new environments.
• Implement new technologies and upgrade existing Databases /Applications.
• Study existing system by application areas.
• Developing and Implementing Disaster Recovery (DR) Plan
• Writing UNIX shell scripts for backup and recovery, Import and export procedures
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Configured and maintained huge OLTP and Data warehouse databases .
• Database security and auditing
• Ensure high availability of Databases at all time.

Environment: Oracle 9i/10g RAC/11g RAC, Red Hat LINUX, Solaris 10, IBM AIX, Confidential -UX, Windows 2003, MS,SQL Server 2000/2005/2008 , OEM/Grid Control, AWR/ADDM, RDBMS, SQL, PL/SQL

Confidential, Tampa, FL

Oracle Database Administrator

Responsibilities:

• 24x7 Production Database administration, support and monitoring to ensure a proactive problem recognition and resolution of Database issues
• Installations of Oracle Databases and clients.
• Supported different Databases like Production Development Testing UAT and Training.
• Creating tablespaces, tables, indexes, views, synonyms, materialized views
• Responsible for upgrade and migration of data from 9g RAC to 10g RAC.
• Migration of Database from 9i to 10g and applying patches whenever required.
• Installed and configured Oracle 10g RAC high availability
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Developing and Implementing Disaster Recovery (DR) Plan
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Analyze SQL statements, reorganize Database objects and design indexes to improve response of queries.
• Creation of Database maintenance plans, rebuild indexes and integrity checks.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Cloning of production Database to the test environment using Recovery Manager (RMAN).
• Monitoring Enterprise Manager Alert Logs for taking corrective actions including table space sizing.
• Performed full and incremental backups using RMAN.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database and managing user groups, Database security, OS space monitoring etc.
• Export and Import of Database objects to copy from one Database to another Database as well as copy the export dump file to tape that can act as a backup.

Environment: Oracle Database Oracle 11g RAC/10g RAC/9i/8i, Sun Solaris, Confidential -UX, RHEL

Confidential, Des-Moines, IO

Database Administrator

Responsibilities:

• 24x7 Production Database administration, support and monitoring to ensure a proactive problem recognition and resolution of Database issues
• Installations of Oracle Databases and clients.
• Supported different Databases like Production Development Testing UAT and Training.
• Installation and configuration of Oracle 10g RAC, Standby Databases for high availability, disaster recovery and reporting purpose.
• Intensively involved in the area of installations of Oracle Software, Configuration for Database and day-to-day routine works for database administration.
• Identify each object with sizing criteria including large, medium and small.
• Sizing estimations and create appropriate table spaces.
• Create Import/Export scripts. dentify potential failures of Export/Import Jobs and resolution of the problem including resizing the table spaces.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Create Database users and roles and implement appropriate user security.
• Fixing Printer Issues, Setting Profile Options, Creating &Assigning Responsibilities.
• Implemented Database auditing, data security and Remediate high-risk violation in production environment.

Environment: Oracle 10g RAC/9i/8i/8.x.x, AIX, SUN SOLARIS, Confidential -UX, OEM

Confidential

Database Administrator

Responsibilities:

• Installation, configuration and upgrading of Oracle server software, related products and applying the patches for database.
• Implemented the Database tuning to improve the performance of the database using the Prestart package.
• Highly experienced in troubleshooting problem queries that take long.
• Application tuning using Hints, Explain Plan, SQL trace, TKPROF using SQL Navigator Expert Tuning, Index Tuning utility.
• Created and maintained a remote copy of the Production Database, using Standby Database to protect data against hardware failures.
• In order to protect data in the Production Database, implemented Standby Database and Synchronization of Standby Database with the primary database.
• Monitored and allocated share memory, table space as needed and managed replicated servers.
• Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.
• Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
• Implemented multiplexing of control files and redo-logs for disaster recovery scenario.

Environment: Oracle 8i/9i, AIX, SUN Solaris, SQL Server 2000, PL/SQL, UNIX Shell Scripting, RMAN, Toad, on Confidential -UX, Sun Solaris 2.x.

Confidential

Oracle Developer/DBA

Responsibilities:

• Responsible for implementing and maintaining the system.
• Health Check of the Database and Performing Database backup as per schedule.
• Shell Scripting, Automation of clonig and backup
• PL/SQL programming, writing Packages, Procedures, Functions and Triggers.
• Space management, adding space to Database as per requirement.
• Taking backups
• Database monitoring
• Creating users, roles, granting privileges
• Creating tablespaces, tables, indexes, views, synonyms, materialized views
• Performance monitoring and tuning

Environment: Oracle 8i/9i, Sun Solaris, SQL Server 2000, PL/SQL, UNIX Shell Scripting