We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Boston, MA

Professional Summary:

Oracle DBA with over6+ yearsexperience maintaining Oracle Database running onUNIX/LINUX ( Sun Solaris, HP-UX, AIX ,RedHat Linux) and Windows.

  • Experience asOn-Call24x7productionDBA support, application/development DBA.
  • Extensive knowledge ondatabase administration for Oracle 8i, 9i, 10g and 11g,with experience in very large scale database environment and mission critical largeOLTP and OLAPsystems.
  • Involved with installation and maintenance ofORACLE 10g RAC/oracle 11gRAC and standby database for High Availability and Disaster Recovery purpose.
  • Experience in managing Oracle databases running onMS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
  • Hands on experienceinOracle 10g/11g RAC implementation & administration(Oracle Clusterware setup and configuration, RAC installation usingASM, Grid Installation).
  • Good experienceRAC Clusterware administration,Configuration and Patching.
  • Extensive experience inDataguard configuration, implementing and maintainingstandby databases.
  • Hands on experience in Grid control, Streams, GoldenGate Replication.
  • Experience in Performance Tuning usingEXPLAIN PLAN, SQLTRACE, TKPROF,STATSPACK, AWRand ADDM.
  • SetupOracle Enterprise Manager(OEM) 10g &Grid Control(11g) for database monitoring/performance/diagnostics.
  • Extensive experience in DatabaseBackups RMAN(Full/Incrementalbackups) and in traditionalhot/coldbackups.
  • Experience inLOGICAL BACKUPSand Databasemigrationtools withDATA PUMP, Export/ImportandTransportable Tablespaces.
  • Good experience in writing/editing UNIXShell Scripts.
  • Good experience inPATCHING AND UPGRADATION. Expertise inupgradingOracleDevelopmentandProductiondatabases from 8i to 9i,9ito10g&11g, 10g to 11g.
  • Extensive knowledge and experience on managing very largeData Warehouse databases.
  • Proficient inSQL, PL/SQL, Stored Procedures, Functions, CursorsandTriggers.
  • Extensive experience in configuring and implementingASMand proficiency in usingASMCMDandASMLIB.
  • Experience inFlash-Back Technology.
  • Experience inDatabase Refreshand patch management and inDatabasecloningwith RMAN and manual methods.
  • Experience in Capacity Planning and Bench Marking.
  • Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control(OEM).
  • Proficient in raising TAR withOracle Supportand usingMetalinkto resolve the bottlenecks in the database environments.
  • ExcellentCommunication skills, co-ordination and communication with system administrators, business data analysts and development teams.

TECHINICAL SKILLS:

  • RDBMS: Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle 8i, Oracle 7.3, SQL Server, MySQL.
  • Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT,2000/2003/2005.
  • High Availability , Tuning:
    & Monitoring Products Oracle 10g RAC, Oracle 11g RAC,
  • Tools & Utilities: ASM, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR,
    ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump (expdp/impdp), SQL Loader.
  • ETL & Reporting Tools: Informatica , Power Center 8.5/8.0,Data Stage6.0,1.0,
    Business Objects Xi R26.1, Oracle Data Integrator, SAS
  • Backup Tools: Veritas NetBackup, NetApp, HP OmniBack, TSM,EMC
  • Programming Languages: C,C++,Asp.Net, XML, HTML, DHTML, CSS, Java

Education:

  • Bachelor of Technology

Professional Experience

Confidential, Boston, MA Aug 09 - Present
Sr. Oracle DBA

Responsibilities:

  • 24x7 Production database and applications support.
  • Installed, configured, and maintained Oracle 10g and 11gR2.
  • Upgradeddatabases fromOracle 9i, 10g to 11g.
  • Involved with installation and maintenance ofORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
  • Restoration and Recoveryof databases at the times of occurrence of critical failures.
  • Responsible forinstalling, upgrading and configuringthe Oracle environment bycreating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
  • Applied CPU patches.
  • ImplementedOracle database backup & recovery solutions using RMANand manual methods.
  • Performed block recovery using RMAN.
  • Moving data between databases using Data Pump.
  • Performedlarge batch jobs, and tuning of SQL queriesand database systems.
  • CreatedUser accounts, Rolesand granting requiredaccess permissions and privilegesto the database based on the applications they are accessing.
  • Partitioned large tables for better performance and manageability.
  • Installed and configured GoldenGate for replication.
  • Responsible inconfiguring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
  • Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
  • Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
  • Worked withData Pumpto take the logical backups of databases.
  • Experienced in performingPoint-in-Time Recovery.
  • Performed Capacity Planning and Bench Marking
  • Load and Transform data using SQL*Loader and External Tables
  • Logical and Physical Database Design
  • Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
  • Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

Confidential, Lincolnshire, IL May 08 - Aug 09
Oracle DBA

Responsibilities:

  • Installed, configured, and maintained Oracle 10g and 11gR2.
  • Upgradeddatabases fromOracle 9i, 10g to 11g.
  • Involved with installation and maintenance ofORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
  • Responsible forinstalling, upgrading, patching and configuringthe Oracle environment.
  • ImplementedOracle database backup & recovery solutions using RMAN.
  • Extensive uses of Oracle Data pumpExports/Imports utilityfor moving data among the servers.
  • Performedlarge batch jobs, and tuning of SQL queriesand database systems.
  • CreatedUser accounts, Rolesand granting requiredaccess permissions and privilegesto the users.
  • Partitioning and re-organization of table and indexes.
  • Configured and implementedOracle Streams.
  • Implemented downstream capture at the destination database using Oracle Streams.
  • Responsible inconfiguring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
  • Written scripts for the automation of backups and clonings
  • Migrated databases from HP-UX to IBM AIX.
  • Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
  • usedData pumpto take the logical backups of databases.
  • Involved in designing logical and physical data models using Erwin.
  • Migrated databases from HP-UX to Sun Solaris, and Windows to Linux.

Environment: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, Data Pump, SQL*Loader, AWR, ADDM

Confidential, Columbus, OH Nov 07 - May 08
Oracle DBA

Responsibilities

  • Provided 24X7 support for all the production and development databases.
  • Installed and configured Oracle 10g.
  • Performed upgrades from Oracle 9i to 10g.
  • Administration of Oracle Applications versions 11i.
  • Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
  • Applied Oracle Applications and database patches.
  • Cloned/RefreshedOracle Databases and Oracle Applications.
  • Responsible for optimizing the queries and application tuning.
  • Perform SQL tuning and assist developers with coding PL/SQL.
  • Provided support to Application Database Administrators in designing the database.
  • Installed and Implemented Backup & Recovery procedures.
  • Implement Hot, Cold and Logical backup plans.
  • Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
  • Automation of data load using Korn shell scripting andSQL*Loader.
  • Responsible for setting and managinguser accounts, Granting required privileges to users.
  • Defining and Implementation of backup and recovery strategies.
  • Perform other regular DBA activities including space management and performance monitoring.
  • Optimizationand tuning SQL queries usingTRACE FILE, TKPROF, EXPLAIN PLAN.
  • Continuous monitoring of database performance during peak and non-peak loads usingSTATSPACK.
  • Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Servers.

Environment: oracle 11g/Oracle 10g RAC/9i/8i, REDHAT LINUX, ASM,OEM (Grid Control), IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, AWR, ADDM

Confidential, Hyderabad, India Jul 06 - Oct 07
Oracle DBA

Responsibilities:

  • Maintenance of Oracle Production, Development, Testing and QA databases.
  • Installation and configuration of Oracle 9i, 10g databases.
  • End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
  • Worked with developers to provide queries and tuning the queries for better performance.
  • Issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.
  • Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files. Allocate and Manage logical storage structures like Table spaces.
  • Databasebackup & Recovery.
  • Load data using SQL*Loader.
  • Alert monitoringandTicketing.
  • Developed SQL,PL/SQL Programssuch as procedures, functions, packages and triggers
  • Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines.
  • Coordinating Backup and Recovery operations over all databases.
  • Creation of users and Granting them privileges and roles.
  • Export and Import Data according to the users request.

Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, REDHAT LINUX, OEM (Grid Control), RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, STATSPACK, AWR, ADDM

Confidential, Hyderabad, India Feb 05 - Jun 06
Oracle DBA/Developer

  • Involved in 24x7 production database maintenance and on-call support.
  • Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
  • Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
  • Designed backup and recovery procedures forOLTPsystem. Conducted periodic cold and hot backups.
  • Instance cloning done to create test and training environments.
  • Developed SQL,PL/SQL Programssuch as procedures, functions, packages and triggers
  • Partitioned large tables to increase the performance.
  • Configured scripts to monitor activity with database.
  • Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, WINDOWS, OEM (Grid Control), RMAN, Explain Plan, Data Pump, EXP/IMP

Hire Now