PROFESSIONAL SUMMARY:

• Ten plus years of IT experience in Oracle Database Administration (9i/10g/11g)/Applications which includes designing, developing, deploying, managing and tuning of databases on SUN Solaris, Linux, AIX, HP - UX Operating system.
• Excellent Hands on in Real Application Cluster (RAC) environment .
• Successfully implemented Physical Standby Database using Oracle DATAGUARD feature for High availability configuration.
• Proficient in Oracle Database Administration encompassing Planning/ Implementing, Memory Management, Table space, File, Segment, User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning, creation and configuration of Database on Oracle
• Multitasking credentials with excellent planning, execution, monitoring and resource-balancing skills, as well as the ability to handle multiple tasks in high pressure environments and under tight deadlines.
• Performed Switch Over and Failover Task for Non RAC and RAC Databases
• Conversant in working with Metalink, SR handling.
• Remotely worked through third party S/W‘s like VPN, Putty, VNC, Psftp, Coreftp.
• Refreshed 9i/10g Oracle Database.
• Proactively monitor the database systems to ensure secure services with minimum downtime.
• Extensive experience designing and implementing backup and recovery strategy for disaster management using the conventional Hot/Cold Backups and using the Oracle backup utility RMAN.
• Experience with various database Backup and Recovery methods like Export/Import, Datapump and Flashback Technologies.
• Articulate communicator with strong analytical and interpersonal skills; known for honest work ethics and delivering projects in time without compromising on quality
• Experience with Database SQL tuning and query optimization tools like TKPROF, SQL Trace, Auto trace, Explain Plan, and STATSPACK.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Upgrading and Migration of Oracle database to higher version and other platforms using Oracle Database Upgrade Assistant (DBUA), Database Migration Assistant (DBMA) and (TTS) Transportable Tablespace.
• Upgraded database from 10g to 11g.
• Applying Patches, Troubleshooting database issues, critical security updates and User Issues using Meta link.
• Partitioning of the database and large tables and creation of the Indexes on large tables to improve the Performance.
• Loading of the data from flat files into tables using SQL*Loader.
• Extensive Experience using UNIX Crontab and writing Shell Scripts for automated monitoring, backup and data loading.
• Managing Security, User groups and Users by using roles, grants, privileges and profiles.

TECHNICAL SKILLS:

Databases: Oracle 8i, Oracle 9i, Oracle 10g,11g RAC.

Application and Operating System: Oracle 11.5.9, 11.5.10.2, R12Red Hat Linux, AIX 5.3, Sun Solaris 5.9, Windows 95/98/NT/2000/XP, UNIX.

Database Tools: OUI, Grid Control, OEM,Putty, DB designer4, DBCA, RMAN, ADDM, AWR,Tkprof, Toad,SQL*PLUS, STATS PACK, JavaScript, MSACCESS, MSEXCEL, Enterprise Manager.

DB Utilities: EXP, IMP, EXPDP, IMPDP, RMAN, SQL*LOADER.

Languages: PL/SQL, SQL, UNIX Shell scripting, C and C++,JAVA,HTML,XML

PROFESSIONAL EXPERIENCE:

Confidential, ITASCA, IL

Oracle DBA

Responsibilities:

• Installer and Configured Oracle 11gR2 database instance running across two oracle RAC nodes on SunOS sun4v sparc SUNW,Sun-Fire-T200.
• Upgraded database from 10g to 11g.
• Setting up of Oracle Security, Database Space Management, distributing the data files, index files, redo logs and rollback segments on different disks to optimize data retrieval, setting Unix Kernel parameters for improved performance, installing Patches, Performance tuning and monitoring of the applications and Documentation.
• Database availability is 24X7. Database mode is ARCHIVELOG. Backup is HOT (online) using utility tar and Cold (Off-line) in weekends. Recovery of Databases including Incomplete & Complete Recovery. Recovery of Control files/ Data files/ Redo logs files.
• Work with RAC pre-installation tasks, like hardware requirements, software requirements, and environment configuration.
• Converted Databases from NON-RAC to RAC using ASM.
• Configuration of RAC database with help of Enterprise manager agent on each cluster node
• Creating and defining redo log files and undo tablespaces for RAC environments.
• Setting up the primary and Standby databases for availability using Oracle Data Guard.
• Configured Oracle 11g RMAN with symantec NetBackup to perform backup on Tape instead of disk.
• Checking ALERT logs to know types of Bottlenecks recorded during the day if any, and rising to counter them
• Scheduling the Database Backup Scripts in the CRONTAB on UNIX
• Implemented TAF load balancer for application.
• Implemented Scan listener for load balancing the databases.
• Implement backup policy on top of target database using RMAN utility.
• Configured and store pre-configured scripts in the RMAN catalog database that can run any time.
• Used to export tablespaces on 10g Oracle Enterprise Edition on Solaris using transportable tablespace concept.
• Using Recovery Manager (RMAN) and Oracle Enterprise Manager (OEM) for various maintenance tasks like backing up of database, restoration and recovery of database.
• Importing and exporting files, databases, schemas and tables using SQL loader and utilities like Import, Export and Data Pump features of Oracle database 10g.
• Performed database Upgradation, Migration from Oracle 9i to Oracle 10g.
• Involved in designing and creating schema objects like Database tables, indexes, views, and synonyms.
• Granting and Revoking privileges and roles to the users on different objects depending on their work requirement and providing the necessary security to the database.
• Performed capacity planning and sizing of databases based on input from business.
• Production Support and Database Monitoring for performance of Databases.
• Monitoring the Alert Logs and User Trace Files for improving database performance and detecting any suspicious activities.
• Tuning the Pl/SQLs for faster execution and better performance of the Database.
• Tuning database server and application logic for performance improvement by using Explain Plan and TKPROF.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces to improve the performance.
• Interacted with oracle PL/SQL developers in developing efficient applications
• Generation of the AWR (Automatic Workload Repository) Reports and using them for tuning the database.
• Hands on experience working with Oracle Grid Control Environment.
• On call 24X7 Production Support.

