Abhishek Maloo

Experience

• 

  Rubicon information Pvt. Ltd

  Mar 2001 - Oct 2002

  Trainee Executive

  Worked as developer on Project called Catalog Manager & Exhibition Expert . Rubicon information Pvt. Ltd had franchise of Aptech Computer Education .Worked as IT Trainee Executive basically subject matter expert in Back end IT technologies.

• 

  Vedam InfoTech

  Oct 2003 - Sept 2004

  Software Engineer

  Worked in database team to maintain and monitor Client's (Citi Financial’s ) Databases.

• 

  Electronic Data Systems (EDS)

  Sept 2004 - Mar 2007

  Information Analyst

  As a Database Administrator worked for 2 clients Westpac Bank (Australia) and XEROX (worldwide) during the Tenure of EDS.

• 

  Citi technologies services (Mumbai) ,Citi Group USA

  Mar 2007 - Mar 2009

  Team Leader

  Worked with Citi technologies services (Mumbai) as Team leader (DBA Practice) supporting GDMG (Global Database Management Group) project.

• 

  HCL Technologies Limited

  Mar 2009 - Oct 2017

  Project Manager at HCL Technologies and HCL America Inc.

  Worked as Database Administrator Specialist for client MERCK & Co. Inc as a CFDBA (Client Facing Database Administrator) from India (Mar-2009 to Dec-2010 , Oct-2013 to Oct 2017 ) and Onsite USA (Jan-2011 to Oct -2013) at Client Location .Played key member role to merge Merck support Services as part of ISM (Integrated Service Management) Implementations. Worked as Database Administrator Specialist on various critical projects which includes but not limited to, MARRS (Merck Adverse Event Reporting and Review System) , SAILOR (Safety Assessment Integrated Legacy Operations Repository), ABWB (Antibody Workbench) , GSIP (Global Safety Integration Program), AMART (Activity Mart) & ABASE (Activity Base) and SADR (Safety Assessment Data Repository). Show less

• 

  HCL America Inc.

  Oct 2017 - now

  Managing high potential, Critical and complex project ORION (One Regulatory Information Online Network) from Database Administrator Standpoint.As a Database Specialist, my responsibilities includes providing upgrade and migration services in discussions with Technical Managers, System Administration experts, Quality Assurance people to perform the activities like Infrastructure requirements gathering, Database Procurement, Migration, Security Architecture , Installation and Configuration of Oracle Golden Gate Replication, Customization and Product Implementations, performing disaster recovery setup addressing all the technical and functional issues. I am committed to delivering innovative and effective solutions that align with organizational goals and drive business success.Golden Gate Hub Configuration : Did Research and analysis to setup Golden Date Hub configuration on AWS EC2 for replication from Azure cloud DB to Database hosted on AWS EC2 machine to support Reporting and Integrations. This unique architecture implementation involved VPN connectivities between 2 clouds, Centralized oracle golden gate hub and several other components like trail file management and security. Expert Level Troubleshooting : Did Optimization of business-critical activities like OGG Re-instantiationm, Database refreshes, ETL performance optimization, Huge page enablement at OS level and Database parameter optimization to improve overall application performance. AWS Resource Build via Infrastructure as Code(Iac): Responsible for procuring AWC cloud resources like RDS for Oracle and EC2 machine using terraform code and integration with CI/CD pipelines using Jenkins and deployed with CloudBees. Show less Managed all DBA related activities in MARRS (MERCK Adverse Event Reporting and Review System) .Responsible for all the DBA related activities typically includes, but not limited to :Database ManagementVendor Product SetupDB tools setup and ConfigurationDisaster Recovery setup and testing Oracle Data GuardInfrastructure planning and Performance AssessmentMigration strategiesEnterprise Data security assessment and performance optimization Troubleshooting and Bug fixingIn-depth understanding of Client's system and services. Show less

  • Database Solution Architect

    Oct 2019 - now

  • Database Administrator Specialist

    Oct 2017 - Sept 2019