SUMMARY

• I am an oracle database administrator over 3 years of experience in designing, developing, implementing Databases, Web development and Application development.

TECHNICAL SKILLS

• Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, AWR, Top, DBCA, DBUA, ADDM, Remedy, Oracle data modeler
• UNIX (Solaris 8/9/10, AIX, HP - UX), LINUX
• 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
• BEA Weblogic 10.2.3
• Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 11.2.0.1 database on HP-UX platform.
• Worked with different middleware & IDM teams to resolve their issues from the database side.
• Experience in Replication of Data bases using Oracle Streams and Logical Standby.
• Worked with Data Architect on dimensional modeling to optimize the already existing data-warehouse database using STAR Schema, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Implemented and managed optimum physical database design (tablespaces, datafilesextents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions,
• Physical and Logical IO and Memory Usage.
• Monitoring Day-Day Backups, Log's and recovering them as per the requirement.
• Utilized LOG MINER Technology and applied Application Database Transactions on other Databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Setup, Configured Oracle Data Guard using physical standby database.
• Implemented Dataguard / Standby (with FAL), performed switchover/failover.
• Patched Oracle databases using OPatch utility. Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using, TKPROF, Explain Plan and SQL Trace
• Setup and documented GoldenGate replication on 11g and 12c for support team.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Wrote database triggers, packages, procedures, functions, utilities for application development.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.
• Successfully performed migrations from Oracle 11g/12c to 11gR2 RAC (Real Application) Database.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration, and solved the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated AWR reports using OEM from Oracle 11g and 12c database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 11g and 12c Oracle databases
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Implemented disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration
• Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, and backup logs to send notification emails.
• Migrated data to a new ASM Disk group to improve the IO performance of the database.

Oracle SQL Certificate

Certification and Education

Oracle Certified Associate - OCA

Oracle Certified Professional - OCP - In-progress

Amazon Solution Architect - In-progress

1