We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

SUMMARY

  • Over 5+ years of IT experience working as Oracle Database Administrator.
  • Around 2 yrs of experience in PL SQL Development .
  • Experience in database administration, installations, configuration, upgrades, performance tuning, backup & recovery , cloning , space management, & patching .
  • Expertise in Oracle Database (9i/10g/11g/12c) Administration.
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Experienced in ITIL framework like Incident Management and Change management.
  • Generate and interpret Automatic Workload Repository ( AWR ), Active Session History ( ASH ) and Automatic Database Diagnostic Monitor ( ADDM) reports.
  • Exposure to several high - end technologies like Database Migration, Cloning, Standby DB’s, Hot and cold Database Backup & Recovery, RMAN and Disaster Recovery.
  • Experience in SQL performance tuning using Cost-Based Optimization (CBO).
  • Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard .
  • Extensively coordinated database and OS support with global vendor support team of Oracle, HP-Unix and EMC SAN Storage.
  • Creating Disaster Recovery Sites (DR) for production and critical database.
  • Experience in SOX Controls, compliance reporting and audit validation.
  • Installed and Configured 2 node 11.2.0.1 and 12.0.1 RAC setup on Linux.
  • Installing ASM environment and migrating database from NON-ASM to ASM .
  • Performed logical backup of database, schemas, tables using Export/Import and DATA PUMP utility. DB User Administration and Security management .
  • Used SQL * Loaders to load data from flat files into database tables.
  • Involved in fine tuning stored procedures by making use of PL/SQL Collections
  • Designed and Developed shell scripts to automate the processes and to proactively monitor the database. Worked on AIX, Linux, Solaris and Windows platform.
  • Proficient in creating primary database storage structures (Tablespaces) and Managing database using Schemas, Tables, Views, Indexes, synonym, functions and Triggers.
  • Controlling and maintaining system security through Profiles, Roles, Privileges and Auditing. Knowledge on using DBMS Packages
  • Extensive experience in Database query and Performance tuning ( Explain Plan and TKPROF utility ) of Reports and troubleshooting Oracle Application issues on OLTP.
  • Involved in database design and creation. Good knowledge in Software Development Life Cycle.
  • Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Database: Oracle 9i,10g, 11g R2,Oracle 12c

DB Tuning/Monitoring Tools: RAC, ASM,DATA GUARD, Oracle Enterprise Manager (OEM) 10g,11g & 12c, TKPROF, SQL Trace, STATSPACK, SAP BRtool, EMC Networker, BMC Remedy, TOAD, Golden gate, SQL *Plus, developer

Programming: PL SQL, Shell scripting, T-SQL,SQL/PLSQL

Operating Systems Platforms: Solaris 5.10, RHEL, AIX,HP-Unix, Microsoft Windows 2003 Server, LINUX, VM Ware 12

PROFESSIONAL EXPERIENCE

SR. Oracle DBA

Confidential

Responsibilities:

  • Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • Experienced with SRVCTL for monitoring and configuring RAC Environment .
  • Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.Refreshed non-production environments from production database backup for developers.
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Perform Database cloning to setup identical databases in the production and development environments.
  • Monitor and troubleshoot database backups, disk space and server availability.
  • Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
  • Creating indexes on fields that are used most often for search criteria.
  • Performing reorganization activity with SAP Brtools on production server.
  • Troubleshooting database/table level deadlock, blocking issue.
  • Experience in SOX Controls, compliance reporting and audit validation.
  • Ability to demonstrate multi-tasking capability, contingency planning, risk assessment and cost benefit analysis.
  • Used EXPORT/IMPORT to do table level and full database de-fragmentation .
  • Supported 400+ databases (Production, Dev, Test, QA) for Pitney Bowes.

Oracle DBA

Confidential

Responsibilities:

  • Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans.
  • Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup.
  • Monitor all production Oracle Databases for disk usage to plan future disk space needs per database.
  • Hands on experience with tools like SQL*Plus , Export and Import Utilities along with Oracle Enterprise Manager ( OEM ), and TOAD.
  • Hands on Experience in Space Management, Capacity Planning.
  • Maintain Oracle service patch levels on all production oracle servers based on the client requirements. Managing Tablespaces, Data files and OS File Systems.
  • Monitor all production Oracle DB servers for performance bottlenecks.
  • Scheduled shell scripts cronjobs for regular maintenance and automating backups.
  • Monitor and schedule backup with EMC networke r.
  • Maintain Backup Policies and procedures including Hot and Cold backup.
  • Involved in Database sizing, Capacity Planning. Perform Database upgrade & apply patches . Perform Space Management & Troubleshooting the database issues.

System Admin

Confidential

Responsibilities:

  • Manage product data and maintain record of all sales.
  • Created and managed SCHEMA, TABLES, INDEXES,VIEWS.
  • Proficient in SQL DDL, DML, DCL, TCL & SELECT statements.
  • Managing Tablespaces, Data files and OS File Systems.
  • User Administration and profile management.

Hire Now