Experience

Aptus Data Labs

• India
• IT Services and IT Consulting
• 1 - 100 Employee

• Consultant DBA

  • Jun 2019 - Present

  ➨ Hands-on experience in installation, configuration and administration of Vertica OLAP environment➨ Responsible for upgrading and patching the database in Production environment, planned and upgraded Vertica 7.x to 9.x and 9.x to 10.x in phases as per Business requirement ➨ Performing several Audits for Vertica environment as per Financial and Banking requirements➨ Managing security and access controls for end users, defining roles, granting and revoking permissions at schema/table level, and maintaining database user and system operation logs for in depth usage and cluster performance analysis➨ Assist Business development teams and ETL developers with Query tuning & optimization, re-designing projections, efficient Bulk loads, etc. to improve user experience➨ Integrating and maintaining cold/archive storage for External Tables using Parquet/csv file formats➨ Automating Infrastructure maintenance by developing bash scripts , scheduling cronjobs, advanced DB and backup monitoring, and a proactive database health check/alert mechanism➨ Manage and provision backup and object/schema/database level restorations in Vertica. Plan and execute Vertica monthly maintenance activities, and assist teams with 24x7 support for minimal Business impact➨ Work closely with Project managers and decision makers on capacity planning, database migration and other major data warehouse activities



Netxcell Limited

• Telecommunications
• 200 - 300 Employee

• L2 Engineer

  • May 2015 - Jun 2019

  ➨ Install, configure and maintain multiple instances of MYSQL with multiple version (5.x) on Linux servers based on Business requirement➨ Handling and providing service support of products and service deployed for various clients locations for operators such as Airtel, IDEA, LEO, MTN, ZANTEL➨ Worked on setting up Master-Slave and Master-Master architecture, participated in daily weekly and bi-monthly status meetings and assisted developers to ensure upcoming deployments are correctly implemented and supported➨ Managed Security requirements, created roles, granting and revoking required permissions, and troubleshoot any reported problems at application level or query level➨ Worked as an active team member, and provided satisfactory resolutions for Issues raised by the L1 team, complete all testing activities according to schedule as a team, and performed monthly maintenance activities for Linux and Windows Servers➨ Automated and scheduled backups using Cronjob, performed daily health checks for servers, and monitored services using Nagios tool



Wipro

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Sr. Associate

  • Aug 2013 - Feb 2015

  ➨ Worked as a Front Line Agent and Solving technical Issues raised by Customers of USA➨ Achieving Team's requirement and completing the set of Targets assigned➨ Worked with US customers, resolved incidents within agreed SLA's and closed tickets with proper RCA➨ Played a role as major contributor to meet monthly Team targets➨ Addressing the customer needs and maintaining product services➨ Working in extended shifts to meet company & client's requirement and received accolades for performance across various teams➨ Delivering expertise solutions to the clients