We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Wayne, PA

SUMMARY

  • I have Over 5 years of Experience in Oracle Database Administration in Various environments including UNIX/LINUX, Solaris and Windows Environments supporting applications with Oracle 10g, 11g & 12c Databases.
  • I have proven technical knowledge of Database Administration and infrastructure management combined with outstanding Database Security, Encryption using TDE, Performance Tuning abilities and Creative problem solving skills in both strategic and tactical areas as well as excellent Communication skills. I have strong aptitude to analyze and resolve problems.
  • To say the least, I’m Proactive, and a fast learner, willing to learn. I’m a Great team player, Dynamic and also Reliable. I’m good with Documentation; Multitasking and I pay Attention to Details.
  • Great Experience in Installation of oracle, 11g (11.2.0.1, 11.2.0.4) and 12c (12.1.0, 12.2.0.2) in development and test environments depending on project requirements.
  • Successfully done Data Encryption in Motion Using Network Encryptions and Data Encryption at Rest Using Transparent Data encryption (TDE) for Maximum Security.
  • I have worked on Improving Database Performance by Tuning SQL Queries in Production, Development, and Test Environments using Plan Table, AWR, ADDM, Utlstat, scripts, Statspack, also using ASH and Dynamic Performance Views to Monitor System Statistics and wait events to improve SQL Query performance.
  • Good Experience Implementing Disaster Recovery strategies using RMAN and other options such as User - Managed Backup, RMAN backup with or without Recovery catalog, operating system backup, Cold and Hot Backup in Full Backup, Incremental and Cumulative.
  • Good Skills in applying security patches (Critical Patch Updates (CPU) / Patch Set Updates (PSU) using Opatch Utility.
  • I have Successfully Migrated Databases across Platform from Solaris on x86 to Linux on x86.
  • I have Good Knowledge and Experience in Database Auditing, User creation, Roles, Privileges and profiles creation to control access over database objects.
  • I have worked on Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
  • Data transferring with export/import utilities, Data Pump and SQL* Loader.
  • I have good experience Optimizing SQL using explains plan to analyze the execution plan and tune SQL statements.
  • Performing complete and incomplete disaster Recovery failures and user errors.
  • I have Successfully Configure DataGaurd 11G in (Maximum Performance) for High Availability.

TECHNICAL SKILLS

Operating Systems: RHEL 6, 7, Linux / Unix, Sun Solaris 11.3. AIX 5.1, 5.2, 5.3, 6.1, Windows 95/98/NT/2000.

RDBMS: Oracle 9i, 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer, and Cisco VPN Client.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export & Import, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDMApplications: PeopleSoft, FN, HR CRM, Portal, Parking and other Custom Applications.

PROFESSIONAL EXPERIENCE

Confidential - Wayne, PA

Oracle Database Administrator

Environment: s: Oracle 11.1.0, 11.2.0. 11.2.4 , 12.1.0.2, 12.2.0.1 RHEL 7, Sun Solaris 11.3, DataGaurd, RMAN, OEM, Datapump Import/Export, AWR, ADDM, ASH, TOAD 11.0., SQL-LOADER.

Responsibilities:

  • Installation of oracle 11g and 12c databases in development and test environments depending on project requirements.
  • On-Call 24x7 production support and Performance Monitoring on Development and Production Environment.
  • Executing Database Platform Migration. Solaris to Unix and AIX to UNIX
  • Database Network Encryptions and TDE Encryptions
  • Extensively use of Datapump, conventional export/import, and SQL loader utilities for loading data to & from databases, logical backups and migration of databases.
  • Refreshing development/test database from production using Export/Import & RMAN backups.
  • Performed periodic cloning/Refresh of production databases to development & testing databases using RMAN Duplicate and Datapump.
  • Database Monitoring Using Oracle Enterprise Manager Grid Control (OEM) and Command line.
  • Performing Database Performance Tuning in Production, Development, and Test Environments using AWR, ADDM, Utlstat, scripts, Statspack and Dynamic Performance Views to Monitor System Statistics and wait events,
  • Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
  • Managing database security.
  • Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
  • Designed Logical and physical database for business transaction functionality.
  • Written SQL scripts to create database objects like tables, views and sequences.
  • Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Defragmentation of tables and indexes to improve performance and effective space management.
  • Managed Database Maintenance Activities to achieve optimum database uptime.
  • Configuration of Listener and Tnsnames.
  • Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
  • Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
  • Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
  • Automated the processes like moving files, managing alert log, efficient Backup and recovery by developing UNIX scripts.
  • Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0 and to 12.1.0
  • Applied PSU Patches as a part of maintenance activity.

Confidential, Handover, MD

Oracle Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, 6, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.

Responsibilities:

  • Refreshing development/test database from production using Export/Import & RMAN backups.
  • Managing database security.
  • Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
  • Provide production support for the deployed project till it is stabilized.
  • Written SQL scripts to create database objects like tables, views and sequences.
  • Created procedures and functions using PL/SQL.
  • Installation of oracle 10g and 11g databases in production, development and test environments depending on project requirements.
  • Collaborated with the UNIX system Administrator to configure software and hardware requirements that will function with the Oracle Database.
  • Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Defragmentation of tables and indexes for improved performance and effective space management.
  • Configuration of Listener and Tnsnames.
  • Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
  • Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
  • Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
  • Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Confidential, Tampa, FL

Jr. Oracle Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.

Responsibilities:

  • Installation of oracle 11g databases in development and test environments depending on project requirements.
  • Refreshing development/test database from production using Export/Import & RMAN backups.
  • Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
  • Managing database security.
  • Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
  • Designed Logical and physical database for business transaction functionality.
  • Provide production support for the deployed project till it is stabilized.
  • Written SQL scripts to create database objects like tables, views and sequences.
  • Created procedures and functions using PL/SQL.
  • Preparation of High Level & Low Level Design documents.
  • Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Defragmentation of tables and indexes for improved performance and effective space management.
  • Managed Database Maintenance Activities to achieve optimum database uptime.
  • Configuration of Listener and Tnsnames.
  • Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
  • Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
  • Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
  • Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
  • Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.

Hire Now