Mayuresh B Email & Phone Number

Bethesda , Maryland Area

Involved in the analysis, design, build, and testing phase of the life cycle for CSS for fanny Mae and Freddie Mac .Allocate S3 buckets , create and maintain databases on AWS cloud.

Greater San Diego Area

Handled and maintained Two node RAC on 12c env for Prod/UAT/Dev/Test.Installed and configured GoldenGate software in Test and Dev instancesMonitored golden gate on Production env and handled replicating issues on UAT env.Maintained OID server , Datagaurd and OEM server.Applied psu and cpu patches on RAC and stand-alone servers.Proactively monitoring of backups.Analyzed and troubleshoot failed backupsMonitored active standby database for production OLTP and Datawarehouse env

Greater Chicago Area

Handled around 100 to 150 databases on two node and three node RAC servers.Installed 12c two node RAC with GRID and ASM Cloned/Refreshed database from production (size of production db 3TB to 8TB)Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.Worked on Performance tuning issues including created SQL Profiles/SQL Baselines and tracing of applications.Performed block recovery using RMAN.Performed large batch jobs and tuning of SQL queries and database systems.Partitioned large tables for better performance and manageability.

Vancouver , Wa

Involved in the analysis, design, build, and testing phase of the life cycle for the project called Edison for new HP printer LIMO going to be released in 2016.Handled Entire DBA activates on HP Vancouver site.Involved in the installation of new database 12c on Redhat Linux for Production and development environments.Migrated Database from 11.2.0.1.0 to 12.1.0.2.0 for both Production and Development environment.Configured flash recovery area, created RMAN scripts and export scripts for regular backups and daily maintenance script.Tuned RMAN backups for maximum throughput and configured backup policies.Worked along with Microsoft server and .NET Team to help setup new application within HP.Trained and nurtured Junior DBA to handle Daily Oracle activities.

Austin, Texas Area

Managed database security , administration and Space ManagementDesigned , developed and implement automated data backup and restoration procedures.Provided technical support for database maintenance and disaster recoveryProvided support to Application Database Administrators in designing the database. Implement Hot, Cold and Logical backup plans.Worked on several shell scripts to maintain the database activities.Configured encryption for backup and tablespace for few critical databases.Optimized and tuned SQL queries . Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Dataguard, Implemented flashback for critical database.Helped application team install and configure of Apache and Tomcat.Helped Setting up New SFTP server for Third party customers.

Arlington Heights,Il

Administered Oracle 11g R2/10g/9i/8i production, test, development environment on RHEL, IBM-AIX , Solaris, HP and Windows .Handled entire DBA activity on server move for Vertas cluster and Dataware house servers Assisted REIP of all the servers (RAC/Standalone) for Engineering systems during Motorola and NSN separation.Installed and configured Oracle Enterprise Manager (OEM) server and deployed agents on hosts.Configured RMAN for business servers again with the new RMAN catalog for new business server.Worked on many Unplanned power outage and restore the DB when Mount points got corrupted.Performed database cloning to setup test and development database.Conducted sizing & capacity planning for Oracle databases.Involved in Migration of Database from 9i to 10g and applying patches whenever required.RAC Troubleshooting (worked on RAC REIP, SCAN IP issue and DB Unknown issue)Worked on maintaining schemas and partitioning tables.Implemented Reorgs on Monthly Basis Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.Implemented Dataguard for 3 Node RAC on standalone server.Implemented an OS upgrade for three node RAC, implemented only on test environment QA and Prod is still under process.Brought DR in sync whenever the DR went out of SYNC.Monitored Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.Used the expdp/impdp utility on aregular basis for copying data across schemas..

Master'S Degree, Electronics And Computer Engineering

Graduate Assistant Physics Tutored and mentored undergraduate Physics students.

Bachelor'S Degree, Electronics And Telecommunications Engineering

Activities and Societies: Acquired J.R.D Tata scholarship and SHRI BRIHAD BHARATIYA SAMAJ scholarship for outstanding performance 2004.

Diploma, Industrial Electronics

Activities and Societies: Joint secretary of the Indian Society of Technical Education(ISTE) during academic year 2003-04. Have organized.

Master'S Degree, Information Systems, 4

Activities and Societies: Graduated with Summa Cum Laude