ANURADHA SONARE

SENIOR ORACLE DATABASE ADMINISTRATOR

Email : acrjy8@r.postjobfree.com

Profile (Summary)

Over 18 years of experience in IT industry with 16 years+ of Oracle Database Administrator experience under different UNIX platforms like Solaris, Oracle Enterprise Linux, Red Hat Linux, Suse Linux, IBM AIX, HP-UX, Tru 64.

Oracle 11g/10g/9i Database Certified Professional, Oracle 11g/10g RAC Certified Expert and Oracle Exadata X3 & X4 Certified Expert from Oracle Corporation.

Experience on implementation of Exadata features – Smart Scan, Exadata Smart Fash Cache, Hybrid Columnar compression .

Experience with EXADATA Database Machine Half Rack and Quarter Rack with 4 Database Nodes & 7 Storage cell nodes using Infiniband Connectivity .

Experience in Patching EXADATA Database Machine .

Proficient in Exadata Backup and Recovery on ZFS Hardware Platform .

Proficient in configuration of ZFS Storage Appliance, VM Server for SPARC .

Experience of Oracle database 12c features .

Expertise in Oracle Database/RAC Administration, Architecture, Installation, Backup and Recovery, Database Security, Application Porting, Database Migration, Database Upgrade, Performance Tuning in Oracle 7/8.0/8i/9i/10g/11g.

Proficient in installation, configuration and managing Oracle GoldenGate Replication and documented procedures for it to be used by Operational DBAs .

Proficient in Oracle 10g/11g RAC Installation, Configuration, Troubleshooting and maintenance on ASM and Veritas Storage Foundation .

Proficient in installation, configuration and implementation of OEM 12c Grid Control.

Experience and Proficient in Oracle Performance Tuning using TKPROF, STATSPACK, AWR,ADDM, SQL Performance Analyzer, SQL Tuning Advisor, SQL Profile, OEM, Cloud Control, instance and session monitoring using custom SQL scripts.

Performed installation, configuration and testing/benchmarking of Oracle Database System using Swing bench tool.

Implemented and managed Disaster recovery solution using Oracle Data Guard.

Proficient in implementing MAA (Maximum Availability Architecture) solution using RAC, ASM and Data Guard .

Performed RMAN Backup and Recovery including Creation and Upgrade of RMAN Catalog, RMAN scripts creation and Troubleshooting RMAN Problems.

Performed General Database Administration activities like Database Creation, Space Management, Database Reorganization, SQL Statement Tuning, Database Troubleshooting, Data loading/unloading.

Designed, Implemented, maintained ETL Process for Data Warehousing Applications.

Experienced and Proficient in Veritas Net Backup Client Installation, Veritas Net Backup for Oracle Installation, Backup Configuration, Applying Net Backup Patches, Troubleshooting Net Backup and Tape Library Problems and configuring RAC High Availability resources on Veritas SFRAC.

Maintain and develop backup/recovery process for Oracle databases using BCV split, EMC SRDF .

Configured Oracle RMAN TDPO Backups and performed Oracle Database Cloning .

RMAN Backup and Recovery using Legato Networker Module .

Experience in Oracle Replication (snapshots/materialized views) .

Experience of Oracle Partitioning and Quest Products.

UNIX System Administration: Creating UNIX File-systems, users, LVM Management, Troubleshooting o/s errors, tuning kernel parameters, configuring peripherals.

Excellent Problem solving skills and ability to co-operatively work with teams in order to achieve goals.

Worked in Production, Test, Development databases and provided 24 x 7 Production DBA Support.

Technical Proficiency:

Hardware:

IBM X3650,Sun Sparc M5000, Sun T series, HP 9000 L class server with AUTO RAID, Digital Alpha Server 1200

Operating System:

Red Hat Linux, Oracle Linux, Suse Linux, Sun Solaris 8.0/9.0/10.0/11, HP-UX 11.0/10.2/9.x, IBM AIX 5L, Digital Unix

RDBMS:

Oracle 12c,11g,10g, 9i, 8i, 8.x, 7.x (SQL, PL/SQL).

Oracle Utilities:

AWR, ADDM,Data Pump Export/Import, TKPROF, OEM, SQL Tuning Advisor, SQL Performance Analyzer, Statspack,SQLTXPLAIN,SQL Profile, Grid Control,SQL Developer, ADRCI,OS Watcher, SQL*Loader, Oracle GoldenGate

Oracle RAC/Exadata Utilities

SRVCTL, ASMCA, ASMCMD, CVU, CRSCTL,OCRDUMP, OCRCONFIG, RACCheck, Exachk, CELLCLI, DCLI, Diagcollection.pl, OIFCFG, ACFSUTIL, Cluster Health Monitor

Backup Tools:

Snap management utility, ZFS snapshot,replication, cloning, Veritas NetBackup, cloning, TDP for Oracle, User-Managed Backup, RMAN, Net Vault.

UNIX Utilities:

Service Management FacilitySAM, SAR, TOP, IOSTAT, VMSTAT, SMIT, TOPAS,PRSTAT, AWK.

Performance Monitoring Tools :

OEM Cloud Control, DTRACE Analytics, SQL Developer, DBArtisan, GRID Control, Quest Products like TOAD for Oracle, BMC Patrol, Swing bench

Data Modeling Tools:

Erwin, Visio 2000

Project Experience:

iConectiv/Ericsson (www.iconectiv.com)

Period : March ‘2014 – Current

Sr. Oracle Engineer DBA

Responsibilities as Senior Oracle Engineer DBA:

Perform installation, configuration and Patching of OEM 12c Grid Control.

Extensive knowledge and understanding of OEM monitoring metrics, interpreting, troubleshooting, and providing recommendations to DBAs for resolving database issues .

Experience with managing multiple OEM groups and templates, OEM 12c job system.

Installed and configured hardware partitioning technology using Oracle VM Manager for SPARC on Sun SPARC T5-2 machine .

Built Oracle 12c RAC on LDOMs with multi-tenant architecture.

Work with Oracle support to design and build standards for ZFS Storage Appliance as a shared storage for Oracle database and backups.

Recommend backup and recovery standards using ZFS Snapshot/Cloning and Replication features.

Recommend and write Oracle Best Practices document for installation, upgrades of database systems.

Install, Configure and manage critical Oracle 11g RAC Cluster and testing RAC Resilience for Number Portability project .

Provide recommendations on configuring/troubleshooting Real Application Cluster databases, implementing best practices to infrastructure/Operational DBAs.

Configure and build GoldenGate Replication .

Performance tuning and monitoring Oracle GoldenGate using OEM and Heartbeat tables.

Installation and Configuration of Swingbench tool, running load test/benchmarking and analyzing performance.

Perform backup/recovery using RMAN, export/import and recommend backup/recovery procedures to operational DBA

Configure and manage Oracle 11g Data Guard.

Implemented Oracle 12c new features.

Awarded as the Most Valuable Person (MVP) for excellent services provided for managing and engineering Database Solutions .

Environment: Oracle 12c R1, Oracle 11G R2, OEL/Red Hat Linux,ASMCA, ASMCMD, SRVCTL, CRSCTL,Oracle 12c Grid, SQL Performance Analyzer,SQL Tuning Advisor,SQL Profile,AWR, ADDM, ASH, TKPROF, STATSPACK,SQLTXPLAIN, Erwin, UNIX SHELL SCRIPTS,Data Pump Exp/Imp,ADRCI,RMAN, SQL*Plus, Oracle 11g Scheduler, SQL Developer.

HSBC Bank, NY (www.hsbc.com)

Period : April ‘2008 – March’2014

VP/Sr. Lead Oracle DBA Engineer

Responsibilities as Senior Lead Oracle DBA Engineer :

Promote Best Practices and recommendations for High Availablity configuration and applying cluster patches.

Performing DBA Engineering tasks for architecture and design of high availability solutions, developing database standards and best practices for database monitoring and maintenance solutions to maximize availability.

Implement Maximum Availability Architecture solution for tier 0 system using Oracle 11g RAC/ASM and Active Data Guard. Also, High Availability solution for tier 1 systems using Oracle 10g RAC and Veritas Storage Foundation and SRDF for Disaster Recovery solution.

Perform database migration from Oracle 10g to 11g and promote Oracle 11g new features .

Working closely with database vendors, infrastructure groups, other DBAs, and application teams to proactively develop strategic Database Solutions, standardized DBMS deployment bundles, automation tools/scripts, best practices etc.

Provided consultation to application teams on design issues, optimizing code and guiding on Application High Availability solutions.

Mentoring and training other database administrators, managing task assignments for other database administrators, reviewing work and providing input to Management.

Supporting FX trading business critical high availability databases.

Installation and configuration of 3 node Oracle 11g RAC/ASM on Red Hat Linux and 2 node Oracle 10g RAC/SFRAC on Sun Solaris.

Worked on Database Security by setting up native auditing, User/Password Management, setting profiles, parameter configuration, applying security patches.

Expertise in AWR,ADDM, ASH, SQL Profile, Statspack,TKPROF, wait-event analysis, Optimizer stats and Explain plan analysis.

Installing OEM 12c client and database administration using 12c Cloud Control .

Providing 24x7 on call Production DBA support.

Troubleshooting complex RAC database performance and database availability issues and working with Database vendors and various infrastructure teams to resolve issues.

Backup and Recovery using RMAN, Datapump Export and Import, Data Recovery Advisor, Flashback database.

Installed, configured and maintained Oracle GoldenGate Replication and performed technical lead role in POC of Oracle GoldenGate and documented procedures for Installation, Testing, Use Cases and Roles/Responsibilities of operational DBA.

Responsibilities as Exadata Database Machine Administrator

Hands on Experience with implementation of ORACLE EXADATA DATABASE MACHINES (X3 Box)

Experience with Exadata Flash Cache, GRID DISK, CELL DISK, ILOM.

Experience in Patching / Upgrading EXADATA Database MACHINE (RDBMS / Grid infrastructure & Storage cells).

Implemented 10GE Interface for RMAN backups to Netbackup Media Server and Dataguard Transportation for higher bandwidth and speed.

Implemented ASR to trap alerts from the database machine to send an alert to oracle support and OEM 12c Ops Center.

Worked Closely with Oracle Platinum Support and Oracle Advance Customer Support Teams in maintaining the environment.

Experience in managing SUN ORACLE EXADATA using command line utilities such as CELLCLI & DCLI.

Worked on Exadata Hybrid Columnar Compression, Storage Indexes, Flash Cache and Flash Logs.

Installed Exadata Plugins for Storage Cells, PDU, ILOM, KVM Switch and integrated Exadata Environment with OEM 12c cloud control .

Troubleshooting Exadata Environment using EXACHK, SUNDIAG, IPMI, DIAGCOLLECTION.PL, SQLTXTRACT and OSWATCHER Tools.

Modified default users password to implement strong one for root, grid, oracle, celladmin, cellmonitor, nm2user.

Troubleshooting Backups External to the Database Machine with Netbackup.

Implemented Cell offloading on EXADATA to push the sql’s to the storage and thus improving the I/O performance on the queries.

Hands on experience with storing the hot blocks / hot objects in flash cache in order to achieve performance through memory instead of disk I/O.

Experience in patching RAC databases in rolling fashion to maintain high availability.

Performed Oracle database machine administration of Oracle Exadata database machine and cell using OEM, CELLCI, DCLI utility .

Performed tuning using Exadata Smart Scan, Health checks and wait event monitoring .

Bank of America Merrill Lynch, NY (www.bankofamerica.com)

Period : Mar ‘2007 – Mar ’2008

Sr. Oracle DBA

Responsibilities as Senior Oracle DBA:

Installed and configured various versions of Oracle (9i,10G) on Sun Solaris 10 and Oracle 10g on Red Hat Linux Release 4.

Performed Database Migration from Oracle 10G on Sun Solaris to Oracle 10G on Red Hat Linux AS Release 4.

Implemented 2 node Oracle 10g RAC on ASM and Data Guard for Maximum Availability solution.

Providing primary Oracle DBA service, database architecture and design.

Extensively worked in capacity planning, logical database design and physical database design.

Performing backup and recovery using RMAN, Flashback database and Legata Networker Module .

Conducted partition and storage management for efficient use of space.

Proactively monitoring and fine tuned End Of Day (EOD) batch jobs for data uploading in warehouse by implementing parallel feature.

Automated database maintenance jobs using AUTOSYS .

Performed database monitoring using Precise/Indepth for Oracle, BMC Patrol, TOAD for Oracle,Teamquest for Oracle etc.

Implemented Oracle 10G new features (ADDM, SQL Tuning Advisor, Oracle 10G Scheduler, RMAN compressed backups, Online segment Organization etc.) .

Performed backup and recovery using RMAN and Tivoli Storage Manager (TSM).

Providing on-call 24x7 production DBA support.

Environment: Oracle 10G R2,Sun Solaris, Red Hat Linux AS Release 4, SRVCTL, CRSCTL, TOAD for Oracle, Oracle 10G Grid, SQL Tuning Advisor, Erwin, UNIX SHELL SCRIPTS, Imp, Exp, SQL, SQL*Plus, TKPROF, STATSPACK, AWR, Oracle 10g Scheduler, Autosys, SQL Tuning Advisor, Teamquest for Oracle, BMC Patrol,Precise/Indepth for Oracle .

BROWN BROTHERS HARRIMAN, Jersey City, NJ ( http://www.bbh.com/)

Period : Mar ’ 2006- Feb ‘2007

Sr. Oracle DBA

Responsibilities as Sr. Oracle DBA:

Installed, upgraded and maintained Oracle software products/versions for RDBMS .

Upgraded Oracle Database from 9.2.0.4 to 9.2.0.6 and from Oracle 10.2.0.2 to Oracle 102.0.3

Set up, testing and implementation of backup/recovery strategies using RMAN and TDPO for Oracle on Oracle 9.2.0.6 .

Proficient in database monitoring and performance tuning using Embarcadero DBArtisan 8.1, TOAD for Oracle Expert Edition, OEM (Oracle Enterprise Manager).

Performed installation, configuration and tuning of Oracle 10g data base software for Autosys.

Performed installation of Autosys 4.5 software and troubleshooting Autosys errors.

Implemented database security and management of role-based security.

Databases recovery using RMAN, Cold Backup and Export/Import.

Performed Database Cloning using RMAN and TDPO. Troubleshooting RMAN backup errors.

Performing day-to-day database administration tasks like checking alert log, trace files, monitoring disk usage, analyze jobs, database backup logs.

Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle

corporation and installation of patches .

Write and modify UNIX shell scripts to manage Oracle environment .

Implemented database security by setting up listener password and managing roles. Implemented database auditing by using custom scripts and implemented purge and archive strategy.

Assisted developers with SQL questions, including the areas of functionality and performance .

Production support for Oracle running on UNIX and experience in Materialized Views tuning.

Analyzing performance problems using Oracle 10g Wait Interface, ADDM recommendations, ASH .

On-Call 24x7 DBA support for production databases in US and Europe.

Environment: Oracle 10G R2,Oracle 9i, Sun Solaris, IBM AIX,Suse-linux, Tivoli Storage Manager, Embarcadero DBArtisian 8.1, TOAD for Oracle, SQL*Loader, OEM, ADDM, SQL Tuning Advisor, Oracle 10G GRID, Erwin, UNIX SHELL SCRIPTS, Unix and Oracle Utilities i.e Tkprof,Statspack, Utlbstat/Utlestat, Packages, Procedures,Triggers, Functions.

Adelphia Communications/Time Warner Cable ( IT Department, Coudersport. PA USA).

Period : February ‘2005 – Feb 2006

Sr. Oracle DBA

Responsibilities as Oracle DBA:

Performed oracle database administration in Test, Development and Production 24x7 environment.

Installed Oracle 10G on IBM AIX and implementing oracle 10G new features. Database upgraded from Oracle 9i to Oracle 10G and latest patch installations on IBM AIX.

Tuned SQL queries on oracle 10G using ADDM, SQL Tuning Advisor etc.Troubleshooting database errors on 10G. Scheduled and monitored jobs using Oracle 10G scheduler. Performed and Optimized data loads using Sql*Loader .

Performed installation, configuration of net vault 7.4 for 10G database backups on IBM AIX 5L and performed backup and recovery of Oracle 10G databases using Net Vault.

Performed remote oracle 9i Server Installation, Oracle Client Installation and applying latest patches.

Performed Oracle Database Migration from Oracle 8.1.7 to Oracle 9.2.0.4. Upgraded database from Oracle 9.0.1.4 to Oracle 9.2.0.7 and implemented Oracle database security for financial databases.

Worked on scheduling data transformation (DTS) jobs from SQL Server database to Oracle databases for Export/Import of data from SQL*Server 2000 to Oracle.

Worked on planning and implementing security policies as per SOX Compliance standards of oracle databases, and also installed Oracle security patch. Involved in user training and technical documentation.

Performed Backup and Recovery of oracle databases using RMAN and Veritas Net Backup 3.4 and refreshing data from production to staging database using RMAN. Worked on creating, upgrading and troubleshooting of RMAN Catalog.

Performed installation of Veritas Net Backup 3.4 client, installation of Veritas Net Backup 3.4 for Oracle on UNIX and Database Backup configuration using Veritas Net Backup 3.4. Performed RMAN troubleshooting, Veritas net backup and ATL P1000 Tape library and swapping Tapes in Robotic Tape Library ATL P1000.

Nominated for the Praise Patrol Prize Package at Adelphia Communications, Coudersport PA and honoured as the Best Oracle DBA for the Star Quality of Urgency.

Environment: Oracle 10G,Oracle 9i, Sun Solaris,IBM AIX, Veritas Net Backup, Net Vault, SQL*Loader, OEM, SQL*Navigator, ADDM, SQL Tuning Advisor, Oracle 10G GRID, Visio 2000, PL/SQL Developer

Nicholas Piramal India Limited, Mumbai, India. (www.nicholaspiramal.com)

Period : June ’2001 – Jan’ 2005

Oracle DBA

Responsibilities as Oracle DBA:

Performed installation, configuration, performance tuning and upgrades of Oracle 9i/8i on Unix.

Implemented and maintained Physical Standby Database/Data Guard on Oracle 9i.

Maintained 2-node RAC on Oracle 9i on Sun Solaris using Veritas Cluster .

Automated Data Loads using shell scripts.

Coded shell script for taking physical and logical back up of the production database and implemented the scripts in Unix CRON scheduler to automate the database backup.

Performed research, root cause analysis, and continuous investigation to identify deadlock and locking issues and resolved issues on production database.

Provided on-call DBA support in 24x7 Production environment.

Prepared work plans to monitor database status for checking buffer cache hit ratio, library cache get hit ratio, dictionary cache ratio and wait event statistics and monitor data file’s disk activity (physical read writes and block read writes).

Created Clone database for Test/Development database using RMAN.

Environment: Oracle 9i, Oracle 8i, Solaris 8/9, SQL*Loader, UNIX SHELL SCRIPTS, Imp, Exp, SQL, SQL*Plus, TKPROF, STATSPACK, UTLBSTAT /UTLESTAT, Packages, DATABASE PROCEDURES,DATABASE TRIGGERS, Functions, PL/SQL .

Mahanagar Telephone Nigam Ltd. (MTNL) Mumbai, India ( http://mumbai.mtnl.net.in)

Period : June’1997 – May’ 2001

Oracle DBA

Responsibilities as Oracle DBA:

Installation, configuration, and administration of Oracle 8.x/7.x on Unix

Designing physical and logical database layouts, Creating new database, database migration from lower version to higher version.

Refreshing development, testing and QA environments with the data from Production Environment.

Co-ordinating with vendors, users and Project teams for Implementation of changes.

Knowledge Sharing across the team and documenting unique/new issues.

Establish, maintain and test backup and recovery policies and procedures using user managed and RMAN.

Configuring shared memory segments and semaphore Kernel parameters in Unix.

Creation of schema, granting of roles and privileges to the users. Creating user profiles and roles as per the access level of user for the data and application security.

Performing database backup and recovery using user managed backup and using RMAN.

Providing backend support for the developers for stored procedures, functions, SQL statements tuning and optimization.

Monitored the performance and made performance improvement recommendations and fixed issues.

Unix system administration, unix shell Programming to develop menu driven script to do database administration and automated job creation and scheduling – using cron.

Involved in Conversion of FRS (Fault Reporting) System developed using Forms*3.0 and Proc*C on Oracle 7.0 into Forms 4.5,Pro*C 2.0 On Oracle 8.0 under Unix.

Worked on Y2K compliance of racle 7.1 by carrying out necessary changes and written a program documentation for Y2K Compliance of Oracle 7.1 and application software.

Performed Database Tuning, Application Tuning, Performance Tuning and monitoring alert.log file, trace file, checking free space on tablespace and percentage of free space on each file system.

Monitored and maintained database batch jobs.

Environment: Oracle Oracle 8.0,Oracle 7.3,HP-UX 10.x/9.x, Sun Solaris, SQL*Loader, UNIX SHELL SCRIPTS, Unix Utilities like: RSH,RCP,FTP,TOP, VMSTAT, IOSTAT, SAR, REMSH, Imp, Exp, SQL, SQL*Plus, TKPROF, STATSPACK, UTLBSTAT /UTLESTAT, Packages, DATABASE PROCEDURES,DATABASE TRIGGERS, Functions,PL/SQL .

Hindustan Lever Limited, Mumbai, India .( www.hll.com)

(Period: April 1994 - June 1997)

Role: As a DBA/System Administrator

Job Responsibilities:-

Database Architecture design, creation and Database support.

Installed, configured and managed Oracle 7.1 and Oracle 7.3 .

Performed Database Migration from Oracle 7.1 to Oracle 7.3 .

Performed User Managed Backup and Recovery.

Performed Database Tuning and troubleshooting.

Performed Network configuration for client server architecture.

Carried out detailed database Capacity Planning and Database expansion planning for future utilization.

Performed Data Loads using SQL*Loader and Export/Import for database backups .

Written PL/SQL Stored Procedures, functions, triggers to support application functionalities.

Documented DBA procedures and standards.

Performed System Administration activities like: - file-system creation and maintenance, User and System Level Security, Monitoring System Performance, Troubleshooting Unix, network.

Written UNIX shell scripts to administer database, system and network performance.

Environment: Oracle 7.1, Oracle 7.3, Digital Aplha Server,HP-UX,SQL, PL/SQL, SQL*Loader, IMPORT, EXPORT, DATABASE PROCEDURES, D2K. Unix Utilities like: IOSTAT, REMSH, TAR, CPIO.

Educational Qualification:

MCA /MS in Computer Science, First Class from Indira Gandhi National Open University, New Delhi, India.

B.Sc. (Physics)/ (BS) First Class from University of Mumbai (Topper from Jai Hind College, Mumbai) India.

Professional Training/Course:

Oracle Exadata Database Machine Administraiton from Xduce, US .

Oracle 11g RAC and Grid Infrastructure from Oracle Corporation of India Ltd, Mumbai, India

Oracle 9i DBA (Backup recovery) from Sql Star International Ltd, Mumbai, India .

Oracle 9i DBA training (Architecture, Backup and recovery, Networking) from Oracle Corporation of India Ltd, Mumbai, India

Oracle 9i DBA training from Oracle Corporation of India Ltd, Mumbai, India .

Digital Unix System Administration From Crompton Greaves Limited, Mumbai, India

Oracle 7.0 DBA from Oracle Corporation, New Delhi, India .

HP-UX (Ver 9.04) System Administration from HCL, Mumbai, India .

Oracle 7.0 from Syspro Software International Services Ltd, Mumbai, India .

Oracle 7.0 from NIC, Pune,India .

Contact this candidate