SUMMARY

• Six years plus of experience as an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation. And support People Soft Application: Finance and Human resources.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD
• Monitoring VLDB (Very Large Databases) using Grid Control
• Involved in performance tuning and database reorganizations.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space. Performed SAN analysis and provided recommendations
• Proficient in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life - Cycle (SILC).
• Knowledgeable in using Grid Control and OEM Features and worked with databases which have critical and BLOB data
• Provided root cause analysis and permanent fix of production problems
• Installation, administration and maintenance of Oracle 11g
• Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to 11g) and patching
• Wrote several Purging shell scripts on Linux which have been using as standard script at the workplace
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc
• Developed RMAN scripts for database back up and recovery including- hot and cold backup
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Team player with excellent interpersonal, analytical and communications skills
• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Performed backup & recovery of large databases and provided 24X7 production support to high critical databases
• Monitored and managed various database components (logical & physical) like table- spaces, segments
• Worked extensively on Shell scripting for backup, recovery and maintenance for databases
• A good understanding of Data modeling, and the tools used to create them (Erwin).

TECHNICAL SKILLS

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 11g/10g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL, SQL*Plus, ERwin

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg PA

Oracle DBA

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g. And also have knowledge on 12c.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
• Index creation and management for optimization of DB Processes
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• 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”.
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
• Experienced in working with 6 TB in OLTP and OLAP environment..
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning

Confidential, Portland, Oregon

Oracle DBA

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.
• 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.
• 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.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Install and configure block change tracking to work with RMAN Merged incremental backups.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Confidential, North Canton, OH

Junior Oracle DBA

Environment: Oracle 11g, Oracle 10g, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

• Managed in-house Oracle Databases running on various operating systems like Windows NT and Linux. backup and recovery solutions, PL/SQL concepts.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Designing and enforcing standards and naming conventions.
• Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise
• Database tuning, backup and recovery and general day to day running of the system.
• Systems analysis and design.
• Writing UNIX shell scripts for backup and recovery.
• Supervised the installation and configuration of Oracle databases on Linux and Windows NT
• Writing SQL scripts to monitor database performance.
• Writing SQL Loader control files for data loading to the payroll system.
• Problem trouble shooting and resolution.
• Database installation and instance creation.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Using Enterprise Backup utilities for backup.
• Writing scripts for backup and recovery.
• System tuning for better performance.
• Creating project plans and implementation schedules.