Harinder Ratra

Harinder Ratra

Oracle DBA

Followers of Harinder Ratra653 followers
location of Harinder RatraFaridabad, Haryana, India

Connect with Harinder Ratra to Send Message

Connect

Connect with Harinder Ratra to Send Message

Connect
  • Timeline

  • About me

    Sr Manager - Technical Support at NEC Corporation India Pvt Ltd.

  • Education

    • K.LMehta Dayanand Public School

      1999 - 2000
      Sr. Secondary Commerce with Maths
    • University of Rajasthan

      2005 - 2005
      Master of Science (M.Sc.) Computer Science A
    • Delhi University

      2000 - 2003
      B.COM (H) commerce
  • 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
  • Licenses & Certifications

    • OCP in 9i and 10g Oracle