Job Description

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.

Job Description:
We are looking for an experienced 8 to 10 years and detail-oriented PostgreSQL Database Administrator to join our dynamic team.

Key Responsibilities:
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.

Experience - 8-10 years
Location - Remote