Madhusudhana(Madhu) Hebbar

*** ******** ** ******** **** CA 91360

805-***-****, adu21y@r.postjobfree.com

Executive Summary

● More than 15 years’ experience in full cycle software development in various roles Technical Manager, DBA, Architect and Consultant.

● Knowledgeable in various technical environments including web technology, middle-ware, database technologies, technical architecture, planning /analysis,

● Over ten-year experience in Oracle (8i,9i,10g,11g, and 12c) database administration (Development and Production).

● Experienced in setting up OEM repositories (13c – Cloud Control), monitoring databases using OEM tools. Backup and recovery using RMAN and OS.

● Experience with E/R, relational, dimensional modeling, star, snowflake and DE-normalization techniques.

● Strong skills in solution architecture, design and analysis (SSAD/OOAD), leadership, team building and mentoring skills

● Worked in various industry sectors: Human Resources, Utility, Banking, Finance, Automotive, Retail, Distribution, and Trade Show.

● Bachelor’s degree in Engineering from Bangalore University and Masters in Mechanical Engineering from Indian Institute of Technology, Kanpur.

● DOD Secret Clearance in July 2018 -Valid for ten Years-(till 2028) Relevant Roles/Certifications

● Mentor, Architect, Team Lead, Product Specialist at major HR company

● Team lead and DBA Asset Reconciliation System for telecoms/banking client

● DBA and development lead Project information system for automotive client

● Architect, DBA, Project Manager for Utility client

● AWS- Cloud practitioner

● AWS- Cloud Solution Architect Associate

Relevant Experience Overview 2022 Nov - Present

Programmers Resource International Inc, Database Architect(at Lucid Motors on Contract)

● Collect business requirements and Create Data Model for SoftwareVersioning System for Lucid Cars

● Redesign/Refactor the database design for scale meeting new business requirements

● Evaluate Hardware,Software, Monitoring options for the Database servers TruePill, Senior Database ADministrator 2021 MAR - 2022 Sep

● Maintaining, Troubleshooting,Performance tuning, Installing in a Multi-database (MongoDB, Mysql, RDS, Postgres,snowflake) environment.

● Migrating database from AWS to Google Cloud

● Automation of repetitive tasks with heavy use of tools - Jenkins,Terraform, AWS CLI, shell scripts, rubyOnRails in google cloud, docker and kubernetes etc.

● Reviewing developer code for optimization, performance tuning and optimal database design Emburse 2019 Feb - 2021 Mar

Principal DevOps Engineer

● Maintaining, Troubleshooting,Performance tuning, Installing in Multi-database (Mongo, Mysql, Aurora RDS, sql server, Percona, Postgres,Oracle) environment.

● Migrating SQLServer, mysql, oracle databases into AWS

● Automation of repetitive tasks with heavy use of tools - Jenkins, Ansible, terraform . AWS CLI, shell scripts etc. Sample savings - 2 Hrs per task to 10 min or less, 12 manual steps to one Jenkins job

● Reviewing developer code for optimization, performance tuning and optimal database design

● Evaluated (POC) Liquibase, Flyway for selection of database migration tool,

● Certified AWS Solution Architect Associate -2020

California Insurance Guaranty Association, Glendale (CIGA) 2018 Aug - 2019 Feb Database Administrator/Architect

● Supporting maintenance and updates to - Guidewire, Oracle BI, SOA, LaserFishe

● Troubleshooting database performance (Oracle12c, sql server -2016)

● Designing/Reviewing/Implementing ETL processes using multiple tools including ODI, shell scripts

● Recreating physical/Logical/Conceptual models for the Data warehouse (star schema/Dimensional modeling).

● Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques

● Troubleshooting, optimizing, tuning complex queries for Data warehouse (Oracle BI)

● Evaluated (POC) Delphix for setting up of disaster recovery environment

● Database migration from Oracle to Sql Server using Delphix InfoGain, Sunnyvale, CA 2018 Jan - 2018 Aug

Consultant, onsite L2 Lead for Enterprise Database Operations Group (at NetApp)

● Support activities for the multi-site, multi database environment, Environment has Oracle, MySQL, Mongo DB, SqlServer databases

● Includes coordinating, scheduling activities with offshore teams.

● Requirements definition, Tickets monitoring, Client engagement at different levels – executive/non-executive, end users

● Troubleshooting issues related to performance, data loading, recovery mGage- a Vivial Company, Los Angeles 2016 – 2017

Database Architect/Administrator

● Migrating Oracle, MySQL databases to AWS (Amazon Cloud) – Worked in EC2/S3/RDS/IAM

● Improving the performance of DW processes – ETL in Oracle (PL/SQL), SQL Sever

● Recreating physical/Logical/Conceptual models for the Data warehouse (star schema/Dimensional modeling).

● Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques

● Process improvement of Database administration though rationalization and automation

● ASM storage management, Oracle Database administration, tuning, troubleshooting (10,11,12c) including active dataguard, RAC

● Troubleshooting, optimizing, tuning complex queries for Data warehouse

● Exposure to MongoDB, SSRS, SSIS, PostgreSQL, MySQL- development and data warehouse environments

● Prioritizing trouble tickets, business requirements, operational issues

● Storage migration of ASM Disks – Implementing New storage solution on production

● Mentoring analysts, database administrators

● Collaborate with Business and Development teams on data and architectural issues. Cloud Creek Systems, Westlake Village, CA as Consultant DBA 2014 - 2016

● Consulting at e harmony as a consultant DBA - Ticket resolution, tuning, installation, upgrades

● Application Monitoring and database troubleshooting using Toad, SQL Developer, TRCA, TKPROF, STATSPACK, ASH reports, AWR reports

● In house consultant DBA responsible for – Oracle installation and Upgrades (11g and 12c), monitoring, tuning and troubleshooting client databases (8i,10g,11g, 12c). Oracle on AWS, EC2, Exadata, ODA including active dataguard, RAC

● Troubleshooting GoldenGate in production environment

● Storage migration of ASM Disks- resolving Disk corruption

● Tuning and Redesigning data warehousing ( ETL) processes – SharePlex/Oracle Stored Procedures( PL/SQL)

● Migrating Oracle, MySQL databases to AWS (Amazon RDS) ADP, Camarillo, CA Technology and Team Lead 2005 –2014

● Migration from 8i to 9i, and 9i to 10g, 10g RAC,11g RAC, ASM, Installing11g RAC, GRID Control, Veritas cluster on Sun SOLARIS 2.9

● Team Lead for a team of up to 6 DBAs and Mentor the DBAs in the Team

● Reduced the time for upgrades (eLabor Application) from 40+hours to 4 Hours

● Oracle Install on 2 Node, 6 Node and 8 node RAC clusters

● Design and development of scripts to migrate data from one data center to another (25000+ schema)

● Real Application Testing (RAT), OEM installation, configuration, monitoring.

● DR set up using Golden Gate and Oracle data guard

● Project planning at technical and executive levels. Project/plan resource requirements for DBA Group, mentor/ guide team members and developers

● Manage/administer database support activities in a production, staging and QA environment and support up to 300 Oracle and SQL server databases, allocate and coordinate tasks across product teams, production resource

● Interfacing with product support and development teams on database performance and new production features.

● Install, upgrade, tuning and maintenance of various oracle 8i/9i/10g/11g (RAC and non RAC) databases

● Working with Application developers to troubleshoot application, SQLs

● Troubleshooting and Solution Development for variety of issues crossing many technologies

(DB/WEB/.NET/JAVA)

● Improved application upgrade performance (Application upgrade from 40 hours to less than 4 hours, data load from 4 hours to ten minutes)

● Designed and Developed scripts to collect Oracle statistics and to track the database performance over time. Trending usage, growth, performance of various parts of the application (capacity planning and forecast)

● Demonstrated experience working with and tuning complex SQLs. Troubleshooting and tuning of application SQLs using TKPROF, STATSPACK, AWR, ASH, Explain Plan, SQL Trace, ANALYZE, HINTS, etc.

Contact this candidate