Support Data

PRAMOD MULLAPPULLI

Title: Senior Database Admin/Lead. Phone: 973-***-****

Email: **************@*****.***

Summary

Over 20 years of experience in Oracle Database and Administration/ Architect on VLDB production, development databases and expertise on HP-UX Administration.

More than 10 years experience in Oracle Team lead, project management.

Oracle RDBMS (7.x/8i/9i/10g/11g), 12c/ASM Installation and configuration on UNIX, Linux, Sun Solaris/Windows NT and AWS environment.

More than 3 year experience in MS SQL Server Administration, Configuration, performance tuning, client/server connectivity, and writing Stored Procedures in MS SQL Server v2000, v2008, v2012.

More than 2 year experience as Sybase DBA.

Configure, install and manage High availability Oracle Real Application Cluster (RAC) on Linux.

Experience in Aerospace ERP on Oracle E-Business Suite (EBS) and MRO environment.

2 year experience in supporting Cassandra database on Solaris and AWS environment.

Oracle Data guard setup and administration.

Oracle streams Master to Master replication setup, maintenance, monitor and administration.

CDC implementation support for data grid/IBM cloud env.

Good understanding about Oracle Goldengate software implementation and maintenance.

Extensive Data Modeling & Design (OLAP/OLTP) experience using Erwin 3.5, ER/Studio and Reflection-X.

Oracle Database and network tuning and SQL query tuning using AWR, ADDM, STATSPACK, trace, RDA, SQL execution plan reports, Toad, Enterprise Manager Tool utilities.

Logical and Physical Facts and Dimensional data modeling & design experience for Data warehouse application.

Strong analytical, technical and business skills in architecting and designing using ETL applications.

Support Oracle/Informatica upgrade.

Support on Oracle Data Integrator to transform data between environment.

Hybrid tuning technologies use data warehouse/Data mart application.

Experience with Backup and Disaster Recovery using export, data pump, RMAN and VERITAS NetBackup.

Backup implementation experience using ESP and Networker scheduler.

Expertise on Database upgrade from 7.x to 9i, 8i to 9i, 9i to 10g, 10g to 11g and to 12c.

Database migration experience from MySQL, Sybase 12.x, DB2 to Oracle and UNIX to Linux.

Cassandra database support on AWS and Solaris env..

Extensive shell (Korn, Born) programming experience.

Development experience with Oracle/Developer2000.

Expertise on SQL and PL/SQL programming.

Pioneer in working with PL/SQL including Procedures, Functions, Cursors and Triggers.

Supporting database-related Java interface layers, and heavily involved in general architectural design decisions for all major system components.

Expertise to implement Oracle advances security features and fine-grained access control.

Expertise to implement data encryption for financial and HRMS systems.

Extensive knowledge in Data Warehouse and Data Mart Design.

Quest shareplex monitoring and maintenance;

24X7 production database support on UNIX, Linux and Solaris environment.

Database audit implementation to monitor login, user activity.

Experience on database patch certification and installation.

Experienced in understanding and analyzing business requirements and working closely with various application teams and business teams to develop ETL procedures consistent across all applications and systems.

Experience in capacity planning and space management.

Database replication management using streams, RMAN and database mirroring.

Extensive knowledge of Oracle functionality & internals. Good consulting and communication skills, knowledge of client-relationship building techniques and project methodologies with good team building skills.

Experience on MySQL database server.

Working experience on HP-UX admin.

Patrol/Tivoli implementation to monitor database alerts.

Professional Skills:

Operating Systems: MS-DOS, Windows 95/98/NT/2000, Linux, UNIX (Tru64, HP-UX, SCO), Sun Solaris, AIX.

Hardware: HP 9000 Series, SUN E450/250, Optical Jukebox, HP SureStore, L20/L40/L80 Tape Libraries, HP Disk Array, Cisco routers and switches.

Databases: Oracle 7.x/8.x/8i/9i/10g/11g/12c, Cassandra, MS SQL Server 2000, 2008 and 2012, Sybase 10.x, 12.x, 15.x, MySQL, XML and DB2.

Languages: C, COBOL, VC++ (SDK, MFC), Pascal, SQL, PL/SQL, MYSQL, UNIX Shell scripting (Bourne, C, Korn, POSIX), Java (JSP, JDBC, Servlets), HTML, Visual Basic, VB.NET, Perl 4.0.

Packages: Microsoft Great Plains, VERITAS Netbackup Datacenter, FoxPro, Office 97, Netprowler 3.5.1, Symantec VelociRaptor Firewall 1.1., Microsoft Visio, MC/Service Guard, MS Project.

