Lead Database Engineer

Qualifications

● 3-8 years experience in Cloud Database Administration

● Proficient in PostgreSQL database management, including installation, configuration, and performance tuning.

● Experience with Amazon RDS or Cloud SQL and managing databases in cloud environments.

● Proficient in PostgreSQL/MySQL database management, including installation, configuration, and performance tuning.

● Proven experience as a Database Administrator with a focus on

PostgreSQL/MySQL.

● In-depth knowledge of database design, implementation, and management for both PostgreSQL/MySQL environments.

● Familiarity with database security, backup procedures, and performance tuning for both systems.

● Strong analytical and problem-solving skills.

● Excellent communication and collaboration abilities.

● Relevant certifications (e.g., PostgreSQL Certified Professional, MySQLDatabase Administrator) are a plus.

Skills:

● Expertise in PostgreSQL/MySQL database management systems.

● SQL programming and query optimization for both databases.

● Data modeling and database design for PostgreSQL/MySQL.

● Backup and recovery procedures for both environments.

● Performance tuning and optimization for PostgreSQL/MySQL.

● Security protocols and measures for PostgreSQL/MySQL.

● Capacity planning and scalability for both systems.

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.

We are looking for a Database Engineer (PostgreSQL) with 1-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:

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

Key Responsibilities

Administer, monitor, and support database platforms including Couchbase, PostgreSQL, and Oracle.

Perform database performance tuning, optimization, and troubleshooting.

Write and optimize complex SQL queries, stored procedures, and scripts.

Ensure database availability, reliability, backup, recovery, and security compliance.

Support production incidents, root cause analysis, and ongoing operational improvements.

Collaborate with application, infrastructure, and support teams to resolve database-related issues.

Required Skills

5 to 10 years of hands-on experience in Database Administration.

Strong experience with Couchbase, PostgreSQL, and/or Oracle databases.

Expertise in performance tuning, query optimization, indexing, and SQL development (Complex Queries, Stored Procedures, Scripts)

Experience with database monitoring, backup, recovery, and maintenance activities.

Production Support, Troubleshooting & RCA

Strong analytical and troubleshooting skills.

Nice to Have

Experience with cloud platforms such as AWS, Azure, or GCP.

Exposure to database automation and scripting

You'll own heterogeneous database migrations end to end for enterprise customers moving off Oracle and SQL Server onto PostgreSQL and Aurora PostgreSQL. That means running the AWS DMS and SCT toolchain, then doing the part the tools can't: rebuilding procedural business logic in PL/pgSQL when SCT flags a gap it can't close on its own. You ship the runbook, you run the cutover, you validate the result. 

What you'll do?

• Lead end-to-end database migration initiatives, including assessment, planning, schema conversion, execution, and post-migration validation.
• Design, configure, and manage AWS DMS and SCT environments while ensuring migration quality, performance, and reliability.
• Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
• Perform database migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.
• Collaborate with infrastructure, application, security, and platform teams to ensure successful migration outcomes.
• Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
• Provide technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
• Lead conversion and refactoring of procedural database code — Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) — into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT.

What we're looking for?

• 8–12 years of professional experience in database architecture and migration delivery
• Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migrations
• Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments, including migration planning, execution, and optimization
• Proven background in delivering heterogeneous database migrations across on-premises, cloud, and AWS environments
• Knowledge of production database operations, including backup and restore strategies, parameter tuning, performance optimization, and failover testing
• Skills in authoring and executing migration runbooks, validation plans, cutover procedures, rollback strategies, and post-migration stabilization activities
• Strong understanding of AWS database services, migration best practices, and integration with broader cloud migration programs
• Experience engaging directly with enterprise customers, architecture teams, and migration stakeholders to drive successful delivery outcomes
• Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions with no native PostgreSQL equivalent
• Ability to identify and remediate SCT action items and manual conversion gaps in procedural code (e.g., DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, and nested/recursive procedure calls) and validate converted logic through functional and regression testing.

You'll be preferred if you

