Deepak Mani

Experience

• 

  Cognizant

  Jul 2009 - Mar 2013

  Technical Lead

  Provide End to End support for application team with respect to Oracle Database Administration. Application Support· Managed application users and database objects. · Configured and managed targets using OEM· Performance tuning and troubleshooting day to day issues of application team.· Creating/Maintenance of shell scripts to monitor Database/Servers.RAC· Creating/Managing RAC databases.· Implemented RAC-onenode and converted databases from RAC to RAC-onenode.· Using SRVCTL/CRSCTL to manage RAC databases..Perform fix for cluster issues/node evictions. RMAN· Configuring and Scheduling RMAN Hot, FRA, Cold backups in Autosys and Crontab· Restoring/recovering database from RMAN backups· Duplication of Databases using RMAN includes 11g r2 Active DuplicationDataguard· Creating physical standby databases using RMAN active duplication.· Resolving physical standby database gap resolution using RMAN incremental scn backup.· Performing database switchover and failover.· Converting the physical standby database to Snapshot standby for testing purpose.· Administering the physical standby databases using DGMGRL CLI.Installation/Patching and Migrations· Performed in-place database upgrades and manual upgrades.· Databases migration using export & import datapump, RMAN.· Applying RDBMS, PSU patches on RAC & non-RAC databases.Exadata· Have basic understanding in architecture of Exadata compute and cell nodes.· Creation and administration of Oracle Databases in Exadata Compute Nodes.Research & Analysis on:· Creating standby database OEM and configuring broker configuration.· Using EXPDP/IMPDP to migrate and copy application Schema.· 11g r2 active duplication using rman to duplicate and create standby databases.· Implementing huge pages versus implementing memory target for databases.· Database getting hung because of configuring DIAG to ACFS file system for multiple databases in 11.2.0.1 version of ASM. Show less

• 

  Wipro Limited

  Apr 2013 - Jul 2018

  Lead Administrator - Infrastructure Specialist

  AWS Certified Solutions Architect providing Core Infrastructure support to Application teams on below mentioned support functionalitiesCapacity Planning for new and existing applicationsAutomation using shell scripting and PL/SQL blocksWork with application team to plan and migrate databases into on-premise cloud solutions.Prepare proof of concepts for latest technologies in Infrastructure including Cloud Computing and Oracle 12c. Architect High Availability & DR solutions with respect to database for critical applications.Senior Administration support on Performance tuning and Bug fixes for applications at Production Infrastructure .Perform End to End Production Infrastructure setup with respect to Oracle database for Digital Applications at my Client Site.Provide infrastructure solutions/support to application teams based on their day to day requirements/issues/testing. Show less

• 

  Object Information Services, Inc.

  Jul 2018 - Jan 2020

  Senior Infrastructure Engineer

  • Setup Oracle Database Engineered machines (Oracle Database Appliance) and design/setup databases for application teams based on their requirements. • Handle installation, upgrade, configuration, monitoring, performance tuning, troubleshooting and backup/recovery procedures for databases.• Design, setup, maintain and manage Oracle Enterprise Manager and MongoDB Ops Manager. • Configure and manage bi-directional replication for mission critical databases using Oracle Golden gate. • Work with product vendors like Oracle and MongoDB to fix/enhance/implement best practices on existing infrastructure at acceptable cost for organization. • Responsible for installing, maintaining and tuning SQL and No-SQL databases like Oracle and MongoDB• Perform Proof of Concept on new emerging technologies and certify the same for adoption in the company.• Conduct DR drills on production and COB databases periodically and document the same.• Utilize expertise of cluster management areas, such as adding/bootstrapping/removing nodes, consistency tuning, replication, and multi-DC configuration.• Automate regular activities using shell/python scripting and display of same in Graphical User Interface using Spring boot REST API and Angular. • Perform capacity planning on existing Engineered machines and optimize the resource/cost utilization for organization. • Review project requests describing database user needs to estimate time and cost required to accomplish project.• Migration of database from on premise to in-house or vendor cloud platforms. Show less

• 

  Amazon Web Services (AWS)

  Jan 2020 - now

  • Sr Cloud Support Eng

    Oct 2023 - now

  • Cloud Support DBA II

    Apr 2023 - Oct 2023

  • Cloud Support Engineer II

    Apr 2022 - Apr 2023

  • Cloud Support Engineer

    Jan 2020 - Mar 2022