Front End GUIs: OBI, Developer 2000 5.0/4.5, Forms 3.0, and Reports 2.5, Visual FoxPro, Crystal Reports.

Middleware: Oracle Application Server (OAS), Apache Tomcat Version 5.0, HP Application Server, Weblogic, Websphere.

Database Admin Tools: OEM (Oracle Enterprise Manager), Keep tool, TOAD, RDA, OpsCenter, Wily

Backup & File Management: OCFS, VERITAS Cluster, VERITAS Volume Manger, VERITAS Database Editor, VERITAS Quick I/O, VxDBA

DB Other Tools: RMAN, Import/Export, Streams, Data pump, DBVerify, SQL*Loader, Datastage, Sync sort, Oracle data Integrator, Informatica, SQL*Plus, SQL Developer, TKProf, Auto trace, Tuning Scripts, ADDM, AWR, SVRMGRL, Net Manager and Stats pack Performance Monitoring tool, Aqua data studio.

Other Tools: Reflection-X, Erwin, VNC Server, ZIP Plus.

Professional Experience:

Client: Verizon Wireless, Warren, NJ, USA – Feb 2015 to Current.

Title: Senior Oracle/Cassandra DBA Lead.

• Project design/support for various applications.

• Configure/manage high availability Real Application Cluster on Solaris.

• Database software installation/maintenance on exadata storage servers.

• Oracle Shareplex configuration/support.

• Oracle 12c/ASM Installation and configuration on Sun Solaris servers.

• Oracle /Os patch installation and support.

• Performance tuning support for various applications.

• Database upgrade from 11g to 12c.

• Cassandra Database configure and support on Solaris servers.

Cassandra instance setup and support on Amazon Web Services cloud env.

Supporting data migration between environment using cloning Cassandra clusters.

Monitor Cassandra instances using DataStax OpsCenter and Wily setup.

Install and support Oracle DB on AWS.

• Shell programming for daily maintenance and pro-active monitoring.

• Database support for application releases.

* Support ETL solution using Oracle SQL Loader, DataStax Cassandra loader.

• Backup implementation/support using RMAN.

• Database cloning for QA support.

Cassandra data modelling support.

• EM installation/support.

• Oracle physical/active data guard installation and support.

Client: Wyndham Worldwide, Parsippany, NJ, USA – Nov 2013 to Feb, 2015.

Title: Senior Database Admin Lead.

Oracle Database Administration for production, QA and development databases.

Configure and manage High availability 2-node and 4-node Oracle 11g RAC implementation and maintenance on Linux/Solaris with ASM and non-ASM storage.

Install and create database on Oracle 12c for Development/QA testing.

Implement 12c OEM agent for monitoring purpose.

Database release design/SQL review.

Work with SME to troubleshoot and resolve database issues.

Work on database scrub process.

Performance tuning on Oracle database application.

Backup and restore using RMAN and SMU utility.

SQL/PL-SQL performance tuning.

Tablespace freespace maintenance on DATAMART database.

Data guard implementation and maintenance for multiple applications DB on Solaris and Linux environment.

Oracle Goldengate software implementation on new database.

Implement Goldengate table replication between multiple databases.

Monitor/troubleshoot and maintenance of Goldengate replication.

Database upgrade from 10g to 11gR1 and 11g to 12c.

Database migration from stand-alone environment to multi-node RAC on Linux.

Support Os/Database patching on Solaris and Linux environment.

Backup production database and restore after scrub process to development and QA environment using RMAN and Oracle SMU technology.

Co-ordinated for Informatica upgrade from V8.6.1 to 9.0.1 and 9.1.0.

Worked on Oracle Data Integrator to transform data between environment.

Experienced in Lead, Design and Develop the ETL processes for Data Warehouse systems.

Define and implement ETL development standards and procedures for data warehouse environment.

Installing and maintaining SQL Server 2012 database systems. Backup strategy implementation, resolving system issues, opening cases with technical support to resolve issues, monitor system availability, updating system documentation, system and database recovery, etc.

Working with SQL server development and systems teams to perform application and database tuning

Client: Verizon Wireless, Warren, NJ, USA – Feb 2011 to Nov 2013

Title: Senior Oracle DBA/Lead.

Data Modeling & Design (OLAP/OLTP) for ERP/ Data warehousing applications.

Oracle Database Administration for VLDB production and development databases.

Configure and manage High availability Oracle Real Application Cluster (RAC) on Linux and Solaris.

Oracle streams Master to Master replication setup, maintenance, monitor and administration.

SHAREPLEX configuration and maintenance for table replication between databases.

