PROFESSIONAL SUMMARY:

• Oracle Certified DBA having around 8 years of experience on database administration on various platforms (i.e.) UNIX (AIX, Solaris, and HP - UX) and Linux (RHEL, OEL) environments. Worked extensively on database Installations, maintenance, migration, upgrade, patching, High Availability & DR (RAC, Datagaurd), performance tuning, backup recovery, and third party tools to get the job done. Managed Multi-Terabyte OLAP/DW Databases.
• Strengths Include OEM/Grid Control, Datagaurd/Standby, RMAN, Datapump, Export/Import, SQL loader, Scripting, CPU & PSU Patches, Cloning/Refresh, AWR/Stats pack, 24/7 database support, performance tuning, designing Backup and recovery strategies, Change Management, Release Management, User Management, Capacity planning.
• Self-motivated individual and possess good communication and interpersonal skills and works well both independently

TECHNICAL SKILLS:

Database: Servers Oracle(11gR1/R2,10gR1/R2,Oracle 9i),Oracle10 XE

Clustering: Oracle 10g/11g RAC, VERITAS Cluster Ware

Operating Systems: Sun Solaris (2.6,5.6, 8, 7), RHEL (4,3,5.3.5-5),OEL (4,5), HP-UX 10.x, 11.xIBM- AIX 5.1, 5.2, 5.3, Windows NT/2003/XP/Vista

Languages: SQL, PLSQL,C,HTML,Java

Scripting: Shell

Utilities & Features: Bulk Load, export/import

Oracle Tools:, Sql*Plus, Data pump, Grid Control/Oracle Enterprise Manager(OEM)

Utilities & Features: DBVerify, Datagaurd, RMAN,SQL*Loader, Export/Import, ASM, TKPROF, AWR, OPATCH, DBCA, DBUA, Statspack, External tables, Oracle Performance analyzer, SQL Developer, .

Thirdparty Tools: TOAD,SQL Developer,Golden,Sql Navigator, PL/SQL Developer, Putty, SSH

Scheduling Tools: Cron jobs, Oracle Enterprise Manager/Grid Control,ESP

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle Database Consultant

Responsibilities:

• Installed and configured Oracle 11g/10g RAC databases..
• Troubleshooting day to day issues in RAC environments and applying ASM, Grid Infrastructure (GI) patches and bug fix when and where required.
• Cloning and maintenance of application system and database on Linux platform.
• Responsible for performance tuning and optimization at both the application level and database level.
• Maintained the disk groups using ASMCMD, to accommodate the huge databases.
• Monitoring the instance statistics and tuning the database to improve performance.
• Monitoring & Scheduling jobs for the daily activities for all the databases using CRONTAB.
• Design and implement database backup and recovery procedures using RMAN.
• Troubleshooting the issues related to Performance issues, especially which impacts the application
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Configured and tested services for failover in the event of node failures.
• Monitoring the instance statistics and tuning the database to improve performance.
• Scheduled the maintenance jobs and alerts through OEM Grid Control.
• Used Data Pump import to load data into tables.
• Databases refresh using Oracle Data Pump export and Import.
• Troubleshooting the OEM Agent issues and fixing.
• Performing clear state of the OEM Agents whenever required to keep the target and destination agents in sync.
• Continuously monitoring Production and Staging databases for optimal performance.
• Worked with Oracle Support on Sev1 issues to keep business running.

Environment: Oracle RAC 11.x.0.x,10.1.x,10.2.x, 9.2.x,Linux, Sun OS 5, HP-UX, Confidential - AIX, RAC, VERITAS Clusters, Oracle Dataguard

Confidential, TX

Oracle Database Consultant

Responsibilities:

• Responsible for tuning the sqls to improve the performance on DB.
• Responsible for managing the RAC db in 3 node cluster with DB size varying from Gb to Tb.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
• Configuring and troubleshooting RMAN backup & recovery issues.
• Cloning and maintenance of application system and database on Linux platform
• Refreshed schemas from one environment to another using exp/imp utility
• Responsible for scheduling daily incremental backups using RMAN and recover when needed
• Responsible for Partitioning the tables as the business demands and Rebuild Indexes when required
• Implementing High Availability solutions with Oracle 11g/10g RAC, Standby (Datagaurd)
• Design and implement database backup and recovery procedures using RMAN.
• Troubleshooting the issues related to Performance issues, especially which impacts the application
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Configured and tested services for failover in the event of node failures.
• Monitoring the instance statistics and tuning the database to improve performance.SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, AWR, Explain Plans, ADDM and monitor the database performance on daily basis.
• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, Database/Instance Tuning on Oracle and SQL Optimization.

