Harinder Ratra

Experience

• 

  Project: Ranbaxy Laboratories Ltd

  May 2007 - Sept 2008

  Oracle DBA

  Title: Ranbaxy Laboratories Ltd. (R&D IV)Role: • Led the creation and management of users and their profiles on operating system and oracle database• Provided connectivity and troubleshooting of connectivity problems between different databases and client computers• Worked as System Administrator for leading software installation, windows troubleshooting, LAN & WAN, hardware maintenance, configuration outlook installing and troubleshooting of network printers

• 

  Worked with HCL Technologies Pvt. Ltd

  Oct 2008 - Nov 2009

  Specialist- Systems

  Title: CROS (Cisco-ROS) as Oracle DBARole: • Tracked the daily jobs and schedules in case of failure rerunning the jobs and schedules• Led the creation and maintenance of physical standby database and cloning a database• Mapped the backup (RMAN backup) jobs which executed daily, weekly and monthly in case of failure reporting the same and rerunning the job• Initiated the creation and management of users and their profiles, datafiles, tablespaces, databaselink, export and import using data pump• Troubleshot connectivity problems between different databases and client computers; administered Oracle Enterprise Manager (OEM) including creating alerts, fixing jobs and logs• Generated the ticket in case of any alert or error and the same notified to the user• Provided 24x7 supports in operations Show less

• 

  NEC India Pvt Ltd

  Nov 2009 - Apr 2019

  Assistant Manager Tech

  • Proven success in managing entire project implementation & support functions with key focus on top line profitability by ensuring utilization of resources; gaining profound knowledge of Oracle Database, UNIX & Linux and Windows• Dexterously gathered requirements from end users and transformed the requirements into functional documents in Reports, Interfaces, Conversions, Enhancements, Forms (RICEF) components• Played a key role as key member of a project Implementation, providing functional and domain expertise related to the implementation, setup, gap/fit analysis, customization analysis and testing, user training, and go-live support • Stellar in working with existing customers in support of their day-to-day business operations, questions, issues and small and medium size projects; developed & managed client relationships and ensured client satisfaction through the entire project implementation cycle• Possess proven analytical, meticulous and quality-oriented professional with an eye for detail• Excellent technical skills analyzing logs, troubleshooting problem, and helping customer to provide quick resolution; extensive experience in examining, investigating and resolving problemsFunctional Skills• Managing users and their profiles, maintaining Datafiles, Tablespaces, Database link, Export and Import using Datapump, troubleshooting of connectivity problems between different Databases and client computers• Preparing technical documents like installation manual, user manual & troubleshooting manual• Imparting training to end users for the applications/solutions, conducting POC of application and products with the clients• Performing UAT for pilot and production setup of the projects with clients, leading installation of biometrics application (including database also) and their maintenance• Applying the application patches after testing them in test setups; supporting all application related issues & resolving them within SLAs Show less

• 

  NEC Corporation India Pvt Ltd.

  May 2020 - now

  • Sr Manager - Technical support

    Apr 2021 - now

  • Manager - Technical Support

    May 2020 - Dec 2021