Database software installation/maintenance on exadata storage servers.

CDC data setup, maintenance and monitoring for data grid/IBM cloud support.

Oracle Shareplex configuration/support.

Oracle RDBMS (10g/11g)/ASM Installation and configuration on UNIX, Linux, Sun Solaris and Windows NT servers.

Oracle /Os patch installation and support.

Design ETL solution Data Warehouse application.

Hybrid Performance tuning data warehouse/Data mart application.

Database upgrade from lower versions to higher versions (10g to 11gR2).

Shell programming for daily maintenance and pro-active monitoring.

Database support for application releases, Data Integration/Data Distribution support.

Backup implementation/support using RMAN.

Database cloning for QA support.

SQL/PL-SQL performance tuning.

EM installation/support.

Oracle physical/active data guard installation and support.

Database replication using RMAN.

Enterprise release support and 24/7 on-call support.

Installing and maintaining SQL Server 2008 database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.

Working with SQL server development and systems teams to perform application and database tuning.

Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.

Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

Client: CGI, Lansing, MI, USA – June 2010 to Feb 2011

Title: Senior Oracle DBA/Architect.

Design and develop methodologies to migrate multiple development/production databases from Sybase to Oracle 11g.

DASD forecast for Oracle databases.

Oracle database performance and tuning.

Install oracle 11g software on UNIX servers for server and client support.

Create and support Oracle 11g databases to replicate Sybase schema objects to Oracle.

Support Sybase functionalities in Oracle using PL/SQL procedures, functions and triggers.

Oracle support for pro*C and COBOL program conversion from Sybase environment.

Install and configure ODBC software for client support.

Implemented data masking and data encryption for secure database support.

Implement backup/restore strategy using data pump, RMAN, flashback and other technologies.

Disaster recovery plan implementation for production database using Data guard.

Shell script to monitor database activities and day to day maintenance.

Client: UPS, Mahwah, NJ, USA – August 2006 – June 2010.

Title: Senior Oracle DBA/Architect.

Responsibilities

Supporting major UPS applications like Data warehousing, PRR, Infolib, DIR, Sales (ESP/ESTAT), IAS, Financial, ECM, E-Billing, SCS along with others and more than 300 production databases inside USA on different versions of UNIX, Linux, Solaris and Windows Operating System.

Oracle RAC implementation, monitoring and support.

Extensive Data Modeling & Design (OLAP/OLTP) experience using Erwin, ER/Studio.

Logical to Physical data modeling and design experience for data warehouse application.

Experience on data warehouse/Data mart application tuning.

IBM DataStage ETL tool experience to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

Experience on SQL Loader, External table, match & merge.

Experience on table/index partition maintenance.

Operational and production database support for data warehousing application.

Implement, maintain and troubleshoot master replication with oracle streams.

Shareplex Monitoring and maintenance.

Implement Grid based monitoring solution for database applications.

Transparent data encryption for critical data storage.

Requirement analysis, design and manage new projects.

Monitor, recommend and maintain SQL activity.

Tablespace freespace maintenance.

Implemented Oracle obfuscation Data Masking for sensitive information including financial & privacy information.

Implemented Advance fine-grained access control including Audit logging for monitoring.

Implemented row-level security mechanism on database.

Involved to implement oracle application modules.

Involved re-writing PL/SQL stored procedures to increase performance.

Supporting database-related Java interface layers, and heavily involved in general architectural design decisions for all major system components.

Implemented PL/SQL Procedures, packages and Triggers for database monitoring.

Implemented auditing to track database activities.

Database refresh from production using export/import, data pump and RMAN.

Configure and implement backup job using export, RMAN and ESP scheduler.

• Resolving critical technical problems affecting the whole production environment.

• 24X7 pager support for production databases.

• Database Performance evaluation and tuning using RDA, AWR, ADDM,

Query execution plan, SQL Profiles and OEM.

Monitor Streams with OEM, scripts, Patrol and Oracle streams commander.

Troubleshoot streams process.

Implemented label security for Oracle database support.

Apply streams related patches to the database.

Quest shareplex monitoring and maintenance;

Sybase database management.

Implement backup strategy for Sybase database.

Sybase database performance and tuning.

Database migration from Sybase to Oracle.

Implement and maintain replication between Financial and HR application databases and ECM, multiple SCS, ECM databases.

• Oracle data guard implementation, maintenance and support.

• Query review and suggestion for major application releases.

• Oracle database, security patch certification on different versions of Linux, UNIX and

Solaris OS and new hardware resources.

• New Oracle database Configuration based on requirement.

Install oracle database software for both database and client.

