We provide IT Staff Augmentation Services!

Oracle Dba Resume

4.00/5 (Submit Your Rating)

Minneapolis, MN

Hire Now

SUMMARY:

Over 7 years of experience in the following areas of Database Administration

TECHNICAL SKILLS:

  • 11g RAC
  • 12c Database Installation
  • Data Guard
  • ASM
  • RMAN
  • Exadata
  • SQL Server
  • SQL / PLSQL
  • GoldenGate
  • Export / import
  • Data Pump
  • OEM / 12c Cloud Control
  • Scripts
  • Performance Tuning
  • Migration
  • On - call support
  • CPU / PSU patches
  • Flashback
  • Database Cloning
  • Upgrade

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

  • Provided day to operations support of Oracle and SQL Server databases.
  • Build Data Guard for DR project.
  • Handling the code deployments developed by Developers on Dev, Test and Production.
  • Managing users, profiles, roles and table space per the requirement.
  • Created custom script to create large number of users automatically.
  • Database user backup using Export /Import Utility. And database backup using data pump.
  • Production refresh to PRR environment and conversion environment when required.
  • Done partitions on tables and indexes to get better performance on large tables.
  • Coded scripts for backup and monitoring of databases.
  • Used TOAD, putty and OEM to managed databases.
  • Applied PSU patches.
  • Applied patches on Exadata Servers.
  • Migrated databases to another data center.
  • Upgraded Oracle 11g to 12c
  • Migrated Oracle Non-RAC databases to Oracle RAC databases.
  • Migrated Oracle database from file system to ASM.
  • Restore and recovered databases using RMAN
  • Resolved Gaps in Data Guard environment.
  • Build Active Data Guard for reporting team.
  • Worked with oracle support on various issues.
  • Build SQL Server environment on Windows Server 2012
  • Managed and upgraded SQL Server 2008 and SQL Server 2012
  • Cloned many SQL Server database from prod to noprod.
  • Used SSIS packages to export/import data in SQL Server.
  • Setup log shipping between primary and standby site.
  • Prepare documentation and baselines.
  • Perform database tuning and performance monitoring at the OS level, DB level and SQL level.
  • Analyze data and make recommendations relating to performance and efficiency of data storage.

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

  • Installed, configured, and maintained Oracle 10g and 11g on Linux
  • Upgraded from Oracle 10g to 11g.
  • Performed the migration from Tandem to Oracle 11g.
  • Performed administrative maintenance, monitoring on Oracle database systems
  • Performed Database Refresh from Production to Development databases.
  • Used PL/SQL (stored Procedures, triggers, packages), SQL* PLUS, SQL* LOADER of oracle database.
  • Supported different Databases like Testing, Staging and Training.
  • Performed installation and configuration of Oracle 10g/11g RAC databases on Linux.
  • Upgraded the Oracle 10g database to 11gR2
  • Applied CPU, PSU, CRS Bundle patches.
  • Build 4-noe 11g RAC with ASM.
  • Worked closely with developers during release and deployments
  • Setup Golden Gate unidirectional replication between oracle instances
  • Successfully implemented Backup using bash scripts and from 11g grid control
  • Restored databases from backups from tapes.
  • Performed Logical backup using export import and data pump.
  • Performed various tablespace management.
  • Defrag tablespaces and indexes.
  • Managing Users and Resources, Granting and revoking privileges through Roles.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
  • Creation of Users and granting them the required Roles and Privileges accordingly.
  • Involvement in space management, managed quotas.
  • Cloned schemas, objects and data on new server using Data pump.
  • Managing databases on multiple servers.
  • Provided 24/7 and weekend support during on-call rotation.
  • Worked with onsite and offshore DBAs.
  • Managed users, tablespaces, user quotas, space management.
  • Troubleshoot connection issues.
  • Worked with app team on tracing sessions.
  • Generated ASH / AWR and ADDM reports and analyzed them.
  • Regular discussions on best practices with Management team.
  • Was point in contact person for databases.

Confidential, Chicago, IL

Jr. SQL DBA

Responsibilities:

  • Installed Oracle Databases using Confidential
  • Load data using sqlldr
  • Exported and imported using exp/imp
  • Installed rdbms software on window
  • Helped users with connection strings.
  • Installed SQL Server using SSMS
  • Load data from excel to SQL Server.
  • Restored SQL databases on other windows database servers.
  • Setup log shipping
  • Load data using scripts.
  • Applied dynamic changes to databases.
  • Coordinate releases and deployment with dev/app team.
  • Add datafiles, resize datasize, tablespace management.
  • Wrote SQL to generate reports.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship