We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

MD

Objective

Seeking a challenging position in Oracle Administration where my skills be fully utilized and provide an opportunity for advancement.

Professional Summary
  • An Oracle DBA having 7 years of progressive experience. Skilled in high-volume workflow and creative problem resolution capabilities. Experienced in managing production databases, troubleshooting, inter-departmental coordination and escalation management.
  • Experience as SPA BASIS Administrator
  • Experience on multiple platforms and environments spanning IT, Medical and Technical sectors.
  • Experience as On-Call 24x7 production DBA support, application/development DBA.
  • 4+ years of experience in Oracle 10g/11g RAC implementation andadministrationfor high availability on Linux and UNIX environments.
  • 4+ years of experience in Oracle ASM configuration and administration.
  • 2+ years of experience in oracle 11gR1/R2 and good knowledge of new features.
  • 5+ years of experience in creating and managing standby databases for disaster recovery.
  • 4+ years of experience in implementing and managing oracle ENTERPRISE GRID CONTROL.
  • 6+ years of experience in planning backup and recovery operations using RMAN & User-Managed.
  • Experience in analyzing AWR, ADDM, Statspack reports.
  • Hands on experience in performing logical backup using DATAPUMP for non-production database, schema refreshes.
  • Database software installations, patch and upgrades.
  • Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
  • Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments
  • Frequent interaction with development, network, system and storage teams.
  • Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training.
  • Hands on experience on RAC (Real Application Clusters) and Automatic Storage Management (ASM)
  • Hands on experience in using SQL * Loader and Log Miner Utility
  • Creation and configuration of Duplicate database by using RMAN utility
  • Good understanding of the business, follow the ITIL process and adhere to customer’s SLA’s.
  • Interface with ORACLE SUPPORT for technical assistance.
  • Ability to learn new technologies and adapt to a dynamic environment.
  • Dedicated and committed with good team leadership skills.
  • Successful in meeting new technical challenges and finding solutions to meet the needs of the customer.
  • Oracle Table Partitioning , Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.

Technical Skills

Operating Systems

HP-UX 10.x,11.x, Sun Solaris 2.5,2.6,8,9,10, AIX 5.1,5.2, Red Hat Linux 2.1,3.x,4.x, SCO-UNIX, OEL and windows 98/ME/NT/2000/XP

RDBMS

Oracle 11g/10g/9i/8i, Oracle 10g Real Application Cluster (RAC), ASM

Tools and Utilities

RMAN, OEM, TOAD, SQL*Loader ,Erwin, Export/Import, Data pump, Query builder, Net
Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard.

Languages

C, SQL, PL/SQL, UNIX/NT Shell Scripting, awk Scripting, Perl.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Others

SAPGUI, Cron

Web Technology

ERP Portals, BMC Remedy, HP Quality Center, Ruby on Rails

Certifications

Oracle Certified Associate 11g, SAP BASIS Administrator

Administration

SAP BASIS, Oracle Administration

Professional Experience

Confidential, MD Sep 2009 - Present
Role: Sr. Oracle DBA

Apex IT services provides database management solutions and data services for many organizations around the globe. Working as a Sr. Oracle DBA to provide support for Oracle databases on various environments.

  • Installed and Created databases on Oracle 11g, upgraded databases from 10g to 11g R2.
  • Setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager (OEM).
  • Worked on database sizing, performance monitoring and tuning.
  • Administered database servers on RAC environment.
  • Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, import/export and SQL Loader, RMAN-managed backup with or without catalog database and implementing backup and recovery strategies.
  • Worked on creating and maintaining database users and roles.
  • Implement and maintain database security by assigning privileges accordingly.
  • Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
  • Create or clone the Oracle Instance/Databases on ASM. Perform database cloning and re-location activities.
  • Worked extensively on SQL, PL/SQL, and Shell Scripting.
  • Optimizing SQL statements using TKPROF, EXPLAIN PLAN, and STATSPACK.
  • Managed and maintained hosted production, development/test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
  • Performed backups, restores, cloning, or refreshing databases and applications.
  • Documented and complied with company policies and standard operating procedures.
  • Managed and resolved design issues during development.
  • Developed automation scripts for database monitoring.
  • Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Created materialized views.
  • Trained a new DBA in our environment.
  • Tickets and Incident management using BMC Remedy

Confidential, Chicago, IL Mar 08 – Sep 09
Role: Oracle DBA

Based in Chicago, Mesirow Advanced Strategies, Inc. (MAS) is widely recognized among alternative asset managers. It has earned a solid reputation for focused due diligence, portfolio construction, risk management and client service. The client base consists of institutional and high net worth clients from all over the world

