SUMMARY

• Oracle 10g certified professional with over 13 years of IT experience as an ORACLE Database Administrator. Have migrated DB between software versions, platforms, and DB products and upgraded Oracle database from 8i/9i to 9i/10g and 11gr2.
• Supported 7/24 mission critical huge database up to 34 TB in size.
• Knowledge of Creation, configuration and maintenance of databases on RAC environment.
• Inspected Database Configuration information, Knowledge of Creation, Configuration and Maintenance of database with Data Guard.
• Experience on Oracle 10g and 11g Grid Control, Experience in tools like OEM, SQL*NET, Net Configuration assistant, Oracle Universal Installer, Oracle Database Configuration assistant.
• Applied the patch sets released by Oracle Corporation from time to time, performed Application tuning (SQL tuning, Memory Tuning).
• Performed scripting of Backup and recovery policy and procedure using RMAN for Oracle database.
• Installed and Implemented Oracle Management Server to serve OEM clients, Setup and configure Statspack for enhanced database monitoring and tuning, extensively used latest features like ASM, Monitoring and tuning tools like ADDM & AWR.
• Extensive experience in Installation, Administration, Maintenance and Configuration of Oracle Databases including the experience in the area of System study, Analysis & Database Design, Program Specification, Project Scheduling, Coding, Report generation, Testing, Implementation.
• Strong Programming knowledge of SQL and PL/SQL with database Packages, Procedures and Triggers, Applied the Critical patch set.
• Trouble - shoot problems arising in day-to-day operation of Oracle databases and Investigate new technologies pertinent to the operation and management of the databases like OMS, Statspack.
• Excellent analytical, problem solving, communication, managerial and interpersonal skills with the ability to interact with individuals at all levels. Good interpersonal skills, self-motivated and fast ability to absorb new technology.
• Have managed and mentored a team of 7 DBA’s across different Continents.

TECHNICAL SKILLS

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

Databases: Oracle 8i, 9i, 10g, 11g r2, MS SQL Server 7.0/2000/2005 , MS Access.

Tools: Oracle Enterprise Manager, Grid Control, Streams, Exp/Imp, Datapump, RMAN, Statspack, AWR, ADDM, RAC, Dataguard, DBArtisan, Autosys, Query Analyzer, Erwin, Toad. Spotlight.

Languages: SQL, PL/SQL, Korn Shell, Pearl Shell, TSql, COBOL, FoxPro, C++.

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr Oracle DBA

Responsibilities:

• Tracking the CRM tool for any issue reported from Client and Managed 7 Oracle DBA’s across Globe for supporting different Client spread across continents by assigning them Tickets/Issues as per their expertise and client location and reviewing them before handing back to the Clients as accepted solution and also mentoring DBA’s where ever needed.
• Extensively used Grid Control (OEM), and Toad to maintain various database servers.
• Database and Server and data warehousing and other application tuning.
• Capacity planning of the Database/Application.
• SQL Tuning using Explain plan, TKPROF with Sql trace and SQL Tuning Advisor.
• Worked with Oracle Support to resolve different database related issues.

Environment: Oracle 9i,10g,11g, RH Linux, Installation, Migration, Upgradation, OEM, Grid, Toad, Dataguard, RMAN, ADDM, AWR, Statspack, Exp/Imp, Explain Plan, TKPROF etc.

Confidential, Minneapolis, MN

Senior Oracle DBA

Responsibilities:

• Used Database Grid Control (OEM), Spotlight, and Toad to maintain various database servers
• Used RMAN for backup and recovery.
• Tuning of databases which includes Server side tuning and Application side tuning based on Java.
• Capacity planning of the databases/applications.
• Upgrade Oracle database from 9i/10g and 11g.
• Refreshing test and development environments (Oracle) from production databases as and when required.
• Completed export and import of different databases using Oracle Export / Import utilities.
• Optimized different SQL queries to insure faster response time.
• Provided all kinds of DBA support to development teams as well as production support to various data warehousing applications.
• Provided on-call support regarding production-related database problems.
• SQL Tuning using Explain plan, TKPROF with sql trace and SQL Tuning Advisor.
• Recorded in the document all the commands and responses in the testing scenarios in order to provide an accurate reference manual for doing recovery when disaster strikes.
• Worked with Oracle Support to resolve different database related issues.

