Purush Mallela

732-***-****

Email: ad3mrl@r.postjobfree.com

Status: US Citizen

SUMMARY:

IT professional with over 19 years of industry experience. Functioned as a Lead Database Administrator / Architect, providing extensive support in the areas of design, development, enhancement, and the implementation of systems developed in ORACLE/SQL Server. Excellent interpersonal skills leading application development teams as well as DBA teams.

TECHNICAL SKILLS:

Software

ORACLE 19c/12c/11G/10G RAC, ASM, Oracle Exadata, Amazon Web Services (AWS),Oracle 12c/11g RAC, JIRA, Liquibase, Oracle RMAN, ORACLE 12C/13c Enterprise Manager (OEM) Grid Control, Database Console, Oracle Internet Directory, Oracle Advanced Replication,Oracle Streams 10G/11G, Oracle Golden Gate. Sharable 3.2/5.3, Oracle Data Guard, VERITAS Cluster Servers, EMC BCV SRDF, COGNOS 6, Informatics, SAS, ORACLE Developer 2000, SQL*Forms 2.3/3.0/4.5, database programming (PL/SQL, procedures, functions, packages, database triggers), SQL*Plus 3.1, Reports 2.5, SQL*Loader, SQL*Net, COBOL, C, Visual BASIC 5.0, Crystal Reports, shell programming (C shell, Bourne shell, AWK programming, corn),Perl programming, Java, HTML, ASP, SQL Server 2000. IBM IIDR replication.

Hardware/Operating Systems

Red Hat Linux 7.x/6.x, Sun Solaris 10, HP Superdome SD32000, HP9000 Series 800/700 Model I-70, HP UX 11.11,11.00,10.20, AIX 6L/5L,AIX on RS 6000 RISC, SunOS 10.x/5.x, Open VMS 7.x/6.2, Alpha, Pentium, IBM 386/486, Zenith Mini, DOS 6.22,Wipro Mini 286 Series, SCO*UNIX, Windows NT/2000, PC Anywhere

ENTERPRISE BACKUP: RMAN and Legato’s Storage Manager, Tivoli TDP, Netback up Ver5.x, TSM

Exadata : Exadata X3-2, X5-2

DBA Tools

Erwin/ERX 3.5/4.1, Data Modeling, Quest Central Software, Informatics Power center, DB Artisan 4.02, Prism CDC for ORACLE 3.0, BMC SqlBacktrack 3.2,3.3,3.4, Recovery Manager RMAN, Veritas Netbackup 5, Oracle Statspack,Quest Live Reorg, Oracle 12c/11g Grid Control, BMC PATROL, PRECISE, TOAD, QUEST, sar, vmstat, HP GlancePlus, Delphix, Oracle Data warehouse Builder 11g.

EDUCATION:

Masters in Computer Science

EXPERIENCE:

DELL Feb 2015 - present

Senior Oracle Database Administrator

Worked as Oracle Exadata Database administrator for VLDB systems . Responsible for following tasks

Install, configure and troubleshoot Oracle 19c/12c RAC databases.

Install and configure OEM 12c/13c to monitor databases and alert setup.

Creating Oracle database on Oracle Multi-Tenant Architecture.

Implemented Oracle Advanced Security - Created Oracle Wallet for user authentication logins.Uploading Wallets to an LDAP directory.

Managing Oracle Databases on AWS on EC2 and RDS services. Migrated Oracle databases from OnPrem to AWS RDS/EC2 Cloud environment with size of 300TB+ and 500+ instances.

Migrated Oracle databases from onPrem to Azure cloud.

Provision and Support Databases on AWS RDS cloud environment.

Install, configure and support Oracle Internet Directory (OID) for user authentication to Active Directory and Tnsnames resolution.

Install and Configure Oracle GoldenGate replication setup.

Monitor Golden gate replication sync and resolve conflict resolutions.

Managing Oracle Exadata servers X5-2 and X7 servers on Half RAC environment.

Supporting Oracle Exadata Cell Servers on 12c/19c version.

Applying patches on Exadata Cell and Database servers.

Working with Oracle Corporation support to do maintenance on Oracle Exadata server’s hardware.

