Understanding the requirement of project and created the Database accordinglyb) Created the stored procedure for updating the DB tables as required .c) Defining the procedure step wise to update Databased) Define the automated Sync Process for data syncing from Production to Live servere) Migrating the Data-set in other form(CSV,Mysql) to Postgresqlf) Database Backup Concepts and Optionsg) Features of different Postgresql versions and their usageh) Modifying database structures including tablespaces,tables,views, triggers,stored procedures I)Moving database Schema changes to stage or productionJ)Do general technical trouble shooting and give consultation to development teamsK)Data Transferring With export/import utilities and SQL * Loader.l)Implement and maintain database security (create and maintain users and roles, assign privileges)m)Table fragmentation tuning, Partitioning the exist large table by range via dbms_redefinitionn)Analyzing the objects using DBMS_STATS and Analyzeo)Provide on-call support regarding production-related database problems along with other environmentp)Plan growth and changes (capacity planning)

1. Responsible for Postgresql DBA activities like Database Creation,Tablespace management, User management, Table/Index management, Query optimization .2. Experience in installation, upgrading and migrating various versions of database on different platforms3. Implementation and maintaining Database Security (create and maintain users and roles, assign privileges).4. Installation and configuration of postgresql, Space management & Storage management.5. Implementation of backup,recovery strategies, performance tuning and streaming replication6. Monitoring the performance of database and documentation7. System administration on Linux/Centos 8. Preparing Daily Sync process for each cities on day to day basis9. Setting the table-spaces for the data and indexes so that it offers maximum speed.