Environment: Oracle 9i,10g,11g, RH Linux, Solaris, Installation, Migration, Upgradation, OEM, Grid, RAC, Dataguard, RMAN, ADDM, AWR, Statspack, Partitioning, Exp/Imp, Explain Plan, TKPROF etc.

Confidential, Richmond, VA

Senior Oracle DBA

Responsibilities:

• Installation, Administration, Maintenance and Configuration of Oracle Databases though Grid.
• Participated in Configuration, Implementation and Maintenance of 3 Node RAC Servers of 32 TB.
• Created and maintained different database entities which included Tablespaces, data files; redo log files, rollback segments and renaming/relocating of data files on servers.
• Provided on-call support regarding production-related database problems.
• Used RMAN for backup and recovery strategy.
• Scheduled Backup using shell Script.
• Tuning of databases which includes Server and Java based Application tuning.
• Capacity planning of the databases/applications.
• Upgrade Oracle database from 8i/9i to 9i/10g and 11g.
• Refreshing test and development environments (Oracle) from production databases as and when required.
• Optimized different SQL queries to insure faster response time.
• Worked with Oracle Enterprise Manager.
• Work with Oracle Support to resolve different database related issues.

Environment: Oracle 9i,10g,11g, RH Linux, Solaris, Installation, Migration, Upgradation, OEM, Grid, Partitioning, RAC, RMAN, ADDM, AWR, Statspack.

Confidential, Christiansburg, VA

Senior Oracle DBA

Responsibilities:

• Installed, configured and maintained (OEM) Oracle 10g and Real Application Cluster (RAC).
• Set up and maintained oracle disaster recovery site using Dataguard.
• Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Utilized RMAN for backup and recovery strategy.
• Completed export and import of different databases using Oracle Export / Import utilities
• Table fragmentation tuning, partitioning the large table by date.
• Studied and Analyzed the business requirements, designed entity relationship diagram using Erwin
• Installed Oracle database 10g, and upgraded Oracle 9i to 10g.
• Cloned and refreshed production database to testing and development environments.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Created and maintained different database entities included Tablespace, datafile, redo log files, rollback segments and renaming/relocating of data files on servers.
• Trouble shooting and resolving any database and/or application issues or errors that occurred
• Performed database tuning by using various tools, like Oracle Enterprise Manager and STATSPACK
• Monitored the various database activities by developing shell scripts and using various tools.
• SQL Tuning using Explain plan, TKPROF with sql trace and SQL Tuning Advisor.
• Patched Oracle Database Server 9i and 10g using Opatch.
• Established database backup (Net backup and Volume Manager)/recovery strategy for different databases.
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Setup and support of Oracle replication(replication and conflict solution)
• Modified database structures including Tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Developed scripts to monitor the storage usage, object status for daily job
• Provided on-call support regarding production-related database problems
• Worked with IT managers and application developers to ensure the database integrity, high availability and security
• Performed other duties as assigned.

Environment: AIX, Red Hat Linux, Oracle 9i/10g/10g RAC/11g/ Dataguard / RMAN / Patching / Upgradation, Replication, Erwin, Autosys, Exp/Imp, Statspack, AWR, ADDM, Explain Plan, TKPROF, OEM.

Confidential, Greenville, SC

Senior Oracle DBA

Responsibilities:

• Providing Oracle DBA support for implementing RMAN backup/recovery strategies.
• Maintained Database servers through OEM.
• Used shell script for backup process of the database.
• 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 that influence planning for backup/recovery.
• Worked closely with the TSM administrator and system administrator to install and configure TDP product, utilities and license on about 20 HP-UX severs, and to ensure the proper backup, restoration and recovery of all database files whenever necessary.
• Used Database Grid Control to maintain various database servers.
• Managed MS Sql Server 2000, 2005 and monitored for performance.
• Designed and implemented various RMAN backup strategies through TDP interface
• Identified all possible database failure and recovery scenarios and played them out in a test environment.
• Used PL/Sql for various work and tuned as and when required.
• Recorded in the document all the commands and responses in the testing scenarios in order to provide an accurate reference manual for doing recovery when disaster strikes.
• Recovered successfully two production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors and lost of control files.

Environment: Oracle9i/10g/10gRAC/11g/OEM/Grid/Dataguard/RMAN/Patching/Upgradation/,Tivoli,RHEL, Solaris. HP-UX, SQL Server 2000, 2005

Confidential

Senior Oracle DBA

Responsibilities:

• Monitoring and maintenance of around 6 database instances which include Development, Test and Production databases on Oracle.
• Configuring backups and recovery of databases which includes 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.
• Refreshing test and development environments (Oracle) from production databases as and when required.
• Tuning of databases which includes Server side tuning and application tuning.
• Capacity planning of the databases/applications.
• Migrate DB between software versions, platforms, DB products
• Upgrade Oracle database from 7.x to 8i/9i.
• Monitored Sql Server and managed sql servers for and Performance issue.
• Design and implement DB security, user management
• Support developers in tuning DB and apps for optimal performance
• Installed and configured Oracle 10g, upgrade software: server, tools, applications
• Design and implement backup methods and disaster recovery strategies
• SQL and PL/SQL: scripts, triggers, procedures, packages.
• Monitor DB growth and provide DB capacity planning for apps expansion
• Work with Oracle Support to resolve different database related issues.
• Performed on call duties whenever required and supported the database in 24/7 mode.

Environment: Oracle 9i, 10g, SQL Server 2000, 2005, SQL*PLUS, SQL*Loader, RMAN, Migration, Upgradation, Linux, Windows.

Confidential

Oracle DBA

Responsibilities:

• Monitoring and maintenance of around 200 database instances which include Development, Test and Production databases on Oracle.
• Configuring backups and recovery of databases which includes configuring EXP/IMP, Cold backups and hot backups. Automated hot/cold and logical backups of databases using customized backup scripts on Linux environment. Scheduling backups using RMAN.
• Upgrade Oracle database from 9i to 10g.
• Wrote shell script for automation of backup jobs.
• Monitor DB growth and provide DB capacity planning for apps expansion.
• Work with Oracle Support to resolve different database related issues.
• Tune databases and custom code using Tuning wizards.
• Perform/automate backups, restore database, and manage TAR/SR with Oracle Metalink.
• Modify database initialization parameters: create additional listeners, create Oracle Net Service aliases, and configure connect-time failover. Control the Oracle Net Listener.
• Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
• Worked with Oracle Enterprise Manager.
• Optimized different SQL queries to insure faster response time.
• Created new databases and users: set up backups, export, and other monitoring scripts.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery.
• Identify, recommend, and implement all new database technologies and Oracle license management.
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Experience in backing up database on Net backup, and Volume Manager with the help of System and Storage Admin.
• Responsible for Oracle 9i logical and physical databases design, implementation, and maintenance.
• Handled database server tuning, application tuning, maintaining documentation, and capacity planning and database security.

Environment: Oracle 8i, 9i & 10g, SQL, Upgradation, Migration, RMAN, SQL*PLUS, SQL*Loader, Solaris, Linux, Windows.

Confidential

Oracle DBA

Responsibilities:

• Capacity planning of the databases/applications.
• Migrate DB between software versions, platforms, DB products
• Design and implement DB security, user management
• Support developers in tuning DB and apps for optimal performance
• Install, configure, upgrade software: server, tools, applications
• Design and implement backup methods and disaster recovery strategies
• SQL and PL/SQL: scripts, triggers, procedures, packages.
• Monitor DB growth and provide DB capacity planning for apps expansion
• Work with Oracle Support to resolve different database related issues.
• Perform on call duties whenever required and support the databases

Environment: Oracle 8i, 9i, SQL, SQL*PLUS, SQL*Loader, Migration, Upgradation, RMAN, Windows.

Confidential

DBA

Responsibilities:

• Design and implement DB security, user management
• Support developers in tuning DB and apps for optimal performance
• Install, configure, upgrade software: server, tools, applications
• Design and implement backup methods and disaster recovery strategies
• SQL and PL/SQL: scripts, triggers, procedures, packages.
• User creation and space allocation, roles and privileges etc.
• Finding the areas related performance issues.
• Space management, user management, performance issue, Backup strategies

Environment: Oracle 8i, 9i, SQL, SQL*PLUS, SQL*Loader, Linux, Windows.