Oracle Database Administrator Resume

SUMMARY

More than 15 years of IT experience and 10 years of professional experience as an Oracle DBA having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 11g/10g/9i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platforms.
8+ years working with Linux, HP-UX, Solaris and 6+ years working with Windows O/S.
More than 5 years in Oracle 10g/11g RAC (Real Application Cluster) with ASM in terms of installation, configuration and tuning on Solaris and Linux platforms .
Performed the installation, configuration and maintenance of databases ranging from 20GB to 25 TB and provided 24/7 support.
Upgraded Oracle databases from 9i to 10g and 10g to 11g and applied patches with OPatch. Perform PSU apply process to the production/QA/DEV/UAT databases in every quarter to meet security standard.
Installation, configuration and managing Golden Gate V10x, V11x on Oracle 10g and 11g with Linux, HP-UX and Windows platforms.
Configuration, installation and maintenance of Oracle Data Guard (primary and standby databases) to ensure disaster recovery, high availability and data protection .
Hands on experience in performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS STATS, Automatic Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostic Monitor (ADDM) and SQL Tuning Advisor .
6+ years of experience managing database security and authorization.
5+ years in developing procedures, functions, packages and triggers using PL/SQL.
Backup and recovery strategies using Data Pump (Expdp and Impdp), RMAN and configured recovery catalog .
Excellent knowledge in Hot/Cold Backup, recovery and Cloning of databases using RMAN .
Experienced in PL/SQL and Shell scripting.
Monitoring of the system, network, database operations, application, and other system components in Grid environment.

TECHNICAL SKILLS

Database: Oracle RDBMS, Oracle 11g/10g/9i/8i, Sybase 15/12.x, UDB 8.1, SQL Server 2005/2000.
Languages: SQL, PL/SQL
Operating Systems: Windows NT/2008/XP/2000/2003, RHEL 4.x/5.x, UNIX (Solaris, Linux).
Database Tools: SQLLoader, SQL*Plus, TOAD 9.x, 8. x., SQL Navigator, Oracle Enterprise manager (OEM), Oracle Golden gate

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

Installation, configuration, upgrade and patching of the databases
User creation and user management
RMAN backup and recovery and fix backup issue
Performance tuning and fix query issue work with application team
Monitor system performance in RAC environment
Performed DB refresh in RAC DB on regular basis

Confidential

Oracle Database Administrator

Responsibilities:

Managing SQL server database also
Regular maintenance (Reorg/ Partition Maintenance/Alter Index/Rebuilt of the table) of the database
Performance Tuning, Monitor database alert log and take suitable action, Create and maintain user, table space and other database object and also maintain the security
Install & configure golden gate

Confidential

Oracle Database Administrator

Responsibilities:

Trouble shooting of the database is handled by service now tool
Appropriate ticket is assigned to DBA group, We have resolved this issues
Regular maintenance (Reorg/ Partition Maintenance/Alter Index/Rebuilt of the table) of the database
Performance Tuning, Monitor database alert log and take suitable action, Create and maintain user, table space and other database object and also maintain the security
Actively work with IS team to apply patch in every quarter to all the prod/dev/QA/UAT environment

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship