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 replication
Configure Barman server for new database cluster
Install PostGIS/pgAudit and other required extension
Responsible 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 DBA
Understanding 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, Python
Technical knowledge of Linux & Windows-based platforms
Strong analytical and problem-solving skills
LDAPs 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
How strong is your resume?
Upload your resume and get feedback from our expert to help land this job
How strong is your resume?
Upload your resume and get feedback from our expert to help land this job