Talk to sales Try for Free
Gayathry Mohanan

Gayathry Mohanan

Followers of Gayathry Mohanan89 followers
location of Gayathry MohananErnakulam, Kerala, India

Connect with Gayathry Mohanan to Send Message

Connect

Connect with Gayathry Mohanan to Send Message

Connect

  • Timeline

  • About me

    Associate Lead Database Administrator at Envestnet, Inc

  • Education

    • Viswajyothi College of Engineering and Technology, Muvattupuzha,Kerala,India

      2010 - 2014
      Bachelor of Technology - BTech Electrical, Electronics and Communications Engineering 7.3/10

  • Experience

    • Tech Mahindra

      Sept 2014 - Jan 2020

      DB2 LUW Senior Database Administrator with 5+ years of professional experience, looking for a full-time position which invites technical challenges and learning opportunities.Experience Summary: 5+ years of 24*7 production support in DB2 Linux and UNIX platforms Currently working at onsite – Australia as Team Lead, leading team of 2 resources Supporting 400+ databases migrated from V9.1 till V11.1 DB2 LUW Managing Critical OLTP databases like Online trading, EAI, Data Stage  Responsible for database support conducting security audits, version/fix-pack upgrades/migrations, health check remediation, database maintenance, database monitoring and alerting  Liaising with key stakeholders and technical/functional teams Proficient in executing and supporting database related changes  Hands on in dealing with major incidents/tickets along with multiple technical teams Managed to reduce the backup run timings in Coles Online to a total of 7 hours from 10+ hours Worked on resolving major Priority - 1 incident which involved an outage of 55 hours outage to online website Set up 20+ monitoring/alerting in various applications to maintain extensive database performance Automating day to day activities like monitoring backups/tables/tablespaces DB2 V10.x version/fix-pack upgrades and installation on database servers and clients  Driving onshore/offshore team members, provide general oversight, task break down and allocation Troubleshooting database issues using db2top, db2pd, db2diaglog and third-party tools such as APPDYNAMICS and SOLAR WINDS. Passion to learn new technologies Core Skills: Database : DB2 V9.1, V9.5, V9.7, V10.1, V10.5 and V11.1 Operating System : LINUX/UNIX/AIX  Scripting language : UNIX shell scripting, Perl Third Party tools : BMC Control M, SQL Developer, WinSCP, Service Now, Service center, AppDynamics, Solar winds, Confluence, SharePoint Show less DB2 LUW Database Administrator Supporting 400+ databases migrated from V9.1 till V10.5 DB2 LUW Responsible for database support conducting security audits, version/fix-pack upgrades, health check remediation, database maintenance, database monitoring and alerting Set up 5+ monitoring/alerting in various applications to maintain extensive database performance Troubleshooting database issues using db2top, db2pd, db2diaglog and third-party tools such as APPDYNAMICS  Automating day to day activities like monitoring backups/tables/tablespaces Show less DB2 LUW Database Administrator  Supporting 400+ databases migrated from V9.1 till V10.1 DB2 LUW Managing Critical OLTP databases like Online trading, EAI, Data Stage  Responsible for database support conducting security audits, version/fix-pack upgrades, health check remediation, database maintenance, database monitoring and alerting  Liaising with key stakeholders and technical/functional teams Proficient in executing and supporting database related changes  Set up 5+ monitoring/alerting in various applications to maintain extensive database performance Monitor and maintain Backup/Restore, Archive logs and tables  Redirect restore/Restore/tablespace restore of databases and taking backup to TSM/Disk Managing DB2 instances, Database objects, optimizing queries and working with DB2 commands Handling file system space issues Daily monitoring of backup and schedule manual backups as needed Granting and Revoking authorities to users, groups, roles to access the database objects  Hands on experience in maintain Backup/Restore, Archive logs and tables in DB2 database running on LUW Creating, scheduling, monitoring and troubleshooting maintenance and housekeeping jobs Show less DB2 LUW Database Administrator with 1+ years of professional experience Managing Critical OLTP databases like Online trading, EAI, Data Stage  Proficient in executing and supporting database related changes  Hands on in dealing with major incidents/tickets along with multiple technical teams Everyday interaction with client and team to resolve requests/incidents/changes and manage deliverables 24*7 production support (On-call) and supporting changes/incidents on after hours/weekends Show less

      • Senior Database Administrator

        Aug 2018 - Jan 2020

      • DB2 Database Administrator

        Apr 2017 - Jul 2018

      • DB2 Database Administrator

        Oct 2016 - Mar 2017

      • DB2 Database Administrator

        Mar 2015 - Oct 2016

      • Associate System Engineer

        Sept 2014 - Feb 2015

    • Coles Group

      Apr 2015 - Jan 2020
      Senior Database Administrator

      Senior Database Administrator/ Change Coordinator Supporting 400+ databases migrated from V9.1 till V11.1 DB2 LUW Managing Critical OLTP databases like Online trading (Coles Online ) , EAI, Data Stage  Liaising with key stakeholders and technical/functional teams Driving onshore/offshore team members, provide general oversight, task break down and allocation Everyday interaction with client and team to resolve requests/incidents/changes and manage deliverables 24*7 production support (On-call) and supporting changes/incidents on after hours/weekends Major incident root cause analysis, in dealing with major incidents/tickets along with multiple technical teams, performance tuning Proficient in executing and supporting database related changes  Managed to reduce the backup run timings in Coles Online to a total of 7 hours from 10+ hours Worked on resolving major Priority - 1 incident which involved an outage of 55 hours outage to online website Set up 20+ monitoring/alerting in various applications to maintain extensive database performance Automating day to day activities like monitoring backups/tables/tablespaces  Responsible for database support conducting security audits, version/fix-pack upgrades/migrations, health check remediation, database maintenance, database monitoring and alerting  Redirect restore/Restore/tablespace restore of databases and taking backup to TSM/Disk Monitoring the database by using Snapshot & Event monitors Handling file system space issues, Configure and manage HADR environment Troubleshooting database issues using db2top, db2pd, db2diaglog and third-party tools such as APPDYNAMICS and SOLAR WINDS. Show less

    • Envestnet, Inc

      Apr 2020 - now
      Associate Lead Database Administrator

      Associate Lead Database Administrator at Envestnet, Inc. Just started working , in progress with Knowledge Transfer.

  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Gayathry Mohanan
      Pat On Back Harshvendra Soin Aug 2019 "I would like to appreciate your hard work and commitment and It has been noticed by Coles during a the activity of patching , failing over the DB and also executing a cluster manager daemon refresh Process to prevent a possible cluster memory leak (risk was high) and completed before Business starts and thereafter doing good work for proactively monitoring and fixing the database related issue and handling On-Call as well along with taking ownership of issues related of DB2. We appreciate your… Show more "I would like to appreciate your hard work and commitment and It has been noticed by Coles during a the activity of patching , failing over the DB and also executing a cluster manager daemon refresh Process to prevent a possible cluster memory leak (risk was high) and completed before Business starts and thereafter doing good work for proactively monitoring and fixing the database related issue and handling On-Call as well along with taking ownership of issues related of DB2. We appreciate your positive attitude and wish that you would keep up the good work in future too. Apart from appreciation. I wish you all the best for future growth in this company. " Show less
    • Awarded to Gayathry Mohanan
      Pat On Back Harshvendra Soin Mar 2017 Single handedly managed database systems while team lead on leave for a month and worked on priority incidents related to online trading application database.
    • Awarded to Gayathry Mohanan
      Pat On Back Harshvendra Soin Sep 2015 Brought services back online in less than 30 mins as part of a Priority 1 incident at Coles for Middleware system ,which is the backbone for connecting multiple source -target systems.