What are the responsibilities and job description for the PostgreSQL Engineer position at SysMind Tech?
This specific posting is for a software / infrastructure engineer with experience in installing, configuring, patching, upgrading, deploying and running Postgres databases. The candidate will put these skills to use by evaluating and preparing new and upgraded Postgres and Postgres-compatible offerings for use across the company, and by documenting, presenting and explaining the appropriate techniques, patterns and best practices for our hosting, database administration and operational support teams.
The candidate will bring solid knowledge of DBMS concepts such as ACID, CAP and consistency. The ideal candidate will have experience with enterprise-scale Postgres deployments, including intra- and inter-data-center high availability configurations, fault tolerance and failover, physical and logical replication, cluster management, automated provisioning, rolling upgrade techniques, backup & restoration techniques, security mechanisms, health monitoring and alerting techniques, and troubleshooting. The candidate will also bring knowledge of Postgres internals such as durability and replication settings, and performance tuning.
Additional desirable attributes
- Skill at the Unix command line
- The ability to write code or script, e.g. for test harnesses or other database-related tools and utilities
- Experience as a database administrator and / or a Unix system administrator
- Knowledge of virtualization and cloud infrastructures, and of implementations such as VMWare, OpenShift, Kubernetes and Docker
- Knowledge of AWS, Google Cloud, Azure or other public cloud offerings
- Knowledge of modern storage and compute technologies, including hyper-converged infrastructures