Worked on extensively application tuning and SQL queries. Analyze and troubleshoot tune SQL queries for most optimal performance using OEM, Toad and SQL profiles.

Created SQL profile for bad execution plan SQL queries to use right plan all the time.

Tuning Oracle SQL queries adding indexes if SQL is not using proper indexes for better plan.

Oracle Exadata Database Machine - Migrating EDIFECS claim application from Oracle RAC databases to Oracle Exadata Database Machine for different clients.

Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating.

Setup,configure support Oracle standby databases on multiple locations using Oracle Data Guard and Active DataGuard in Oracle 19c/12c.

Implemented Disaster Recovery Solutions using Oracle Active Guard technology.

Upgrading Oracle 11g to 12c databases.

Resolving Oracle database performance tuning issues. Creating profiles to stabilize SQL plans.

Support and Monitor SQL server 2012 databases.

Scripting using Oracle SQL and PL/SQL languages.

EXPERIENCE:

Jennison Associates, New York November 2013 - Feb2015

Senior Lead Oracle/SQL Server DBA

Worked as Oracle Database administrator for Asset and Trading Company. Client manages $100 billion worth of assets for various clients and supporting live trading systems for various Trading applications, responsible for following tasks

Install, configure and troubleshoot Oracle 11G R2 RAC databases.

Install, configure and setup monitoring for Oracle 11G/12C grid control databases.

Oracle Exadata Database Machine Migrating databases to Oracle Exadata Database Machine for different clients.

Supporting Oracle/SQL server databases on AWS cloud environment.

Migrating standalone databases to AWS environment.

Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating.

Experience with cross platform Database Migration using Transportable tablespaces and Datapump, Migrating Oracle database from Solaris to Linux.

Plugging the tablespaces between different platforms using Cross platform transportable tablespace Utility. Migration of Databases from Oracle 10G HP/Sun to Oracle 11G R2 RAC Linux environments.

Setup,configure support Oracle standby databases on multiple locations.

Refreshing production databases to Virtual databases for testing using Delphix software.

Upgrading Oracle 10g to 11g R2 databases.

Applying Oracle Security PSU patches.

Migrated database from one data center to other using SRDF and Oracle data guard/backup restore.

Resolving Oracle database performance tuning issues.

Support and Monitor SQL server 2012 databases.

Applying development changes to Oracle/SQL server databases using MicroSoft TFS tool.

Federal Reserve Bank, New Jersey Sept 2012 to October 2013

As a Database administrator managing multiple Bank applications – Cash, Equity, Wealth management and Remedy database on Oracle 11g/10g RAC databases.

Installed, configured Oracle 11G RAC Release 2 databases on Sun/Linux/AIX environments.

Applying PSU/CPU patches and TNS Poison security fixes.

Worked with developer for database deployments.

Creating change control process thru Remedy for database changes.

RMAN backup setup/config thru TSM media.

Restoring database using RMAN utility from TSM Tape backups.

Setup, configure and monitor VCS clusters for Oracle Physical Standby databases on Oracle 11g databases.

Installed, configured Oracle 12c Grid Control for monitoring databases.

Environment : Oracle 11g/10g RAC, Oracle 11g Data Guard, EMC SRDF, Oracle 11g/12c OEM Grid, Redhat Linux, AIX, Solaris, Oracle ASM, Veritas Cluster Servers

UBS Financials, Jersey City, New Jersey Oct 2010 – Sept 2012

Sr. Lead Oracle Database Administrator/Database Engineer

As a Database administrator supporting UBS Trading,Prime Brokerage, Cash Equities and PeopleSoft ERP applications HRMS 9.2 on Oracle 11G RAC R2/R1 and 10G RAC.

Install configure Oracle RAC 11G R2/R1 and 10G on Linux/Sun/AIX with ASM storage.

Monitoring databases thru Oracle 11G/12c Grid control.

Define various migration Strategies and Migrate PeopleSoft databases from Oracle 10G to 11G Rel 2. Migrating database from one data center to other.

Monitor troubleshoots databases using Oracle 11g/10g Grid control.

Setup Backup/Recovery strategy thru RMAN, restoring database using RMAN restore/recovery process.

Troubleshoot performance issues in Production and development database.

