Opening for Postgree

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.

We are looking for a Database Developer (PostgreSQL) .

Requirements

- 5+ years of hands-on PostgreSQL experience in a production or production-adjacent context 

- Strong SQL skills, including joins, aggregation, common table expressions, window functions, upserts, and DDL

- Ability to read execution plans and use a systematic approach to diagnose and rewrite slow SQL statements

- Practical understanding of transactions, isolation levels, locking, and MVCC

- Experience with physical database design, including tables, keys, constraints, indexes, and partitioning

- Practical experience with data migrations, including bulk or incremental loads, cutovers, and validation

- Practical backup and restore experience, including retention, point-in-time recovery, or restore testing

- Ability to write reliable operational scripts and idempotent reconciliation or backfill processes

- Basic Python experience for data loading and operational scripting.

Nice to have

- Experience with a schema migration tool such as Alembic, Flyway, or Liquibase 

- Experience managing declarative partitioning at scale

- Experience with managed cloud PostgreSQL

- Experience tuning PostgreSQL statistics, autovacuum, bloat, and lock contention

Database Engineer (PostgreSQL) | 5+ Years | Bangalore

We are looking for a Database Engineer (PostgreSQL) with 5+ years of experience to manage, optimize, and maintain PostgreSQL databases. The ideal candidate will have expertise in PostgreSQL, SQL Optimization, Database Design, Performance Tuning, Data Migration, and Backup & Recovery.

Responsibilities:

• Design, develop, and maintain PostgreSQL databases.
• Optimize SQL queries and improve database performance.
• Perform database design, indexing, and schema management.
• Execute data migration, backup, recovery, and disaster recovery activities.
• Monitor database health and troubleshoot performance issues.
• Collaborate with development teams to ensure scalable database solutions.

Requirements:

• 5-9 years of PostgreSQL database experience.
• Strong SQL and performance tuning skills.
• Knowledge of database backup, recovery, and migration processes.

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.

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.

Job Description: 

• Understand existing databases and develop schemas, tables, indexes, relationships, constraints, stored procedures, and data access patterns. 

• Design and build the target database structure based on application requirements and business logic. 

• Define database architecture, data models, table structures, indexing strategies, and performance optimization approaches. 

• Support mapping of existing database objects and data access logic to the target Java application architecture. 

• Develop and validate SQL queries, database scripts, and data access components. 

• Assess data migration requirements, data integrity, reconciliation, and compatibility. 

• Support database testing, performance tuning, troubleshooting, and production readiness. 

Experience – 8-10 Years 

Location – Preferably Bengaluru 

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