Database and ORACLE_HOME cloning.

• Install, recommend and support oracle database and Os patches and Library packages.

• Oracle database upgrade from lower version to higher version (9i to 10g, 10g to 11g).

• Backup testing and implementation on different OS/database versions.

• Written and implement many shell scripts to monitor, automate and day-to-day maintenance jobs.

• Implement and support disaster recovery and data protection solution using Oracle Data guard.

• Implement and monitor Database activity using oracle Auditing.

Configure Enterprise manager and OEM agents.

• Oracle database migration form UNIX to Linux.

• Sybase 12.x database migration to Oracle

• Db2 database migration to oracle.

• Preparing database manuals, application inventory documents and various database-element reports.

• Storage - space forecast for multiple projects and applications.

• Create and support on oracle service request for ultimate solution.

Patrol/Tivoli implementation to monitor database alerts.

Client: Facebook, Palo Alto, CA, USA - July 2006 – August 2006

Title: Senior Oracle DBA

Responsibilities

Coordinate to design and develop methodologies to migrate MYSQL to Oracle.

MYSQL data ETL using CSV engine, SQL Loader and Oracle external table utility.

Installed Oracle 10g software, created databases for maintenance and support.

Tablespace and schema support for Oracle databases.

Written and implemented PL/SQL cron jobs for database monitoring purpose.

Implemented transparent data encryption for user access.

Re-written PL/SQL stored procedures to increase performance.

Implement and maintain replication technology using streams.

Backup recovery implementation using RMAN.

Client: Asianet Communications Ltd., India January ‘2006 – May 2006’

Title: Senior Oracle DBA/Architect.

Responsibilities

Project requirement analysis and design.

OLTP Data Modeling & Design using Reflection-X.

Project database implementation and support.

Production Maintenance and database tuning.

Implemented transparent data encryption for user access.

Backup-recovery implementation using export/import and RMAN.

Implemented PL/SQL jobs for database monitoring.

Development and implementation of UNIX cron jobs.

Client: Airod sdn. bhd., Malaysia August ’2002 –January 2006’

Title: Senior Database Analyst.

Responsibilities

Experience of working with high availability Database group in Aerospace ERP and MRO environment.

Requirement analysis, designing and managing new projects.

Database performance tuning by collect statistics with Oracle Trace, STATSPACK utility.

Responsibility of monitoring production database (24x7).

Oracle 9i RAC implementation.

Experience of working with high availability Database group in Aerospace ERP on Oracle Ebusiness Suite (EBS) and MRO environment.

Patch, clone and backup maintenance for Oracle Ebusiness Suite application.

Expertise in ASM configuration

Application patch implementation in the production environment.

Expertise in designing Backup & Log archival policy with RMAN, export/import, hot/cold backup and writing scripts for their operation, handling the Block Corruption and recovery.

Managing Incremental, Cumulative and Full database backup using VERITAS NetBackup Data Centre.

Experience on Oracle streams replication between multiple oracle databases.

Implement, maintain and monitor streams for master replication between Oracle and MSSQL database.

Expertise in Oracle Advance Queuing.

Plan and implement (failover) high availability ORACLE standby database. Backup & recovery plans.

Experience of Configuring Physical/Logical Standby database

Supporting QA/Development database.

Planned and migrated Oracle database from version 7.34 to 9i.

Implemented many ETL data migrations for both legacy systems and for daily data production loads.

Outstanding problem solving abilities on various database issues and critical circumstances.

OLAP and OLTP Data Modeling & Design using Erwin 3.5, ER/Studio and Reflection-X.

Design and development experience in Data Warehouse and Data Mart.

Pioneer in working with PL/SQL including Procedures, Functions, Cursors, Triggers, Partitions, Packages, security access etc.

Java Authentication and Authorization services implemented for internet users on Supply chain/MRO and oracle E-Business Suited identity management.

Written many PL/SQL for Logistics and financial reporting purpose.

Implemented security features in database using Event triggers, Application context and Fine-grained access control.

Implemented many shell scripts and PL/SQL jobs for database monitoring and daily maintenance.

Implemented data masking and DBMS_CRYPTO options for data encryption for user access.

Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, backup/recovery and writing Stored Procedures in MS SQL Server v2000.

Responsible for investigating, project planning, recommending and implementing all new database technologies, develop IT Policies, Procedures and Manuals.

Expertise in HP/UX system administration.

Sybase database management.

Experience in Symantec VelociRaptor Firewall administration with Netprowler 3.5.1.

Client: Softex, Trivandrum, India January ’2001 –July 2002’

Title: Software Engineer.