Setup Oracle 11G physical Data Guard, EMC SRDF, VCS high availability for DR solutions. Switchover/failover of databases using DataGuard Broker, EMC BCV SRDF.

Monitoring and Sync up of Oracle Standby databases.

Implement Oracle Streams for Replication between RAC nodes. Troubleshoot various Streams conflict resolutions and data issues sync issues.

Implementing Databases changes (DDL’s), Releases thru Change management process.

Automate database jobs thru Autosys job schedule.

Preparing Unix Korn Shell scripts to maintain database jobs.

Involved in Data Center migration from New York to Richmond,VA

Environment : Oracle 11g/10g RAC, Oracle 11g Data Guard, EMC BCV SRDF, Oracle 11g/10g OEM Grid, Redhat Linux 5.x, AIX 5/6.x, Oracle ASM, Veritas Cluster Servers, Oracle 11g Streams, Oracle Internet Directory.

US Census Bureau, Dept. of Commerce,MD July 2009 – Sept 2010

Sr. Oracle Database Administrator/Database Engineer

As a Database administrator supporting PBOCS Census 2010 Project on 8 Node Oracle 11G RAC R2/R1 and 10G RAC.

Install configure Oracle RAC 11G R2/R1 on Linux with ASM storage.

Monitor troubleshoots databases using Oracle 11g Grid control.

Setup Backup/Recovery strategy thru RMAN.

Troubleshoot performance issues in Production and development database.

Setup Oracle 11G physical Data Guard solutions for DR solution.

Monitoring and Sync up of Oracle Standby databases.

Implement and Configure Oracle Streams Replication between 8 RAC nodes.

Troubleshoot Oracle streams performance issues by implementing Streams parameter settings.

Resolve Conflict Resolution in streams by implementing Rules.

Implemented Oracle Streams TAGs to exclude data replication.

Migrating Oracle databases from Oracle 10.x to Oracle 11G.

MERRILL LYNCH & Co. Feb2006 – June 2009

Sr. Oracle Database Administrator/Database Engineer

Responsibilities –

Currently supporting multiple Large mission critical Merrill Lynch Oracle database applications like Orchestria, Total Cost Ownership, GcaTs, NAS replication, Salesforce, MLR, trading applications etc.,

Implemented and Supporting Oracle 10g RAC databases on Multinode environment for Merrill Email Orchestria application using Oracle 10gR2 RAC on LINUX RedHat 4.0 using OCFS, ASM, EMC-SRDF, Veritas Cluser Server for high availability and Disaster Recovery(C&R).

Troubleshooting Oracle RAC environment issues on production databases, migrating Oracle RAC environment from Linux 4.0 to 5.0. Removing and adding nodes to RAC environment based on application and database load. Converting single node database to multinode RAC environment. Setting up multiple services to load balance and improving performance of RAC environment. Guideline application vendor and team to effectively write SQL queries to improve performance of RAC databases.

Upgraded Oracle RAC cluster ware components.

Upgraded Oracle 10g RAC database from OCFS filesystems to ASM storage.

Architect and created IBM MLR content management application and database on AIX UNIX servers.

Expert in Oracle database recovery using RMAN and Manual process.

Involved in Monthly Capacity plan meetings with Merrill Oracle Managed Services to estimate CPU, Storage and adding nodes to the cluster. Used TeamQuest to analysis of server capacity.

Implemented OMS migration project for all Merrill current service groups from current tier-1, tier-2 Dev, QA and Production, CNR environments to PA and Teleport Data Center. Provided timelines for the migration and prioritized the migration process.

Implemented Oracle Range and Hash Partitioning, Automate the partition drop and create process.

Created Materialized views to replicate data between databases.

Analyze and Reorg the databases to gain space and improve the performances of application.

Architect and Created Oracle Advanced replication synchronization process on 3 way replication process UK, EMEA, North America. Leading all regional DBA’s in Replication Environment.

Setup and supported Oracle 10g Streams.

Installed Oracle Software on Solaris, Linux, AIX and NT - Product installation Oracle 11g, 10g and 9i applied patches and upgrades.

Implemented Oracle physical Data Gurad for database high availability.

Migrated databases and application from Oracle 9i to 10g & 11g.

Troubleshoot and Tuned Database Performance for optimal I/O and memory.

Tuning and rewriting SQL queries for optimal performance issues. Fixing vendor application SQL queries for performance issues.

Worked extensively on Performance tuning which involved in Session tracing, Query tuning using Oracle 10g AWR, ADDM, ASH, SQL Tuning Advisor, SQL profiles.

Defined and Implemented Backup & Recovery using RMAN and Legato/TDP.

Provided 24 hour support to database operations and the Development community to ensure daily production business requirements are met.

Refreshing development and QA databases with Production data.

Involved Data Center Migration from 101 Hudson to PA location using SRDF.

Implemented Sarbanes Oxley audit and security procedures according to Merrill Complaint.

Planned the Database related to performance during access, backup and recovery procedures, archivelog mode, replication, nightly refresh, disaster recovery-Oracle Replication/Streams

Implemented logical and physcial Database Design – Created tablespaces, rollback segments and database objects, constraints, monitoring temp tablespace issues.

Automate DBA tasks using Oracle PL/SQL and UNIX shell scripts.

Involved in development team to implement ETL process on Data warehouse project.

Implemented Siebel CRM application on Oracle Database RAC servers.

Re-design some object tables objects in Siebel application for optimum performance.

Design/Architect Merrill RecordsNet Data warehouse project on Oracle 10g database.

Wrote PL/SQL Packages, Stored Procedures, Functions and Triggers for application releases like Total Cost Ownership, Orchestria, GCat etc.

Co-ordinate with development team to assist application code changes and implementing Oracle 10g features.

Implementing applications changes/releases on QA and Production databases.

Environment : Oracle 11g/10g/10g RAC/9i, Oracle 10g Data Guard, Oracle 10g OEM Grid, Redhat Linux 3.0/4.0/5.x, Sun Solaris, AIX, EMC-SRDF, Veritas Cluster Servers, Oracle Streams.

EXPERIENCE:

BRISTOL MYERS SQUIBB CO. Mar 2005 – Feb 2006

Oracle Database Administrator

Install and Configure Oracle Software 10g/9i/8i on HP-UX and RedHat Linux.

Install and configure Oracle 9i/10g RAC software on RedHat Linux and HP-UX servers.

Install and configuring Sybase Server ASE 12.5.

Backup and load, recovery of Sybase databases.

Implemented Auditing in all Sybase databases to audit sessions.

Setup,configure, support mission critical Oracle 9i/10G RAC databases on Redhat Linux 3.0.

Production & Application Development Database Support of Oracle 10gAS in HP-UX 11.11 environment with EMC Clustering.

Installation and Administration of Oracle 10gAS (Oracle Application Server), Apache Web Server . Deploying J2EE applications and Oracle Portal using DCM and Startup Shutdown of Application server components using OPMN (opmnctl and dcmctl), setting up DAD etc.

Implemented RMAN for One BMS Enterprise level with central catalog and to backup critical RAC databases.

Supporting HA databases on Oracle 9i RAC environment.

Troubleshoot different database problems and suggest alternate optimized solutions.

Setup and configure Oracle Stream

Setup and support Oracle 9i R2 Data Guard for SAP R/3 Physical/logical standby databases.

Upgrade SAP R/3, SAP BW Oracle database from Oracle 8i to 9i.

Upgraded SAP Business Warehouse database to SAP Unicode coversion.

Migrated multiple Oracle databases from 8i to 9i and 9i to 10g.

Maintain Oracle SAP R/3 database instances thru BRconnect/sapdba tools.

Refreshing SAP R/3 VLDB instances from production to test, dev instances.

Support, monitor and backup (RMAN) Oracle SAP R/3 instances and various other applications.

Applying Oracle patches on SAP R/3 database instances according to the SAP recommendations.

Leading multiple application developers teams as well as DBA teams.

Writing PL/SQL Packages, Stored Procedures, Functions and Triggers according to applications changes.

Automate Database as well as application tasks using UNIX shell and PL/SQL scripts.

Working with development teams to assist application code changes for optimal performance.

Performed query tuning using Oracle 10g AWR, ADDM, ASH, SQL Tuning Advisor, SQL profiles