Responsibilities:

  • Installed Oracle 10g, 11g database on HP-UX 11.0 and Linux.
  • Upgraded the application database from 9.2.0.7.0 to 11.2.0.1.0
  • Installed and maintained Oracle 10g 2 node RAC and worked on ASM feature
  • Installed, configured and maintained Oracle data guard(primary andphysical/local standby databases) to ensure disaster recovery, high availability and data protection.
  • Involved in setting up of OEM and Oracle grid control.
  • Upgraded databases from 9i to 10g, 10.2.0.1 to 10.2.0.4 and applied patches.
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
  • Performing Data modeling using Erwin.
  • Synchronize Databases with production for data and testing purpose.
  • Creating Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups using OEM & SQL commands.
  • Involved in migrating databases from HP-UX to Linux.
  • Implemented design of physical data storage, maintenance, access and security administration
  • Supported data transfer operations - import/export, SQL*Loader and data pump.
  • Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
  • Used Logminer utility for precision recovery.
  • Cloned Production databases using RMAN, hot and cold backups.
  • Expertise in using RMAN for not only backup and recovery strategies but also to validate databases regularly to reduce redundancy and disk space usage.
  • 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.
  • Handful of experience in performance tuning using the reports generated by AWR, ADDM, Statspack.
  • Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
  • Developed database and warehousing designs across multiple platforms and computing environments.
  • Utilized advanced Oracle features such as table partitioning, Oracle Streams.
  • Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
  • Developed UNIX shell scripts to perform the above tasks efficiently.
  • Tickets and Incident management using BMC Remedy
  • Help and co-ordinate with UNIX Administrators and development team for space management on various servers and help in Oracle installation, upgrading and database issues.
  • Active participation in all team meetings and group meetings to meet the business requirements.

Confidential, PA Mar 2007 – Mar2008
Role: Oracle DBA
Pfizer Inc. is an American pharmaceutical corporation which develops and produces medicines and vaccines for wide range of conditions. Worked as a DBA for over 200 databases on Unix Platforms.

  • Upgraded and migrated databases from Oracle 9.2.0.8 to Oracle10.2.0.1 and applied patches.
  • Upgraded the application database from 10.2.0.3.0 to 10.2.0.4.0.
  • Configured Oracle data guard and Streams.
  • Supported Oracle 9i and 10g databases on 24X7 shifts.
  • Analyzed tables and re-built indexes regularly.
  • Setup of Jobs (startup/shutdown/export data pump) using the Oracle Grid.
  • Setup of the cold backup of test/development databases through RMAN for weekly maintenance.
  • Automating the routine DBA tasks through the Crontab.
  • Improving the performance using the AWR, ADDM, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrievaland processing of queries used for retrieving the data.
  • Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.
  • Online Database Backup, Archived redo log files and Offline backup
  • Configuring Recovery catalog for RMAN
  • Managing table spaces, data files, redo logs, tables and its segments.
  • Maintaining data integrity also managing profiles, resources and password security.
  • Managing Users, Privileges and Roles.
  • Tune SQL statement against database and its objects.
  • Write script to monitor the database with shell and PL/SQL code or SQL PL/SQL code such as procedure, function, and package.
  • Coordinated with cross functional teams to accomplish several DB projects within timelines

Confidential, India
Oracle DBA May 2005 – Mar 2007

SAP AG is the market leader in enterprise application software. Worked as an SAP BASIS admin, Oracle DBA on SAP applications which uses oracle database as backend for ERP production.

  • Create databases, configuring them to meet developer and user requirements.
  • Installed ECC & post installation activities completed
  • Established three system landscape
  • User Creation & Management, spool configuration, Client copy, patch download & updating,
  • etc. are done simultaneously in the landscape as the project grown gradually
  • Client administration which includes copying, export and import.
  • Scheduled standard background jobs periodically
  • Monitoring Logged Users locally and globally
  • Creating and testing the RFC destinations
  • Involved in applying of SAP Support Patches, Kernel Patches and upgrade of other SAP
  • executables for fixing SAP bugs and smooth system runtime
  • Package deployment using SDM
  • Analyzing ABAP Dumps, System Logs, Update Statistics and Locks
  • Maintaining Profile parameters
  • Printer Configuration
  • Monitoring work processes
  • Analyzing of missing authorizations (SU53) and assigning Roles to users
  • SAP GUI Front End Installation
  • Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
  • Involved in Data Extraction using UTL_FILES in PL/SQL.
  • Supported Oracle 8i, 9i databases on 24X7 shifts.
  • Implemented Oracle Streams from Oracle 8i to Oracle 9i.
  • Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards & Quality assurance.
  • Tune database to ensure acceptable level of performance and availability.
  • Install client side of Oracle on developers and end-users PC and configuring them with network connections.
  • Extending the database storage capacity by creating new tablespace, adding datafiles to table space
  • Manages and maintains the data dictionaries.
  • Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files.
  • Configuration of physical standby database.
  • Good understanding of the business, follow the ITIL process and adhere to customer’s SLA’s.
  • Extensive experience in handling different kinds of ORA errors.
  • Used Hints, Indexes, Explain Plan, Sql_Trace and Tkprof for effective retrieval and processing of queries used for retrieving current details and also history of changes made for a version.
  • Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.

Education:

  • Master in Computer Applications

Hire Now