• Have tuned production database performance, backup and restore strategy, and failover testing in high-stakes environments.
• Have led migration teams or mentored engineers through complex conversions.
• Bring experience with broader AWS cloud migration programs beyond the database layer.

We are looking for a Database Administrator to keep our databases fast, secure and highly available.

Responsibilities

• Install, configure and maintain Oracle, PostgreSQL and SQL Server databases
• Tune queries and database performance
• Manage backup, recovery and disaster-recovery plans
• Handle replication, high availability and security

Requirements

• 2+ years as a DBA on Oracle, PostgreSQL or SQL Server
• Strong backup, recovery and tuning experience
• Oracle or Microsoft DBA certification is a plus

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.

About NonStop io Technologies

NonStop io Technologies is a value-driven company with a strong focus on process-oriented software engineering. We specialize in Product Development and have a decade's worth of experience in building web and mobile applications across various domains. NonStop io Technologies follows core principles that guide its operations and believes in staying invested in a product's vision for the long term. We are a small but proud group of individuals who believe in the 'givers gain' philosophy and strive to provide value in order to seek value. We are committed to and specialize in building cutting-edge technology products and serving as trusted technology partners for startups and enterprises. We pride ourselves on fostering innovation, learning, and community engagement. Join us to work on impactful projects in a collaborative and vibrant environment.

Brief Description

We're seeking an experienced Senior Backend Engineer/Tech Lead to join our team. As a backend engineer, you will be responsible for designing, developing, and deploying scalable backends for the products we build at NonStop. This includes APIs, databases, and server-side logic. Also, guiding the mentoring the junior team members

Responsibilities

• Design, develop, and deploy backend systems, including APIs, databases, and server-side logic
• Write clean, efficient, and well-documented code that adheres to industry standards and best practices
• Code Quality: Ensure code quality through code reviews, adherence to best practices, and continuous improvement
• Mentorship: Guide and mentor team members, fostering growth and innovation
• Collaboration: Work closely with stakeholders to align technical goals with business objectives
• Problem-Solving: Analyze and resolve technical challenges promptly
• Innovation: Stay updated with the latest technology trends and integrate them into solutions

Requirements

• At least 5+ years of experience building scalable and reliable backend systems
• Strong expertise in NodeJS/NestJS, Express, PostgreSQL
• Experience with microservices architecture and distributed systems
• Proficiency in database design (SQL and NoSQL)
• Knowledge of cloud platforms (AWS, Azure, or GCP) and CI/CD pipelines
• Deep understanding of design patterns, data structures, and algorithms
• Hands-on experience with containerization technologies like Docker and orchestration tools like Kubernetes
• Familiarity with Frontend Development Technologies (React, JavaScript, HTML, CSS)
• Exceptional communication and leadership skills
• Strong understanding of object-oriented programming principles and design patterns
• Familiarity with automated testing frameworks and methodologies
• Excellent problem-solving skills and attention to detail
• Strong communication skills and ability to effectively lead and maintain a collaborative team environment

Why Join Us?

• Opportunity to work on a cutting-edge healthcare product
• A collaborative and learning-driven environment
• Exposure to AI and software engineering innovations
• Excellent work ethic and culture

If you're passionate about technology and want to work on impactful projects, we'd love to hear from you!

Senior Backend Engineer

Node.js, System Design & Production Platforms

📍 Mumbai (On-site) | Full-time | 5+ years

About the Role:

Unico Connect is an AI-first technology partner that builds custom mobile, web, and AI products for clients across multiple geographies.

We are hiring a Senior Backend Engineer to own the backend architecture of a complex production AI platform on a dedicated client engagement: API design and data modelling, multi-tenancy, orchestration of long-running agent workloads, and the services that manage user projects and generated output.

We are open to full stack engineers whose primary strength and interest is backend. If you have shipped full stack work but the backend is where you do your deepest engineering, you are a fit for this role.

The mandatory requirement for this role is hands-on production experience as a senior backend engineer building complex, scalable systems in Node.js, with end-to-end ownership of architecture, data, and operations on at least one live platform.

The role is hands-on and architectural.

Expect to design system architecture, lead a small group of backend engineers, build the hardest parts yourself, set engineering standards, and partner closely with frontend, AI, and DevOps engineers.

A typical week includes an architecture decision on a new service, hands-on implementation of a critical path, a code review with mid-level engineers, and a working session with the AI engineer on an integration contract.

Responsibilities:

System Architecture

Own the backend architecture across engagements.

Make and document decisions on service boundaries, data models, API contracts, deployment topology, and trade-offs.

Hands-on Backend Delivery

Lead by example on complex modules, performance-critical paths, and high-risk areas using Node.js (Express, NestJS, Fastify) with TypeScript.

Pick up Python (FastAPI) where engagements require it.

Database Design and Performance

Drive PostgreSQL schema design, indexing, query optimisation, migrations, and capacity planning.

Set the data-modelling standard across the pod.

Caching, Queues, and Workflows

Design caching (Redis), event-driven patterns (Kafka, RabbitMQ, SQS, NATS), and long-running workflow orchestration (Temporal, BullMQ, Celery, or equivalent).

Handle retries, idempotency, and failure recovery.

Multi-Tenancy and Platform Patterns

Design and implement multi-tenant data isolation, RBAC, audit logging, and resource quotas appropriate to enterprise-grade products.

API and Integration Design

Set the standard for REST, GraphQL, and gRPC contracts.

Drive versioning, authentication (OAuth, JWT, SSO), security by default, and developer ergonomics.

Observability and Operations

Instrument services with OpenTelemetry, Prometheus, and Grafana.

Define SLOs, lead incident response, and write postmortems.

Code Quality and Mentorship

Run code reviews, define conventions, mentor mid-level engineers, and raise the engineering bar.

AI-Assisted Engineering Discipline

Use Claude, Cursor, and similar tools day to day.

Set the team standard for prompts, patterns, AI-assisted review, and validation of AI-generated backend code.

Client Engagement

Represent Unico Connect in technical conversations with customers.

Defend architectural decisions, communicate trade-offs, and manage scope.

Requirements:

Hands-on Production Experience as a Senior or Lead Backend Engineer in Node.js (Mandatory)

Must have personally built and shipped complex production systems in Node.js, owning architecture, data, and operations on at least one live engagement.

Full stack engineers whose deepest work is on the backend qualify.

POCs and internal tools alone do not qualify.

5+ Years of Professional Backend Engineering Experience

With at least 1 to 2 years in a senior or lead role with direct responsibility for technical decisions and team output.

Deep Node.js and TypeScript Proficiency

Strong with Express, NestJS, or Fastify.

Comfort with async patterns, streams, worker threads, and performance profiling.

Python as a Strong Plus

Hands-on production experience with FastAPI, Django, or Flask is a meaningful advantage.

Willingness and demonstrated ability to pick up Python as engagements demand is required.

PostgreSQL Depth

Schema design, normalisation, indexing, query performance, migrations, and at least one production system where you owned the data model end to end.

Caching and Event-Driven Architecture

Hands-on with Redis (or equivalent) and message queues or event-driven patterns (RabbitMQ, SQS, Kafka, NATS).

AWS Depth

Hands-on production experience with EC2, S3, RDS, IAM, VPC, ECR, and at least one of EKS, ECS, or Lambda.

Comfort owning deployment, monitoring, and cost.

System Design and End-to-End Ownership

Able to take an ambiguous problem, break it into components, evaluate alternatives, produce an architecture that holds up under review and load, plan execution, and ship with limited supervision.

AI-Assisted Engineering Experience

Daily use of Claude, Cursor, Copilot, or equivalent.

Strong discipline for reviewing and validating AI-generated backend code.

Excellent Written and Spoken English

Experience working directly with international clients.

Confident defending architectural choices in writing and in review.

Nice to Have:

• Workflow orchestration (Temporal, Airflow)
• GraphQL (Apollo, gRPC)
• Sandboxed execution environments
• Multi-tenant SaaS experience
• OpenTelemetry instrumentation
• Prior agency or consulting experience