Oracle Data

SHRADDHA GOREGAONKAR

Senior Oracle DBA

Email Id: acy2gr@r.postjobfree.com /Mobile: +1-352-***-****

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 /12c 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 12c/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) and Data Warehouse

Planning, developing, deploying and supporting RAC/ASM environment for 10g/11g/12c versions.

Implementation and support of 10g and 11g/12c

Migrations and upgrades from Oracle 9i and 10g databases,on HP-UX and Linux.

Hands on knowledge of RCA Preparation, Monitoring and managing database. Day-to-day activity like check all databases, check alert log for errors and report, Space management in data files

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, blocking, deadlock & also flash recovery area.

Installed and configured Oracle application server, web sphere 8, WebLogic, Apache, Tomcat, Jboss setup with multiple ports

Deployment of front end,back end components and check with the batch script

Strong interpersonal, time management and organizational skills

Excellent communication, training, presentation and persuasive skills.

Quick learner with a penchant to multi-task with ease

Self-motivator and team-player with ability to drive team and thereby projects to completion

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, 12c

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

EDUCATION

Bachelor of Engineering in Electronic Engineering

Mumbai University, Maharashtra, India

CERTIFICATIONS

Oracle Certified Professional (OCP) in 11g Database Administration

Oracle Certified Professional (OCP) in 10g Database Administration

Oracle Certified Associate (OCA) in 10g Database Administration

Structured Query Language (SQL) in 9i Database Administration

PROFESSIONAL EXPERIENCE

Client: Bank Of America, Jersey City, NJ Aug’15–Nov’16

Senior Oracle DBA

Description: Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. As of 2013, Bank of America is the twenty-first largest company in the United States by total revenue. In 2010, Forbes listed Bank of America as the third biggest company in the world.

Bank of America provides its products and services through operating 5,100 banking centers, 16,300 ATMs, call centers, and online and mobile banking platforms. Its Consumer Real Estate Services segment offers consumer real estate products comprising fixed and adjustable-rate first-lien mortgage loans for home purchase and refinancing needs, home equity lines of credit, and home equity loans.

Responsibilities:

Performed system analysis; provided DB2 & DB3 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).

Provide support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN, trace analysis, service creation, cluster and system management.

Configured and Installed new Oracle 12c database environment

Expertise in Oracle RAC and ASM administration/installation

Convert single node to RAC

Added nodes to RAC

Configured and implemented Oracle Standby databases (Data Guard) for higher Availability and Disaster recovery

Applying Critical Security Patches, PSU patches and One off patches to environment as on need and as per oracle recommendations.

Have knowledge of SQL server.

Extensive experience in Solution Design, Integration, Analysis, Development, Testing and post-production support for Oracle EBS Suite R12 version.

Working closely with application teams and supporting on various performance and configuration issues on day to day basis.

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, SQL*Loader,HP-UX 11.x, AIX 6.1, 5.1 and Redhat Linux 5.x, 4.x.

Client: American International Group, New York, NY July’14–July’15

Senior Oracle DBA

Description: American International Group, Inc. – also known as AIG – is an American multinational insurance corporation with more than 88 million customers in 130 countries. AIG companies employ over 64,000 people in 90 countries. The company operates through three businesses: AIG Property Casualty, AIG Life and Retirement and United Guaranty Corporation (UGC). AIG Property Casualty provides insurance products for commercial, institutional and individual customers. AIG Life and Retirement provides life insurance and retirement services in the United States. UGC focuses on mortgage guaranty insurance and mortgage insurance. AIG also focuses on global capital markets operations, direct investment and retained interests.

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 DB2 & DB3 production support depending upon the ticket assigned to meet the corresponding SLA’s

Monitored the system, Install and configure various Oracle DB objects

Server and various platforms like Linux, Sun, and Windows

Installed and configure web sphere, WebLogic, Oracle report server and manage environment database 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

Client: State Farm, New York, NY Jan’14–July’14

Senior Oracle DBA

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

Implementation of high availability solutions with Oracle 11g RAC, physical and logical standby database (Data Guard)

Installation, Configuration and administration of Oracle11g RAC Database for testing, development and production

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.

Client: VPI, Navi Mumbai, India Jan’12–Apr’13

Senior Oracle DBA

Description: VPI Industries Inc., is an American manufacturer of high-end phonographs, tonearms, and phonograph accessories.

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.

Client: Affin Bank, Kuala Lumpur, Malaysia Feb’10–Dec’11

Senior Oracle DBA

Description: Affin Bank Berhad (AFFINBANK) is a wholly owned subsidiary of Affin Holdings Berhad which is listed on the Bursa Malaysia. It commenced operations in January 2001 following a merger between the former Perwira Affin Bank Berhad and BSN Commercial (M) Berhad in August 2000. In June 2005, it merged with the former Affin-ACF Finance Berhad.

AFFINBANK provides a suite of financial products and services that is catered to both retail and corporate customers. The target business segments are categorized under key business units such as Business Banking, Consumer Banking and Treasury. Business Banking offers services in corporate banking, contract financing and trade finance to corporations, institutional clients and SMEs. Consumer Banking provides credit cards, personal loans, mortgages, savings/current and deposit taking services as well as hire purchase loans to individuals.

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

Client: Amerisure, Navi Mumbai, India May’09–June’10

Oracle DBA

Description: Amerisure is an insurance organization charged with creating exceptional value for its partners for success agencies’, employees and policy holders. For more than 100 years, Amerisure has worked tirelessly to make America’s workplaces safer. On September 12, 1912, the Michigan Manufacturers Association joined with a group of local manufacturers to form the Michigan Workmen’s compensation Mutual Insurance Company. Based on the mutual concept, the mission of this newly created partnership was to solve the problems of workmen’s Compensation, reduce accidents, exchange experience and maintain a high standard of service to employers and employees.

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

Client: Cypress, Navi Mumbai, India Jul’08–Sep’09

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

Contact this candidate