Summary
Overview
Work History
Education
Skills
Software
Languages
Timeline
Generic

Naveen Bains

Jaipur

Summary

Having 10+ Years of IT experience as PostgreSQL Database Administrator with added knowledge of AWS RDS, EDB, MongoDB and IBM Informix databases. Strengths in troubleshooting and maintaining Database and systems to support smooth business operations 24*7 environment of big OLTP platforms.

Overview

11
11
years of professional experience
3
3
years of post-secondary education

Work History

Senior Technical Lead

Genus Power Infrastructures
Jaipur
04.2024 - Current
  • Dynamic professional with 9+ years of experience in PostgreSQL DB on Linux/Unix and Windows Platform respectively.
  • Different databases working experience like PostgreSQL, IBM Informix, MongoDB, PL/SQL etc.
  • 2+ Years of experience in AWS RDS/Aurora.
  • Writer and Reader instance formation and integration on RDS/Aurora.
  • Cross-Region disaster recovery using Amazon Aurora.
  • Heterogeneous and Homogeneous migration by DMS.
  • Setup streaming and Logical replication.
  • Performed Oracle to PostgreSQL migration using EDB migration toolkit.
  • Setup Active/Passive HA Cluster with Pacemaker.
  • Upgrade DB from lower version to higher version.
  • Experience in MongoDB Installation version 4,5 and 6 Production support.
  • Experienced in Backup & Recovery using mongodump and mongorestore.
  • Experience in setting up Replication and High Availability environment of database via Replica Set.

Technical Lead

NEC Corporation India Pvt Ltd
Noida
05.2023 - 04.2024
  • Different databases working experience like PostgreSQL, IBM Informix, MongoDB, PL/SQL etc.
  • Experience in PostgreSQL Installation version 9.X,10,11,12,13,14 Production support.
  • Setup and configuration logical replication.
  • Bash scripting for DB Backup and Vacuum.
  • Setup and configuration High availability in Production environment using EFM, Patroni and Keepalive with virtual IP concept.
  • Setup EDB-PGPOOL-4.3 to balance load in Production environment.
  • Setup BARMAN tool to take full and Incremental backup of production server.
  • Planning and setup of DB architecture as per requirement, using different-2 replication and clustering methods like rsync, pg_basebackup, Patroni, logical replication, keep-alive, repmgr, pg_auto_failover etc.
  • Experience in VACUUM and REINDEX in Production Database for Maintenance Activities.

Senior DBA

Estel Technologies
Gurgaon
01.2020 - 05.2023
  • Managing large database systems supporting one or more business and technology areas.
  • Experience in PostgreSQL Installation 9.X, 10,11,12 and 13 Production support.
  • Experience in Installation and creating Hot Streaming Replication (Master and Slave).
  • Experience in setting up High Availability environment of database.
  • Expertise in building Database servers ready for production , reporting server , warehousing, Disaster Recovery (DR) setups.
  • Planning and setup of DB architecture as per requirement, using different-2 replication and clustering methods like rsync, pg_basebackup, logical replication, keep-alive, repmgr, pg_auto_failover etc.
  • Experienced in Backup & Recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in time recovery.
  • Creating index and monitoring index using Explain Plan to make better Performance of Queries.
  • Experience in VACUUM and REINDEX in Production Database for Maintenance Activities.
  • Monitoring production PostgreSQL alert logs for database errors.
  • Creating Stored Procedures, Functions, Materialized View, Triggers.
  • Upgrade DB from lower version to higher version.
  • Authored and coded logical and physical database descriptions.
  • Experience in IBM Informix Installation and Configuration.
  • Experience in creating HDR and ER Configuration on production environment of Informix database projects.

Database Administrator

Adroitest Panacea Pvt. Ltd
Gurgaon
10.2018 - 11.2019
  • Maintaining PostgreSQL Database.
  • Database design (Creating Database, Performance Tuning, database cloning, Creating Tables and Writing Queries).
  • Scheduling Jobs.
  • New Application testing and Integration through CRs.
  • Managing ACS Application and platform.
  • Coordinate with all L1 & NOC teams for arrangement of activities, regional/site testing, patching.
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
  • Tested programs and databases to identify issues and make necessary modifications.

Associate Database Administrator

MoDe India Pvt. Ltd
Gurgaon
12.2014 - 09.2018
  • Installation of Database over RHEL Operating System.
  • Patch Upgrade from 9.2.3 to 9.2.4 in production and Testing Environment.
  • Adding database Users, Adding Roles and Granting permission on Database Level, Schema Level and table level.
  • Database Recovery,backup and Restoration.
  • Monitoring Alert Log, scheduled jobs and troubleshooting database problems.
  • Resolved problems, improved operations and provided exceptional service.
  • Analyze and resolve all basic problems associated with Linux OS related issues.
  • Monitoring systems performance on regular basis.

VAS Engineer

Mahindra Comviva Technologies Ltd
Gurgaon
08.2013 - 06.2014
  • Worked in Manage Services of Airtel & handle SMSC & MCA services.
  • Managing and troubleshooting for SMSC.
  • Making reports and basic trouble shooting of MMSC and PSA through BOXI.
  • Responsible for configuration changes as for requirement..
  • Generate database reports and scripts running in system.
  • Doing various operational activities like defining new MSISDN series, short codes, ranges etc.
  • Solving issues related to Billing, HLR and SMSC teams.
  • Make daily server utilization reports and report to manager.
  • Escalation of cases internally/externally.

Education

Bachelor of Science - Information Technology

Sikkim Manipal University
Chadigarh
03.2010 - 04.2013

Skills

    PostgreSQL

AWS RDS

PL/SQL

MongoDB

IBM Informix

Linux/Unix

Manage High Availability DB Clusters

Relational Database Management

Data Modeling and Migration

ER Diagram and Data dictionary

Security and Compliance

Software

PgAdmin

PgBouncer

PgUpgrade

EDB Migration Toolkit

DMS (Database Migration Service)

PgPool

Repmgr

DBeaver

Zabbix

WireShark

Apache Superset

Languages

English

Hindi

Punjabi

Timeline

Senior Technical Lead

Genus Power Infrastructures
04.2024 - Current

Technical Lead

NEC Corporation India Pvt Ltd
05.2023 - 04.2024

Senior DBA

Estel Technologies
01.2020 - 05.2023

Database Administrator

Adroitest Panacea Pvt. Ltd
10.2018 - 11.2019

Associate Database Administrator

MoDe India Pvt. Ltd
12.2014 - 09.2018

VAS Engineer

Mahindra Comviva Technologies Ltd
08.2013 - 06.2014

Bachelor of Science - Information Technology

Sikkim Manipal University
03.2010 - 04.2013

Similar Profiles

  • Prakash Singh Rauthan

    Prakash Singh RauthanPrakash Singh Rauthan

    Senior Store Executive at Genus Power Infrastructures LtdSenior Store Executive at Genus Power Infrastructures Ltd

    View Profile
  • Ajeetabh Ajeet Srivastav

    Ajeetabh Ajeet SrivastavAjeetabh Ajeet Srivastav

    Assistan Manager Finance & Accounts at Genus Power Infrastructures LtdAssistan Manager Finance & Accounts at Genus Power Infrastructures Ltd

    View Profile
  • Pramod Jangid

    Pramod JangidPramod Jangid

    Assistant Manager at GENUS POWER INFRASTRUCTURE LTDAssistant Manager at GENUS POWER INFRASTRUCTURE LTD

    View Profile
Naveen Bains