SUMMARY

• Eight plus years of experience in Information Technology as Oracle Database Administrator and knowledge in Systems Analysis, Design, Development and Documentation at various levels
• Performed Oracle 8i/9i/10g/11g software and database installation and upgraded various versions
• Experience in administering and monitoring database using Oracle Enterprise Manager, TOAD and SQL Developer
• Data guard for disaster recovery, installation, configuration, migration, upgrade, cloning, patching and performance tuning
• Creation of Development, Integration Test and Production Oracle 11g/10g databases
• Experience in Performance Tuning such as tuning of memory, CPU, I/O distribution, shared memory segments using utilities like Explain Plan, Statspack, OEM, AWR, TKPROF
• Designed strategies for performing database backups and recovery
• Planning and scheduling the Physical (Cold/Hot) backups as well as Logical backups
• Knowledge of using RMAN for Backup and recovery
• Knowledge of Real Application Cluster (RAC)
• Planning, developing, deploying and supporting RAC/ASM environment for 12c, 11g and 10g versions.
• Experience in Add/removal of nodes in cluster environment.
• Experience in cluster ware and database upgrades from 10g to 11g and 12c.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Issues with block change tracking & also flash recovery area.
• Resolved/Diagnose Node Eviction.
• Knowledge on Apex, Websphere and WebLogic support.
• Strong interpersonal, time management and organizational skills.
• Proven team player with strong ability to multitask.
• 24x7 on - call Production support for database activities.

TECHNICAL SKILLS

Operating System: Windows 7/XP/2000, UNIX, Linux, Suse Linux, Red Hat Linux, Sun Solaris

RDBMS: Oracle 8i, 9iR2, 10gR1 & R2, 11gR1 & R2

Application Server: Oracle Application/Report Server 10g (9.0.4), 10.1.3, 10.1.2.0.2 , 11g, Web sphere, Web logic

Tuning Tool: TKPROF, EXPLAIN PLAN, AWR, ADD M

Backup Tool: Cold, Hot backup, RMAN, Import/Export

Tools: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader, TOAD, FILEZILLA, Putty, FTP, MS Office, MS Excel, MS Access, MS outlook, MS Power Point

Language: Having Knowledge of SQL, PL/SQL

Virtual Machine: VM Ware server 2.0 to 2.2, Oracle VM Virtual box 4.0

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Senior Oracle DBA

Responsibilities:

• Performed system analysis; provided Level 2 & Level 3 support and maintenance of the entire system
• Installing & configuring Oracle cluster ware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, de installation & clean-up of cluster ware).
• Applying Critical Security Patches, PSU patches and One off patches to environment as on need and as per oracle recommendations.
• Support on day-to- DBA actives.
• Working closely with application teams and supporting on various performance and configuration issues on day to day basis.
• Involved in the implementation of High Availability solutions Oracle 11g RAC with ASM.
• Created Shell scripts, SQL scripts and worked on various tasks such as explain plan, data log files processing, data import/export and automatic workload repository reports on UNIX platforms
• Responsible for configuration changes and created some conditions necessary for negative testing
• Identified, evaluated and prioritize customer problems and complaints and escalated the issues to the appropriate development/senior team with the investigated root cause
• Troubleshoot and followed up with the escalated ticket
• Supported new production releases and deployments
• Developed new jobs as per the requirement of the business in unix environment
• Monitored and checked the logs files for the file failures or successful processing in various environments
• Performed regular UAT/Prod health check, monitored the system and fixed if any issues
• Worked on installation, configuration of 11g database and report server setup and used Websphere 8 to deploy applications

Environment: Oracle server 11g, HP - UNIX, TOAD, SQL, PL/SQL, RMAN, ASM, Data Pump, RAC, SQL*Loader, HP-UX 11.x, AIX 6.1, 5.1 and Redhat Linux 5.x, 4.x.

Confidential, New York, NY

Senior Oracle DBA

Responsibilities:

• Performed systems analysis, design, develop, test and implement technology solutions
• Plan, install, configure and performs patching, upgrades of Oracle RDBMS software on various platforms. (AIX/WINDOWS)
• Modifying the database structures, as necessary, to accumulate application growth and maintain peak performance.
• Familiar with Import And Export Utilities
• Creating Primary database structures (Table spaces), altering according to the user requirements.
• Worked on various Databases Issues like table space, disk space etc
• Provided Level 2 and Level 3 production support depending upon the ticket assigned to meet the corresponding SLA’s
• Monitored the system, Install and configure various Oracle DB objects
• Worked on Oracle Application Server and various platforms like Linux, Sun, and Windows
• Installed and configure web sphere, WebLogic, Oracle report server and manage environment refreshment
• Worked on database backup cold/hot/export/import and troubleshoot various Server related issues
• Created, deleted, and renamed new databases, tables, columns and objects
• Supported Data enter migrations along with upgrades for huge databases.
• Maintenance of Development, Production, QA Test Databases.
• Modifying the database structures, as necessary, to accumulate application growth and maintain peak performance.

