SUMMARY

• With more TEMPthan 7 years of IT experience as Oracle Database Administrator on a variety of UNIX (Solaris, HP - UX, IBM-AIX), Windows NT 4.0/2000/2003 with Oracle (9i, 10g, 11g) 11g/10gRAC, Data Guard, Installation, Configuration, Migration, Capacity planning and Performance Tuning, Backup and Recovery, Performance tuning and troubleshooting.
• Experience with databases running on Windows / UNIX (HP-UX, Sun Solaris, AIX) /REHL
• Expertise in Oracle 11g/10g/9i database administration in high availability production environment in Unix/Linux and Windows environment.
• Experience in Upgrade and Migration of oracle database to higher version installing patches and other platforms using Oracle Data Migration Assistant (DBMA) and Oracle Data Upgrade Assistant (DBUA).
• Thorough noledge in high availability RAC (multiple nodes) environment and Upgradation of teh standalone databases to 11g RAC environment. Experience in Installing and configuring Automatic Storage Management (ASM), CRSand RAC for high availability databases.
• Expertise in using oracle Export/import, Datapumputility to migrate data across schemas.
• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
• Experience in taking logical backups of data using oracle data pump utilities EXPDP and IMPDP, to move Oracle data from a database or schema to another.
• Experienced in using 10g features AWR, ASM, ADDM, Grid Monitoring, and Oracle Enterprise Manager.
• Good experience in SQL, Shell Scripting, Data modeling,Logical and Physical Database Design, Backup and Recovery procedures.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard).
• Experience in using oracle packages such as DBMS STATS, UTL FILE, DBMS JOBS and DBMS SCHEDULER.
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL*TRACE, 10g OEM Grid Monitoring.
• SGA tuning including Shared Pool, Buffer Cache, Large Pool, Redo log buffer, Sort area rollback segments me/O, Query response time hit/miss ratio etc.
• Experience in applyingsecurity patches to teh databases
• Experienced in Oracle Support processes for technical requests through Oracle Metalink and other Support Procedures.
• Automated many common tasks using crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Configuring user creation, their roles and privileges profiles to control access over database objects.
• Demonstrated ability to work well with a wide variety of people at various levels, faster co-operation and Collaboration among individuals in teh work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 5.8/5,9/5.10, RHEL 3.x/4.x/5.x, HP-UX 11i, Linux, IBM AIX 5.2/5.3/6.1, Windows Server 2000/2003/NT/XP

RDBMS: Oracle 11gRAC/10gRAC/9i

Languages: SQL, PL/SQL, C, C++, Unix Shell Scripting

Tools: RMAN, OEM Grid Control, SQL*Loader, EXP/IMP, Datapump Utilities, RAC, ASM TOAD, SQL Developer, SQL Navigator, Data Guard

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

Database Modeling: Erwin 4.0

Other: Hummingbird, Putty, FTP, SFTP, SSH, SCP, TELNET

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Performing all teh Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all teh databases.
• Installed, configured and maintained Oracle 11g Real Application Clusters (RAC).
• Implemented Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Migrated database schemas across servers of same application as per requests from development team using Data pump export/import.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Performed HOTbackup and COLDbackup using scriptsand RMAN and also Implemented backup strategies using incremental and cumulative backup methods
• Experienced in OLTP (On Line Transaction Processing) environment.
• Modeling Entity Relationship Diagrams (Physical & Logical designs) using Erwin tool
• UNIX shell scripting as and when required based on teh requirement.
• Patched Oracle Database Server 10g using Opatch utility.
• Refresh development/test databases from copies of production.
• SQL Tuning using EXPLAIN PLAN, TKPROF with SQL*TRACE, SQL Tuning Advisor.
• Performance tuning via OEM, STATSPACK/AWR for 10g/11g.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Perform other regular DBA activities including space management and performance monitoring.
• Oracle Database monitoring, troubleshoot and resolve teh issues.

Environment: Oracle 10g/11g RAC on Solaris 5.10/AIX 6.1/Linux, SQL, PL/SQL, SQL developer, RMAN, Data Guard, UNIX Shell Scripting, Toad, OEM.