Environment : Oracle 10g/9i/8i, Oracle 9i RAC, Oracle 9i Data Guard, SYBASE 12.5, Oracle 10g/9i OEM, Redhat Linux 2.1/2.4/3.0, HP-UX 11i, Sun Solaris

PFIZER, INC. November 2004 – February 2005

Oracle DBA

As a DBA administered Argus Safety application Oracle production, development and test databases.

Install and Configure Oracle 10g,9i,8i and its patches on HP-UX and Windows servers.

Created multiple Oracle instances for Argus Safety & Risk management application according FDA regulations.

Setup and Configure HA solution using Oracle physical standby database.

Recover standby database as and when required.

Monitor and troubleshoot database performance issues and user requests.

Refresh the development database with production database.

Monitor Oracle database space issues and design capacity plan for future growth.

JOHNSON & JOHNSON September 2000 – November 2004

Oracle DBA

As a DBA administered the Oracle production, development and test databases for various clients of NCS.

Responsibilities:

Install and configure ORACLE Software Versions 9i Rel 1 &2,8i(8.1.7.4,8.1.6) on HP Superdome, HP_UX B.11i, 11.00 and Sun Solaris, Windows NT,2000.

Lead and mentor different application developers teams as well as DBA teams.

Installing Oracle 9iAS as well as LDAP to setup and configure Oracle Internet Directory for Global database access.

Install,configure and support Oracle 9i RAC on test environment.

Setup and configure Standby databases. Supporting VLDB’s for big size OLTP applications.

Creating and configuring databases according OFA for production, testing and development for application like Documentum 4i, JDEdwards, Maximo MRO, Sales Force CRM, BMG Projx, Drug discovery, Remedy Picasso, SAP R/3, Oracle 11i Financial Applications and other Pharmaceutical applications.

Preparing different validation IQ/OQ documents to meet the FDA regulations for validated systems.

Setup and support Oracle Advanced replication for CRM Sales Force Application thru Master – Master groups with Johnson & Johnson, Dendrite and SAI companies to replicate data.

Setup and configure SharePlex replication from primary node to failover node.

Implementing Oracle backup/recovery strategy thru BMC SqlBacktrack ver 3.2,3,3,3,4 and RMAN catalogue.

Installing configuring VERITAS Netbackup ver4 agent for SqlBacktrack OBSI and RMAN to automate Oracle backups/restore process thru Veritas netbackup.

Migrating/upgrading databases from 8i(8.1.7) to 9i and 7.3.4 to 8.1.7.

Designing physical database capacity planning for future database growth and implementing database security policies.

Implementing e-Commerce Oracle Application database on high availability solutions using Veritias Cluter Servers.

Setup OEM for monitoring, tuning, scheduling jobs for nodes, databases thru OEM alerts with failover database instance.

Tune Oracle database using OEM as well as Statspack to analysis database health.

Monitoring production databases using OEM.

Setup Oracle Names server to distribute Oracle database instance services.

Supporting Drug discovery Oracle databases applications on Open VMS environment and migrating from Open VMS to Sun OS Unix environment

Setup,configure and support production, development, quality test database instances for JDEdwards OneWorld and JDEdwards APS for JDE Supply chain application.

Implementing benchmark solutions to test the performance tuning of the JDEdwards, CRM sales force applications.

Involved in writing PL/SQL Packages, Stored Procedures, Functions and Triggers.

Environment: ORACLE 10G/9i Rel 1,2/8.1.7.4/8.1.7.2/8.1.6/8.1.5/8.0.5/7.x on HP 9000 Series, HP_UX B.11.00, 10.20, Sun OS 5.x, Solaris 2.x, Windows NT/2000, Open VMS, Veritas Cluster Servers.

DENDRITE INTERNATIONAL, INC. July 2000 – September 2000

Oracle DBA

As a production DBA, administered the ORACLE production and development databases for Pfizer.

Responsibilities:

Installing ORACLE Software Release 2 (8.1.6) on HP_UX B.11.0.

Setting-up ORACLE Replication and replicating data using Prism CDC to the Pfizer master sites.

Creating databases for production and development according to OFA.

Monitoring production databases and tuning the ORACLE Server.

Performing back-up/recovery from EMC and Omni back-up.

