Database Admin - PostgreSQL at Codvoai · Remote only · 8 - 13 years · ₹20L - ₹40L / yr · Raised funding · Remote only · Posted 4 Feb 2025

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:30-11:30PM

About Codvoai
About
At Codvo, we accelerate Cloud, AI, and Transformation roadmaps while offering most satisfying mix of work-life balance, quality of living, and cutting edge work to our employees.
We deliver value through our unique "Virtual Silicon Valley" model where we bring seasoned experts and global talent together as a Product Oriented Deliver (POD) unit to successfully deliver on your next roadmap priorities.
Our “Virtual Silicon Valley” PODs deliver better success and speed because they are self-managed, have right expertise mix, and most importantly are aligned to work in your time zone. The goal is to balance speed, expertise mix, and cost while ensuring the success of core product development, design, and transformation activities.
We are proud to have our customers ready to vouch for us and share their success stories. Our teams of scientists, engineers, architects, and designers have helped AI-driven companies, fast-growing Fintechs, Wealth Management & Healthcare startups, Energy companies, and US Defense contractors accelerate their product and transformation roadmaps.
Photos
Connect with the team
Similar jobs (10)
Job Summary
Responsible for administration of Postgres databases with secondary skills in administration of
DB2, Oracle, MS-SQL, Clickhouse, Neo4J.
Skill Requirements:
5+ years of experience in Postgres database administration
DB design (Architecture design principles, modelling, partitioning, setting standards and
normalisation), installation, managing schemas, performance tuning, parameter tuning,
storage management, DB maintenance, patching, upgrade, back-up & recovery, High
availability ,replication and capacity planning.
Coding Stored procedures
Working with Linux OS including shell scripting.
Strong experience in AWS and Azure environment.
Experience with an organisation with reliance on 24x7 database services.
Must be an initiative-taker & analytical person with good communication and
interpersonal skills.
Key competencies
Postgres database administration
Skills on other database technologies like DB2, Oracle, MS-SQL, Clickhouse
Cloud services - AWS and Azure.
We have an opening for a PostgreSQL Developer with Cloud Sara Technologies Pvt. Ltd.
Job Details:
• Experience: 1.5–3 Years
• Location: Chennai
• Employment Type: Full-Time
• Budget: Up to ₹6 LPA
• Joining: Immediate joiners only
Required Skills:
• Hands-on PostgreSQL experience
• SQL queries, views, stored procedures, and custom functions
• Triggers and indexing strategies
• Query optimization and execution plan analysis
• Troubleshooting slow queries, blocking sessions, deadlocks, and database locks
Please let me know if you are interested and available for an immediate joining.
Postgress Developer
Experience: 1.5 to 3Years
Location: Chennai
Type: Full Time
Budget: 6LPA
Immediate joiners only
Roles & Responsibilities:
Hands-on experience writing efficient SQL queries, views, stored procedures, custom functions, indexing strategies.
Analyse execution plans, and triggers.
Ability to Identify and resolve blocking sessions, deadlock issues, slow queries, and database locks in high-concurrency environments.