Confidential, Tampa, FL

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for both production and development databases with on-call pager.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of teh databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Involved in Installation and configuration of a 4 node cluster Oracle 11g RAC in Sun Solaris 10 on Sun Server Platform, used ASM for configuring database file system.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Created Physical Standby database as a part of DR planning, also involved in creating teh Logical Standby database for teh reporting using Data Guard 10g.
• Daily Health Check Up of teh Database using STATSPACK, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Experience in monitoring and tuning system resources associated with teh database performance, Buffer cache hit ratios, me/O.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Taking periodic Backup of teh Database and teh software using RMAN.
• Automating teh daily routine activities backups using teh DBMS SCHEDULER using Oracle Enterprise Manager.
• Reading Alert Log and User trace Files and Diagnosing teh Problem.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Monitor CPU usage, me/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Automated teh process of analyzing tables every night.
• Write SQL scripts to monitor tablespaces and extent growth.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Space Management, which includes table space creation, adding new Datafiles.

Environment: Oracle 10g/11g R2 RAC, Sun Solaris 5.10, ASM, ERWIN, GRID, AWR, ADDM, OEM, Data Guard, Shell Scripts.

Confidential

Oracle DBA

Responsibilities:

• 24x7 Production Database Administration and support
• Teh work involves overall maintenance of ORACLE database, performance, tuning, backup, recoveries and other database related activities.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Day to day performance monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespaces
• Implemented Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in installation and configuration of Real Application Clusters (RAC) running on 2 node clusters.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh Databases and viewing Alert log files & Trace files.
• Monitoring of database for growth and performance
• Implemented backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Solaris platform.
• Using TKPROF, EXPLAIN PLAN for teh Better performance.
• Setting up and maintaining user accounts and profiles
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)

Environment: Oracle 9i and 10g,Windows NT / 2000, Solaris 5.9 and Linux, TOAD 7.5.0.0/7.6 Database Tools/Utilities, Enterprise Manager, Query Analyzer.

Confidential

Oracle DBA

Responsibilities:

• Provided technical support for Oracle Server to customers for Production Database.
• Supported customers including international customer to install teh developed application on different operating system e.g. windows, UNIX of all flavors on Oracle Database (9i, 10gR1)
• Also provided support to customers to manage their operational dataranging from GB to TB in Oracle database, solving of space problem, data loading problem Experience with building, installation, upgrade, and patching of Oracle.
• Analyzed SQL queries causing performance problems.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities.
• Refreshed schema using Export/Import. Created teh database, table space, tables, indexes, set privileges and user logins.
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
• Provided OS (RAM, me/O, CPU) tuning for Oracle Database.
• Worked on Unix Shell scripting in BASH, KSH for automating startup/shutdown of databases, getting system alerts etc.
• Applied patches both Server side and Client side.
• Worked on setting up new environments (Development, Production etc.).
• Supported teh Upgradation from Oracle Database9i and tan to 10gR1.
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Autantication.

Environment: Oracle 9i/10gR1, Solaris 5.9/5.9, HP-UX 11.2x, AIX 5.3, RHEL 3.x, Windows 2000/2003, Oracle Enterprise Manager, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, ERWIN 3.6.

Confidential

Jr. Data Base Administrator & Developer

Responsibilities:

• Installation and configuration of Oracle database 9i (9.0.2) on various OS platforms like HP-UX, Linux, and Windows NT, 2000.
• Monitored Customer Databases, physically located in Singapore and Remote administration of five Production Databases in UNIX environment.
• Worked on teh physical and logical designing of teh database, which includes teh distribution of data- files on different disks.
• Controlled and monitored user access to teh database. Optimized teh performance of teh database. Tuned SGA data dictionary and set database parameters.
• Defined and implemented database backup and security strategies, tested teh backups periodically for consistency and reliability.
• Created primary database objects (tables, views, indexes) once application developers has designed an application.
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune teh SQL statements.
• Reorganized data files, identified and eliminated contention factors like me/O, buffers and locks.

Environment: Oracle9i, SQL, PL/SQL, HP-UX 11.x, Linux, RMAN, Export/Import, SQL*Plus