SUMMARY

• Results - oriented Oracle Database Administrator with over 7 years of IT experience, including extensive technical background in Windows, UNIX & Linux application. Strong knowledge of Oracle Architecture, Schema, Installation, Upgrade, Patch Application, Oracle Enterprise Manager, Unix Shell Scripting, Configuration, Migration, Sizing and Space Management, Backup and Recovery, Flashback, Data guard, Performance Tuning and Troubleshooting. Installed Oracle 11gR2, Database Replication, Upgraded Oracle 10.2.0.4 to 11.0.2.0 on RAC Configuration and loaded data accordingly.
• Performed 11gR2 software installs and configured it as RAC Architecture on ASM Storage.
• Managed RAC environment by Creating, Relocating Services for better Load Balancing.
• Administer multiple instances of Oracle 10g, 11g & 12C databases running on the UNIX, Linux & Windows Operating Systems. Experience with installation, setting up and configuring DATAGUARD, ASM, and RAC in a heterogeneous environment.
• Implement & maintained backup procedures using RMAN.
• Implemented Database Monitoring and Tuning, Application, and Queries using TKPROF, ADDM Statistics, Stats Pack, OEM, Explain Plan and Custom Scripts for optimum performance within Testing, Development, and Production environment.
• Managed and create Schema Objects like Table Space, Tables, Views, Indexes using OEM and SQL*PLUS. Extensively used SQL*PLUS for querying/reporting.
• Responsible for administration of over 20 Oracle Databases.
• Working in 24/7 production environment and provided On-Call and Day-To-Day Support.
• Strengths include Interpersonal Skills, Communication, Problem Solving, Highly Energetic, Team-Oriented, and Flexible and ability to work in parallel.

TECHNICAL SKILLS

Database Tools: Oracle Enterprise Manager(OEM), Recovery Manager(RMAN), Data Migration- Export-Import, Replication, Switchover, Backup & Recovery, Performance Tuning, SQL-Loader, RAC, Data Guard, Toad, Oracle Data Warehouse, Data Pump, Unix Shell Scripting, SQL*PLUS, PL/SQL, Oracle Golden Gate.

Hardware/Software: HP-UX, Compaq, Oracle Linux, Red Hat, IBM RS6000, Linux, Solaris, UNIX 5.2, AIX, Windows 2000,2003, 2008 server, Windows NT 4.0, Windows XP professional.

Programming Languages: SQL, PL/SQL, SQL*PLUS

PROFESSIONAL EXPERIENCE

Confidential, Glen Burnie, MD

Oracle Database Administrator

Responsibilities:

• Install, setup & configure Oracle 10g, 11g & 12C databases running on the Unix, Linux & windows operating systems.
• Perform maintenance, monitoring & performance tuning of databases.
• Administered & managed user’s accounts using OEM and SQL*PLUS
• Monitored the alert logs and troubleshot the errors.
• Set up and manage database security by creating new user’s, roles, profiles, and provide required user privileges & permission using OEM and SQL*PLUS.
• Perform database backup and recovery using RMAN.
• Perform routine database performance tuning
• Apply Oracle PSU/CPU patches & database upgrades.

Confidential, Houston TX

Oracle Database Administrator

Responsibilities:

