We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

ChicagO

SUMMARY

  • Over 7+ years of experience as an Oracle Database Administrator, having hands on experience in Development, Production environments Implementation and Testing of Relational Database Management systems for Business solutions.
  • Installed Oracle database server on SOLARIS, HP - UX, AIX, WINDOWS NT, LINUX, UNIX and migration of oracle server from 9i to 10g and 10g to 11g applied oracle patches.
  • Migrated single instance databases to multimode 10g, 11g RAC environments for high availability and load balancing.
  • Installed, configured and maintained single node/multi nodes instances with RAC, ASM.
  • Hands on experience in Data guard, Grid control, streams, replication.
  • Expertise in Oracle Grid control installation, monitoring and maintenance.
  • 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.
  • Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, UNIX Shell Programming.
  • 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.
  • Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
  • Experience with Oracle Application Server 10g and Oracle Weblogic 11g .
  • Experience 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.
  • Have knowledge on ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases.
  • Knowledge on Golden Gate Unidirectional and bidirectional replication.
  • Involved in setting up the configuration of Golden Gate director.
  • Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
  • Skilled in database upgrades 9i to 10g R2 and 10g to 11g.
  • 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.
  • Experienced in Oracle Support processes for technical requests through Metalink and other support procedures.
  • Ability to function successfully in a highly stressful, 24x7 mission critical environment

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat, Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 95/98/NT/2000/XP/07 Windows server 2008

Data Bases: Oracle 11g, 10g/9i, Oracle 10g Real Application Clusters (RAC), SQL Server 2000/2005/2008

Software Applications: Srvctl, Crsctl Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, IBM CDC(Change Data Capture), Clusters, Veritas Backup, Golden Gate, SQL Loader.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting.

Web Tools: HTML.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Oracle Database Administrator

Responsibilities:

  • Installation and Maintenance of Oracle 11gR3/10gR2 on Red Hat LINUX 6.3 and Windows platforms.
  • Install, upgrade and maintain Oracle 10g2, 11gR2 on RHEL 6.3 and Windows 2003.
  • 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.
  • Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
  • 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.
  • 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.
  • Implemented the major migrations like DB2 to Oracle Using CDC tool, MY-SQL to Oracle using SQL-Developer tools in data ware house environment.
  • Involved with OLTP relational databases system analysis, design, implementation and management.
  • Involved in setting up of Golden Gate environment.
  • Experience in setting up Dataguard 11g environment with MAA.
  • 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.
  • Experienced in Installation of OEM Grid Control 12c.
  • Documented the Standard Processes for peers to follow.

Environment: RHEL 6.3, Oracle 11gR3/10gR2, RAC, SQL-Developer, OEM 12c, DATAGUARD, RMAN, Golden Gate, Data Pump, Diagnostic and Tuning Advisors, Change Data Capture(CDC) IBM tool.

Confidential, St.Louis

Oracle DBA

Responsibilities:

  • Installation and creation of 10g and 11g databases for Testing, Development and production.
  • Configured ASM for Oracle database files
  • Creating and Managing Tablespaces with different block-sizes to prevent row chaining
  • Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
  • Data Refresh from Production to Test and Development environments using RMAN Duplicate database.
  • Developing and Implementing Disaster Recovery (DR) Plan.
  • Setup of Standby Database using Data guard for faster Disaster Recovery.
  • Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
  • Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
  • Daily Health Check Up of the Database using statspack, AWR, ADDM.
  • Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
  • Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup
  • Written shell scripts for digitization the process.
  • Reading Alert Log and User trace Files and Diagnosing the Problem.
  • Automation of Startup Shutdown on all Production and Development Database.
  • Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.

Environment: Oracle 10g, 11g, RAC, Sun Solaris 5.10, AIX 5.1, 5.2, HP-UX, Toad, ASM, ERWIN, GRID, AWR, ADDM, OEM, Data Guard, RMAN, Shell Scripting.

Confidential, NJ

Oracle DBA

Responsibilities:

  • Upgrade/Migration of Databases from Oracle 9i to 10g Cross platform migration from different platforms.
  • Installation, setup and configuration of DATA GUARD.
  • Implementing Database Security, Management of role-based security.
  • Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
  • Applying Patches like cpu patch sets and applying Oracle DST Patches on Oracle database.
  • Experience in ORACLE SERVER ADMINISTRATION. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE Database.
  • Write and modify UNIX shell scripts to manage Oracle environment.
  • Review of Database logical and Physical design.
  • Performed Data Migration as a part of enterprise data warehouse project.
  • Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices.
  • Cloning databases using scripts as well as RMAN.
  • Established database backup/recovery strategy for different databases.
  • Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
  • Management of table space growth, monitoring data files additions, extent growth. Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
  • Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.
  • Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
  • Performed scheduling Control-m for scheduling jobs.
  • 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.
  • Provided 24X7 supports for all the production and development databases.

Environment: RedhatLinux, IBM-AIX, Windows2000/2003, Oracle9i/10g/11g, RAC, Dataguard, Oracle Streams, Toad v10, PL/SQL, SQL*Loader, Oracle Warehouse Builder, ODBC, ASM, OLTP, OEM, Erwin 4.1.2, VERITAS Net backup.

Confidential

Oracle Jr.DBA

Responsibilities:

  • 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. Refreshed Dev &QA databases from production.
  • 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

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

Hire Now