Postgresql DBA

Job description Roles and Responsibilities:

· 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, Rendering, Archieving)

· Responsible for pro-active remediation of database operational problems

· Responsible for Query tuning and preventative maintenance