N a r e n d r a

Mobile: 408-***-****

acy3va@r.postjobfree.com

mailto:acy3va@r.postjobfree.com

Systems Technology and Database Applications Administrator lead

Relational Database Management Client/Server Architecture CRM Technology Technical Architect and Solution Business Requirements Analysis Business Process Transformation Methodologies Project Leadership On-Site and Off-Site Project Delivery Model

PROFESSIONAL SUMMARY

An accomplished and highly competitive professional bearing over 17 years of Computer Systems Engineering and related technology being applied to a variety of projects encompassing government, academic institution, construction industry, financing firm, software corporations, research and development manufacturing, semiconductor industry and general equipment engineering manufacturing. I am highly organized and able to work in between complex and fast-paced environments. I have adept knowledge in implementing technical architecting solutions using Oracle application suite and keen ability on providing cutting-edge solutions using the best industry practice. I am highly inclined on learning and developing new technologies to sustain progression.

TECHNOLOGY SUMMARY

Operating Systems HP UNIX, AIX, Linux, Sun Solaris 8 and Windows 2003, 2008,2008 R2 and 2012 Servers

Storage Devices HP Superdomes, ASM, EMC and IBM Fast-T

RDBMS Oracle 12c, Oracle 11GR2, Oracle 11GR1, Oracle9i, Oracle8i, 8.x, Oracle7.x,

MS SQL Server 2008 R2, 2012, 2014 and mongodb,

ERP Oracle Applications R12, 11.5.10.2, 11.0.2 & 11i (Installation, Upgrades, and migration)

Modules Advanced MRP, AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, MRP, WIP, BIS, FII, and iSupplier Workflow, WSC, MWA (Mobile Web Applications),

Oracle CC&B

Database Tools NOSQL, Oracle Enterprise Manager, SQL Developer, TOAD

Backup Tools Recovery Manager (RMAN), Manual backups

Data Modeling Tools MicroStrategy, Oracle ODI Oracle Designer 6i

Monitoring Tools Nagios, Oracle Enterprise manager and Crontab manual scripts

Languages Developer 6i, C, Shell Scripts, Oracle Workflow

Scheduling Tools Cronjobs, Oracle Enterprise Manager (Intelligent Tools)

CRM* Oracle (iStore, iPayment, iProcurement and iExpenses)

*Oracle proficiency includes installation, configuration and administration of Oracle Application 11i; cloning using rapid clone, autoconfig and adclone utility; well-versed skills in Rapid Install, AdPatch, Adadmin, Adsplice, Adlicmgr and Adcrtl utilities for Oracle applications; refreshing Oracle applications 11.0.2 environment, core database, 11i ebusiness and R12 instance; adhoc reports, Oracle application and Internet database administration on UNIX platforms; Oracle online/offline back-up and recovery principles; Oracle Server Utilities like SVRMGR, Export, Import, and SQL Loader

Web Servers 9iAS and Oracle Web Servers, web-logic Server,Apache tomcat and IIS

WORK EXPERIENCES

Wells Fargo San Francisco, CA

Sr. Oracle Database Administrator Consultant June 2016 – Present

As senior database administrator responsible for install and upgrading, performance tuning, support and following activities.

Experience of working with high availability Database ORACLE 11GR2 and 12C

Responsibility of monitoring production database (24x7) on-call support.

Experience of working with high availability Database using Oracle 11G RAC 12C database with ASM file system.

Upgrading 11GR2 database to 12C on RAC and NON RAC

Upgrading Oracle 11G and ODAC clients to 12C oracle and ODAC clients on windows servers.

Supporting patch implementation in the production environment.

Support NetBackup configuration with RMAN Backup

DBA activities to support various production and development databases.

Installed and Configured SQL Server 2012

Migrating databases, applications from sqlserver 2008 R2 to 2012

Applying cumulative updates.

Changing service account password in stand alone servers, clusters

Upgrading SQL Server from 2008 R2 to 2012 servers.

Monitoring Clusters and troubleshooting Cluster Issues, Performing failovers

Trouble Shooting performance issues and fixing them.

Performed T-SQL Scripts, Stored Procedures & Triggers

Modified powershell scripts to do refreshes of production databases to Dev and QA Environments

Configuring Mirroring, replication, log shipping, clustering setup between database servers/instances.

Monitoring MS SQL servers database backups.

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

Experience of Configuring Physical/Logical Standby database

Weekly patch implementation

Supporting production/QA/Development database

Provided On-Call 24/7 database support

Sanmina Corporation San Jose, CA

Oracle Database Administrator/Applications Database Administrator and Lead Feb 2006 – May 2016

I am serving as a team lead, senior database administrator and senior Oracle application database administrator responsible for the installations, upgrades, patches, TAR support, database tuning, concurrent manager administration, and cloning and Oracle application SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, script development, and documentation. Specific Oracle Applications modules installed include Advanced MRP, AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, MRP, WIP, BIS, FII, and iSupplier.

Documented and plan and executed Upgrades 9i RDBMS 9.2.0.5 to 9.2.0.8, 9i 9.2.0.8 to 11GR1 11.1.0.7, 11GR1 11.1.0.7 to 11GR2 11.2.0.3, 11.2.0.3 to 11.2.0.4

Installed and managed 12c database.

Install & configuring of Oracle 11gR2 RAC two-node on Linux with ASM.

Plan upgrade road map and perform upgrade of Databases from 11gR2 to 12c in RAC environment.

Implemented Database Mirroring for maintain a 'Hot Standby' for a critical operational database and also used the same as a mechanism for fault tolerance.

Installed and configured Oracle Customer Care and Billing applications

Supported and applied patches on CC&B database and applications.

Used SQL Server Management Studio (SSMS) for monitoring, troubleshooting and addressing SQL Server database related issues.

Solved issues related to server performance and disk space.

Resolved issues related to query optimization, database optimization and index tuning.

Resolved issues related to long running queries.

Developed RMAN Cold Backup Script to take backups automatically every week for about 50 databases vary in size from 400GB to 2TB and automated the process through crontab.

Documented and plan and executed Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.

Monitor Databases Backups and Restore validity periodically, and Data refreshes from Production to Non-Production environment using RMAN Backups.

Performing Backup/Restore of all the Oracle databases using RMAN.

Plan and implement Dataguard Configurations for oracle database 11GR1 and 11GR2.

Planning and Configuring Physical Standby setups.

Exceptional background in analysis, design, implementation and testing of software applications and products.

Build Automation of Refresh/Cloning of Database and application process.

Documented and executed Upgrades 11i ebusiness suite from 11.5.9 to 11.5.10.2, and localization of 11i ebusiness suite from 11.5.8 to 11.5.10.2.

Install R12 ebusiness suite 12.1.1 with VCP and upgrade to 12.1.3 and upgrades VCP to 12.1.3.5.

Upgrades R12 ebusiness suite 12.1.3.5 VCP to 12.1.3.7 VCP .

Integrating weblogic server with R12 VCP and managing weblogic servers administration.

Installing and configuring MongoDB architecture in Development servers.

Also developed and implemented a Java script to report the health and metadata of a shard cluster on development mongoDB.

Troubleshooting and fixing issues nosql-java code developed by development team.

Configuring managed servers in weblogic server.

Cloning weblogic server from production to development and test servers.

Build scripts for monitoring weblogic managed servers memory usage.

Build scripts for monitoring weblogic managed servers, engine domain, and UI domain logs.

Build Automation of cloning process the weblogic server cloning.

Involved in all phases of project development life cycle.

Experience design, development, maintenance and production support MySql Server.

Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task.

Implemented best practices in structuring SQL queries, Debugging Unexpected SQL Results etc.

Developed and created the new database objects including Tables, Views, Index, Stored procedures, Functions and Advanced Queries.

Installing agile PLM 9.3.1.2 with oracle application server 10.1.3.5.

Managing and administrating agile PLM application and database.

Installing SQL Server 2012 and SQL server tools

Backup & Restores, Log shipping Maintenance

Provides 24/7 production databases and development databases support.

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports.

Tuned Sql queries using oracle performance adviser in OEM.

Building plsql packages, triggers for required applications.

Manages all application upgrades, migration and implementation involved in the use of 11i ebusiness suite.

Handles the maintenance and overall monitoring of all database functions related to 11i ebusiness suite

Contacting Oracle support for identifying and fixing issues.

Team player with excellent communication and problem solving skills.

Applied Materials Santa Clara, CA

Oracle Database Administrator/Applications Database Administrator Aug 2005 – Jan 2006

Environment: HP 9000 Superdome Server with HP-UX 11i, Sun Solaris with EMC Oracle Applications 11.0.2 and 11i, Oracle 8i & 9i

Installed Oracle 9i and applied patches on sun and hp servers, upgraded Oracle database from 8.0.5 to release 8i and 9i, and migrated concurrent managers to separate server

Monitored Oracle application 11.0.2 and 11i refreshed Oracle application environment on multi node

Managed assigned databases which including 6-production database, 14-development databases and Oracle Applications 11.0.2 and 11i

Interacted extensively with Oracle support onsite as well as through Metalink on working with Dual Data Center project migrating the production database to a new data center

Carried out setup and validation of sun servers for migration of application and database and validated all database links to other applications

Worked with development team in database performance issues and with systems administrators to setup storage requirements

Managed application of security changes to the databases to comply with SOX standards

Diodes Incorporated Los Angeles, CA

Oracle Applications Database Administrator Dec 2004 – Jul 2005

Environment: Oracle Apps 11.5.10 and Oracle 8i, 9i

Installed Oracle 8i and 9i, upgraded applications from 11.5.7 to 11.5.10

Migrated database from Oracle 8i to 9i

Cloned Oracle application environment using Rapid Clone and performed database refresh

Applied RDBMS patches using Opatch and used Oracle application tools for maintaining database and application such as adpatch, adadmin, adctrl, etc.

Created a number of database instances for development, testing and production

Managed the Concurrent Managers and its operations which includes starting, stopping the concurrent managers, re-scheduling requests, purging the concurrent requests historical data, tuning the concurrent managers and monitoring the concurrent manager operations

Created new scripts to automate the procedures and generate statistics on database space management, performance and for proactive monitoring

Agilent Technologies Colorado Springs, CO

& New Delhi, India

Oracle Applications Database Administrator Jun 2002 – Oct 2004

Environment: HP 9000 Superdome Server with HP-UX 11i, Oracle Applications11i, Oracle 8i, Financials, MRP, Inventory, Order Management, Purchasing, HRMS, CRM, Manufacturing, Oracle Supply Chain Management, iStore, iProcurement, iSupplier, Workflow, Dazel and Remedy Software

Installed and configured the applications on multi node

Performed upgrades, cloning, patching and performance tuning of applications and database

Configured apache webserver, metricserver, formservers and adminserver; iStore, iProcurement, iSupplier modules; and third party tools like VistaPlus, ClearOrbit and Dazel

Monitored applications and database backups, and troubleshot the servers when deemed necessary

Provided 24/7 system administration activities assistance and support using remedy BLT tool for monitoring and troubleshooting high and low priority calls

Created user setups and responsibilities, menu, functions and profile option settings

Managed printer setups, Dazel printer server and troubleshooting for customer facing documents on different servers such as file.net and vista plus

Developed request group, data group, value sets and flex field setups

Created concurrent managers, programs and request sets used for automating day-to-day activates, and provided troubleshooting when needed

NetGenesis Boston, MA

Oracle Database Administrator Apr 2001 – May 2002

Environment: AIX 4.3, Oracle 8i & 7x

Installed Oracle Software on various platforms (Windows NT, Windows ’95)

Developed Oracle database according to customer requirements which includes table spaces, users, roles for the application, database and application design

Created backup, export/import and various database security concerns

Performed implementation at the client site and performed user training

Monitored and performed troubleshooting requirements of database activities

Harvard University Boston, MA

Oracle Database Administrator Mar 2000 – Mar 2001

Environment: HP-UX, Oracle RDBMS 7.3.4

Cloned Prod to Dev, performed crash recovery, configured rollback segments

Developed, tested and automated the hot/cold backups, applied patches and monitored on timely basis

Oversaw day-to-day activities of production database, monitored its growth and performance

Developed scripts for refreshing development and QA databases

Handled user management and statistics gathering on database objects

Maintained development databases, test databases and patch application

EDUCATION

Bachelor of Engineering

Nagpur University India

Diploma in Relational Database Management System

CHARACTER REFERENCES

Available upon request

Contact this candidate