We provide IT Staff Augmentation Services!

Senior Technical Analyst ( Sr Oracle Dba) Resume

SUMMARY:

A results - oriented Oracle certified professional with 5+ years of experience in every stage of Database Implementation includes experience designing & Performance. Team player with ability to design and develop structured that adheres to well establish software engineering standards. Proven ability to fix Error, bugs and problems quickly and effectively. Excellent communicator and team player.

STRONG SKILLS IN:

  • RAC/ASM
  • Database Designing / Database Administration
  • Database Monitoring / Performance Tuning
  • Installation/ Upgrade/Downgrade
  • Backup and recovery (RMAN & Manual).
  • Standby Servers (Manual, Managed)
  • Data Guard/Cloning

KEY SKILL:

DATABASE: Oracle 8i & 9i, 10g, 11g , Sybase, Informix, MS SQL Server 7 & 2000, MS Access.

O. S: MS-DOS, Window 95/97/2000/NT/ME, Linux, UNIX, (Sun Solaris, Novell, HP).

TOOL: Quest Suite, Oracle Enterprise Manager, Toad, RMAN, Export and Import Utility ( expdp/Impdp), Oracle Tuning Tools (SRVCTL, CRS STAT, ADDM, AWR, STATSPACK, SQL TRACE,ADDM, TKPROF, Explain Plan)

LANGUAGE: C, C++, Unix Shell scripting, PL/SQL, Pro “C”

PROFESSIONAL EXPERIENCE:

Confidential

Senior Technical Analyst ( Sr Oracle DBA)

Responsibilities:

  • Installed, Configured and Managing Database 11gR2 Grid Infrastructure (RAC ), 10gr2 on ASM and SAN storage devices. (Installation /configuration/administration/ Performance).
  • Troubleshooting of Clusterware issues in RAC using dynamic and component level debugging of CRS, OCR, CSS, and EVM Modules.
  • Resource Debugging along with Checking the Health of the Clusterware and Troubleshooting the Oracle Cluster Registry.
  • Managing ORACLE RAC from GC, Install Grid Control agent and configure the agent targets ( databases, listener, hosts ).
  • Setup the notifications alert and handle the database performance tuning
  • Migration of 10gr2 to 11gr2 along with storage.
  • Migrate OCR and Voting disks from Shared location (RAW) to ASM diskgroup (11gr2), Migrate Non RAC to RAC database. Configure Scan listener and Add new nodes in cluster.
  • Database Server Tuning using Explain the Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH), SQL Performance Analyzer (SPA), Memory Tuning, Disk I/O Tuning.
  • Database Application Tuning using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM),, Automatic SQL Tuning, Automatic Tuning Optimizer,SQL Tuning Advisor,SQL Profiles,SQL Access Advisor.
  • Operating system tuning using Monitor Operating system using the following tools: (Sar, vmstat, iostat, glance, netstat, ps, sam).
  • Web logic 10.3.2 / 10.3.5 installation and configuration, Upgrade, Patching, Monitoring along with Fusion Middle Were (SOA, IPM, BEPL, IAM, OES, BPM, UCM, ODSM, bpel) products as per customer specification.
  • Established Database performance tuning for middleware product and implemented same to production for go live.

Confidential

Sr. ORACLE DBA

Responsibilities:

  • Managed Production Database on RAC Environment on 10g and Standby Database on 11g, 10g, and 9i. Closely Monitor all database and there performance along with team.
  • Configured raw disks, ASMLIB (ORCL) disks for Oracle RAC.
  • Allocate space in Diskgroup in ASM through ASMLIB and Raw device.
  • Also Installed Oracle RAC and Performances tunning for Oracle Real application Cluster (RAC).
  • Database configuration Task, Database instance control tasks like add, remove, modify nodeapps configure services and managing Oracle RAC with SRVCTL.
  • Applying a patch set to $ORA CRS HOME, Debugging CRS problems starting/stopping nodes, Resource permission, Resource relocation, register/unregister application in CRS Management. Adding/Replacing/Deleting/Moving OCR and Voting disk to Raw device to ASM
  • Data migration between environments using Export/Import, EXPDP, Transportable Table space, and knowledge about Oracle Streams
  • Tuned large database for optimal performance using 10g OEM, AWR, STATSPACK, AUTOTRACE, SQL TRACING, EXPLAIN PLAN, ADDM, SQL Advisor, GRID Control with Stored Outlines and Performance views.
  • Generating administrating Reports of Database on free space statistics, cache statistics and database. Performance tuning of variable parameter, disk I/O, CPU utilization, paging rate, buffer, data dictionary and library cache, miss ratios calculations.
  • Space Fragmentation monitoring and reorganizing tables and rebuilding indexes
  • Creating, altering and dropping datafiles, tablespaces, and schema objects in the database.
  • Writing scripts to record and report the change of free space, data extents, datafiles and system static information.
  • Implemented and tested RMAN Backup strategies in Production, Testing environment for Backup and Recovery.
  • Responsible for monitoring daily and weekly backups, alert logs & space.
  • Monitoring archived logs generation archived log disk partition and archived log backup.
  • Monitoring Oracle backup schedule and completion of backup activity.
  • Monitor all applications, processes & services for healthy and Create primary database storage structures and primary objects, Table partitions.
  • Created Index Organized tables, Creating Locally managed Tablespaces.Storage Management, Managing Space, TablespacesManaged Standby Servers on RAC and Cloning the databases using Hot backup RMAN. Conversion of single node oracle database to ASM/RAC in test environment

Confidential

ORACLE DBA

Responsibilities:

  • Priorities included 24 x 7 production support on - call emergency response on Pepolesoft, Remedy. Lingo Servers. Worked with application developers in resolving application issues.
  • Used performance tuning utilities like SQL trace, Tkprof, Explain plan, Schema statistics, Auto trace and Stats pack to monitor performance and made the appropriate changes to improve performance.
  • Generating administrating Reports of Database on free space statistics, cache statistics and database. Performance tuning of variable parameter, disk I/O, CPU utilization, paging rate, buffer, data dictionary and library cache, miss ratios calculations.
  • Creating, altering and dropping datafiles, tablespaces, and schema objects in the database. Writing scripts to record and report the change of free space, data extents, datafiles and system static information.
  • Responsible for monitoring daily and weekly backups, alert logs & space. Monitoring archived logs generation archived log disk partition and archived log backup. Monitoring Oracle backup schedule and completion of backup activity.
  • Monitoring, Maintenance, Trouble Shooting of running Oracle Database server.
  • Monitoring of the Oracle Database Server to ensure database availability and smooth functioning of the databases
  • Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.Storage Management, Managing Space, TablespacesCreating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).Deciding the naming conventions of datafile, redo log files, tablespaces, and segments.
  • Backup and recovery: Ability to implement and test valid backup and recovery strategies for database. (with RMAN & User Managed Backup & Recovery)
  • Managing Standby Servers and updating archives manually on weekly basis. Also implementing Managed Standby Server. Cloning the databases using Hot backup RMAN.
  • Worked on Oracle Clustering on testing phase to implement in Production mode on 10g environment..

Confidential

DATA BASE ADMINISTRATOR

Responsibilities:

  • Writing, Implementing and testing of backup procedures for the Development, testing and production environment using hot back-up strategy and Oracle provided tool Recovery Manager (RMAN) for 8i and 9i on Solaris 5.7,5.8 and RHEL 4
  • Performance tuning of variable initialization parameter, disk I/O, CPU Utilization, paging rate, buffer, data dictionary and library cache, miss ratios Calculations.
  • Tuned the database for optimized performance, by tuning the SGA, Rollback Segments, and Redo Log Buffer. Database performance tuning experience using EXPLAIN PLAN, AUTOTRACE, TKPROF and STATSPACK utility.
  • Database design and creation estimate size for table spaces, tables, redo log files, indexes, rollback segments and managing objects
  • Take backup of these databases on daily routine Backups are performed using via RMAN/hot backups as well as Oracle Exports and weekly physical backups.
  • Database tuning, application tuning, rebuilding indexes, performance monitoring, changing initialization parameters, disk I/O, memory tuning to improve the performance of online database monitored the database and tuned the application code for better performance. Upload and download files directly from the database.
  • Doing Automation work on servers for table space auto extends and maintenance. Work on monthly maintenance for production servers.
  • Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access databases and what data user can access.
  • Handling backup and recovery of database, applied partial recovery due to loss of data file. Backup and recovery via RMAN/hot backups

Confidential

Data base Designer/DBA

Responsibilities:

  • Responsible for assisting with the conversion of data during a systems integration process.
  • Writing, Implementing and testing of backup procedures for the development, testing and production environment using Recovery Manager (RMAN) for 8i, 9i.
  • Migrated and automated the process of existing application from MS-Access to Oracle.
  • Designed, developed and maintained application using, Oracle8i & 9i, and PL/SQL & UNIX shell scripts.
  • Provided support and training to business analysts, maintained the application and database
  • Database tuning, application tuning, rebuilding indexes, performance monitoring, changing initialization parameters; disk I/O, memory tuning to improve the performance of online database.
  • Migrated existing application from MS-Access to Oracle .Created a custom extraction system that populated a data according the user requirement.
  • Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
  • Monitoring the database using the Oracle Enterprise Manager and third party tools like Quest suite, Toad.
  • Backups are performed using Oracle Exports and weekly physical backups.

Confidential

Database Designer/DBA

Responsibilities:

  • Monitoring disk space, CPU and memory usage
  • Configuration of Oracle database initialization parameters
  • Working with programmers to suggest more efficient usage of the database
  • Responsible for trouble shooting the performance issues on the application Backend & databases
  • Backup and recovery via RMAN/hot backups
  • Automated monitoring and maintenance tasks by writing scripts (PL/SQL and/or shell scripting)
  • Maintain Users, Creation of Users, Grant of necessary Roles/ Privileges and allocation of tablespace.Rollback Segment creation, management as need arise
  • Granting roles & privileges to the user
  • Integrate/collaborate with application development and support teams on Projects
  • Maintain the uptime and availability of 2 primary databases and 2 standbys databases running Oracle 8i/9i on Solaris/Linux

Hire Now