Responsibilities

Installed oracle 8i on Linux machine and configured oracle parameters.

Installation and Configuration for Net8 connect to client.

Performed OEM setup on client machine to monitor production Database.

Created more stored procedure and packages for application.

Responsible for configuring JDBC and checking the connectivity in client server environment

Performed Multi-Threaded server Configuration

Configured Partitioning the Tables

Installed Web logic system and Configured to connect ORACLE server.

Implemented data encryption using DBMS_OBFUSCATION toolkit.

Used SQL* Loader to Migrate the DAT files.

Optimizing the SQL’s for maximum performance by using TKPROF and EXPLAINS PLAN.

Performance Tuning of the Production Database and Application Severs.

Experience on MySQL database server.

Managing Tablespaces, Online redo logs, Archive files and Data files.

Created Users Schema and Security Administration for the database Designed and developed all critical Stored Procedure, Functions and Packages.

Responsible for databases Backup/Recovery using Off-line and On-line Backups.

Monitoring the performance of Sessions, Users, and Tablespaces for the database using Oracle server Manager.

Client: Jash Technical Services Ltd., Saudi Arabia November ’1999 –December 2000’

Title: Programmer/Administrator.

Responsibilities

Requirement analysis, designing and managing new projects.

Database Designing and Normalization using Analysis case tools.

Standardizing data definitions across databases.

Independently configured the SQL*NET V2 at the Sever end as well as at the client end to setup the client server environment with developer /2000.

Performed the user requirement and trouble-shooting activities like create new users, daily backup connectivity issuers and tuning the SGA.

Tuning production databases and performance monitoring by using UTLBSTAT and UTLESTAT.

Managing Users, Profiles, Privileges and Rolls.

Implemented label security to access database information.

Implemented view based data masking for sensitive information.

Created Procedure, Functions, Trigger and Views.

Regular Backups (Different levels) & Recovery. Writing automated regular daily backup procedures.

Developed applications using Oracle/Developer 2000.

Administrated and developed applications using Wang COBOL system.

Client: Softpack Systems, Andheri, India April ’1998 –August 1999’

Title: Programmer/Customer Support Engineer.

Soft pack systems is a Business Group in India engaged in various manufacturing, trading & consulting activities. With a clear focus on identified industry domains and consistency of delivery, Softpack has carved a niche in the IT Solutions and Services Industry.

Responsibilities

Prepared of software requirement specifications.

Involved in the development, testing, and implementation of various modules using Forms 5.0 and Report 3.0.

Created primary database Objects - Tables, Views, Procedures, Functions, Packages and Indexes.

Enrolling Users and maintaining system Security.

Used SQL* Loader to Migrate the DAT files which were created from dbase Packages and Reorganized the data.

Monitoring and turning the application.

Backing up and restoring the database.

Performing regular HOT/COLD backups. Used different utilities like export import for on-line backup/restore.

Client: The Penguin Institute Of Computer People, India September ’1995 –March 1998’

Title: Programmer/Administrator.

Responsibilities

Requirement analysis, designing and leading new projects.

Created primary database Objects - Tables, Views, Procedures, Functions, Packages, and Indexes.

Tuning/Optimizing SQL statement using EXPLAIN PLAN utility.

Create databases, moving transaction logs, changing database ownership and dropping the database.

Security issue-permissions/access rights.

Written stored procedures for archiving data from production.

Performed all aspects of data and DB administration including, hardware and software evaluation.

Implementing the Backup strategy for the new database server, writing and automating scripts for compile and incremental backups.

Prepared the proposed system, process specification, Screen Layouts, Data Stores, and Report Formats.

Developed applications using Oracle/Developer 2000 and FoxPro.

Educational Qualification: Bachelor Degree in Computer Application.

Professional Certifications:

Diploma in Information and System Management from Aptech, India with Dos, WordStar, Lotus 1-2-3, Dbase IV & COBOL Programming.

Computer certificate in FoxPro, Ms Office from The Penguin Institute of Computer People, India.

Computer Certificate in UNIX & C from Bureau of Information Technology studies, India.

Computer Certificate in Oracle with Developer 2000 from Bureau of Information technology studies, India.

Computer Certificate in Visual programming and Network Os Administration from NIIT, India.

Computer Certificate in Java Programming and XML from Tandem InfoTech (P) Ltd., India.

Oracle 8i Enterprise DBA Certificate from SQL Star International Limited (Oracle Education Partner), India.

Oracle 10g: New Features for Administrators Certificate from Oracle India Pvt. Ltd., India.

PMP certification training from Technical Institute Of America.

Contact this candidate