Postgress Developer

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.

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.

Data Platform Engineer

Design, automate, and scale our data platform — this is an engineering role, not a traditional "DBA job.

Must-have :

• Data modeling & schema design (from first principles, not just maintenance)
• PostgreSQL (deep, hands-on — partitioning, replication, tuning)
• Any distributed NoSQL store (Cassandra, ScyllaDB, or similar wide-column/distributed DB) (real production experience)
• Python (automation & tooling, not just scripting)
• DevOps & CI/CD (building pipelines, not just using them)
• Terraform (infrastructure-as-code)

You'll:

• Design schemas, partitioning strategies, and lead the Postgres → Cassandra migration end-to-end
• Own PostgreSQL performance, replication, and zero-downtime schema changes
• Build Python-based automation to eliminate repetitive DB work
• Own CI/CD pipelines and Terraform-based infra provisioning
• Drive uptime, DR, monitoring, and incident response
• Own multi-tenant security (RLS, least-privilege access) and data governance

Experience: 4–9 years, data/database/platform engineering in demanding production environments.

Bonus: Kafka/Debezium (CDC), Redis, Flyway/Liquibase, GDPR/DPDP exposure.

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. 

Job Summary

We are looking for a skilled Python Backend Developer with strong hands-on programming experience and a good understanding of SQL, databases, REST APIs, and backend development. The ideal candidate should have experience developing, maintaining, and optimizing backend applications, along with strong debugging and problem-solving skills.

Key Responsibilities

• Develop, maintain, and enhance backend applications using Python.
• Write, optimize, and manage SQL queries, including joins, subqueries, and complex queries.
• Work with relational databases such as PostgreSQL, MySQL, or SQL Server.
• Develop and integrate RESTful APIs for backend services.
• Perform debugging, troubleshooting, and performance optimization.
• Write unit tests and ensure code quality and application reliability.
• Use Git for version control and collaborative development.
• Collaborate with frontend developers, QA teams, and other stakeholders.
• Support data processing and ETL-related activities.

Required Skills

• Strong hands-on experience in Python programming.
• Good knowledge of SQL, joins, subqueries, and query optimization.
• Experience working with PostgreSQL, MySQL, or SQL Server.
• Knowledge of REST APIs and backend development concepts.
• Understanding of debugging, testing, and troubleshooting.
• Hands-on experience with Git and version control.
• Strong analytical and problem-solving skills.

Preferred Skills

• Experience with Python frameworks such as Django, Flask, or FastAPI.
• Knowledge of data processing and ETL pipelines.
• Familiarity with cloud platforms such as AWS or Microsoft Azure.
• Understanding of application deployment and backend architecture.

​Kindly fill the Details :-

Job Title: Senior Data Engineer

Position Summary

We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.

Key Responsibilities

• Design, develop, and maintain reporting infrastructure and data platforms.
• Build and optimize complex SQL queries, data models, and reporting datasets.
• Develop scalable ETL/ELT pipelines and data integration processes.
• Design and maintain database schemas to support analytics and reporting requirements.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Implement data quality, governance, and performance best practices.
• Support and enhance enterprise reporting solutions and dashboards.
• Work with large-scale datasets in cloud data warehouse environments.
• Troubleshoot reporting issues and optimize database performance.
• Partner with engineering and product teams to establish sustainable data architecture.

Must Have: Technical Skills

• PostgreSQL
• Snowflake
• Advanced SQL
• Data Modeling
• Data Warehousing
• Reporting & Analytics Infrastructure
• ETL/ELT Development
• Query Performance Tuning

Success Profile:

The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.

Experience Range: 5-10 years

Role Type: Individual Contributor / Senior Engineer

Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.

Senior Database Administrator (DBA)

Database Reliability & Performance  •  Senior Individual Contributor

• Experience: 6–9 years in production database administration / engineering
• Level: Senior Individual Contributor (hands-on)
• Function: Data Platform — reliability, performance, and governance across relational and distributed SQL & NoSQL DBs.

About the Role

