Senior DBA PostgreSQL Engineer (Remote & Hiring Immediately)

Duties and responsibilities:

• 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.

Job 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.