Postgres DBA

You should have at least 6+ years of experience working as a PostgreSQL DBA or in a similar database administration role. Your responsibilities will include demonstrating a strong understanding of PostgreSQL architecture, installation, configuration, and management. Proficiency in SQL, PL/pgSQL, and implementing database optimization techniques is crucial for this role. Experience with PostgreSQL replication methods such as streaming and logical replication is required. You should also possess a robust knowledge of database security practices and be well-versed in data privacy laws. Familiarity with backup and recovery techniques and tools like pg_dump and pg_restore is essential. Additionally, experience with cloud database platforms like AWS RDS for PostgreSQL and Azure Database for PostgreSQL is preferred. You should be proficient in Linux/Unix systems administration and have a good grasp of scripting languages such as Bash and Python. Knowledge of other skills, such as PostgreSQL on Kubernetes or containerized environments, NoSQL databases, and relational databases like MySQL and Oracle, is considered a plus. Understanding automated deployment tools like Ansible and Chef, as well as experience with monitoring tools like pgAdmin, Prometheus, and Grafana, will be beneficial in this role.,