Ashutosh Dhar Email & Phone Number

Saint Paul, Mn, Us

Santa Clara, California, Us

• Premium Support Engineer for Datastax Cassandra• Solving critical production issues for clients• Advocating best practices and Datastax recommended production settings• Diving deep into a problem, figuring out RCA, and providing the solution• Writing Datastax Cassandra knowledge articles• Re-producing issues and filing Jira for Bugs and improvements• Thread dump, Heap dump, and GC log analysis• Reading Cassandra code to analyze a certain behavior• Weekly meeting cadence with premium customers to go over any open issues andplanned activities

Mumbai, Maharashtra, In

• Automation - Expert in reducing redundant DBA tasks via shell scripting and Ansible• Oracle, Cassandra and E-Business Administration, Production support and project activities.• Established standardization and increased stability across large footprint of Oracle(700+) and Cassandra(+150) databases• Database optimization - Capacity planning, Performance management, Query tuning recommendations, baseline performance parameters, historic data purging and reorg• License Optimization - Database consolidation and optimization• TCO reduction - Migrating non-critical databases from SAN to NAS• Transformation - Migrating Oracle databases from Physical to Virtual servers• Backup - RMAN backup validation and auto-backup purging from Data Domain• Cross skilling - Training junior DBAs in multiple technologies - Oracle, Cassandra, EBS• Upgrades - Upgrading Oracle and Cassandra databases to latest version. EBS upgrade.• Patching - Quarterly to latest PSU or RU• Introduced Kibana for Auditing and Cyberark for password management and security• High availability - Configuring RAC for Core and EBS database for HA• EBS R12.2 upgrade and administration• Expert in database performance tuningHardware HP Servers and SAN storageOperating System Linux, HP-UX, Windows 10, Windows server 2008 R2, 2012 and 2016Cloud Microsoft AzureLanguages SQL, PL/SQL, PERL, Python, Unix Shell Scripting, Ansible, PowerShell scripting, Core Java, J2EE, JSP, HTMLSpecial Software Oracle RDBMS, Oracle Grid Infrastructure, Oracle Enterprise Manager Cloud Control, Datastax Cassandra, DataStax OpsCenter, ImanisData, Azure Cosmos DB, RMAN, Oracle E-Business Suite ERP, Retek, Oracle WebLogic server, SQL Developer, Oracle Client, Microsoft SQL Server, Microsoft Azure SQL database, Microsoft Active Directory, VM, Microsoft Office, Adobe Acrobat Professional (PDF), Service Now, HP BSM/APM, Kibana, Elasticsearch Storage, Dynatrace, Logstash, IBM Workload Scheduler

Pune, Maharashtra, In

Solution Environment : Oracle E-Business Suite 11i and R12, Oracle Database 10g, Sun Solaris 10, Appworks Description : Monitoring & Maintenance of Oracle E-Business Suite 11i and R12, implemented in CTT (Cummins Turbo Technologies) and Corp – finance instance. Performing the daily activities like backup checking, Tablespace Monitoring, communication with Appworks & Unix team regarding issues. Oracle Application Cloning and PatchingResponsibilities : Monitoring and Troubleshooting Performance Issues like High CPU and Memory Utilization using OEM, v$ views and other OS utilities.Performing RMAN cloningAppling PatchesPerforming Technical Code ReviewsPerforming C & I and AOL MigrationsPerforming Sysadmin Activities like User Creation, Responsibility Addition, Setting Profile Options, Creating and Adding Functions to Menu, Attaching Reports to ResponsibilityMonitoring Concurrent Managers, Submitting Requests and diagnosing issues related to Concurrent Requests on daily basisMonitoring Workflow Mailer ServicesMonitoring Database via OEMGenerating ASH Report and AWR ReportMonitoring Back Up chains in AppworksResolving Back Up failure issuesDiagnosing Appworks Job Failure issuesCreating and Scheduling scripts via crontabResolving alerts like Long Running Requests and various ORA ErrorsDB and Application Mountpoints Monitoring.Tablespace MonitoringTroubleshooting of Locking issueCommunication with Oracle on different Issues and Bugs related to Oracle Application and Database.Performing admin tasks using adadmin utilityPerforming Re-org and Rebuild activityPerformed Database Upgrade from 10g(10.2.0.4) to 11g(11.2.0.3)