ECMS Request Number* ECMS ID# 464522 (2-5 Yrs.) ECMS ID# 464525 (5-8 Yrs.) Number of openings 2 Job Title* PostgreSQL DBA Work Location & Reporting Address* Bengaluru Vendor Rate* 2-5 Yrs. 4971 INR/Day 5-8 Yrs. 6214 INR/Day BGV Check Pre - Onboarding Must Have Skills (Top 3 technical skills only) * - PostgreSQL Database Support , PostgreSQL Streaming Replication, Linux . Nice to have skills (Top 2 only) : AWS RDS , Linux Shell Scripting Detailed Job Description: : Must have expertise in Installing, configuring, securing and managing Postgresql to ensure better performance. :Should be be able configure and maintain streaming replication. :Able to configure jobs for routine activities and troubleshooting them in case of failures. :Familiar with backup/recovery strategies. :Able to understand and work with BARMAN backup tool. :Creating database users, controlling access and making sure right people get access to right data and looking after the security issues. :Should have working experience on EPAS 14 , EPAS15 , PostgreSQL 13,14,15. :Ability to perform all Database Administration (DBA) tasks like performing installations, database backups and recovery, monitoring logs and hard disk consumption growth rate etc. :Configuring and Maintaining and troubleshooting the Database replication and experience in DR activities. :Performing Maintenance Tasks such as Vacuum, Vacuum full, Analyze on required tables. :Troubleshooting Space issues and performing Capacity Planning for Production Database servers by clearing old backups and logs. : Database performance monitoring and tuning when required as per application and business requirements. Minimum years of experience*: 4 to 6 and 6 to 8 .