Job Title: PostgreSQL Database AdministratorCompany 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.Job Description:  We are looking for an experienced 8 to 10 years and detail-oriented PostgreSQL Database Administrator to join our dynamic team. The ideal candidate will be responsible for managing and optimizing PostgreSQL databases, ensuring high performance, and assisting in the design and implementation of database systems. You will also play a key role in database troubleshooting, backups, migrations, and scaling solutions to meet company needs. 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: Work with developers to optimize application queries and database design. 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. 

Summary:  This role is pivotal for ensuring the seamless operation of PostgreSQL databases and their integration into scalable, high-performance solutions. The candidate’s expertise in advanced PostgreSQL features, cloud platforms, and distributed database solutions will contribute significantly to achieving our organization’s goals.