SUMMARY

• Over 8 years of experience as an Oracle DBA in various domains to deliver new products, upgrades with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux and Windows platforms.
• Experience in Configuring Single instance, Oracle Real Application Clusters(RAC) and Automatic Storage Management(ASM).
• Experienced in day - to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Experienced with Data Modeling (Logical & Physical) techniques.
• Involved in analysis, design and development of business logic using SQL & PLSQL procedures and packages and Oracle Partitioning
• Effective skills in Backup, Restore and Recovery strategies using RMAN and also TSPITR
• Oracle Dataguard Installation
• Oracle Database Installation and Data Migration and applying Patches
• Cloning Database
• Exposure to GRID CONTROL and Database UPGRADE
• Optimizing SQLs using explain plan to analyze the execution plan and tune the statements.
• Performance Tuning for SQL through HINTS/Oracle BASELINE/SPA/Database Replay and reframe SQL Queries
• Designs, tests, implements, maintains, and controls the companies physical, relational, and object-oriented databases like Oracle 11g,10g,9i,8i across multiple platforms like HP UNIX, Red hat LINUX,IBM AIX, Sun Solaris, Windows with the performance tuning of the databases
• Installation of ASM (Automatic Storage Management).
• Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by working in development area more with STATSPACK, OEM Grid Control, AWR as the main tool to tune SQL queries and dynamic performance views to monitor system statistics and wait events.
• Creation of database, tablespaces, rollback segments and tuning the physical structure of database.
• Creating packages, procedures, functions, queries in DDL and DML through PL/SQL
• Defining Backup Strategy for databases and testing them periodically.
• Configuring user creation, their roles and privileges, profiles to control access over database objects.
• Backup and Restore (complete/incremental Hot and Cold Backups).
• Excellent Communication and Interpersonal skills
• On call 24X7 Production Support. Willingness to work beyond regular hours

TECHNICAL SKILLS

Operating System: Sun Solaris 8/9/10,, HP UNIX, IBM AIX 5.2/ 5.3, Red Hat LINUX, Windows 95/98/NT/XP

Programming Languages: Java, C, C++, PL/SQL, UNIX/NT Shell Scripting, SQL

Databases: Oracle 11g,10g/9i / 8i /8/ 7.3

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Tools: & Utilities: Oracle Enterprise Manager, Toad, Export, Import, Data Pump, SQL Loader, SQL*plus, SQL Optimizer, Oracle 9i/8i IAS, Business Objects, Oracle Discoverer, Forms, Reports, Autosys.

Version Control: CVS,SVN

J2EE Technologies: EJB 3.0,XML, XSL, XSD, Servlets, JSP, HTML, Ajax, JDBC, Spring, Hibernate, Swings, Webservices.

PROFESSIONAL EXPERIENCE

Confidential, Peoria, IL

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 10g, 11g databases on Linux 5.4.
• Implement Oracle 10g Release 1 RAC on Enterprise Linux 5.4 in a Test environment.
• Migrated databases from 9i to 10g, 11g and 10g to 10g on different platform.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Cloned databases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment.
• Support database platform are AIX, Hp-Unix, Solaris, REHL and Window.
• Create UNIX shell scripts that automatically monitored all databases on all servers for alert log messages, tablespace growth and process scheduler problems.
• Create table with Daily Range partition as per the requirement.
• Create standby database and worked with data guard to provide high availability.
• Create and Manage user, table spaces, datafiles and archive log.
• Monitor, tune and maintain overall database.
• Create Functions, Procedure, triggers, synonyms and profiles.
• Work with Flash Recovery Area.
• Create and implement backup and recovery strategies using RMAN configuration.
• Provide troubleshooting and problem solving support to application developers.
• Create Clone databases using user-managed as well as RMAN.
• Support the development staff for implementation of database objects.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR and ADDR report generated from snapshots taken at the peak business hours.
• Transported tablespaces and data exports from production and staging databases.
• Applied client patches and other patches as required.
• Support production databases on 24x7 on call basis.