Postgress Developer
Experience: 2 to 5 Years
Location: Chennai
Type: Contract
Duration : 6+ Months
Immediate joiners only
Roles & Responsibilities:
Hands-on experience writing efficient SQL queries, views, stored procedures, custom functions, indexing strategies.
Analyse execution plans, and triggers.
Ability to Identify and resolve blocking sessions, deadlock issues, slow queries, and database locks in high-concurrency environments.
PostgreSQL Developer – Chennai
Experience: 2–5 Years
Location: Chennai
Employment Type: Contract
Contract Duration: 6+ Months
Immediate Joiners Only
Payroll: Candidate's existing payroll will continue (Payroll stays with you).
Job Description
We are looking for an experienced PostgreSQL Developer with strong hands-on experience in SQL development, database optimization, and troubleshooting.
Roles & Responsibilities
- Write and optimize efficient SQL queries, views, stored procedures, and custom functions.
- Develop and implement indexing strategies for better database performance.
- Analyze SQL execution plans and optimize query performance.
- Work with database triggers and troubleshoot database-related issues.
- Identify and resolve blocking sessions, deadlocks, slow queries, and database locking issues.
- Handle high-concurrency database environments and ensure optimal performance.
Required Skills
- PostgreSQL
- Advanced SQL
- Stored Procedures & Functions
- Views & Triggers
- Indexing & Query Optimization
- Execution Plan Analysis
- Deadlock & Lock Management
- Performance Tuning
Interested candidates can share their updated resumes.
Job Description (JD) for the MySQL Database Administrator role
Experience: 4-8 Years
Location : Mumbai
Job Title: MySQL Database Administrator
Responsibilities
- Provision and configure MySQL database instances in clustered and non-clustered environments.
- Ensure database performance, security, availability, and reliability.
- Prepare and maintain database documentation, technical specifications, and operational procedures.
- Perform database upgrades, backups, restoration, recovery, and migrations.
- Monitor database and server resource utilization and perform performance tuning and optimization.
- Manage database users, access privileges, periodic access reviews, audits, and documentation.
- Configure, monitor, and troubleshoot MySQL replication.
- Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues.
- Provide database and application deployment support, as required.
- Perform database backup and restoration validation, data integrity checks, and post-migration validations.
- Follow database change management, security, and operational best practices.
Skills and Qualifications
- Strong hands-on experience in MySQL database administration.
- Good working knowledge of recent MySQL versions, preferably MySQL 8.x.
- Understanding of MySQL storage engines, including InnoDB and MyISAM.
- Practical experience in configuring, monitoring, and troubleshooting MySQL replication.
- Knowledge of MySQL administration best practices, security, and high availability.
- Proficiency in writing, analyzing, and optimising SQL queries.
- Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring.
- Ability to assess database resource requirements based on application workloads and technical specifications.
- Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB.
- Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds.
- Working knowledge of version control tools such as Git, SVN, or CVS.
- Graduate degree in a relevant discipline and good verbal and written communication skills.
Good to Have
- Basic Linux administration, command-line troubleshooting, and Bash scripting skills.
- Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly.

Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.
We are seeking an experienced Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post–go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration.
What you will do?
- Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
- Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
- Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
- Identify, troubleshoot, and fix database-related application bugs.
- Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
- Support and monitor AWS DMS during full load and CDC phases.
- Diagnose and resolve DMS data and performance issues.
- Perform data validation and reconciliation between Oracle and PostgreSQL.
- Collaborate with application teams to align SQL behavior and performance expectations.
What are we looking for?
- Bachelor's degree in Computer Science or a related field.
- 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
- Strong experience with Oracle Database and PostgreSQL / Aurora PostgreSQL.
- Hands-on expertise in Oracle to PostgreSQL migration.
- Advanced SQL and query performance tuning skills.
- Experience with AWS SCT and AWS DMS.
- Knowledge of Flyway/Liquibase or similar schema migration tools.
- PostgreSQL internals: indexing, statistics, execution plans.
- AWS services: RDS/Aurora, CloudWatch, IAM (preferred).
You will be preferred if:
- Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet.
- Familiarity with IAAC tools such as Terraform, CloudFormation.
- Familiarity with CI/CD implementation tools like Liquibase/Flyway.
- AWS Certified Database – Specialty.
- AWS Certified Solutions Architect.
Role overview:
· Technology Expertise & DBA Skill Set
· Cloud Platforms: AWS, Azure
· Database IaaS: Oracle, Microsoft SQL Server, PostgreSQL
· Database PaaS: CosmosDB, MySQL, SQL Managed Instance, RDS Aurora, MongoDB
· Infrastructure as Code: Terraform, Ansible
· CI/CD & Automation: GitHub Actions, GitLab, Azure DevOps
· Programming & Scripting: Python, Bash/Shell, PowerShell
· Operating Systems: Linux/Unix (RHEL, Ubuntu), Window
Database Team Overview
Our Database Team is the foundation of enterprise-grade databases delivering secure, compliant and high-performing database platforms across Azure and AWS. We provide managed services for Oracle and Microsoft SQL Server, operating in a system DBA role to ensure platform reliability, resilience, and operational excellence. In addition, we support PaaS and RDS database services by acting as the platform team defining policies, enforcing security standards, and managing networking configurations while enabling self-service capabilities for application teams to consume these services efficiently.
What would you do here:
· Database Security & Compliance: Implement robust security controls, encryption, and auditing to safeguard sensitive data and meet regulatory requirements.
· Lifecycle Management: Oversee patching, upgrades, and end-of-life transitions to maintain platform stability and minimize risk.
· Performance Optimization: Monitor and tune databases for optimal performance across diverse workloads.
· Automation & Operational Excellence: Design and deploy automation for provisioning, monitoring, and maintenance to achieve “brilliant basics” and reduce manual intervention.
· Business-Critical Certification: Validate and certify database environments to support mission-critical applications with high availability and disaster recovery strategies.
· Incident & Problem Management: Provide rapid response and root-cause analysis for database-related incidents to ensure business continuity.
· Capacity Planning & Scalability: Forecast growth and optimize resources to support evolving business needs.
Best Regards!
Job Description:
Mandatory Skills: Linux Administration, Production Support, Database Support, and Monitoring & Observability, with exposure to Cloud and Automation.
Primary Skills: Linux Administration, Production Support
Secondary Skills: Oracle SQL, Splunk, Grafana, AppDynamics, Cloud (OCP/AWS/Azure/GCP), Incident Management, AI/Automation (Good to have)

Location: Bangalore
Experience: 6+ Years
Role: Java Backend Developer
Required Skills:
Java.
PostgreSQL / Database Management.
AWS services such as:
AWS ECS
AWS Lambda
How to Apply
Interested candidates can share their updated resumes:
Email: revathi.r @vysystems. com
WhatsApp: 6 3 8 5 0 7 6 1 4 2










