Oracle DBA Resume Bloomington Mn - Hire IT People

SUMMARY

Database Architecture, Data modeling techniques and tools capture and translate complex system designs into easily understood representations of the data flows and processes, creating a blueprint for construction and/or re - engineering. Physical/Logical database design.
I have used Data mapping as a first step for a wide variety of data integration tasks including: Data transformation or data mediation between a data source and a destination.
Performance Tuning and improving Database performance management to ensure high availability by using AWR, ASH, ADDM SQL query optimization, Sar, Autotrace, Vmstat, Explain Plan, and SQL Tuning Advisor to gathering statistics.
Database Patches, Upgrading, installation and Migration to Oracle 10g/11g &12c database by using Data Pump Export and Import to new platform.
BackUp and Recovery Database by using RMAN and OEM for logical and physical backup and Hot/Cold backup, database clone and database refreshing.
Proactively monitoring RAC, Data guard, Standby database performances for high availability and optimum performance.
Database Security Management to ensure reliability, availability and integrity for the organization.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Bloomington Mn

Responsibilities

Maintained Oracle Applications Administration for 10/11g &12c DBA skills for complex 24×7 environments for consistency and availability. Monitored Oracle Database and WebLogic, for consistency, availability and high performance.
Using E-business Suite to manage the complexities of our global business environment.
Provide migration for Oracle 10g/11g &12c database by using Data pump/EXPDP/IMPDP oracle utility and SQL*Loader, to move data and schema from one database to another database.
Provided logical and physical backups and database recovery by using RMAN and OEM
Assisted in installation, Patching and upgrading for security, consistency and availability.
Provide database security measure for the users by, Auditing, granting and revoking access.
Assist in developing strategies backup and recovery for hot and cold backup.
Performed Performance Tuning by using AWR, ASH, ADDM, Explain Plan, Vmstat to gather statistics.
Assisted and monitored RAC and Data guard performance for high availability with OEM
Maintained Oracle Data Guard & Standby Database and provides critical solutions for database security and disaster recovery.
Communicated with Oracle support via the Metalink for other important troubleshoot issues.
Provides trend analysis for service management team to enable them to make informed decisions regarding resource management.
Experience in replication using golden gate, materialized views.
Experience in using SharePoint to assist company employees work with the same level of agility and coordination.
Experience in Intergraph SmartPplant 3D piping modeling, continually leveraging technology to improve processes, streamline procedures and improve efficiency.

Oracle Certified DBA

Minneapolis MN

Responsibilities

Provide migration for Oracle 10g&11g database by using Data pump/EXPDP/IMPDP oracle utility and SQL*Loader, to move data and schema from one database to another database.
Provided logical and physical backups and database recovery by using RMAN and OEM
Assisted in installation, Patching and upgrading for security, consistency and availability.
Provide database security measure for the users by, Auditing, granting and revoking access.
Performed HOT and COLD backups for consistency and availability. Assist in developing strategies backup and recovery for hot and cold backup.
Performed Physical and Logical Design of the database include Database creation, schema tables - paces, tables and indexes creation.
Monitored indexes, table-space and analyze performance measures and query optimization.
Provided Backup & Recovery techniques and conducted disaster recovery drills.
Monitored data Migration Process Flow from (HIPAA 4010A to 5010) transition system.
I have used SharePoint in various application programming interfaces (APIs: client - side, server side, Java script) and REST,SOAP and Odata based interfaces.
Provided Performance Tuning by use AWR, ASH, ADDM, Explain Plan, and Vmstat
Assisted in SQL*Loader and PL/SQL statements by extract data from the legacy application in the form of flat files and load the extracted data into the new application.
Performed ongoing capacity planning and expansion to meet organization requirements for data improvements.
Communicated with Oracle support via the Metalink for other important troubleshoot issues.
Provides trend analysis for service management team to enable them to make informed decisions regarding resource management.

We provide IT Staff Augmentation Services!

Oracle Dba Resume

Bloomington, MN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship