We provide IT Staff Augmentation Services!

Oracle Dba Resume

Durham, NC

PROFESSIONAL SUMMARY
Have 6yearsof experience as anOracle DBA. Expertise in database administration, production support, installation, upgrades, patches, performance tuning, backup and recovery, troubleshooting database design, Unix shell scripting and documentation.

  • Experience with Oracle 10g/9i/8i in Installation, Administration, Monitoring, Maintenance, Performance Tuning, Database Backup and Recovery.
  • Experience with working on HP-UX, AIX, SUN SOLARIS, Linux and Windows environments. Installation and configuration of Oracle8i, 9i, 10g in UNIX/LINUX and Windows environment.
  • Worked with team to support 24/7 production environments.
  • Involved in administrating multiple 24*7 Production Oracle 8i/9i/10g RAC databases as well as Development/Test databases.
  • Configured RMAN and Recovery Catalog for all database. Database backup for all databases running on ARCHIVELOG and NOARCHIVELOG mode using RMAN.
  • Optimal configuration of SGA and PGA.
  • Checking for Alert log file for errors and monitoring the Hit ratios.
  • Worked in Database Application Design and Data Modeling.
  • Knowledge in developing Oracle PL/SQL based applications.
  • Extensive use of Erwin v4. x/3, x as a modeling tool.
  • Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.
  • Good Hands on experience in Database Design.
  • Database Administration tools like OEM (Oracle Enterprise Manager) and TOAD.
  • Oracle Database capacity planning, space management and storage allocation.
  • Utilized SQL* Loader and data pump import to load data in to tables.
  • Experience in migrating data from Oracle to Sql Server.
  • Experience in Writing Perl Scripting, Shell Scripting, ksh and bash scripting and Partitioning.
  • Worked with Creating and maintaining of Oracle Data guard configuration.
  • Experience in configuring Oracle Streams for the replication of Data.
  • Implementation of Oracle advanced replication and mechanism.
  • Knowledge in Oracle Data ware house DBA skills relating to administration and management of VLDB environments, Oracle OLAP.
  • Worked on Data transferring with export/import utilities and Data pump.
  • UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
  • Applying patches under UNIX platform.
  • Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
  • Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Languages

SQL, PL/SQL, Perl scripting, Shell, korn shell and bash programming

Storage Technologies

EMC CLARIION, OCFS,OracleASM, SNAPVIEW, SAN

Virtualization Technologies

VMware,OracleVirtual Machines.

Backup Recovery Tools

RMAN, flashback, Legato networker,OracleSecure Backup.

Development and Administration Tools

OracleEnterprise Manager, Grid Control, TOAD, Glance Plus, SQL developer, PL/SQL Developer, SQL*Plus,OracleForms and Reports developer, RMAN

Utilities

SQLLoader, Exp/Imp, expdp / impdp, and stats pack

Technologies

OracleData Guard,OracleStreams

Operating System

UNIX, Sun Solaris, Windows 98/2000/2003, HP-UX

Replication Technologies

Real Time Database Management (RTI), Materialized view

Clustering Technologies

OracleReal Application Clusters (RAC),OracleCluster ready services (CRS), Transparent Application Failover (TAF),OracleCluster File System (OCFS), MC Service guard, Automatic Server Management (ASM).

Confidential, Jul 2008 – Till Date
Durham, NC
Role: DBA
Responsibilities

  • Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and databases upgrade support for approximately 40Oracledatabases.
  • 24x7 Production-on call support for all the production databases withOracle8i, 9i, 10G version.
  • Multi Master Replication/ Streams Support (High Availability) for mission critical databases.
  • Administration and support ofOracleApplication Server 9i and 10g.
  • Stream data between 2 nodes through the use ofOracleStreams.
  • Installed, configured and maintainedOracle10g Real Application Cluster (RAC).
  • Database clone, rename between different platforms.
  • Standby database setup via Dataguard for Database Disaster Recovery.
  • Providing technical support to Application Support team for performance and database related issues.
  • UNIX shell scripting as and when required based on the requirement.
  • Creating Customized Scripts for Streams Replication based on the Clients Requirement.
  • PatchedOracleDatabase Server 9i and 10g using Opatch.
  • Upgrading/migratingOracledatabases from 8i/9i to 10g.
  • Tuned production databases supporting the application using Statspack/AWR.
  • Develop, document, and implement operational support procedures for theOracle infrastructure components.
  • Develop, document, and implement security configuration forOraclesoftware and database instances to comply with existing standards.
  • Refresh development/test databases from copies of production.
  • SQL Tuning using Explain Plan, tkprof with sql trace, SQL Tuning Advisor.
  • Performance tuning via OEM, STATSPACK/AWR for 9i/10g.

Environment:Oracle9i/10g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Toad, PL/SQL Developer, OEM, Windows NT/XP.

Confidential, May 2007 – June 2008
Des Moines, Iowa
Role:Sr.Oracle/SQL ServerDBA

Responsibilities:

  • Installed and configuredOracleRDBMS on various platforms.
  • Physical and Logical Design of the database which includes Database creation, tablespace creation, table and index partitioning and also mapping of different objects with disks
  • Carriedout EXPORT and IMPORT operations on Oracle Database from command promptusing data pump.
  • Monitored the performance ofdatabaseduring stress testing fromOEM (OracleEnterprise Manager).
  • Upgraded databasesfromOracle9i to Oracle 10g version on Solaris and AIX environments.
  • Configured physical standby database as a copy of production database for disaster recovery
  • Maintained Test Databases onOracleand SQL Server for testing and research work
  • Used Flashback feature to recover a dropped tablesand also to recover a database.
  • Configured standby database for SQL Server production database server using sql server log shipping.
  • Used SQL Server Management Studio and T-SQL for managing database related activities.
  • Extensively used SQL Server database tuning advisor and SQL profiler for performance optimization.
  • Installation and configuration of a 4 node clusterOracle10g RAC in Sun Solaris 10(SunOS 5.10)and used ASM for configuring database file system.
  • Restored RMAN backup from4node RAC to single instancebackup server.
  • Developed UNIX Shell scripts for automation ofRMANbackups and othertasks using cron tab.
  • Experience onNETBACKUP CLIENT & SERVERwith RMAN to automate the backups withOraclePolicies.
  • Monitoring ofqueries with high response time andhigh disk reads per execution i.e., Top SQL using OEMand tuning the same using Explain Plan.
  • Used Automatic Workload Repository (AWR) for analyzing the database performance.
  • Performed User Management by creating, monitoring and management of database users.
  • Installedand configuredOracleEnterprise Manager with grid control to manage databases
  • WrotePL/SQL blocks andstored procedures for the tasks of useraddition to databasesand user auditingbased on the user ids required functions and assigned roles, privileges etc.
  • Maintainedand administeredoracledatabase security by granting and revoking system/objectprivileges, roles, auditing user actions in the database.
  • Developed and implemented new shell scripts for various tasks and modified existing scripts based on changes with respect to the environment
  • AppliedOracleSecurity and DST Patches.
  • Generated workingdocumentationfor theDBAteam use.
  • Analysis of alert logfor error tracing

Environment:Solaris (Sun OS 5.10, 5.9), IBM AIX (5L 5.3),Oracle9.2.0.8 &Oracle10.2.0.1, 10.2.0.2, SQL Server 2000 & 2005, Wintel Server, RAC, ASM, UNIX Shell scripting, VI Editor, RMAN, Data pump, OEM,OracleData Grid Control, Sun Fire.

Confidential, Jan 2006- Apr 2007
Buffalo, NY
Role: Oracle DBA

Responsibilities:

  • Involved in design, development, and management of large complex production databases.
  • Responsible for installation, up-gradation ofOracle(9i, 10g, 11g) software in different Environments, Creating and maintainingoracle development and test databases.
  • Conducting sizing and capacity planning fororacle databases.
  • Responsible for the technical support of mission-critical databases running on Oracle, SQL Server and/or other database management systems.
  • InstalledOracle 10.2.4 with multi nodes RAC in ASM storage with normal redundancy.
  • Managed CRS Cluster ware, ASM, Installed DB Control and OEM control Grid control.
  • Up gradation of database fromOracle 9.2.6 toOracle 10.2.4.
  • Determine the best RAC and Data guard topologies for your environment. Defining redo log files, undo table spaces in a RAC Environment. Implement the most common RAC tuning tips.
  • Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
  • Configure and manage services in a RAC environment. Configure services aggregation and tracing. Manually control the Oracle Cluster ware stack.
  • Involved in the design, review, implementation, testing, and release of databases, design specifications and application software.
  • Involved in Oracle Partitioning and responsible for online and offline backups, and Recoveries of variousOracle databases using Data Pump Export/Import Utility.
  • Worked with the Recovery Manager RMAN and OEM in recovering the database.
  • Created Standby databases for Disaster Recovery using Streams and implemented the Streams Advanced Queuing (AQ) messaging setup and supporting it.
  • Involved in data modeling and designing the database using CA-ERwin data modeler.
  • Ensuring security of the database by creating profiles and monitoring user sessions.
  • Interaction with Development Team in fine tuning the SQL and PL/SQL code.
  • Resolve the database issues of the users whenever in need of.
  • Extensively working with Performance/Application Tuning and Memory (SGA) tuning, optimizing and troubleshooting of databases.
  • Migrated databases from Sun Solaris to Windows using RMAN CONVERT option.

ENVIRONMENT: Oracle 11g/10g/9i, Sun Solaris 9,Windows NT, SQL, PL/SQL, ERwin, TOAD, OEM, AWR & ADDM, RAC, ASM, RMAN, STATSPACK, Dataguard/Streams, UNIX Shell & Perl Scripts.

Confidential Oct 2004 - Dec 2005
Role: Oracle DBA

Responsibilities:

  • Installation, configuration, and maintenance of Oracle 8i and 9i on both Windows NT and UNIX environments
  • Create and Maintain Roles and assign necessary privileges to users according to business rules.
  • Allocating system storage and planning future storage requirements for the database
  • Implemented Database Backup (Physical and Logical) and Recovery strategy
  • Configuring TNSNAMES.ORA and LISTENER.ORA for Client-Server connections
  • Creating Database objects like (Tables, views, indexes, procedures, triggers etc) and also monitoring Alert Logs
  • Using Database replication by shareplex.
  • Creating & Maintaining Tablespaces.
  • Choosing different types of data storages (Locally managed tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.
  • Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack, Utlbstat, Utlestat, Diagnostic and tuning packages
  • Plan and Implements backup and recovery of theoracle database Using Rman and Veritas Net backup.
  • Creating and maintaining database cloning and database replication.
  • Implementing Advanced Security in Databases using User, Roles etc
  • Data loads using SQL*Loader, export-imports for backing certain tables.
  • Backing up the production database, synchronizing the standby database by responding to any physical changes in the primary database.
  • Back end Programming using SQL and PL / SQL and UNIX shell scripting.
  • Modifies Oracle instance initialization parameters as necessary
  • Coordination with front-end developers in designing complex queries.
  • Tuning of all the queries using Explain Plan, Tkprof and perfstat tuning of other objects in the database, tuning of database, tune the memory structure.
  • Media Recovery (eg. Hard disk failure, Block Corruptions) using archived logs.

Environment:Linux 8/9, Win NT/03, Oracle 9.2/8.1,PL/SQL,OEM, RMAN, SQL*NET, TCP/IP,
SQL Server 2005.

Confidential, June 2003 – Sep 2004
Role: Jr.OracleDBA
Responsibilities:

  • Perform server installations, configuration, upgrades, and maintenance of Data.Environment multipleOracleServers, distributed database systems,Oraclereplication across multiple locationstuning the server environment, including theCPUandRAM, Monitoring and tuning disk I/O subsystems
  • Detecting and correctinginstanceperformanceproblemsusing statspack.
  • Locating and tuningSQLstatementsusing toad and OEM.
  • Involved inMemoryTuning, Rollback segments, Latch contention Issues, Optimize Sort Operation.
  • Create appropriate indexes for queries and suggesting changes to application developer.
  • Testing the production archive log files by performing time-based recoveries on simulation databases.
  • Performs extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.
  • Creating objects required for the application team after carefully estimating the sizes.
  • Applyingand testing security, applicationpatches.
  • Monitoringalert log and trace files using shell scripts anduser activities by auditing, user privileges, roles.
  • Electronically documented all the Development/Test/Production Activities for the client Record.

Environment:Oracle9i, PL/SQL, OEM, Solaris 8, Windows NT, Windows 2000 Server, MS SQL Server 2000.

Educational Qualifications:B.TechinComputer Science

Hire Now