Oracle Database

202-***-**** ***********@*****.***

PROFESSIONAL PROFILE

A proactive Oracle Database Administrator with strong interpersonal skills and determination to contribute to the success of the organization’s mission. Detail orientated, self-driven and able to work independently as well as a cooperative team member. Worked on Oracle 10g, 11g, 12c versions involving database administration production support, installation and configuration, performance tuning, upgrades and patches, migration on same and different platforms, backup and recovery, cloning, database and schema refreshes, space management, auditing and security.

SKILLS

Operating Systems: 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.

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, UNIX Shell Scripting

Tools: TKPROF, EXPLAIN PLAN, AWR and ADDM. Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*PLUS, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export/Import

WORK EXPERIENCE

Chase Bank -Irving, TX Jun’14 -Present

Oracle Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Build single node RAC standby database for RAC primary database and using RMAN active duplication method.

Troubleshoot complex problems with root cause analysis during product deployment/release.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used SQL Loader and External Tables to extract data from flat files and loading into the new application.

Performed database analysis, design, coding, testing and implementation of database structures.

Maintain UNIX scripts for monitoring and backup.

Installed and Configured GOLDEN GATE Extracts/replicate for databases

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

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.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g, Oracle 11g and to Oracle 12c database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, three Node RAC (Real Application Cluster) with ASM file system on Linux platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Linux, RAC, ASM, RMAN, AWR, ADDM, SQL Plus, SQL*Loader, OEM, TOAD 10.0.

Astoria Bank - Lake Success, NY Mar ’12 - Jun ’14

Oracle Database Administrator

Supported multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Installed Oracle 11g on Linux platform using ASM.

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Upgrade and Migration of Database from 10.2.0.2 to 11.2.0.3 and applying patches whenever required.

Performed installation, setup and creation of RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 databases

Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.

Capacity planning: Allocate system storage and plan future storage requirements.

Creating OEM alerts that provides notifications through emails.

Experience in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Worked on both VMS and UNIX environments.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, database design, database tables, indexes, Instance, memory and operating system

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Education

Towson University-Maryland, Bachelor of Science

Major-Sociology, Minor-Health Science

Montgomery College-Maryland, Associate of Arts

Major-General Studies

Certification

Oracle Certified Associate 11g

Contact this candidate