Senior PostgreSQL Database Administrator

Job Description

• This Candidate is responsible for full life cycle support of client and internal database(s).
• This Candidate is responsible for Developing Stored Procedures, Functions, Packages, and Database Triggers in support of application development.
• This Candidate is responsible for building Database Relational Structure including tables, views, and relations.

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 Procedures, Functions, Packages, and Database Triggers in support of application development.
• Participate in application development projects and be responsible for 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.
• Support complex web-based applications.
• Perform other duties as assigned.