Prashanth P

Oracle DBA

Phone: 302-***-**** Email: aczrgw@r.postjobfree.com

Professional Summary

Over Eight years of experience as Database Administrator in multiple Database technologies

Expertise in Design, Configure, Create, Monitor, Administration, Backup, Monitoring, upgradation, Patching, Grid Infrastructure, Cloud infrastructure

Strong experience installation and configuration of Oracle 12c Container Databases, Pluggable on standalone servers and cluster on windows and UNIX platforms.

Experience in Amazon Web Services Cloud environment

About Three years of experience in MongoDB Administration

Strong Experience in MongoDB administration, maintenance, monitoring

Strong command on performance tuning and proven experience in troubleshooting performance of SQL Server databases

Experience in business object tool SAP Lumira, and business intelligence Qlik

Experience in creation of database for database environments, Dev, Test, UAT, SIT, and Production

Experience in RAC, OEM, Patching, and Upgradation of database

Extensively worked on Real Application Clusters (RAC) setup, configuration, and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability

Design and implementation experience of Oracle Enterprise Manager (OEM) 12c for database monitoring.

Experience in troubleshooting RAC databases and engaging with application team for gaining performance enhancements for application in clustered environment

Expertise in Automatic Storage Management (ASM), VERITAS Volume Manager Administration, Cluster Interconnects, Load balancing and designing failover systems on UNIX platforms.

Expertise in Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runInstaller under UNIX and Windows

Strong installation and configuration of Golden Gate with experience in controlling processes such as Extract, Replicate, and Manager

Experience in carrying out RMAN cloning operations in 10g/11g to clone production environment

Effectively deployed active data guard standby on 11g database for test and production environments and performed switchover drills for immediate availability.

Experience in writing shell scripting and Perl scripting

Experience in administration and development of SQL server database system and IBM DB2 Systems

Great understanding of MongoDB, Cassandra DB NO-SQL database technologies

Experience in developing BMC Remedy tool for all change management process

Implemented Data guard for Disaster Recovery and performing production databases Maintenance.

Experience in Performance, Tuning of databases using AWR, ADDM explain plan, stats pack, and TKPROF and dictionary views. Gather statistics, de-fragmentation of table, re-organize structure. Monitor memory, index, Schedule jobs, Partition pruning for big table.

Tuning of database for Top Sql/session, bottle-neck issues, and Tune init parameter, Full table scan and Index usage

Strong exposure on Oracle Access Manager (OAM), Access Gate, Single Sign On

Proficiency in SQL Server Administration:

About 3 years of experience in SQL Server 2012 in designing database

Good understanding of T-SQL syntax

Good working knowledge of SSMS, SQL Profiler

Worked on Database replication, analysis Services

Good understanding of SQL server architecture, T-SQL

Worked in database tuning, performance and optimizations

Monitoring Daily backup for Databases

Strong understanding of SQL server databases

Strengths:

Ability to communicate fluently both technically and in general

Knowledge of VLSS and Six Sigma environments

Experience in handing crisis bridges, weekly team calls, Change Activity calls

Experience in handling team lead position, as a backup

Experience in giving presentations to Executive level whenever required

Capable of understanding and working in Sense of urgency

Capable of handing of multiple systems change activates in production environments.

Mentor for team members

Enthusiastic to learn and explore new concepts and new technologies

Team Player, Sharing the knowledge to team on new enhancements

Certifications:

ITIL Foundation Certification V3

Education:

Bachelors in computer science

Technical skills:

Platforms

Linux, Sun Solaris, Centos Windows, AWS Cloud

Languages

Shell Scripting, Oracle PL/SQL

RDBMS

Oracle 10g, 11g, 12c, IBM DB2 9.7, Sql server 2008 R2, MongoDB, Cassandra DB

Utilities

Oracle Pl/SQL Oracle RAC, Oracle Standalone, Grid Infrastructure, Oracle ASM

Tools

Oracle Enterprise Manager, Grid Control, TOAD, Oracle Golden gate, Oracle Streams

Business Intelligence

SAP Lumira, Qlikview.

Security tools

Spunk, Wireshark.

Middleware

Oracle Access Manager, Oracle Identity Manager, Access Gate, Single Sign On

Professional Experiences

Verizon Communications May 2013 to Current

Basking Ridge, NJ

Job Title: Senior-Database Admin

Project Description:

Verizon Communications employees, vendors, enterprise customers those access the Verizon information systems should pass through the Single Sign on (SSO) authentication system. Oracle Access Manager (OAM) and Oracle Identity Manager (OIM) manages this authentication system; applications, websites, tools, products are integrated to Single Sign on (SSO) system. My role is administration of Database of OAM, OIM, SSO systems.

