• Responsible for the monitoring and up time 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 for downtime. • 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 of databases (e.g., Vacuum, Reindexing, Archiving). • Responsible for proactive remediation of database operational problems. • Responsible for Query tuning and preventative maintenance.
Requirements
• +4 Years of relevant experience. • BS/MS degree preferred in Computer Science, Engineering, or a related subject. • Must have experience in PostgreSQL ver 9.3 or higher. ( we are running version 13 ) • Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc. • Must have strong knowledge of Linux. • Strong understanding of command line and server administration. • Must have strong analytical, verbal, and written communication skills. • In-depth knowledge of community version PostgreSQL architecture version 9.3 (or higher). • Preferred to have experience in PostgreSQL architecture ver 13. • Experience investigating/troubleshooting PostgreSQL performance issues with native Postgres catalog and statistics • Experience with streaming and logical replication, HA, Backup and Recovery, and Maintenance utilities including setup, configuration, and monitoring