PostgreSQL Dba

**Job Title: PostgreSQL Database Administrator**

**Company Overview**:

- At Codvo, software and people transformations go together. We are a global empathy-led technology services company with a core DNA of product innovation and mature software engineering. We uphold the values of Respect, Fairness, Growth, Agility, and Inclusiveness in everything we do.

**Key Responsibilities**:
**Documentation & Collaboration**:

- Ability to write structured documentation in Markdown, Confluence, or dedicated documentation tools.

**Database Reverse Engineering**:

- Understanding schema visualization, entity-relationship (ER) modeling, and dependency tracing.

**Database Design & Management**:

- Design, implement, and manage PostgreSQL database systems.
- Perform regular maintenance of PostgreSQL databases, including updates, backups, and restores.
- Ensure database availability, reliability, and performance tuning.

**Optimization & Troubleshooting**:

- Monitor and optimize the performance of PostgreSQL databases.
- Write efficient SQL queries, create stored procedures, and optimize queries for better performance.
- Troubleshoot and resolve database issues, performance bottlenecks, and outages.

**Backup & Disaster Recovery**:

- Implement and maintain regular backup and disaster recovery processes for databases.
- Perform database replication and clustering for high availability.

**Security & Compliance**:

- Enforce database security policies, including user access management and data encryption.
- Ensure compliance with relevant data protection regulations and standards.

**Collaboration & Development**:

- Assist in database migrations and upgrades to new versions of PostgreSQL.
- Participate in code reviews, system design discussions, and database architecture planning.

**Skills & Qualifications**:
**Experience**:

- Proven experience as a PostgreSQL Database Administrator.
- Strong knowledge of PostgreSQL database design, administration, and performance tuning.

**Technical Skills**:

- Proficiency with SQL and PL/pgSQL
- Experience with PostgreSQL clustering, replication, and sharding.
- Familiarity with database backup tools (pg_dump, pg_basebackup) and high-availability techniques (replication, failover) tools like patroni, pgpool2 etc.
- Understanding of PostgreSQL performance tuning, indexing, and query optimization.

**Preferred Skills**:

- Should have experience in Azure-managed databases.
- Ability to manage databases (specifically Percona Postgres Distribution) in Kubernetes environments.
- Expertise in managing Postgres databases on cloud virtual machines (VMs).
- Proficiency in configuring distributed storage solutions like Citus.
- Experience in database partitioning to optimize large datasets.
- Should have experience in configuring tablespaces in PostgreSQL.

**Additional Skills**:

- Knowledge of containerization technologies and orchestrations such as Docker,kubernetes for PostgreSQL deployment.
- Experience with cloud platforms (AWS, Azure, Google Cloud) and PostgreSQL in the cloud. Familiarity with scripting languages like Python, Bash, or Shell scripting for automating database operations.