We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Tampa, FL

SUMMARY:

  • Database Administratorwith 7+ years of experience in installation and administration ofOracle databases (8i/9i/10g/11g), backup and recovery, performance tuning, performance monitoring, schema maintenance in platforms includeSun Solaris, HP-UX, AIX, LINUXandWindows 2000/NT.
  • Expertise in logical backups,Hot/Cold Backup, RMAN Backups, Recoveryand Cloning of databases.
  • ImplementedRMANfor backups andPoint-In-Time Recovery strategy.
  • Experience in ConfiguringRMANwith Catalog for Differential, compressed Backup and Recovery.
  • Expertise in data transfer using Export/Import using command line as well as in interactive mode and throughData pump.
  • Experienced in features likeDatabase Replay, Log MinerandFlashback data Archive, Schema Management, Data guardandRMANinOracle 11g.
  • Implemented Database cloning to disaster recovery database using physical standby database.
  • Successfully installed, configured and supportedGolden Gate & Streams Replication.
  • Experience in configuringData guard 10g R2for physical standby databases.
  • Configured and implemented physical standby database for switch over and failover operations on 11g usingActive Data guard.
  • Successfully configured and implemented Physical Standby Database usingOracle DATAGUARDfeature for High availability configuration and reporting.
  • Experience inPerformance Tuning (I/O, Memory & SQL Tuningetc) by using tools/utilities byAutomated Workload Repository (AWR),Automatic Database Diagnostics Monitor (ADDM),Explain Plan, Auto trace, TKPROF and Stats pack.
  • Extensive experience on Partitioning
  • Extensively usedOracle Enterprise Manager-Database Control, 10G Grid Control for monitoring and tuning the databases.
  • Expertise in upgrading and migrating of oracle database to higher version
  • Cross PlatformUpgrades/Migrationof Databases from Oracle 8i to 9i, 9i to 10g and 10g to 11g.
  • Extensively usedSQL*Loaderand External Tables to load data from flat file to oracle server.
  • UsedSQL Access Advisor, SQL Tuning advisor, Segment Advisor.
  • Experience in Data transfer betweenSQL Server and Oracle.
  • Extensively used Advance Replication (Oracle Streams) of oracle databases for high availability.
  • Installations and Configuration of 10g/11gRAC with ASMandVCFS.
  • Converted single instance databases to multi node RAC environment for high availability and load balancing.
  • Extensively worked on Oracle10g/11gReal Application Clusters (RAC)environment on different nodes with Automatic Storage Management (ASM) to support large volume.
  • Specialized in tuning onRACdatabases and monitoring for high availability.
  • Experience on 11gR2RACnew feature SCAN.
  • Experienced in utilizingGolden Gate replicationtechnology for ORACLE Upgrades.
  • Expertise in usingGolden Gateto support data replication in the Oracle database environment.
  • Expert in writing Unix shell scripts and assigning cron jobs for day to day activities.
  • Extensive experience in writingSQL, PL/SQL packages, functions, stored procedures, triggers
  • Responsible for working on database design and data requirement analysis usingERWINdata modeler andToadfor Data Analysts.
  • Worked in database design, logical and physical modeling of the database using CASE tools likeERWIN, and normalization/de-normalization of database tables and object sizing.
  • Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
  • Load data from OLTP systems intodata warehousedatabases.
  • Strong knowledge and experience of managing Oracle 9i,10g RAC and 11g RAC environments using theOEM Grid Controltools.
  • Extensively used Oracle support and Metal ink to troubleshoot the problems and issues.

TECHNICAL SKILLS:

Operating Systems

HP-UX 10x, 11.x, Sun Solaris 8,9,10, IBM AIX 5.1,5.2,5.3, 6.1, 7.1, RedHat Linux 4.x,5.x,6.x, Windows 2000/2003/Vista/XP, Windows 7,

Databases

Oracle 11g RAC/10g RAC/9i/8i, Microsoft SQL Server 2005,2008

DB Utilities

SQL Navigator, SQL*Loader, Sql*Plus,10g OEM/Grid Control, RMAN, DBCA, DBUA, Data Pump, Toad, Data guard, Export / Import, TKPROF, Stats pack.

Scripting

Shell Scripting Korn & Bourne

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.

Tools

OEM/Grid Control, TOAD, SQL Developer, Putty, SQL*PLUS, ERWIN, SQL- Navigator, ERWIN, Golden Gate, Streams,

Languages

SQL, PL/SQL, C,C++,UNIX Shell Scripting, XML,HTML., Data modeling, Erwin, Apache Tomcat, Java

Other

EMC, NetApp, Veritas NetBackup, TSM, HP Data Protector

EDUCATION:
Bachelor of Commerce

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL April 2010 – Present
Sr. Oracle DBA

Responsibilities:

  • 24x7 Database Administration Support
  • Installing and configuring several Oracle 10g, 11g databases on Linux and Unix platforms.
  • Responsible for installing and configuringGolden Gate.
  • Responsible for upgradingGolden Gate.
  • Installed and implemented 10gR2/11gR2RAC.
  • Performed Import and Export usingOracle Data Pump.
  • Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
  • UpgradedRACdatabases from10gR2 to 11gR2.
  • Written shell scripts for backups, cloning of databases.
  • Applying Patches, Patch sets, CPU updates where ever necessary.
  • Enabled client applications to automatically reconnect to the database if the connection fails usingTAF (Transparent Application Failover).
  • Setup FAN mechanism inOracle RACto quickly alert applications about configuration and workload service level changes.
  • Setting up and monitoring the Data Guard for Production servers.
  • Working Closely with System administrators, developers, technology Stack team and Server Tech team
  • ConfiguringTNSNAMES.ORA and LISTENER.ORA for SQL* NET connectivity
  • Writing of UNIX shell scripts to manage the health of database proactively.
  • PerformedSQL tuning, System tuning, Database and Instance tuningby root cause analysis.
  • Data partitioning & tuning queries on largeOracle RACdatabases.
  • Monitoring the instance statistics and tuning the database to improve performance.
  • Use of tools likeOEM, STATSPACK,TKPROF, SQL Trace, Explain Plan, AWRandADDMreports to proactively monitor performance.
  • Backup procedures usingRMAN.
  • Recovery of Database usingRMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
  • Performed full and incremental backups usingRMAN.
  • Monitoring experience includesOracle Enterprise Manager Grid Control.
  • Establish standards, policies, and procedures forGolden Gate replicationadministration.
  • PerformedGolden Gate replication monitoring, tuning, and capacity planning.

Environment: Oracle 9i/10gR2 RAC/11gR2 RAC, RedHat Linux, HP–UX, IBM AIX, SUN SOLARIS, WINDOWS, OEM/Grid Control, RMAN, ASM, DataPump, SQL*Loader, GoldenGate, Oracle Streams, ERWIN

Confidential, San Francisco, CA January 2009 – March 2010
Oracle DBA

Responsibilities:

  • 24x7 Database Administration Support
  • Supporting both production and development Database activities.
  • Creating databases for Testing, Development and Production.
  • Performed database cloning to setup test, development database and Disaster Recovery Database using Physical Standby.
  • Performance tuning for optimized results using toolsEXPLAIN PLAN, SQL*TRACE AND TKPROF, STATSPACK.,AWR, ADDM
  • Migration of Database from HP-UX to AIX
  • Upgraded databases from Oracle 9i to 10g, 10g to 11g
  • PerformingSQL*Loader jobs for data loading.
  • Data refresh from production to test and development.
  • Configured and installed oracle 10g Data guard for Physical standby Databases on Linux.
  • ImplementedData Guard, Standby, and Oracle Streams technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on Linux environments.
  • PerformedRMANBackups and Conventional Hot/Cold backups, logical Backups.
  • Worked on recovering data files, table spaces, control files, block corruption etc.
  • Implement “Stored Procedures, Packages, Functions and Triggers” based on business requirements using PL/SQL
  • Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers withPL/SQLcoding.
  • Installed, configured and performed the maintenance ofSQL Server.
  • Rebuilding of Indexes for better performance, maintenance of Oracle Databases.
  • Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
  • ImplementedActive DATAGUARD (Standby)for high availability/disaster recovery purpose.
  • Taking periodic Backup of the Database and the software usingRMAN and VERITAS.
  • Written shell scripts for digitization the process.
  • Hands on experience injava database connectivity (JDBC)with oracle thin driver.
  • Scheduling jobs through Oracle Job Scheduler.
  • SQL Tuningsfor Performance of Objects and providing support to end users.
  • OS level activities like space monitoring of Mount point.
  • UsingERWINfor Creating and managing the logical and physical Data Models.
  • Working with system administrator to monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck.
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment:Oracle 11g, Oracle 10g RAC, Oracle Data Guard, Sun Solaris, Red Hat Linux, IBM AIX, HP-UX, WINDOWS, RMAN, ASM, SQL*Loader, DataPump, Oracle Streams

Confidential, Wayne, NJ March 2007 – December 2008
Oracle DBA

Responsibilities:

  • Creating and installation ofDatabases 10g on AIX server.
  • Worked onVery large Databases (VLDB) up to 6TB in size.
  • Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
  • Performed Import and Export using Oracle Data pump utilitiesEXPDP and IMPDP.
  • Installation, Configure, setup of 10g RAC and add new nodes toRAC 10g Clusterto distribute the load.
  • Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and ‘rewind’ entire database to a particular time respectively.
  • Optimized data loading usingSQL*Loaderto load different types of data from flat files to the Oracle server.
  • Worked on Oracle Streams by managing Oracle environment, either by creating a new user with the appropriate privileges or grant these privileges to an existing user.
  • Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
  • Supported offshore setup ofOracle10g with Automatic Storage Management (ASM).
  • Created and maintained all databases required for development, testing and production usage.
  • SQL tuning using SQL Trace and TKPROF, explain plan and SQL Analyze.
  • AdministeringORACLE Databases 10g, 10g RAC & Upgrade database 10.1 to 10.2 and applied patch set 10.2.0.3 to multiple databases.
  • Worked as part of a team and provided24/7 supportwhen required.
  • Established and maintained sound backup recovery and procedures.
  • Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
  • Configuring Data guard 10g R2for physical standby database.
  • Managing data guard configuration using DGMGRL tool.
  • Designed backup and recovery procedures for OLTP system.
  • Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
  • Implementing range, list partitions, hash sub partitions.
  • Involved in the Analysis, Logical Data modeling and Physical Database Objects creation like Business Transaction Tables, Indexes, Constraint, Materialized Views, and Partitions.
  • Creating and refreshing materialized views.

Environment: Oracle 9i/10g, Solaris, AIX, OEM, RMAN, ASM, DataPump, SQL*Loader

Confidential September 2005 – February 2007
Oracle DBA

Responsibilities:

  • Involved in the maintenance of the Oracle 8i/9i databases
  • Perform Space Management & Troubleshooting the database issues.
  • Developed backup and recovery strategies for Oracle Server databases.
  • Handled database migration from Solaris to Linux
  • Worked on monitoring and optimizing the database by performance tuning.
  • Monitored indexes and analyzed their status for performance tuning and query optimization.
  • Involved in Documentation of the Database.
  • Responsible for taking logical backups of data using exp, Imp, exude and impdp.
  • Responsible for taking HOT and COLD backups of the databases and also the individual table spaces.
  • Experience in Backup & Recovery techniques using RMAN and conducted disaster recovery drills.
  • Responsible for partitions on tables and indexes for managing large tables.
  • Used STATSPACK for Database Monitoring and Database Performance.
  • Tuning the SGA, Buffer Cache, Rollback Segments, Redo Mechanisms, Monitoring and Detecting Locks.
  • Maintenance & modification of Shell Scripts.
  • Extensive use of Scheduler in Windows and Crontab in UNIX environment for scheduling routine tasks.
  • Creating Stored Program Units in the Form of Packages, Functions, Triggers and Procedures for implementing the database intensive business rules.
  • Optimization and enhancement of existing procedures and SQL statements for better performance.
  • Involved in the logical and physical design of the database tables.
  • Killing sessions requested by users and/or jobs running much longer than expected time.
  • Manage and resolve design issues during development
  • Extensive use ofExplain Plan, TKPROFand Stats pack for Query tuning and performance Optimization.
  • Used PL/SQL table to avoid mutating problem in database trigger.
  • Upgrading and Patching of the Oracle software.
  • Providing backend support to junior developers for stored procedures and functions, reporting, SQL query tuning and optimization, performance monitoring, resource usage and profiles.
  • Coding stored procedures, Packages and functions and well tuning the SQL in the application.
  • WritingSQL*Loaderscripts to load the external files into the Oracle Database.
  • Using SQL Loader for populating static tables and fact tables.
  • Using EXPORT/IMPORT for table level and full database de-fragmentation.
  • Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).

Environment: Oracle 8i/9i/10g, AIX, SOLARIS, REDHAT LINUX, WINDOWS, OEM, RMAN, ASM, DataPump, SQL*Loader.

Hire Now