My Roles

Expertise in Planning, Design, Development, Installation, administration, monitoring, maintenance of enterprise database systems for Oracle and SQL server

Supporting 40 plus applications, and about 150 database systems for different environment

Responsible for all duties for the database administration, configuration, administration, installation, database design, modeling, development, user creation, networking for the client-server environments

Experience in setting up Amazon Web Services cloud infrastructure

Responsible for writing scripts for database backups using Data pump utility for tape drives, and RMAN backup scripts for daily backup

Responsible as primary database administrator for 40 application for Dev, test, UAT, production environments

Responsible for database monitoring, maintenance, upgradation, patching.

Experience in developing PL/SQL procedures, triggers

Experience in configuration of Oracle Enterprise manager monitoring for all the databases

Expertise in configuration of golden gate environment between Oracle and SQL server databases

Responsible for opening Service Request to Oracle on critical issues, collaborating with team, updating the regular status of SR- results to the managers, and DBA director. Following up the support team to gain the appropriate resolution strategy and steps for the issue

Responsible for supporting the major releases development, testing, and deployment strategy, steps, documentation, and deployments are tested in production like environment.

Responsible to work with all the team for step by step deployment of major release, gain approvals for major releases on the production systems

Responsible for business continuity strategy for the system in my support, Disasters systems locations, availability, accurate ETA to switch to disasters system if some incident are reported and databases are down.

Configuration of Test, UAT, Dev database environments depend on the project requirements.

Configuring and Administration of RAC infrastructure

Experience in 12c multitenant architecture, configuring CDB, PDB databases

Experience in reviewing AWR, ADDM reports for troubleshooting the performance related issues

Very strong in Creation, Installation, Administration, Maintenance, Backup restore, and recovery of Oracle database Server in Single Instance & RAC for 11g.

Core Knowledge of internal working of UNIX operating system

Database patching, OEM administration

Database creation, Administration, Monitoring, Maintenance activities are handled for VRD (Verizon Rapid Delivery) environments.

Monitoring of alert log file, and regular database health checkup

Experience in handling production releases, Major and Minor releases, Maintenance activities

Checking and verifying for the corrupt blocks and recovering them.

Tuning Oracle databases and tuning applications, with Tuning Tools like OEM, SQL analyzer, Statspack, AWR, ADDM, ASH, RDA, Explain plan, TKPROF, SQL TRACE, SQLT, TRCA, RAT(Real Application Testing) Tool and Oradebug.

Experience in handling Crisis Bridge

EPS-DBA (Enterprise production support-DBA) team which was responsible for supporting all the production databases

Responsible in handling Very Large Database Environments (VLDB)

Environment: Oracle 9i/10g/11g, Linux, AIX, HP-UX, Solaris, OEM GC, TOAD, RAC, RMAN, Legato Networker, Explain Plan, Data Pump, AWR, ADDM, Oracle Replication, SQL*Plus, PL/SQL, SQL*Loader, Oracle Access Manager(OAM), Oracle Identity Manager(OIM), Single Sign On(SSO)

Convergys Dec 2012 to Apr 2013

Watertown, NY

Job Title: Oracle Database Administrator

Project Description:

This Project involved managing all Oracle Database systems for one of the Health care client. About 20 applications are Mission and Business critical. Managing 200+ databases in 24/7 shifts. Applications have monthly, quarterly production releases. DBA instant tickets, documentation of database systems, disaster systems, recovery planning. Developing customized reports daily inwards, outwards patients, transaction metrics.

My Roles

Verifying AWR, ADDM reports, checking the statistics and troubleshooting for good performance of the database

Handling incident tickets opened up for DBA team, Space issues, database high CPU issues, memory utilization above the threshold, open cursor issues.

Incident tickets with ETA, resolution should not breach the ETA time.

Handling sensitive environment, customer dependent applications, very short SLA duration.

High level monitoring of the database using many different tools, constant health checks of the systems.

Process oriented environment, documentation of every problem of the databases, resolution with proof of concepts.

Stability and availability test of the database system are performed after every incident reported, and resolved.

Capacity planning test are performed on all the production systems

Careful verification of the scripts written by developer to identify and control improper use of access levels

Identification of users on the database, eviction of

Experience in database administration like Import/Export, Data Pump, RMAN, and Physical standby databases using Data Guard

Experience on ASM, Data Guard with switch over and fail over.

Expertise in configuring and Maintaining Data Guard

Handling incidents of all the application in support, Running all the basic health checks of the databases respective to the application and confirming on the incident response calls

Handling Change Activity bridges for planning of any Production changes/ Releases /Maintenance activities

Verifying all the database health checks before the business hours are started

Opening SR case - with Oracle for unresolved issues and driving the task for the problems resolution.

Keeping a track of fast forward recovery for the problems occurred and impacted production systems.

Handling on-call duties for week-ends

Environment: Monitoring database, Export, Import, Expdp, Impdp, Production support, Oracle Enterprise Manager, Oracle Data Guard.

Convergys Sep 2012 to Dec 2012

Watertown, NY

Job Title: Oracle Database Administrator

Project Description:

These were two database residing in Tampa Data center, Management have decided to move all the database system to Tulsa center. I was responsible for migration of the two very large database system to new hardware. New setup of Oracle Database on new hardware replica to the database in Tampa data center.

My Roles

Planning and migration of databases between different data centers were initiated and driven

Contacting all the teams respective to the application and brought up a plan for migration of the application to new hardware

Closely working with Application Manager for the approval of new hardware and necessary installation of latest version of Operating system

Installation of Oracle 11g and creation of databases with same kind of setup which is available on old hardware

Taking database export dump using Data Pump utility and copying on the new server, and importing the data on the new databases created

Environment: Oracle 11g, Export, Import, SCP, Installation, configuration, networking, ASM(Automatic Storage Management), NAS(Network Attached Storage), Tape Drives, Migration.

Bloomberg L.P Jun 2010 to Aug 2012

Philadelphia, PA

Job Title: Oracle Administrator/Developer

Project Description:

This project is development of new system for the Asset Management business unit/portfolio. The emerging area of business unit required new systems, applications. New environment setup, new database configuration, setup of RAC infrastructure, launch of applications, integration of enterprise products, and applications.

My Roles

Oracle Database support for Dev and test environments.

Database support for production system, administration, configuration of RAC setup

Experience in troubleshooting RAC databases and engaging with application team for gaining performance enhancements for application in clustered environment

Upgraded multiple Standalone and RAC databases and grid infrastructure from 10gR2 to 11gR1

Managed migration processes through Golden Gate Pump process and Checkpoint Table with zero downtime to the target server.

Databases on standalone servers and cluster on windows and UNIX platforms

Experience in configuration of 4 node RAC setup

Load balancing of the database cluster step

Design and setup of disaster recovery system for 4 node RAC database system

Business continuity planning, documentation, practice of the plan, setting of the steps for

Developed Oracle system, based on the requirement designed by architect

Installed Oracle engine, created database, configured environments for developers

Responsible in developing backup and recovery plan for the development databases

Configured Oracle enterprise manager for test, and dev database on existing gird server

Developed prod-like environment for the final stage of testing

Experienced in configuration of Oracle enterprise manger on 10g and 11g versions

Developed 2 node RAC environments on 11g version on RHEL

Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager

Installation and configuration of RAC instances in 11g and maintaining clusters with utilities like CRSCTL, SRVCTL, OCRCONFIG, OCRDUMP

Documenting various recovery scenarios for DR site and managing the gaps in archive logs to bring the standby in sync with primary database through Data Guard Broker and building DR environment for the business critical databases

Tuning the SQL statement by analyzing the explain plan and ADDM reports

Application with tuning tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries

Colruyt Group Feb 2009 to Jun 2010.

Bangalore, India

Job Title: Software Developer/Admin

Project Description

This project is support for production system for retail store, monitoring of the production systems. Development of the changes for next releases and working with developers, tester for deployment of scripts, resolving the issues. Managing the dev, test systems.

My Roles

Creating database for dev, test database for developers

Creation of users, assigning roles, privileges.

Taking backup of the database, RMAN backup for the development database.

Administrative activities of Oracle 10g systems

Handled L1 DBA tasks like, Monitoring Database, Adding space, checking Database health before business day starts, Handling new dev and test request like deploying stored procedure

Database monitoring, administration, maintenance, adding space, adding users, clearing the mount spaces, monitoring the backup of the database

Database health check reports, identifying the long running transactions

Working with developers for the deployments, change in the code, development activities.

Deployments of script of development, test environments

Environment: Oracle 9i, Oracle 10g, Hot backup, Archived logs, backup of databases, user management, Network management, Space management. Monitoring databases, Deployments, PL/SQL Development, Memory Management. Export, Import.

Employer Information:

Assent Solutions LLC

Ashok

Phone: 832-***-****(Direct)

Office: 713-***-****

aczrgw@r.postjobfree.com

Contact this candidate