SUMMARY

• Oracle 10g certified professional with 9 years of IT experience as an ORACLE Database Administrator.
• Sound understanding of Oracle database architecture, configuration and administration, backup & Recovery, Performance tuning etc.
• Experience in high availability solution like Oracle Real Application Cluster, Data Guard, and Automatic Storage Management (ASM).
• Knowledge of implementing Disaster recovery products like Data Guard.
• Expertise in Shell scripting to automate database related tasks..
• Experience in tools like OEM, Manage Engine App Manager, SQL*NET, Net Configuration assistant, Oracle Universal Installer, Oracle Database Configuration assistant and Toad,
• Performed scripting of Backup and recovery policy and procedure using RMAN for Oracle database..
• Performance Tuning with measurable performance enhancement with STATSPACK, AWR, ADDM, Automatic SQL Tuning, TKPROF and Auto trace
• Strong Programming knowledge of SQL and PL/SQL with database Packages, Procedures, cursors and Triggers
• Sound understanding of application server like jboss and oracle web logic server.
• Experience in implementing Auditing policies using audit trail and syslog.

TECHNICAL SKILLS

Operating Systems: UNIX (Solaris, AIX, Red Hat Linux), Windows 9x/2000/2008/NT/XP

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

Backup/Recovery: RMAN, User Managed Backup/Recovery

High Availability: OPS, RAC, CRS, Grid Infrastructure, Data Guard, Replication, Automatic Storage Management (ASM).

Tools: Oracle Enterprise Manager, Manage Engine Application Manager, Exp/Imp, Data pump, RMAN, Stats pack, AWR, ADDM, RAC, Data guard, Toad, putty, tkprof etc.

Languages: SQL, PL/SQL, Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Oracle DBA

Responsibilities:

• Worked in production support For managing Different components of Confidential product suite which includes oracle database, jboss application server, oracle web logic application server and STG suite components.
• Used Manage Engine Application manager tool to monitor all different component of infrastructure like database, application servers, Operating systems,
• Installation and Management of Oracle Real Application cluster for maintaining high availability of databases.
• As part of Disaster recovery implemented and managed oracle Data Guard.
• Actively participated in Performance tuning activity which will cover all the component of infrastructure like database, application, operating system, network components etc.
• Implemented Different backup and recovery related processes using RMAN.
• Worked closely with Auditing team to implement auditing using audit trail and syslog.

Confidential, Oklahoma

Oracle DBA

Responsibilities:

• Installation, Administration, Maintenance and Configuration of Oracle Databases.
• Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Worked very closely with Development team to address their issue.
• Managed export and import of different databases using Oracle data pump utility.
• Optimized different SQL queries to insure faster response time
• Developed PL SQL procedures, functions and triggers for different database related task like backup and recovery
• Performed database tuning by using various tools, like Oracle Enterprise Manager and Stats pack, Explain Plan, AWR and ADDM.
• Used SQL*Loader utility for loading the data through ‘*.csv’ file
• Worked with security team to implement PCI compliance related changes for oracle. Implemented oracle Auditing policies at database and operating system level.
• Extensively used Shell and awk scripts to automate database related tasks.

Confidential

Oracle DBA

Responsibilities:

• Installation, Administration, Maintenance and Configuration of Oracle Databases.
• Created and maintained different database entities included Tablespaces, data files; redo log files, rollback segments and renaming/relocating of data files on servers.
• Used RMAN for backup and recovery strategy.
• Tuning of databases which includes Server side tuning and application tuning.
• Capacity planning of the databases/applications.
• Refreshing test and development environments (Oracle) from production databases as and when required.
• Optimized different SQL queries to insure faster response time
• Developed PL SQL procedures, functions and triggers for different database related task like backup and recovery.
• Cloning of Databases and applications
• Application of oracle database and oracle application patches
• Worked with Oracle Enterprise Manager.
• Worked with Oracle Support to resolve different database related issues.
• Worked with the implementation and maintenance of RAC & Data Guard.
• Managed TAR/SR with Oracle Metal ink

Environment: Oracle 9i,10g,11g, AIX, Installation, Migration, Up gradation, OEM, RAC, RMAN, ADDM, AWR, Statspack, Tivoli.

Confidential

Oracle DBA

Responsibilities:

• Installed, configured and maintained different version of oracle.
• Interacted with Client Entities and application developers to ensure the database integrity, high availability and security.
• Daily backup using RMAN and recovery catalogue for local and remote databases.
• Managed export and import of different databases using Oracle data pump utility.
• Performed table fragmentation tuning, partitioning the large table by List and range partitioning.
• Cloned and refreshed production database to testing and development environments.
• Trouble shooting and resolving any database and/or application issues or errors dat occurred
• Performed database tuning by using various tools, like Oracle Enterprise Manager and statspack.
• Monitored the various database activities by developing shell scripts.
• SQL Tuning using Explain plan, TKPROF with sql trace and SQL Tuning Advisor.
• Developed procedures, functions and cursors in PL SQL
• Established database backup/recovery strategy for different databases.
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Monitoring and detecting lock detection.
• Developed scripts to monitor the storage usage, object status for daily job
• Replication using Materialized view and streams.
• Created and maintained B - tree and bitmap indexes, IOTs

Environment: AIX, Oracle 9i/10g, Replication, RMAN / Patching / Upgradation.

Confidential

Oracle DBA

Responsibilities:

• Providing Oracle DBA support for implementing RMAN backup/recovery strategies.
• Configured backups and managed recoveries of databases which include configuring EXP/IMP, Cold backups and hot backups. Automated hot/cold and logical backups of databases using customized backup scripts on Windows environment Scheduling backups using RMAN.
• Ensuring seamless integration of Oracle RMAN with the Tivoli Data Protection (TDP) for Oracle module of the Tivoli Storage Manager product (TSM).
• Coordinating with TSM administrator, system administrator and project manager to analyze business recovery requirements and review factors dat influence planning for backup/recovery.
• Used oracle streams for real time multi-way replication of database objects.
• Used Materialized views approach in replicating objects from different location to consolidated database location
• Design and implement DB security, user management
• Used SQL*Loader utility for loading the data through ‘*.csv’ file.
• Extensively used Shell and awk scripts to automate database related tasks.

Environment: Oracle 10g, SQL*PLUS, SQL*Loader, oracle Streams, RMAN, Migration, Up gradation, Linux, Windows, Putty, WinSCP

Confidential

Oracle DBA

Responsibilities:

• Involved in research and development of content filtering project for Cyberoam Product. Cyberoam is a vendor of identity-based network security products including UTM security, logging and reporting and secure remote connectivity appliances and data loss prevention software.
• Developed Web Categorization Engine which automatically categorized websites into more than 60 different categories.
• Designed and implemented the system for categorizing websites on the bases of region and local Popularity
• Extensively used Shell and awk script to automate not only database related tasks but also other operations of project.
• Designed the whole system along with the database design.
• Management of control files, redo log files, Table spaces, data files and undo data.
• Managed Tables, indexes and data integrity.
• Configuration of RMAN & Recovery Catalogue.
• Linux CRON job for daily backup operation.
• Partitioning of large tables by list and range based partitioning.
• Resolving performance problems.
• Written automated scripts for backups.
• Written Database Packages, Procedures, Functions and Triggers using PL/SQL.
• SQL query and Statspack performance improvement for report execution time

Environment: Oracle 9i,10g, Linux, Installation, Migration, OEM, RMAN, ADDM, AWR, Statspack, Shell scripting, awk, SQL,PL/SQL.