We are hiring a Senior Database Administrator to own the health, performance, and reliability of the data layer behind a high-scale, multi-tenant platform. Our environment spans several independent PostgreSQL database instances, a cache-first read tier, change-data-capture pipeline, analytics and archival stores. Should be capable of implementing NoSQL stores (Cassandra / ScyllaDB) & MySQL  end to end as we scale.

This is a hands-on senior IC role for someone who has run demanding production databases and wants full ownership: partitioning and maintenance, performance tuning, monitoring, uptime, disaster recovery, and the security and data-governance documentation that keeps a regulated, multi-tenant platform audit-ready. You will work closely with, and take direction from, engineering leadership — translating priorities into a well-run, well-documented data platform.

What You'll Own

PostgreSQL Depth

• Administer multiple production PostgreSQL instances (v16+), including schema/DDL review, migrations, and release coordination.
• Design and maintain table partitioning strategies (range/hash/time-based) and automate partition lifecycle — creation, retention windows, and safe drops.
• Own query and instance performance tuning: EXPLAIN/ANALYZE, indexing strategy, autovacuum/bloat management, connection pooling (e.g. PgBouncer), and parameter-group tuning.
• Execute zero-downtime schema changes using expand–migrate–contract / blue-green patterns; assess lock impact and avoid long ACCESS EXCLUSIVE locks on hot tables.
• Manage replica topology (writer/reader endpoints), replication lag, and read-scaling as load grows.
• Partner with app teams on migration tooling (e.g. Flyway) and paired forward/rollback scripts; enforce idempotent, reviewed, tested DDL.

NoSQL & Scale

• Data-model, deploy, and operate distributed NoSQL clusters — Cassandra and/or ScyllaDB — including partition/clustering key design, compaction strategy, repair, and node operations (bootstrap, decommission, scale-out).
• Lead the planned migration of high-volume payload tables from partitioned PostgreSQL to Cassandra/ScyllaDB: capacity planning, dual-write/backfill design, cutover, and validation.
• Tune distributed-store read/write paths, consistency levels, and cluster sizing for predictable latency at scale.
• Support the cache-first architecture (Redis) and change-data-capture / streaming pipelines (e.g. Kafka) that move data to analytics and cold-archival stores.

Operations, Reliability & DR

• Own database uptime and SLOs; build and maintain monitoring, alerting, and dashboards for the key signals (latency, replication lag, CPU/IO, connections, vacuum lag, error rates).
• Define and regularly test backup and disaster-recovery strategy — RPO/RTO targets, point-in-time recovery, restore drills, and cross-AZ / future multi-region readiness.
• Drive incident response for database-related issues: triage, mitigation, root-cause analysis, and follow-up actions.
• Write and maintain runbooks (partition maintenance, failover, archival, DR, migration procedures) and participate in an on-call rotation for the data layer.
• Establish production-change discipline: pre-flight and post-deploy verification, rollback criteria, and backup verification before destructive operations.

Security, Governance & Documentation

• Implement and maintain database access control — least-privilege roles, schema-scoped permissions, and row-level security (RLS) for multi-tenant isolation.
• Own data-governance documentation: PII maps, per-table retention policies, audit-readiness, and the controls behind privacy-regulation compliance (e.g. GDPR / DPDP-style erasure and legal-hold workflows).
• Author and maintain architecture decision records (ADRs), schema documentation, and monitoring/runbook docs so the data platform is legible to the wider team.
• Uphold encryption-at-rest/in-transit posture and safe handling of sensitive columns; keep the data layer aligned with the platform's compliance requirements.

Coding & Automation Bar (Required)

This role is automation-first, not click-ops. The right candidate treats repetitive database work as something to script away and can drop into application code when a problem demands it.

• Strong scripting in Python and Bash for automation of maintenance, backups, partition management, backfills, and health checks.
• Comfortable with infrastructure-as-code (e.g. Terraform) and configuration management (e.g. Ansible) for reproducible database infrastructure.
• Solid SQL and PL/pgSQL; able to read and debug application-layer database code and, worst case, write or patch application code (e.g. Python/Node/Java) to unblock a fix.
• Fluent with Git-based workflows, code review, and CI for database migrations and tooling.

Required Qualifications

• 6–9 years operating relational databases in demanding production environments, with deep PostgreSQL expertise (internals, partitioning, replication, performance tuning).
• Hands-on experience running at least one distributed NoSQL store in production — Cassandra or ScyllaDB strongly preferred (other wide-column/distributed stores considered).
• Proven ownership of backup/DR, monitoring, and incident response for production databases.
• Strong scripting/automation background (Python, Bash) and experience with IaC.
• Experience with managed cloud databases (AWS RDS or equivalent) and understanding of instance/parameter-group tuning, replicas, and failover.
• Experience designing for multi-tenancy and data isolation at scale.
• Clear written communication — able to produce runbooks, ADRs, and governance docs a team can rely on.

Nice to Have

• Experience migrating workloads from PostgreSQL to Cassandra/ScyllaDB (or similar relational-to-distributed migrations).
• Familiarity with Redis as a cache tier and with CDC / streaming pipelines (e.g. Kafka, Debezium).
• Exposure to Flyway (or Liquibase), pgTAP or similar schema testing, and PgBouncer.
• Working knowledge of privacy regulations (GDPR, India DPDP) and audit/compliance processes.

How You Work

• Ownership mindset — takes a directive and runs it to done, with sound judgment on trade-offs.
• Reliability-first and detail-oriented; disciplined about verification, rollback, and documentation.
• Collaborative in a high-performing engineering team; communicates clearly with developers and leadership.
• Pragmatic and scale-aware — designs for where the platform is going, not just where it is.

Role Overview

We are looking for a Senior Full Stack Developer to build and scale our fintech platform. You will own the entire lifecycle of our financial products, from designing high-performance relational schemas in PostgreSQL to building interactive dashboards in React.

Key Responsibilities

• Full Stack Development: Build and maintain end-to-end features using the PERN stack

(PostgreSQL, Express.js, React, Node.js).

• Database Optimization: Design complex relational models and optimize SQL queries to

handle high-volume financial data and audit trails.

• Security & Compliance: Implement rigorous security measures (e.g., JWT, OAuth, data

encryption) and ensure the platform adheres to fintech standards like PCI-DSS.

• API Architecture: Develop robust RESTful APIs to integrate with third-party banking APIs,

payment processors (Stripe/Plaid), and KYC providers.

Technical Requirements

• Front-end: Advanced proficiency in React.js (Hooks, Context API, Redux or TanStack Query)

and modern CSS (Tailwind/Styled Components).

• Back-end: Expert-level Node.js and Express.js experience, with a focus on asynchronous

programming and secure API design.

• Database: Deep knowledge of PostgreSQL (complex joins, indexing, triggers, and

migrations).

Additional skills

• Understanding of Event-Driven Architecture (using AWS SQS/SNS or Kafka).

• Familiarity with SOC2 or ISO 27001 compliance frameworks.

• Cloud (AWS): Proven experience with:

• RDS/Aurora for managed databases.
• IAM for secure access management.
• AWS Lambda & API Gateway for serverless architecture.
• CloudWatch for monitoring and alerting.

• Tools: Git, Docker, and experience with CI/CD workflows.

About US

RJ Fintech Solutions Pvt. Ltd. is a high-growth fintech startup on a mission to automate business financial operations. In a world where financial systems are often slow and opaque, we are building the "missing link"—a secure, transparent, and lightning-fast platform that puts banking and compliance first for various corporates.

We are not just another financial app; we are an engineering-first company. We believe that elegant code and robust architecture are the foundations of trust. By leveraging the PERN stack and AWS cloud-native infrastructure, we are replacing legacy complexity with modern, scalable solutions.

Why Work With Us?

1. Build the Foundation, Not Just Features

You won't be a small cog in a massive machine. As an early member of our engineering team, you will help define our technical architecture, choose our libraries, and set the coding standards for everyone who follows. Your fingerprints will be on the core DNA of our product.

2. Solve Problems That Matter

Fintech is one of the few industries where code has a direct, measurable impact on people's lives.

Whether we are [e.g., simplifying cross-border payments, democratizing investment, or building the next generation of credit], you will be solving high-stakes challenges around security, trust, and financial inclusion.