SUMMARY

• Over 5+ years of experience in Oracle database administration in multifarious system environments including Red Hat Linux, Solaris, Unix and Windows, supporting a variety of mission critical applications with Oracle 10g 11g and 12c.
• Oracle Database Upgrades 10g to 11g and 11g to 12c.
• Migrating and consolidation of 11g databases into 12c in both QA and Production environments.
• Strong knowledge of Oracle RDBMS 10g and 11g environments, PL/SQL, including OEM, Golden Gate and Data guard.
• Demonstrate strong working ability in production and developing environments with strong knowledge in upgrading and patching Oracle software installation.
• Great mastery of database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Configure Migration, Replicate and Extract processes and implement unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• Oracle Database Upgrades 10g to 11g
• Experience in monitoring oracle instances and maintaining databases performance using OEM (Oracle Enterprise Manager), Oracle GRID - control and database monitoring using 11g Grid monitoring tool.
• Experience in data migration using Data Pump utilities (Expdp)/(Impdp) and SQL*Loader.
• Experience in backup & database recovery using data pump and RMAN for logical and physical backups including hot/cold backups as per the SLA.
• Hands on experience in conventional Hot and cold backups, database recovery, cloning of a database using RMAN backup and recovery.
• Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through profiles and roles.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage using AWR, ADDM, Statspack, and ASH Report.
• Experience in application and memory tuning with explain plan, TKPROF, STATSPACK, SQL trace, SQL optimization utilities, SQL tuning advisor, SQL access advisor and SQL planned management.
• Identified and resolved performance issues caused by table fragmentation using segment Advisors
• Experience in creating, configuring physical standby database using data guard 10g and 11g active data guard.
• Experience with flash back technology.
• Troubleshoot and resolved locking and concurrency issues, Excessive parsing, resource bottleneck (including memory and CPU bottlenecks) and recommending a solution
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch as well as database upgrades
• Extensive experience in database production support.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Hands on experience in database troubleshoots and problem solving to ensure that the system meets requirements, consistency and availability.

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle Enterprise Manager, SQL*Plus, SQL Loader, RMAN, Data Pump Exp/Imp, Dataguard, AWS, Toad, Log miner, Statspack/AWR, Shareplex Top, Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA), ADDM, Oracle Migration Workbench, Virtual Private Database, ERwin, QDesigner, Remedy

Operating Systems: LINUX, MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX)

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE

Confidential - Washington DC

Oracle DBA

Responsibilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Managing database security and encryption through Authenticating, Authorizing and Auditing users.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Configuration of Listener and Tnsnames.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM and ASH.
• Designed and implemented backup and Disaster recovery strategies with RMAN. Performed logical backup using traditional export/ import and Data Pump.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance.
• Reorganized databases and Sizing of database objects for effective space management and optimal performance.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.
• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.
• Preparation of High Level & Low Level Design documents.

Environment: Oracle 11g, Oracle Wallet, Linux, PL/SQL, DataPump, RMAN, OEM, SQL*LOADER, Microsoft Word

Confidential - Silver Spring MD

Oracle DBA

Responsibilities:

• Perform backup and recovery by using RMAN for hot/cold backups, and weekly full backups.
• Provides physical and logical database backup for database recovery to ensure consistency and stability.
• Perform Configuration and utilize oracle flashback technology for recovery of errors.
• Maintain Oracle Dataguard for Physical and Logical standby databases for disaster recovery.
• Monitor database health to ensure high performance capacity, availability and reliability using vmstat, Sar, iostat, Top and netstat.
• Utilize Automatic Workload Repository (AWR) to generate snapshots for key performance data.
• Proactive manage the database to prevent it from poor performance by using the Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) to analyze the statistic levels.
• Perform Installation and configuration of Oracle Enterprise Manager (OEM) and Grid Control for Oracle 10g and 11g.
• Provide solution and maintain the database for troubleshooting by using trace files, alert log and oracle mata links.
• Perform database maintenance by applying required patches and software updates.
• Perform migration by using Data Pump utilities (Expdp)/(Impdp) and SQL*Loader.

Environment: Oracle 11g,Oracle, Linux, PL/SQL, DataPump, RMAN, OEM, SQL*LOADER, Microsoft Word

Confidential - New York

Oracle DBA

Responsibilities:

• Provided and maintained Oracle Applications Administration for 11g DBA skills for complex 24×7 environments.
• Conducted Performance Tuning by using SQL query optimization, Autotrace, Vmstat, Explain Plan, AWR, ASH, ADDM and SQL Tuning Advisor to gathering statistics.
• Monitored and prevented the database from a poor performance by proactively managing the Automatic Workload Repository (AWR) and using the Automatic Database Diagnostic Monitor (ADDM).
• Proactively monitored the disk usage and the memory usage of the server, and monitored table-spaces for performance measures.
• Performed migration by using Data Pump utilities (Expdp)/(Impdp) and SQL*Loader for availability and satiability.
• Managed databases and instances using Data Guard in a real time production, testing, and Development environment.
• Performed logical and physical backups database and recovery by using RMAN.
• Maintained and provided Database Security through DDL/DML by authenticating, auditing user actions in the database, altering passwords of users and granting and revoking system/object privileges, roles in database.
• Performed database maintenance by applying required patches, upgrades and software updatesfrom 10g to 11g release.

Environment: Oracle 11g,Oracle, Linux, PL/SQL, DataPump, RMAN, OEM, SQL*LOADER, Microsoft Word, Oracle RAC