Role PurposeInstallation configuration upgrade administration monitoring maintenance production support and developer support of database environmentsResponsibilitiesDesign and create relational databasesDatabase Performance Monitoring and TuningAlways ensure Database AvailabilityDatabase Security and AuthorizationDatabase Backup and RecoveryDevelop and maintain a database backup strategyMaintain Data IntegrityDBMS Release MigrationDatabase ArchitectureData ModellingAdditional RequirementsExperience in PostgreSQLUnderstand audit and complianceLinux Red Hat Enterprise experienceData archiving and high availabilityServer Setup and OperationsCreating Database Cluster and Management there-offManaging the Security of the DatabaseReview logs for the Server on Audit EventsServer ConfigurationSetting Parameters to comply the bank standards for PostgresUser Access Management for DatabasesAccess and Permissions for all instancesAudit Management of the Databases and serversCapacity Management of the database environmentBackup and Restore of the DatabasesRestore testingBackup testingrebuild of environments for DRHigh Availability ManagementLogical ReplicationStreaming replicationBuilding and Managing High AvailabilitySQL Query and Statements UnderstandingExtensive experience on SQL Statement and Stored ProceduresPGADMIN administrationMonitor Database ActivityMonitor Database Disk UsageWAL log file Management of Large databasesVacuum ManagementUnderstanding of Table PartitioningQualifications and ExperienceRelevant Degree in Computer Science or Information Systems or related field.5 Years related experience.