PROFESSIONAL SUMMARY:

• Over 7+ years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, Golden Gate Administration, RMAN, ASM, Data Guard, space management, database security, providing 24x7 production support of development and production db version 12c/11g/10g/9i RAC and Non - RAC databases on different Platform.
• Setting up and Migrated database upgrades on Solaris, HP-UX, AIX, Linux, Windows platforms using Golden Gate, Transportable tablespace and Datapump.
• Extensive knowledge on database backup/recovery strategy (RMAN), Data guard, database cloning.
• Worked on Data Export/Import, Data pump, Database Vault, Database Firewall for various requirements.
• Experience in installing Oracle patches on 11g/10g/9i Linux.
• Experience with scheduling jobs using Cron jobs, DBMS SCHEDULER, DBMS JOBS.
• Experience in Migration of database across different platforms.
• Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Reports builder, Forms 6i, SQL developer, SQL* Plus, Crystal reports.
• Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD i.e. logical standby and physical standby databases.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, AWR Reports, ADDR Reports TKPROF, STATSPACK, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Efficient in Database performance monitoring, enable Audit diagnostic and Tuning, Backup and Recovery, managing users and security.
• Comprehensive knowledge in Database Architecture & Implementation, Data Models, Database design, Normalization & System study.
• Expertise in managing database by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments.
• Expertise in maintaining Database Security using security compliance auditing, Vault and expertise in loading data from flat files using external tables and SQL*Loader.
• Expertise in Oracle Enterprise Manager (OEM) and setup of Oracle Grid Control.
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA) and a very good team player, self-motivated, dedicated in any work environment.
• Expertise in using Oracle streams, Golden Gate tool for data replication

PROFESSIONAL SKILLS

Operating Systems: Red Hat Linux RHEL 6.x,5.x,4.x,3.x,, HP-UX 10.x, 11.x, Oracle Linux, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, IBM and Windows 8/7/Vista/XP/2003/2000/NT.

Data Bases: Oracle 12c/11g/10g/9i/RAC /Non RAC, MS SQL Server 2008,2005,2003,2000, Microsoft Access.

Software Applications: Toad BMC,STATSPACK, ERWIN, IBM RSA, VERITAS Backup, File maker Pro.

Tools and Utilities: RMAN, OEM, CRS, Oracle Management Server, SQL*Loader, TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDM SQL Server, Export/Import, Oracle Golden Gate, Exadata, TOAD, Data pump, MS Access, Data Mapping, Data Guard, Golden Gate 10.4

Languages: SQL, PL/SQL, JSP, C#, C, C++, UNIX Shell Scripting, Perl.

Web Tools: HTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, Dorchester MA

Oracle DBA

Environment: Oracle 12c/11gR2/10g/9i, Sun Solaris, Unix, Ignite, Windows NT / 2000, Red Hat Linux, TOAD, RMAN, Exadata, SQL server, OEM12C, Grid Control, Data Guard, STATSPACK, ETL, AWR, Explain Plan

Responsibilities

• Involved in the installation of 11 g RAC and standalone server on LINUX environment.
• Administered Oracle 11g/10g production, test, development environment on RHEL, IBM-AIX.
• Involved in Migration of Database from 9i to 10g and applying patches whenever required.
• Production support for Oracle database cluster with databases running 2-3 and over 500 simultaneous connections and managed with over 2+ TB size databases, performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on need basis. Applying patches, deployments and upgrades, implementation of database backup/restore methodologies, RMAN, hot/cold backups, export/import user, Management User, Roles, database objects like tables, indexes, views, synonyms Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Upgraded Databases from 10g to 11g and Performed database cloning to setup test and development database. and Worked on tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Experienced with SRVCTL, OCR and Voting Disk of 10g/11gr2 RAC
• RAC Troubleshooting and Conducted sizing& capacity planning for Oracle databases.
• Create PL/SQL Stored Procedures, Triggers, Packages, Functions, Views and Materialized views and maintaining schemas and partitioning tables.
• Implemented the Security using ORACLE Database Vault.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Created table spaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.

Confidential CA

Oracle DBA

Environment: LINUX, 10g/11g R2 RAC, OEM, Toad, 10g Grid Control, Data pump, AWR, ADDM, Data guard, RMAN and PUTTY.

Responsibilities:

• Installation and configuration of Oracle 10g/11g servers and creation of databases in UNIX and Windows environments.
• Installing and configuring 10g/11g Real Application Clusters (RAC). Troubleshooting performance problems.
• Using OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, creation of users, schemas, Table spaces and other database objects.
• Establishing and monitoring database RMAN backups and export schemes (hot/cold).
• Implementing Oracle 11g Dataguard for high availability.
• Migrating and upgrading the Oracle 9i database to Oracle 10g/11g and incorporating the changes in the database design.
• Implemented Data Pump, Import and export techniques for Schema level export and imports.
• Implemented database level performance tuning using AWR, ADDM and Statspack.
• Installing Oracle applications on server and client machines, and developing Scripts for common Oracle tasks.
• Create PL/SQL Stored Procedures, Triggers, Packages, Functions, Views and Materialized views.
• Performing SQL*Loader jobs for loading data from text files.
• Database performance tuning using different methods.
• Creating and maintaining database links between different Oracle databases.

Confidential

Oracle Administrator

Environment: Oracle 10g with RAC, ORACLE 9i, Java, J2EE, SQL, PL/SQL, Toad, Pl/SQL Developer, Erwin, RHEL 4.2, HPUX, VMware, Windows 2003.

Responsibilities:

• Provided 24X7 supports for all the production and development databases.
• Installed and configured Oracle 10g.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.
• Applied patches using OPATCH and Patch sets using OUI
• Cloned/Refreshed Oracle Databases and Implemented Disaster Recovery plans
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Worked on several shell scripts to maintain the database activities
• Monitoring the Database Performance using automated scripts.
• Answerable for setting and managing User Accounts, Granting required privileges to users.Experienced in Security Administration and Space Management
• Perform other regular DBA activities including space management and performance monitoring.Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Dataguard, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.

Confidential

Oracle Administrator

Environment: Oracle 9i / 10g, OEM, RMAN, DBCA, Data Guard, Putty, XML, FTP, TOAD, UNIX, Solaris, Windows XP

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g databases includes Database cloning for test environment and applying patches, tuning etc.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Involved in Database migration from Oracle 9i RAC to Oracle 10g RAC from different servers.
• Backup and Recovery, Setting up and testing the backup and recovery strategies.
• Implemented different Partition methodologies to improve performance and manageability.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in administering Oracle database running on Unix and Windows Machines to support Oracle database.
• Involved in the installation of Oracle 10g on Windows NT and Linux.
• Performed various database refresh’s, patching, upgrading over the databases.
• Setting up and maintaining user accounts and profilesandmanagement of table space growth, monitoring data files additions, extent growth.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Oracle database administration on Windows platform.Monitoring of database for growth and performance and Setting up and maintaining user accounts and profiles.
• Coordinating with various QA, development and unix teams periodically in handling multiple projects.