Database support Engineer

Create the objects in the database, such as triggers, indexes, etc. Able to setup streaming replication between two databases Monitor the performance of the database and ensure optimum performance. Identify potential issues in the database to solve them early. Maintain backups and should be able to restore the database Monitor security and apply preventive measure to adhere security guidelines Schedule consistent maintenance on the server Maintain database schema Manage database availability Give best practice guidance to the development team Resolve any production data issues Taplespace management Role and privilege management Develop automation technologies to accelerate the process of data loading. Develop relational databases Ensure data integrity Manage user access and permissions by adding and removing users as required Maintain the database using different utilities. This includes using like pg_ctl and psql. Should be able to write complex queries, function / procedure to get required data Should be able to analyse cost of the query and do necessary changes to improve performance. Experience of AWS(Snapshot backup, RDS creation & restoration, monitoring, performance insight, Major & Minor versio upgrade). Cloud experience is must. Requirements Postgres Database Admin L2, AWS, Job Location: PUNE/Mumbai