Environment: Oracle Server 10g/11g, HP - UNIX, Windows NT, SQL Loader, Toad

Confidential, New York, NY

Senior Oracle DBA

Responsibilities:

• Performed requirement gathering, design, development, testing, deployment and provided L2,L3 support to the entire application
• Worked on Queries related to database size, space related queries and database version
• Created Database objects like views, columns and tables as per requirement
• Developed functions, Stored Procedure and Triggers for Validation
• Created cluster and Non cluster indexes to improve the overall performance of the system
• Created SQL scripts to automate the manual process
• Created Database Users, Roles and manage Security issues
• Implemented effective database security practices and procedures
• Refreshed environment and took Database Backup cold/hot/export/import
• Troubleshoot issues on various applications, database and report server errors
• Worked on DBA activities like Adding/Deleting table spaces, data files, space management etc
• Granted and revoked read-only, update, insert, and delete access to Users

Environment: Oracle Server 10g, SQL Server, Data Guard, UNIX Shell Scripting, SUN SOLARIS 10, AIX 6.1, 5.1 and RHEL 5, 4.

Confidential

Senior Oracle DBA

Responsibilities:

• Planned and upgraded DB including patch updates (CPU/PSU), performance tuning using (AWR/ASH/ ADDM), managed Oracle partitioning, Materialized views, cross platform migration of Oracle from Solaris to Linux
• Production application migrations; database performance monitoring, tuning, and troubleshooting; database reorganization and defragmentation, physical database refresh and schema/table level refresh; database upgrades, apply patches, database; design, develop, and implement automated data backup and restoration procedures; Unix scripts to automate DB tasks, On call support.
• Maintained and setup streams for schema level propagation
• Applied patches of Oracle 10g Enterprise Edition on Sun Solaris UNIX server and windows NT/2008 server.
• Responsible for User Management and Role Management using SQL authentication.
• Configured and implemented Oracle Standby databases (Data Guard) for higher Availability and Disaster recovery.

Environment: Oracle 10g RAC/11g RAC, SQL, PL/SQL, RMAN, ASM, Data Pump, SQL*Loader, HP-UX 11.x, AIX 6.1, 5.1 and Redhat Linux 5.x, 4.x.

Confidential

Senior Oracle DBA

Responsibilities:

• Performed database maintenance activity, released database report on daily basis to send client
• Created new users, profiles and manage roles and privileges
• Performed sanity check daily on production and UAT
• Checked the growth of archived log files and table spaces
• Monitored the alerts and performed the necessary action on them
• Rebuild the index and analyzed the schema to improve the overall performance of the system
• Extracted/Migrated data from multiple applications, execute Insert, Delete Truncate, Select, Update operations on the Tables according to the requirement
• Designed the packages to support DML operations in production environment, tuned SQL statements using Cursors, Joins and Indexes
• Installed and configured web sphere 8. Jboss setup with multiple ports

Environment: Oracle Server 10g, HP - UNIX, SQL Loader, Toad

Confidential

Oracle DBA

Responsibilities:

• Performed data management for all Data Center controlled databases
• Controlled the platform's strategies for database performance, sizing, tuning, upgrades, security and high availability/failover
• Installed, configured, upgraded and patched Oracle10gR2/11g databases, Setup of report server 11g & JBoss application setup
• Installed, configured and upgraded Oracle server software and related products
• Granted read-only access to Users on servers through creation of read-only schema and synonyms
• Planned and implemented backup script daily
• Upgraded database from 10g to 11g
• Installed and configured Weblogic11g, Oracle AS, and report server on various platforms
• Performed application setup with SSL implementation and Jbatch batch setup

Environment: Oracle Server 10g/11g, HP - UNIX, Sun OS, SQL Loader, Toad, Windows 2000 Advanced server

Confidential

Jr. Oracle DBA

Responsibilities:

• Performed system analysis; provided Level 2 & Level 3 support
• Created Shell scripts, SQL scripts and to complete various tasks such as data log files processing, data import/export and reports on UNIX platforms
• Involved in configuration changes; created conditions necessary for negative testing
• Performed the necessary configuration changes, regular monitoring of system and fixed the issues if any
• Identified, evaluated and prioritized customer problems and complaints and escalated the issues to the appropriate development/senior team with the investigated root cause, trouble shoot, followed up with the escalated ticket
• Supported new production releases and deployments; developed new jobs as per the requirement of the business in Unix Environment
• Monitored and checked the logs files for the file failures or successful processing in various environments
• Installed and configured 11g database and report server setup

Environment: Oracle Server 11g, HP - UNIX, Windows 2000 Advanced server, SQL Loader, Toad