Akash Dalmia

Customer - Indus Towers Pvt. Ltd.:

• Critical Monitoring Process and Automated Health Check Scripts : Implemented monitoring procedures and automated scripts to continuously assess system health and performance, ensuring early detection of issues and proactive maintenance.
• Self-Service Datafix Tool : Developed a user-friendly interface allowing stakeholders to execute datafix operations independently, streamlining the process and reducing dependency on technical resources.
• Oracle Production Environment Stabilization : Collaborated with Oracle Support to address critical system issues and identified missing patches, enhancing the stability and reliability of the production environment.
• End-to-End Cloning of Oracle Database and EBS : Successfully executed complex cloning procedures, including multi-node to multi-node and multi-node to single-node cloning, facilitating environment replication for testing and development purposes.
• Production Maintenance Management : Conducted routine maintenance activities during planned and unplanned outages, ensuring minimal disruption to operations and maximizing system uptime.

Customer - General Electric Aerospace

• MAA Implementation: Established Maximum Availability Architecture using standby and ZDLRA backups, reducing downtime during quarterly switchover
• Oracle EBS Upgrades: Successfully upgraded Oracle EBS from version 12.1.3 to 12.2.9 and from version 12.2.8 to 12.2.11, ensuring the adoption of the latest features and enhancements.
• Oracle Exalogic to PCA Migration: Managed the migration of Oracle Exalogic VMs to PCA VMs for EBS, ensuring smooth transition and minimal disruption to operations.
• Logical hostname implementation for EBS and Database completed
• Oracle Database and Weblogic Upgrades: Completed upgrades of Oracle Database from version 12c to 19c and Oracle Weblogic from version 11g to 12c, as well as from version 12.2.1.3 to 12.2.1.4, enhancing system performance and security.
• Oracle HTTP Server and Demantra Upgrades: Upgraded Oracle HTTP Server from version 12.2.1.3 to 12.2.1.4 and Oracle Demantra from version 12.2.8 to 12.2.11, ensuring compatibility and functionality improvements.
• Performed Oracle Internet Directory 12.2.1.4 setup and integration with EBS for MWA Authentication
• Enterprise Command Center and Demantra Integration: Successfully integrated Oracle Enterprise Command Center and Demantra with EBS, streamlining business processes and improving data visibility.
• Oracle Identity Cloud Services: Integrated Oracle EBS and Demantra with IDCS/IAM Suite for SSO authentication and OpenIDConnect, enhancing security and user experience.
• Database Management and Performance Tuning: Implemented database space management, reorganization, and performance tuning strategies, optimizing system performance and responsiveness.
• Disaster Recovery: Performed annual disaster recovery testing activities with RTO of 120 minutes and RPO of 1 minute.
• Automation and Cloud Migration: Automated EBS cloning, password changes, and disaster recovery processes using shell scripts, and worked on migration to Oracle Cloud Infrastructure, leveraging automation and cloud capabilities.
• Collaboration and Leadership: Collaborated with stakeholders, led project teams, coordinated critical activities, and worked with audit teams and Change Approval Board to ensure compliance and risk mitigation.
• Conducted technical evaluations and defined timelines for upgrades by ensuring minimal downtime for users
• Monitored team performance to keep projects on task
• Coordination and leading the team to perform mission critical activities
• Worked with audit teams to identify over-access to users and remediating them
• Worked with Change Approval Board to identify risks in moving changes to database
• Collaborated with functional and technical users to enable self service based approach with minimal involvement of DBA
• Worked on performance tuning of custom queries
• Identified huge tables in database causing performance issues to application users and proposed solutions

• Worked as a DBA for Oracle India Pvt. Ltd.
• Managed critical production environments for customers like GE Oil & Gas/Baker Hughes and Office Depot
• Created tablespaces, users, roles and profiles to manage database security.
• Deployed scripts to automate various tasks like backups, log rotation.
• Provided support to end-users regarding any issue related to Oracle applications or databases.
• Conducted regular health checks for all databases running on different platforms.
• Partnered with project management teams on development of scope and timelines.
• Installation of Oracle Database 11g and 12c
• Installation and configuration of Oracle E-Business Suite R12.2.4
• Performed patch analysis for CPUs and PSUs