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.
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.
Implement and maintain regular backup and disaster recovery processes for databases.
Perform database replication and clustering for high availability.
Enforce database security policies, including user access management and data encryption.
Ensure compliance with relevant data protection regulations and standards.
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.
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.
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.
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.