SUMMARY

• Over 5 Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Energy, Financials and Insurance Industries.
• Experienced with Unix, Solaris, AIX, NT, Linux, Windows
• Installed, configured, maintained RAC databases
• Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
• Design, development, and testing of backup and recovery to ensure complete recoverability.
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Extensive experience in 7*24 production database support.
• Security management for database, network, and operating systems.
• Solid experience in disaster recovery, routine maintenance for Oracle databases.
• Experienced in Installing, maintaining Standby DR servers using Dataguard
• Design and implement of database backup strategy and performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem.
• Performance monitoring/tuning/troubleshooting on for systems: Oracle, UNIX, Linux, and Windows NT/2000/2003 servers.
• System resource management including bottleneck detection, contention tuning on SGA, CPU, Memory and I/O etc.
• Ability to prioritize and meet operational deadlines in fast paced environment with good stress management skills.
• SQL Net installation/configuration/troubleshooting (Server and Client side
• Storage Management including fragmentation detection, tablespace growth ratio.
• Excellent interpersonal and strong analytical, problem - solving skills.

TECHNICAL SKILLS

Database: Oracle 10g, 11g

Operating Systems: Windows NT /2000/XP, RHEL (RedHat Linux), UNIX, Solaris

Database languages & Tools: TOAD 9.0.1.8/9.0/8.6.1/7.2 , Pl/SQL Developer, SQL*PLUS, SQL* LOADER,VBA,JAVA, SQL, SQL*Loader, Database Links Utilities, RMANOAM, OEM, EXP, IMP, expdp, impdp, TOAD, SQL*LoaderEMC, Veritas NetBackup

PROFESSIONAL EXPERIENCE

Confidential -Madison, WI

Responsibilities:

• Install client/server Oracle and MS SQL Server database Software
• Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs. Working with Java J2EE developers to develop and formulate capacity planning for 11g databases.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard
• I have work with cloud control console in 12c to monitor multiple intances, and I have use sql advisor Tuning to get recommendation in AWR.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Used Exadata: Using Exadata to support ACFS running Grid Infrastructure version 12.1.0.2
• Resizing and reorganization of database objects: Tables, Indexes, Rollback segments and Redo log files of existing production and development systems. Resizing Tablespaces, Tables, indexes, Rollback segments.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1
• Database reorganizations and refresh schema - using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Creating physical databases with multiple table spaces from logical and physical data model
• Prepared scripts to tune developer SQL codes to maximize result return time
• Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.
• Performed cold and hot backup using Oracle's Data pump.
• Provided remote technical support using SSH and terminal services
• Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.
• Design of databases following OFA: Creating Databases schemas, profiles, database links, Snapshots and Synonyms of objects as required to ensure data quality and security to comply with company's business rules. Oracle scripting in Windows/ Solaris and UNIX platform.
• Backup / Recovery methodology specification for mission critical databases
• Performed hot and cold Backups.
• Scheduled daily Exports/Imports to serve as temporary backups.
• Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs.
• Capacity planning and creating databases for development, staging and production.
• Database and Data Migration using Export/Import, Migration Utility.
• Performed bulk data loads using SQL Loader.
• Performed proactive and reactive tuning/managing database space utilization and growth
• Implementing Oracle ASM and resolving ASM related issues
• Set up and configured SQL*Net and on servers and client machines.
• Administration of RAC and DATAGUARD databases in Oracle 11g.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier Architecture.
• Experience in WebLogic Application.
• Designed, tested and documented Oracle RAC database procedures
• Created, relocated and removed Services as needed in an Oracle RAC configuration
• Adding and removing nodes to existing Oracle database RAC configurations
• Resolving RAC specific issues such as node evictions
• Detailed analysis of the business and users requirements by doing various information gathering techniques.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Boston,MA

Jr Oracle DBA

Responsibilities:

• Managed Oracle Databases on Windows and Linux platforms.
• Performed activities like monitoring the database and provide maximum uptime.
• Scheduled the backup jobs such as export through cron job in UNIX environment.
• Rebuilt indexes and analyzed tables to ensure good performance of database.
• Installed Oracle 9i and 10g on multiple platforms.
• Performed up - gradation of 9i to 10g.
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Monitored the alert logs and troubleshot the errors.
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.,.

Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8), RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0