• Responsible for administration of over 10 Oracle Databases in a UNIX, Linux & Windows environments.
• Installation of new databases, upgrades, applying PSU/CPU patches, create primary database objects like table space, tables, views, synonyms, snapshots, partitioning and sizing tables, indexes etc.
• Installed Oracle 11gR2, Database replication, Upgraded Oracle 10.2.0.4 to 11.0.2.0 on RAC configuration and loaded data accordingly.
• Implemented Oracle security using database audit, audit trail review, user account management, connection manager, and Oracle security patch updates.
• Performed 11gR2 software installs and configured it as RAC architecture on ASM storage.
• Managed RAC environment by creating, relocating services for better load balancing.
• Set up & manage database security by creating new users, roles, profiles, and provide required user privileges using OEM and SQL*PLUS.
• Administer multiple instances of Oracle 10g, 11g & 12c databases running on the Unix, Linux & Window Operating System.
• Load and transfer data into the database by using Data pump & SQL Loader utilities
• Designed daily, weekly Backup and Recovery procedures for production, non-production databases using RMAN backups taking periodic complete, cumulative and differential incremental backups. Monitored and solved RMAN backup issues.
• Implement & maintained backup procedures using RMAN, Data Pump utility for Oracle databases and test regularly in conjunction with Operations. Extensively used SQL*PLUS for querying/reporting.
• Use data pump utility to export and import data from the database
• Troubleshoot and resolve various Oracle problems such as connectivity issues, backup, disk space and performance issues.
• Provide support and maintenance for Golden gate on production & test environments.
• Perform maintenance, monitoring and tuning of databases.
• Communicated regularly with technical support, applications and operational staff to ensure database integrity and security.

Confidential, Laurel, MD

Oracle Database Administrator

Responsibilities:

• Responsible for administration of over 20 Oracle databases in a UNIX, Linux & Windows environments.
• Installation of new databases, upgrades, create primary database objects like table space, tables, indexes, views, partitioning and sizing tables etc.
• Implemented backup and recovery strategies via RMAN and Data Pump utilities.
• Monitored/managed 2node RAC environments, databases using OEM Grid control, and RMAN database backup/recovery.
• Implemented high availability solutions using Oracle RAC, Standby Database using Data guard.
• Implementing Oracle ASM and resolving ASM related issues.
• Database cloning/exp/imp to setup identical databases in the production and development environments.
• Directed software installation for client server and web (intranet/internet) environments.
• Administered and managed user’s accounts using OEM and SQL*PLUS.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges) using SQL*PLUS and OEM.
• Performed routine database tuning and administration activities for several Oracle databases.
• Monitored the production Oracle alert logs for database errors.
• Configure Oracle networking components such as the listener, TNS names and other connection protocols for the Oracle client.
• Implement Oracle Critical Patch Update (CPU), Patch set Update (PSU), one-off patches and bug fixes to ensure a stable and robust Oracle environment.
• Proficient with Unix shell scripting.
• Communicated regularly with technical support, applications and operational staff to ensure database integrity and security.
• Troubleshoot and resolve complex database issues.

Confidential, Laurel, MD

Oracle Database Administrator

Responsibilities:

• Performed Oracle 10g database installation of all kinds on Windows 2003 server, UNIX (Solaris 9), & Linux platforms.
• Oracle database upgrade and quarterly patch application.
• Working with Oracle Connection Manager - connecting users, preventing security breaches, providing server access etc.
• Performed backup & recovery for numerous Oracle 10g databases using RMAN.
• Performed data migration - export & import of database data.
• Performed hot and cold backups & analysis of Oracle and alert log files.
• Maintained stored procedures, functions, triggers, packages & view used by the database instance.
• Administer database user accounts by creating roles, profiles, & privileges.
• Performed routine database tuning and administration activities for several Oracle databases.
• Resolve complex database issues.

Confidential, Northglenn, CO

Oracle Database Administrator

Responsibilities:

• Responsible for administration of over 10 Oracle databases in a Unix/Linux environments.
• Managed and create schema objects like table space, tables, views, indexes using OEM and SQL*PLUS.
• Create and Managed database roles and privileges using OEM and SQL*PLUS.
• Performed database backup using RMAN.
• Administered and managed user’s accounts using OEM SQL*PLUS.
• Database tuning, Application tuning and Performance tuning. Fine tuning initialization parameters, I/O, memory and operating system kernel parameters.
• Monitored the production Oracle alert logs for database errors.
• Working in 24/7 production environment & provided on-call and day-to-day support.
• Resolve complex database issues such as connection, performance & backup problems.