Environment: ORACLE 8i/8.1.6/8.1.5/8.0.5 on HP 9000 Series, HP_UX B.11.00

BOWNE & CO., INC. February 1999 – June 2000

Oracle DBA

As a production DBA, administered the ORACLE database for Bowne Business Organizational Support System (BOSS), which includes modules such as Pricing, Page Track, Sales, Shop Floor, Time Card Adjustment, and Clipper Ship.

Responsibilities:

Installed database servers on UNIX/NT and created databases for testing, development, and production based on OFA recommendations.

Monitored 70 instances including 25 production databases for object growth, extents and tablespace, using the Monitor (MON) database.

Prepared a migration plan from ORACLE 7.x to 7.3.4/8.0/8.15.

Archived BOSS archived tables based on different partitioning options.

Designed and analyzed storage parameters, tablespaces, roll-back segments, and indexes for application.

Tuned the ORACLE database and BOSS application using various diagnostic tools.

Installed and configured SQL*Net 2.3.4 and Net 8.

Resolved on-line production application programs using tools such as OEM, DBArtisan, and SQL*Tuner.

Refreshed the databases for the development team to upgrade changes.

Developed PL/SQL scripts for database physical layout changes according to the business analyst requirements of the application.

Configured a multi-threaded server for production databases.

Set-up a symmetric replication environment to replicate data in a distributed environment.

Performed back-up and restore using EMC storage back-up utilities.

Developed and implemented database back-up and recovery procedures and disaster recovery.

Created shell scripts for the operation personnel to monitor, back-up, start-up and shut-down.

Rebuilt and estimated the cardinality of indexes as part of the production database tuning.

Created snapshots, snapshot logs, and refresh groups. Refreshed the snapshots on all instances of Bowne at specified intervals of time.

Major Achievements:

Migration of ORACLE 7.x to ORACLE 7.3.4 under the platform of VAX/Open VMS Alpha to UNIX AIX on RS6000 server for 30 different databases.

Migration of ORACLE 7.x to ORACLE 8.0.5 under the platform of UNIX AIX on RS 6000 server for all 45 databases.

Migrating databases from one physical layout to other physical layouts.

Installing and configuring the ORACLE database instances in a Y2K test environment.

Evaluating data for Y2K compliance.

Executing Y2K test plans/roll-out to verify Y2K compliance.

Developing PL/SQL and shell scripts for BOSS application integration with PeopleSoft accounts payable/receivable database.

Environment: ORACLE 7.x/8.0.5/8i (8.1.5) on UNIX AIX 4.3 RS6000 RISC, VAX/OpenVMS Alpha

GEMINI CONSULTING April 1997 – February 1999

Database Administrator

Responsibilities included installing a database on HP_UX/Windows NT, installing Siebel Marketing Software, performing the configuration of the database, creating a database, creating tablespaces, rolling back segments and data files, creating database users and roles on ORACLE 7.3, granting access to required information, performing SQL*Net set-up for remote clients, migrating the database from (ORACLE 7.0) an existing GMDKN marketing application on HP_UX to a Siebel application, performing data mapping conversion from GMDKN to Siebel, creating PL/SQL scripts for data mapping, database migration, back-up strategy, editing initialization parameter files, and tuning the database.

Responsibilities also included administering and configuring the database for the following Siebel modules:

Siebel Call Center

Siebel Marketing Enterprise

Siebel Remote

Siebel Sales Enterprise

Siebel Service Enterprise.

Environment: ORACLE 7.x/8.x on HP9000 Series, HP_UX 10.x (10.01), Windows NT

QUEST SYSCON INTERNATIONAL PVT. LTD February 1992 – March 1997

Database Administrator

Responsibilities included installing and administering the ORACLE database, designing and analyzing the space requirements for the installation of an ORACLE database, application development tools, creating the tablespaces, rolling back segments and data files, creating the primary objects (tables, views, indexes, sequences), creating database users and granting access to required information, analyzing the storage parameters for the installation of an ORACLE database, modifying the database structure per the application requirement, enrolling new users and providing system access, maintaining the system’s security, performing back-up and restore, connecting the two databases by creating database links using SQL*Net, tuning the database, upgrading and migrating the database.

Contact this candidate