SUMMARY:

• Administering Oracle RDBMS Performance Tuning RAID configuration
• Build Real Application Clusters (RAC) SQL Tuning Database Migration
• Build and managed Data Guard Instance Tuning Database Upgrade
• Build DR using 11g Active Data Guard Network Tuning Transportable Tablespace
• Worked on ASM (Build and Managed) Index Management PL/SQL, Function, packages
• Build and managed Golden Gate SQL Baselines Data Modeling / ERWIN
• Export Import and Data Pump SQL Profiles TOAD / SQL Developer
• Team work with Offshore/onshore SQL Tuning Advisor Oracle Security
• Provided 24/7 on - call support Oracle OEM Grants / Permissions / Privileges
• Tablespace Management Shell Scripting Oracle Backup and Recovery
• OMA / OMS / OMR - 12c cloud control Oracle Patches Cloning of DBs using RMAN OS → Linux, HPUX, AIX, Windows SQL Scripting Troubleshooting with Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Oracle DBA/ Oracle DBA/Tech Support

Environment: Oracle 12c, 11g, RAC, ASM, Data Guard

Responsibilities:

• Expertise in SQL, RMAN backup and recovery, expdp/impdp, performance tuning, Unix Shell scripting.
• Good knowledge in ORACLE DATA GUARD.
• Expo/Imp of User, Tables and Database using exp/imp and Data Pump.
• Experience in taking Logical backups by using Oracle utility Expdp and Impdp.
• Migrate databases from source DB to new DB Instance Transportable tablespaces for large DB’s Import/Export for smaller.
• Responsible for overall migration approach & processes validation.
• DB instances in other environments support will be provided during regular working hours.

Confidential, Austin, TX

Oracle DBA Support

Environment: Oracle 12c, 11g, RAC, ASM, Data Guard

Responsibilities:

• Installed databases using silent install.
• Performed Database refreshes using RMAN duplicate database
• Performed schema level refreshes. Build 2-node RAC cluster.
• Migrated databases from standalone to 2-node RAC clusters.
• Setup DR using Data Guard.
• Put up monitoring scripts for Data Guard
• Modified / added functionality in existing monitoring shell scripts.
• Applied PSU / one off patches. Provided on-call support.
• Scan databases for security issues. Provided support to offshore DBAs.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Ensure databases adhere to corporate standards and policies.

Confidential, Seattle, WA

Oracle DBA

Environment: Oracle 12c, 11g, 10g, 9i, Toad, RMAN, Data Pump, SQL Developer

Responsibilities:

• Installation of Oracle 11g, 10g, 9i installation and Configuration.
• Build RAC on 2 nodes, 3 node clusters.
• Add/Remove node to/from existing RAC.
• Supported multiple database farms including development/production sizes up to 5 TB for 24/7.
• Designed, Installed and configured the Oracle server software and related products. Upgraded 30+ databases from 9.2.0.6 to 10.2.0.1 to 10.2.0.3 to 11gR1/R2 on RHEL and AIX.
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Setup and documented Oracle Golden Gate replication on 11g for support team.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers.

Confidential, Chicago

Oracle DBA

Environment: Oracle 11g/10g, 9i, Toad, RMAN, Import/Export, Oracle OEM, WinScp/FTP.

Responsibilities:

• Oracle client installation.
• Configure TNS names.
• Oracle 10g, 9i installation and Configuration.
• Apply Patches to existing versions.
• Worked on Windows and Linux database farms.
• Installed oracle 10g from scratch on a new server
• Configured backups
• Written batch jobs to automate backups.
• Refreshed schemas.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required
• Ensuring successful & periodical Backup & Restoration.
• Develop, Implement and administer database policies and procedures.
• Perform database analysis, design, coding, testing and implementation of database structures.
• Used Oracle backup utility RMAN to implement Oracle backup strategy.
• Capacity planning, capacity monitoring and management.
• Managed day-to-day production databases.
• Monitoring CPU, memory, disk I/O, paging, and swapping using various UNIX commands.
• Analyze disk space requirements.
• Reported to Lead DBA upon all project completion. Configured RMAN backup for 10g RAC database
• Monitoring 10g RAC performance
• Applied CPU patches.
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Provide 24/7 on call support
• Created and maintain documents on SharePoint.

Confidential

Windows OS / Microsoft Office Support / Microsoft Access

Responsibilities:

• Windows support
• OS installation
• Troubleshoot Office products • Create and maintain spreadsheet
• Apply patches.
• Apply services patches.
• Configure RDP
• Setup NAT/PAT on the firewall side.
• Worked on Access
• Worked on SQL Server 2005
• Written SQL Queries and T-SQL
• Monitored and troubleshoot high CPU utilization
• Installed customized application.
• Written ad-hoc queries.
• Worked on reports.