Job responsibilities: migrate databases from on-premises to azure flexible postgres servers.perform backup and restore of postgres databases.provision azure flexible postgres servers.build/configure postgres database cluster and replicationconfigure barman server for new database clusterinstall postgis/pgaudit and other required extensionresponsible for the monitoring and uptime of all production databases.estimate postgresql database capacities; develop methods for monitoring database capacity and usage.lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.develop stored procedures and database triggers in support of application development.participate in application development projects and be responsible for the database architecture and design.participate in the creation of development, staging, and production database instances, and the migration from one environment to another.responsible for developer sql code review to ensure queries are optimized and tuned to perform efficiently prior to production release.responsible for regular backups and recovery of databases.responsible for regular maintenance on databases (e.g., vacuum, reindexing, archiving).responsible for pro-active remediation of database operational problems.responsible for query tuning and preventative maintenance.participate in a weekend support for database migrations to cloud.perform other duties as assigned. Required skills: at least 6+ year's hands-on experience as postgres dbaunderstanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code.encryption(tls 2)strong dba experience – postgres.write efficient queries.strong scripting experience - unix/shell scripting, pythontechnical knowledge of linux & windows-based platformsstrong analytical and problem-solving skillsldaps configuration for authentication desired skills: hands-on experience in azure and aws
oracle dba experience will be a plus.
disaster recovery and business continuity
postgres xl