Innovecture

Database administrator

Mexico

2 months ago
Save Job

Summary

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

People also searched: