We provide IT Staff Augmentation Services!

Oracle Dba Resume

0/5 (Submit Your Rating)

SUMMARY

  • Highly motivated individual with excellent communication skills and a strong desire for perfection at work activities, friendly and reliable team player with exceptional work ethics.
  • Excelent understanding of RDBMS systems and working experience on Oracle database administration including Real Application Clusters,Golden Gate on 11G / 12C versions and 12C Oracle Enterprise Manager.

TECHNICAL SKILLS

Operating Systems: RHEL 6.x/5.x/4.x, Sun Solaris 9.0/10.0

Technologies: Oracle 12C/11G, GRID 12C/11G, ASM, RAC, GOLDENGATE, DATAGUARD, Entity Relationship Modeling

Programing Languages: SQL, PL/SQL, Unix shell scripting, Java, C++, C, HTML.

Tools: /Utilities: RMAN, Data Pump, SQL*Loader, Oracle Enterprise Manager, Toad, Putty, DBCA, RMAN

Backup Tools: RMAN, Datapump, Export/Import

Monitoring Tools: OEM 12c, TOAD, ASH, AWR, ADDM

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

  • Installed and configured 12.1.0.2 grid on two node Real Application cluster and created cluster databases.
  • Creating, configuration and management of 11.2.0.4 and 12.1.0.2 oracle on RHEL and SOLARIS servers.
  • Performed database upgrades of single instance database from 11.2.0.4 to 12.1.0.2 databases
  • Responsible for configuring and taking Full database, Incremental and Cumulative backups using RMAN utility.
  • Implemented Flashback on database to support rolling back the database in case of application upgrade failures
  • Performed adding and removing hosts, databases, targets and creating administration groups in oracle enterprise manager 12c
  • Applied patches on 12.1.0.2 cluster nodes provided by oracle support for bug resolution
  • Performed Refresh of Schema from production environment to lower environments using datapump
  • Debugged Real application cluster node reboots to find root cause for node eviction
  • Generated AWR reports, ADDM reports for fine performance tuning and worked closely with PL/SQL developers to tune top resource intensive SQL queries in databases.
  • Enabled archive log mode on production databases allowing to replace RMAN cold backups with hot backups thus reducing database downtime.
  • Monitoring the database for growth and added space to the table spaces as per demand.
  • Responsible for configuring and backing up database using RMAN and performed Hot backups, Cold backups and Logical backups.
  • Performed Application Tuning by tuning sql queries, identifying problematic code, creation of indexes, re - writing queries to use an optimized path
  • Created change and incident tickets in Remedy and coordinated with UNIX support on server level requirements
  • Experience in monitoring Oracle Database 11G and 12C using Oracle Enterprise Manager (OEM).
  • Utilized OEM Advisory home to fine tune SGA, PGA memory sizes and undo tablespace size
  • Managed and modified Automatic scheduler jobs, windows using DBMS SCHEDULAR package
  • Collected statistics on tables using DBMS STATS and purged explain plan from shared pool to cause hard parsing and generate new explain plan
  • Hands on experience in performance tuning using EXPLAIN PLAN,Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM).
  • Extensively utilized server control utility SRVCTL to manage Database, ASM and LISTENER targets
  • Created new range partitions on tables on yearly basis to support incoming data for the coming year
  • Experience as On-Call 24x7 production DBA, monitoring OEM alerts and responding in time to resolve the underlying issue.
  • Implemented Automatic memory management and set minimum values to SGA and PGA
  • Modified dynamic and static parameter in both pfile and spfile to make in memory and permanent changes.
  • Implemented numerous application code deployments and reviewed application scripts for potential issues.
  • Created and dropped restore point in databases before performing code changes on the databases
  • Created par files and set up daily expdp metadata and schema backups using CRONTAB
  • Backed up spfile by creating a pfile whenever parameter changes are required
  • Performed various tasks on ASM, creation of disk groups, Adding disks to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.
  • Experience in designing and implementing PL/SQL stored procedures, functions, packages, triggers
  • Performed Data load on different databases from flat file using SQL*Loader.
  • Created db links between databases and utilized them to retrieve objects from remote databases.
  • Conducted daily routine checks using alert logs and trace files for database errors and performed necessary actions to resolve the issue.
  • Designed table structures, applied foreign key relationships between tables and included unique constraint to avoid data duplication.
  • Created 11G/12C databases using Database Upgrade Assistance (DBUA) and manually with create database statements.
  • Created indexes on columns that are used in the data retrieval condition clause to improve data retrieval speeds.
  • Created and maintained oracle databases 11g and 12C on ASM and Non-ASM hosts
  • Extensively utilized CRONTAB to schedule and automate maintenance jobs
  • Modified extract and replicat parameter file to add tables to setup table replication
  • Stopped goldengate extract, replicate and manager process to allow unix to perform server patching and brought up golden gate process once the patching was complete.
  • Performed blackout on targets in OEM to avoid alerts while performing maintenance tasks
  • Performed debugging of status pending on targets and restarted agent in cases where agent could not start automatically.
  • Created change tickets, incident tickets using BMC remedy and presented high risk production changes in CAB - Change Review Board meetings for approval.
  • Created and Managed users accounts, roles, privileges, and assigned, revoked roles and privileges from users.
  • Assisted developers in creation of schema objects such as tables, indexes, materialized views, sequences and making them aware how the objects can be created, modified to provide optimal application performance.
  • Involved in capacity planing and specifying CPU, memory and space requirements by considering database workload metrics.
  • Raised Service requests and worked with oracle support on critical issues/bugs to analyze the cause and obtain permanent fix
  • Manage agents using emctl utility and creating incident rules in enterprise manager 12c
  • Application of PSU's on 11G,12C environments on single instance and mutli node RAC systems to adhere to oracle security standards and to implement bug fixes
  • Performance Tuning for the SQL queries which are Running slow and consuming high resources
  • Worked on day to day activities like Space management, managing user privileges managing tablespace quotas, table partitioning to improve I/O access.

Confidential

Intern Jr DBA

Responsibilities:

  • Assisted in Installing and configuring oracle 11.2.0.4 software home
  • Created and performed user maintenance tasks like creating users, unlocking users and assigning profiles to users.
  • Performed resource management and applied user level security recommendations on user accounts using profiles.
  • Implemented range partition and hash partition to improve performance.
  • Created Packages, Stored procedures for automating regular developer tasks such as table truncation, statistics gathering, enabling/disabling constraints and rebuilding indexes.
  • Created and Managed Schema objects like tables, indexes, constraints, views, materialized views, synonyms, DB links, sequences and triggers.
  • Created DML queries to retrieve/load/update/delete data while implementing complex conditional clauses

We'd love your feedback!