DBA job

Full–time
TATA Consultancy Services Limited AWS Administrator 1013182 Ravindra Navada Bangalore FSIT Postgre administrator Part of team NA Experience on installation of different versions of Postgre on Redhat Linux Environment Good knowledge of Linux Scheduling shell scripts on LINUX environments Postgre10.x,11.x EDB postgre advanced server -Postgre based AuroraDB -EDB postgre tools -ORA2PG,PG Cluu , PGClinet, Toad tools, -PGadmin and other tools for backup and admin -Oracle basic knowledge Postgres Enterprise Manager, Backup and Recovery Tool, PgAdmin, Repmgr, Pg-Pool, Pg- Bouncer and Pg-Badger. Experience on EDB failover manager for Automatic failover Experience in configuring logical backups (pg_dump), online backup (pg_basebackup) and in configuring WAL backup (Archiving), hot standby and Warm standby Migrating database from different RDBMS to PostgreSQL Experienced in Backup & Recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, PGBASE BACKUP using BART. Implemented and Configured PostgreSQL Replication for more than one hot Standby and also handled concepts like transferring WAL to standby machines to make sure zero percent data loss. Perform day-to-day administration of postgre databases, including security, backup/recovery, capability planning and performance tuning. Perform feasibility studies for installation Monitor database performance and recommend improvements for operational efficiency. Capacity planning, space management and data maintenance activities for database system. Perform database enhancement and modification as per the requirements. Perform database recovery and backup tasks on daily and weekly basis