We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume Profile

Greensboro, NC

PROFESSIONAL SUMMARY:

  • Over 7 years of experience as Oracle Database Administrator on UNIX and Windows platforms with Oracle 8.0.5, 9i, 10g, 11g on OEL, RHEL, UNIX, AIX, Sun Solaris. Experienced in Oracle Database high availability solution sets like Configuration and monitoring of Oracle Real Application Cluster RAC , Dataguard. Expertise in Performance tuning and monitoring of database's using OEM grid Control.
  • Expert knowledge in installing oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 9i to 10g and 10g to 11g and 12c.
  • Expertise in migrating single instance databases to multimode 10g, 11g R1, R2 and 12c RAC environments for high availability and load balancing.
  • Strong experience in implementing ORACLE STREAMS, and two types of standby databases supported by logical standby and physical standby.
  • Extensive experience in using Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL PLUS, TOAD, ISQL PLUS.
  • Hands on experience in Data guard, Grid control, streams, replication, and monitoring batch performance.
  • Extensive knowledge on database backup/recovery strategy RMAN , Import/Export Data pump, Capacity Planning, Replication Streams standby databases, Oracle configuration management, Data guard, database cloning, refresh and patch management.
  • Established Disaster Recovery for Oracle 11g RAC database.
  • Ample knowledge on Exadata Architecture, Smartscan, and Advanced compression.
  • Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
  • Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
  • Experience with SQL coding including DDL, DML and fine-tuning those sql's for better performance.
  • Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.
  • Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
  • Expert in using Oracle development tools such as Tool for Oracle Application Development TOAD , Oracle Reports builder, Forms 6i, SQL developer, SQL Plus, Oracle Enterprise Manager OEM , Crystal reports and PL/SQL Developer.
  • Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
  • Ample knowledge in GoldenGate implementation.
  • Deep knowledge and hand on experience on Oracle Database Vault, Data Encryption and other Oracle Security related features.
  • Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
  • Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
  • Designed and developed database applications and data warehousing for business intelligence.
  • Ability to coordinate in a team as well as to work individually.

TECHNICAL SKILLS:

Operating Systems:

LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.

Databases:

Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2005.

DBA Tools:

SQL Developer, SQL Loader, TKPROF, Toad, OEM, Oracle Goldengate, Control-M, Tortoise SVN, Fortify 360, Putty.

Tools and Utilities:

Export/Import, RMAN, Data Pump, Winscp3, ERWIN.

Languages:

C, C , JAVA, Unix shell scripts, PL/SQL, Perl.

RDBMS Tech:

Oracle 8i, 9i, 10g, 11g R1, R2, 9i/10g RAC, Standby Database.

Web Tools:

HTML and XML, APEX, SQL NET, ODBC, TCP/IP.

Terminal Emulation:

Putty, Telnet, FTP

PROFESSIONAL EXPERIENCE:

Confidential

Role: Oracle Database Administrator

Environment: Oracle 10g with RAC and ASM, ORACLE 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Data Guard, AWR, ADDM, Cronjob, Erwin, O/S: RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, ASM Packages.

Responsibilities:

  • Installation and Maintenance of Oracle 9i, 10g, on IBM-AIX, LINUX and Windows platforms.
  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
  • Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
  • Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
  • Applied Patches on RAC, Standalone, Standby databases based on the requirements.
  • Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
  • Experience on working with data guard physical/logical standby databases.
  • Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
  • Database Refreshing / Replication from production to testing using Exp/Imp.
  • Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
  • Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
  • Monitored and provided weekly reports on the server's memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
  • Planned and configured disk layout, mount points and capacity requirements for servers.
  • Provided maintenance of user accounts, privileges, profiles and roles.
  • Involved with OLTP relational databases system analysis, design, implementation and management.
  • Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
  • Administered 10g RAC environments adding and removing nodes to the cluster and handled performance tuning using AWR.
  • Supported off-hour on call support for database related issues.
  • Created logical and physical design installed and upgraded databases.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks SAN and Network attached storage NAS .
  • Documented the Standard Processes for peers to follow.

Confidential

Role: Oracle Database Administrator

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g/11g, PL/SQL, SQL PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software 5.0 , VERITAS Cluster, RMAN.

Confidential

Responsibilities:

  • Database monitoring and performance tuning using OEM Oracle Enterprise Manager and STATSPACK.
  • Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
  • Implemented Data guard and administered the production database.
  • Installed Oracle 10g RAC database on RHEL and applied all current patches
  • Scheduled several backups through RMAN.
  • Database Restore using RMAN, Cold Backup and Export/Import.
  • Used Flashback table to restore tables which is a new feature of Oracle 10g.
  • Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
  • Extensive application tuning through STATSPACK, explain plan, SQL Trace.
  • Worked on decommission of database and services which are no more required
  • Monitored the Oracle Streams topology and performance.
  • Identified the long running transaction through V session longops and also for Rollback monitoring which is an enhanced feature of Oracle 10g.
  • Used EM on Oracle 10g for diagnostic summary, host CPU utilization, finding wait events, alerts Log errors etc.
  • Re-engineered system to J2EE using Oracle 10g backend database.
  • Extensively used SQL Queries Sub queries, correlated sub queries and Join conditions to handle data mapping.
  • Performed the SGA tuning, monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Tablespaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.

Confidential

Role: Oracle Database Administrator

Environment: IBM-AIX, Windows 2003/NT, Oracle 9i, 10g, 11g, RAC, TOAD, OEM, AWR, ADDM, DATA GUARD, RMAN, Golden Gate, Diagnostic and Tuning Advisors.

Confidential

Responsibilities

  • Installation and Maintenance of Oracle 9i, 10g, 11g on IBM-AIX, LINUX and Windows platforms.
  • Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
  • Implemented the Oracle 10g, Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
  • Applied Patches on RAC, Standalone, Standby databases based on the requirements.
  • Install and Configure Oracle Apex 4.1 in the RAC environment
  • Provided Oracle Application Server and Oracle APEX implementation and support.
  • Used Oracle Transparent Data Encryption and Database vault to encrypt some of the data in the database.
  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
  • Database Refreshing / Replication from production to testing using Exp/Imp.
  • Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
  • Monitored and provided weekly reports on the server's memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
  • Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
  • Replicated data using GoldenGate.
  • Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.
  • Provided maintenance of user accounts, privileges, profiles and roles.
  • Designed, developed and maintained UNIX shell scripts and Perl scripts to collect and monitor database metrics and Statspack snapshots and reports.
  • Administered 10g RAC environments adding and removing nodes to the cluster and handled performance tuning using AWR and ADDM.
  • Documented the Standard Processes for peers to follow.

Confidential

Role: Oracle DBA, Developer.

Environment: Oracle 10g, 11g RAC, ASM, Shell Scripting, 11g Oracle Enterprise Manager, Oracle Partitioning, SQL Plus, PL/SQL, SQL Loader, SQL Server 2000, Toad

Responsibilities:

  • Provided 24X7 supports for all the production and development databases.
  • Installed and configured Oracle 10g.
  • Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.
  • Applied patches using OPATCH and Patch sets using OUI
  • Cloned/Refreshed Oracle Databases.
  • Implemented Disaster Recovery plans
  • Responsible for optimizing the queries and application tuning.
  • Perform SQL tuning and assist developers with coding PL/SQL.
  • Provided support to Application Database Administrators in designing the database.
  • Installed and Implemented Backup Recovery procedures.
  • Implement Hot, Cold and Logical backup plans.
  • Worked on several shell scripts to maintain the database activities
  • Mentoring the Database Performance using automated scripts.
  • Answerable for setting and managing User Accounts, Granting required privileges to users.
  • Experienced in Security Administration and Space Management
  • Perform other regular DBA activities including space management and performance monitoring.
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
  • Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
  • Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Dataguard, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.
  • Implement Stored Procedures and Triggers based on business plans using PL/SQL.
  • Automation of data load using Korn shell scripting and SQL Loader.

Confidential

Role: Oracle DBA

Environment: ORACLE 8i, 9i, SQL, PL/SQL, Import/Export, UNIX AIX 5.1, Windows NT.

Confidential

Responsibilities:

  • Involved in production support activities 24/7 during on call and resolved database issues.
  • Backup scheduled Script creation and Standardization. Performed Database Installation and up gradation.
  • Experience in working with cold and hot backups and recoveries.
  • Installation and creation of databases.
  • Worked on user management mainly on grants, privileges, roles and profiles.
  • Designing and developing SQL procedures, query performance tuning.
  • Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
  • Setting up new development and QA environments and involved in deployments and migration. Cloned databases for development and testing.
  • Customized database backups for Disaster Planning and implementation.
  • Creating profiles and attaching them with users, performing hot and cold backups.
  • Performed database tuning for daily loads and slow response issues by refining queries.
  • Used STATSPACK, TKPROF utilities for Tuning and analysis.
  • Recovery of database from media failures, dropped accidentally and data block.

Hire Now