ENVIRONMENT: Oracle 10g/11g RAC, SQL Loader, Windows 2008, Sun Solaris 10, FTP, putty, OEM Programming Language/Tools: TOAD, PL/SQL

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Installed and configured oracle 10g and 11g on Solaris.
• Performed upgrade of oracle database from 10g to Oracle 11g with Oracle Database Upgrade Assistant (DBUA) in development, test and production environment.
• Performed HOT backup and COLD backup using scripts and RMAN and also developed backup strategies using incremental and cumulative backup methods.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Worked on database design, creation and configuration, space management and other database maintenance procedures in a multiple oracle production and development environments.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager / Grid Control to monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
• Performed Data migrations from CSV/flat files using scripts and SQL Loader.
• Developed automated scripts for database creation and builds.
• Monitored database Performance using AWR, ADDM, SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.
• Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.
• Creating batch files and automating the tasks.
• Granting roles and privileges to end users.
• Scheduled various job using UNIX Crontab utility.
• Worked on import/export and Datapump utility.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
• Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.

ENVIRONMENT: Oracle 10g/11g RAC, SQL Loader, Windows 2008, Sun Solaris 10, FTP, putty, OEM Programming Language/Tools: TOAD, PL/SQL

Confidential, Denver, CO

Oracle DBA

Responsibilities:

• Creation of the Development, Test and Production Oracle 9i databases.
• Part of Migration team from 8i/9i test databases to 10g, my role was to test the migrated database in different scenarios with different loads, test different new features of 10g and how can we take advantage of those new features.
• Setting up and configuration of database with 10g in RAC environment with data guard.
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN and Data Guard in RAC environment.
• Team member of Strategic planning team was responsible for Developing backup and recovery strategy, database tuning strategies, capacity planning etc.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Database Administration & Planning including logical design, physical design, backup & recovery.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
• Setting Oracle Streams for bi-directional replication between two databases. Worked with application developers on setting of 9i advanced queuing for data transfer between various applications.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting.
• Experience working with XML files, edited the XML document which were associated with the ORM tool HIBERNATE to configure and tune the queries.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Export and Import of database objects to copy from one database to another database as well as copy the export dump file to tape that can act as a backup.
• Used UNIX shell programs & CRON jobs for automating the process of refresh of data periodically.
• Documentation of Data Base Setup and administration of Server Environment.

Environment: Oracle 8.1/ 9.2.0/ 10.1/11 , SOLARIS 8/9, AIX 5L, SQL, PL/SQL, Putty, TKPROF, Designer 2000/6i, Erwin Tools 4.5, TOAD 7.6, SQL*Loader, TDP 5.2, Legato Media Manager, RMAN, RAC, 9i Advanced Queuing

Confidential, Northboro, MA

Oracle DBA

Responsibilities:

• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the production database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches
• Responsible for maintaining Oracle 10.1.0.2 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Configured the VERITAS clustering for Oracle on the production and pre-prod databases.
• Migrated databases from 10g to 11g using transportable tablespace and datapump
• Responsible to schedule backups through RMAN.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Used Flashback table to restore tables which is a new feature of Oracle 10g.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
• Implemented scripts to capture high resource utilization queries.
• Implemented scripts for daily monitoring like db status, no of extents, free space etc.
• Implemented Oracle Advanced Security Options
• Maintained multiple terabyte databases on oracle.
• Cloned the production database periodically to the testing databases through SQL backtrack.
• Monitored the Oracle Streams topology and performance.
• Identified the long running transaction through V$session longops and also for Rollback monitoring which is an enhanced feature of Oracle 10g.
• Used EM on Oracle 10g for diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.
• On-Call 24x7 DBA support for production databases.
• Re-engineered system to J2EE using Oracle 10g backend database.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
• Tuned the SGA. Monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Tablespaces and Segment fragmentation. Performed trouble shooting activities, created new users and assigned privileges and roles to users.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g/11g, PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.

Confidential

Oracle DBA

Responsibilities:

• Review of Database logical and Physical design
• Install, upgrade and maintain Oracle 10g, 9i on Sun Solaris and Windows 2003, Redhat4
• Installation, setup and configuration of DATA GUARD
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc
• Implementing Database Security, Management of role-based security
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database
• Write and modify UNIX shell scripts to manage Oracle environment
• Performed Data Migration as a part of enterprise data warehouse project
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Cloning databases using scripts as well as RMAN
• Established database backup/recovery strategy for different databases
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files
• Implemented schema level, table level and bidirectional oracle streams
• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store
• Performed scheduling Control-m for scheduling jobs

Environment: Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK