Experience

• 

  Netambit infosource & e-services pvt. ltd.

  Jan 2014 - Feb 2017

  Database administrator (postgresql, cassandra)

  - Postgresql cluster installation, configuration and operations.- Configuring synchronous/asynchronous replication using Transaction Log Shipping to achieve high availability.- Configuring Point-in-time recovery (PITR) and performing recovery in case of failure.- Database user role management and auditing.- Writing Procedures, Function, Trigger, Perl, Shell scripts and optimization of complex queries.- Cassandra cluster installation, configuration, monitoring and maintenance.- Adding, removing and replacing nodes in Cassandra cluster.- Written plug-in in Perl which are able to communicate with web service and distribute data in different databases.- Writing scripts to perform database migration from old database structure to new database structure.- Perform migration of database server from one major version to other.- Writing scripts for legacy data upload from excel sheet to database.- Performing database maintenance, backup and restoration. Show less

• 

  Fis

  Feb 2017 - Oct 2018

  Database administrator ( pstgresql, edb, nosql, mongodb )

  - Installation, Configuration, and Administration of PostgreSQL, EnterpriseDB, MongoDB and MongoDB OpsManager on Redhat systems.- Monitoring database performance and capacity planning for databases like Postgresql, EDB, MongoDB.- Implemented replication using Transaction Log Shipping on PostgreSQL and EDB replication environments.- Data Recovery operations for PostgreSQL, EDB and MongoDB.- Performing Database Upgrdation/Migration for PostgreSQL, EDB, MongoDB and OpsManager.

• 

  Adobe

  Oct 2018 - now

  - Led categories of problem we get, doing the analysis and brainstorming upon solution into implementation along with communication stack-holders.- Writing bugs/features/enhancements for products as part of Software release in Sprint based environment.- Developing tools for projects or daily activities that helps customers e.g., provisioning of customers, database/RDS mass upgrades of major version.- FinOps – Working into ETL driven cost optimization which involves warehouse data management, report creation and actions to make sure cost optimizations.- RDBMS/DBA concepts including complete administration of PostgreSQL.- Performance optimization and replication management, Cloud cost efficiency. Show less - Writing bugs/features/enhancements for products as part of Software release in Sprintbased environment- Responsible for database reliability along with tuning and optimization.- Working on cloud technologies like AWS, Azure along with few legacy hypervisor-container data centers.- Amazon RDS Handling and monitoring.- Azure Managed database optimisation. - Automating certain day to day repetitive tasks via scripting (Python, shell scripting, Ansible etc.)- Deployment of new versions of application from end to end using automation, CI/CD tools like Ansible, Rundeck etc.- Working on different database technologies like PostgreSQL, MongoDB etc.- Proactively monitoring application and database alerts via key tools like New Relic monitors, Nagios, Splunk for logging etc. Show less

  • Computer Scientist-II

    Feb 2024 - now

  • Computer Scientist

    Jan 2021 - Feb 2024

  • Site Reliability Engineer,Database

    Oct 2018 - Jan 2021