We provide IT Staff Augmentation Services!

Oracle Dba Resume

MI

SUMMARY:

  • Over 8 years of DBA Experience.
  • Migrated databases to AWS platform.
  • Expertise in managing 10, 11g and 12c Databases.
  • Expertise in setting up RAC Clusters
  • Expertise in setting up Data Guard.
  • Expertise in managing 13c OEM.
  • Intermediate expertise in administering SQL Server.
  • Expertise in setting up ASM storage.
  • Installation of Oracle on Linux.
  • Adding and deletion of Node in RAC.
  • Build and worked on Oracle Data Guard environment
  • Written shell scripts to monitor oracle databases that includes alter log, file system and tablespace.
  • Provided technical assistance to vendors in development and implementation of applications.
  • Solved difficult performance tuning, troubleshooting and administration issues.
  • Involved in database capacity planning
  • Provided 24/7 on - call support.
  • Migrated database from non-ASM to ASM.
  • Worked on migration project
  • Managed databases on Exadata
  • Applied PSU and bundle patches.
  • Worked on DB Links and Materialize Views Server.
  • Worked on oracle Security.
  • Worked on Transparent Data Encryption.
  • Worked on many performance related issue involving SQL Tuning, Instance Tuning and network troubleshooting
  • Performed DR exercise using Data Guard
  • Designed and developed PL SQL stored procedures to automate dbms jobs.
  • Setup backup jobs using RMAN
  • Restored and recover databases using RMAN
  • Administered replication done via GoldenGate.
  • Used export import and Data Pump for refreshing database objects.
  • Monitor the database by collecting statistics of instance and files by querying data dictionary views, SQL trace files and TKPROF, STATSPACK to find ways to improve the database's performance.
  • Loading data in to the Database using SQL*Loader and scheduled Cronjobs.
  • Analyzing the SQL Query using Explain plan.
  • Analyze the index if necessary rebuild or Coalesce index to rectify segment fragmentation
  • Cloning databases using RMAN duplicate database
  • Worked on partitioning tables

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, MI

Responsibilities:-

  • Installing and creating 11g and 12c databases on AWS cloud.
  • Migrated database to Exadata.
  • Build RAC Clusters
  • Build and managed Data Guard.
  • Installed and configured Oracle 12c, 11g, 10g 64 Bit on Linux for Production, Development and Testing.
  • Provided day to day operations support.
  • Applied PSU patches.
  • Managed databases on Exadata.
  • Implemented GoldenGate replication.
  • Cloned Databases via RMAN duplicate
  • Restored databases from RMAN backup
  • Performed point in time recovery.
  • Monitoring & Managing the Tablespaces and datafile growth
  • Proficient in database design, triggers, snapshot and stored procedures in Oracle 9i,10g and 11G
  • Database designing, Database administration.
  • Defining backup & recovery plan, Database tuning.
  • Worked on oracle TDE and wallet management.
  • Tuned instances and SQL queries.
  • Worked on Analyzing ASH and AWR reports.
  • Data Guard implementation and maintenance for Disaster Recovery.
  • Alert Log Checking (Monitoring) and User trace File and Archive log maintenance.
  • Creating users, granting roles, Creating and Maintaining snapshot.
  • Refreshed database objects using Data Pump.
  • Monitoring locks and various sessions.
  • Monitored and scheduled jobs via 13c Cloud control.
  • Performing Day-to-Day DBA tasks - performance tuning, database design, system security, database installation configuration, patching, technical database support in 24X7 environments.
  • Responsible for quarterly patches, /maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products.
  • Setup/configured oracle RMAN for database backup and recovery. Application of different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & OS scripts like shell & cron job schedule.
  • Installation of oracle database and clients on UNIX and windows (Silent installation, GUI installation.

Oracle DBA

Confidential

Responsibilities:-

  • Performed core DBA tasks such as Database Administration on Oracle 10g/11g environments, performance tuning, schema creation, maintenance and troubleshooting.
  • Developed ad hoc shell scripts and dynamic SQL codes to automate and schedule maintenance jobs.
  • Involved in performing Oracle 10g/11g to 12c upgrades on Sun and Linux.
  • Designed conversion of non-partitioned to partitioning of very large tables for performance improvement.
  • Coordinated with application patches and database upgrade from Oracle 10.2.0.3 to 11g release 2.
  • Worked on RAC on RHAS with 4 nodes server side load balancing using Automatic Storage Management.
  • Worked with PL/SQL stored procedures, developed SQL scripts and Korn shell scripts to automate tasks.
  • Database Cloning & Advanced Queuing Concepts.
  • Worked on Shell scripts given by Linux Admin for automating various database tasks in UNIX platform.
  • Created and maintained standby databases.
  • Created new users and managed roles and privileges.
  • Managed Rollback Segments, Redo logs, Control files, and Table spaces.
  • Developed and fine-tuned PL/SQL & UNIX that update the data warehouse on their scheduled run.
  • Generated reports in Oracle Reports by analyzing the database based on the specific business requirements.
  • Involved the Post-migration task (Unit-testing) for every RAC & standalone servers.
  • Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.
  • Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery.
  • Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues disasters from happening.
  • Successfully configured the databases to switchover, failover and fallback scenarios.
  • 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.
  • Written shell scripts to automate jobs.
  • Worked on performance related issues.
  • Build RAC and added node.
  • Worked on SQL Server 2005 and SQL Server 2008 instances.

Oracle DBA

Confidential

Responsibilities:-

  • Oracle DBA experience includes monitoring table space, indexes, reorganization databases, Backups, Alert files.
  • Create new users and manage privileges and monitor user access to the databases.
  • Monitoring the Database growth and increase the table space size in production databases.
  • Upgraded/migrated the production & development databases from 10g to 11.2.0.1 to 11.2.0.2
  • Participated in discussions with the management regarding the advantages/disadvantages and upgrade plans.
  • Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Assisted in Database sizing, Capacity Planning.
  • Performed Space Management & Troubleshooting the database issues.
  • Upgraded OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
  • Configured and managed agents to work efficiently with Grid Control.
  • Generated ASH, AWR, ADDM reports from Grid Control and command line.
  • Set up privileges to create local and remote objects.
  • Created materialized views to refresh data at regular intervals.
  • Used materialized view logs to reduce the replication time costs for fast refreshes.
  • Upgraded/Migrated from Oracle 9i databases to 10g and to 11g.
  • Discoverer Administration including the design and administration of Business areas.
  • Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.
  • Developed PL/SQL based program for loading Data Mart.
  • Created and maintained users, roles and privileges.

Hire Now