We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

Bristol, PA

PROFESSIONAL SUMMARY:

  • Over 7 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c
  • Experience as On - Call 24x7 production DBA support, application/development DBA, system administrator.
  • Monitored physical I/O and Proper sizing of rollback segments.
  • Data warehousing / Exadata.
  • Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.
  • Oracle Golden Gate and Dataguard
  • Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
  • Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
  • 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 and Data Pump and SQL* Loader.
  • PeopleSoft Finance (PFSCM) 7.5 and 9.2 application support and Upgrade.
  • Performing complete and incomplete recovery during disasters, failures and user errors.
  • Configuring user creation, their roles and privileges profiles to control access over database objects.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch as well as database upgrades
  • Installed and maintained Real Application Clusters (RAC)
  • Performance Tuning and SQL Engineering
  • Autosys Batch Job Scheduler
  • EMC APX Application Support
  • Microsoft SQL Sever 2003, 2008,2012,2016 Database Administrative Support.
  • Shell Scripting/Perl Scripting
  • Tape Backup
  • Extensive experience in database production support.
  • Cmvault Backup
  • Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
  • Deployed Standby databases using Data Guard 11G (Maximum Performance).

TECHNICAL SKILLS:

Databases: Oracle 11G/10G, Oracle 11g/10g Real Application Clusters (RAC)

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

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

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer. Autosy Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Bristol, PA

Senior oracle Database Administrator

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump. Autosys Scheduler, Data warehousing, PeopleSoft FNC, EMC APX application Support etc..

Responsibilities:

  • Installation of oracle 11g and 12c databases in production, development and test environments depending on project requirements.
  • Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
  • 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.
  • 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.
  • Schedule Batch Jobs and Cyco Count Jobs through AutoSys
  • 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..
  • 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.
  • Upgrade oracle database from 10g to 11g and to 12c.
  • Created procedures and functions using PL/SQL.

Confidential, Pittsburgh,PA

Oracle/sql server Database Administrator/Unix Autosys

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump,RAC and ASM

Responsibilities:

  • Installation of oracle 11g databases in production, development and test environments depending on project requirements.
  • Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
  • 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.
  • 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..
  • 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, EBS.

Confidential, Washington, DC

Mid Level Oracle/SQL server 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:

  • Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
  • Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
  • Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
  • Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.
  • Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
  • Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
  • Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
  • Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
  • Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • 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.
  • Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
  • Enforced corporate business rules through adequate user/resource/object management.
  • Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.
  • Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Confidential, Minneapolis, MN

Junior Oracle Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.2, Sun Solaris 10.0.

Responsibilities:

  • Estimating table sizes, table spaces.
  • Created database objects like tables, tablespaces, buffer pools, indexes and views.
  • Analyzing tables and indexes for performance tuning.
  • Creation, maintenance, backups and restoration of databases.
  • Analysis and Designing Database.
  • Create a PL/SQL function, stored procedure, package to support reports.
  • Refreshing and manipulating data in tables using PL/ SQL procedures.
  • Creation of logins and user ids and setting up privileges and procedures for protection of data
  • Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size.
  • User creation with proper roles and privileges.
  • Complete responsibility and control for writing DDL, DML and security of databases.
  • Decided and Implemented table and Index Partitioning of major Tables for better performance, handling and management of data.
  • Tuned the System Global Area (SGA) components dynamically according to the requirement after observing different Hit Ratios, caching of small tables in the Database Buffer Cache, keeping the mostly used and huge packages in the Shared Pool.
  • Implemented Partitioning on huge tables to improve the performance and reduce the maintenance to finite window operation.
  • Developed PL/SQL scripts for exception handling.

Hire Now