Codvo - Database Administrator - PostgreSQL (8-10 yrs)

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.

Time : 2:30PM to 11:30PM.