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.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.