Environment: Oracle 11.x.0.x,10.1.x,10.2.x, 9.2.x,Oracle E-Business suite R12/11i, SIBEL,Command Series, Sun OS 5, HP-UX, Confidential - AIX, RAC.

Confidential, DE

Oracle Database Administrator

Responsibilities:

• Installed, Configured, Upgraded and Supported Oracle database 10g/11g.
• Responsible for performance tuning and optimization at both the application level and database level.
• Monitoring & Scheduling jobs for the daily activities for the performance of all the databases using CRONTAB.
• Design and implement database backup and recovery procedures using RMAN.
• Tuning the databases for optimal performance using TKPROF and EXPLAIN PLAN.
• Applied High priority, CPU/PSU and Interim Patches as recommended by oracle.
• Perform RMAN Cloning; troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Managing the databases in VCS (VERITAS Cluster Environments) & Installed Oracle Grid Infrastructure.
• Managing the security features for the different environments having Vault features, with mostlyuse in authentication of different application users accessing the high secure DB.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE, ADDM and ASH.
• Using & Implement Monitoring strategy for databases via Oracle Grid Control and managing targets via OEM and fixing alerts generated on the OEM console.
• Excellent experience in Upgrade database from 10g to 11g
• Management of Schemas, Objects & Partitioning the tables & indexes.
• Experienced in creating USERS, GRANT privileges and ROLES to users.
• Co-ordinate with UNIX administrators for space managements on various servers.
• RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
• Performed Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup, Confidential TSM Storage Manager.
• Monitoring and management of various database components (logical & physical) like table- spaces, and segments.

Environment: Oracle 11.x.0.x,10.1.x,10.2.x, 9.2.x,Linux, Sun OS 5, HP-UX, Confidential - AIX, RAC, VERITAS Clusters, Oracle Dataguard.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed 9i, 10g applied patches in various environments and upgraded databases from 9i to 10g
• Created Users and granted Roles & Privileges to users
• Created Tablespace for new applications and Added new data files when needed
• Refreshed schemas from one environment to another using exp/imp utility
• Responsible for scheduling daily incremental backups using RMAN and recover when needed
• Created automated backup scripts using Data Pump and traditional exp/imp utilities for seamlessly refreshing the development databases with testing database
• Responsible for Partitioning the tables as the business demands and Rebuild Indexes when required
• Created scripts for complete database report that shows the database hit ratio, shared pool, rollback segment stat, and table space statistics
• Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Audited database for statements, privileges, and schema objects.

Environment: Oracle 10g/9i, Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TPROF, STATSPACK, SQL* Loader

Confidential

Oracle Database Administrator

Responsibilities:

• Provide technical assistance using oracle tools (Sql Loader, Sql Plus, PL/SQL, Tablespace maintenance, Import and export, Database Administration, Backup and Recovery, Troubleshooting).
• Performing 9i and 10g Oracle Databases Administration.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, users, roles and privileges.
• Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments.
• Ensuring physical backups are complete on a regularly scheduled basis and performing recovery of the database as required.
• Used TOAD tool to access the database.
• Extensively used Oracle utilities -Export, Import, data pump and Sql loader etc.
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.
• Monitoring the database, Managing sessions, listeners, underlying physical components against performance and availability thresholds.
• Creating user accounts within the database and granting roles and privileges as requested, in accordance within the security compliances.
• Used PL/SQL developer to create PL/SQL Procedures
• Involved in creating use cases and test cases.
• Increasing the size of table spaces by adding data files.
• Configured scripts to monitor activity with database.
• Implement Hot, Cold and Logical backup plans.
• Used STATSPACK, TKPROF utilities for Tuning and analysis.
• Designed backup and recovery procedures for OLTP system

Environment: Oracle 10g/9i, Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TPROF, STATSPACK, SQL* Loader