Environment: Oracle 10gR2, SunOS sun4v sparc SUNW,Sun-Fire-T200, OEM (GridControl), RMAN, RAC and DataGuard, Explain Plan, Metalink, Data Pump, Putty.

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

• Worked as a Team lead in Production Environment.
• Performance Tuning of Oracle Real Application Clusters.
• Configured and maintained physical standby databases using Oracle DATAGUARD to perform quick disaster recovery.
• Develop database Backup and Recovery and Disaster recovery strategies; scheduling full and incremental backups using RMAN.
• Developing Shell Scripts to automate the Data Loading process, automate the Backup process and for automation of various Database-Monitoring activities.
• Imported and exported files, databases, schemas and tables using SQL loader and utilities like import and export dump features of Oracle database 10g.
• Troubleshoot database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and Tuning the database for optimum performance.
• Identification of poorly performing queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace and SQL Tuning Advisor.
• Creation of schema objects like Database tables, indexes, views, and synonyms
• Setting instance parameters and managing Table spaces, segments, extents, indexes, undo data and redo logs.
• Creation of Partitions on tables and using Indexes for management of large tables and improving the performance
• Creating Users and managing Users by assigning roles, privileges and profiles to users.
• Tuning, monitoring and managing oracle databases using the Oracle Enterprise Manager (OEM).

Environment: Oracle 10g, Red Hat Enterprise Linux 4, Toad9.0, Oracle Enterprise Manager, RAC, Exp/Imp, Toad, Data Guard, Grid Control.

Confidential, New York

Oracle DBA

Responsibilities:

• Installation and creation of 9i and 10g databases for Testing, Development, Production including configuration, backup & performance tuning.
• REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of Stand by database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrade of Database from 9.2.0.6 and to 10.2.0.2.
• Designing the logical and physical database structure.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options includingRMAN.
• Partitioning Strategies for very large tables.
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Data refresh from production to test and development, maintain Database Security.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies
• Optimization and tuning SQL queries using TRACEFILE, TKPROF, EXPLAINPLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Writing scripts for the system and database for effective functionality and report generation.
• Applied High priority, security patches downloaded from Metalink.

Environment: Oracle Server 10g/9i, SQL, AIX, Toad, Imp/Exp, DataGuard, Enterprise Manager

Confidential, Washington, D.C

Oracle DBA

Responsibilities:

• Created and customized Oracle Database and Schema.
• Responsible for maintenance and improvement of production, archive Oracle databases.
• Tuning and optimizing current and new applications utilizing SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Extensive work with write a shell scripts and with use of this setup cron job into environments.
• Design and implement database backup and recovery procedures using RMAN.
• Conducted extensive Backup and Recovery for the Database.
• Administered Hot/Cold Backups on a regular basis.
• Implemented security protocols for the database.
• Monitored Alert Log Report and system Error Logs.
• Carried out Optimizing performance and Query tuning using Statspack, Utlbstat, Utlestat, Tkproof, and OEM.
• Cloned database from PROCUCTION to create TEST, DEVELOPMENT and UAT instances.
• Creation of Database Links, Table spaces and make sure that all objects must be valid in the database.
• Installed and Upgrade database with help of patches to maintain environment.
• Configured and mange OEM to stabilized oracle database into healthy environment

Environment: Oracle 9i, Sun Solaris, Toad, OEM, Imp/Exp.

Confidential

Oracle DBA

Responsibilities:

• Performed database tuning and performance monitoring.
• Monitored growth of data and managed space allocation accordingly
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity.
• Backup strategies, scheduling the backups. Backing up and restoring the databases whenever necessary.
• Actively involved with application team in coding SQL statements in PL/SQL.
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.
• Used Quest TOAD to tune query performance.
• Planned and performed the migration of Oracle version 8.1.7.4 to version 9.2.0.7
• Performed off site on call 24x7 production support for Oracle 9i database administration activities.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Setting up of RMAN on the database to perform necessary back up.