Skip to main content
Zobhira
Home
Jobs
Certifications
Zobhira
JobsCertificationsTodayAbout
Log inSign up
Zobhira

New job and contest openings, updated every morning on one searchable board.

Find work

  • All jobs
  • Fresher roles
  • Remote roles
  • Certifications

Compete

  • Added today

Popular cities

  • India
  • Bangalore, Karnataka, India
  • Hyderabad, Telangana, India
  • Pune, Maharashtra, India
  • Chennai, Tamil Nadu, India
  • Mumbai, Maharashtra, India

Company

  • About
  • Contact
  • Privacy
  • Terms

Stay updated

One email a week with new roles.

Secure infrastructure
Free to use, no account needed to search

Board updated daily · © 2026 Zobhira. All rights reserved.

Privacy PolicyTerms of Service
Home / Jobs / Mactores

Senior Database Administrator (Freelancer)

Mactores

IndiaremotePosted 26 days ago
Mactores logo

Skill Required

Database-AdministrationDatabase-EngineeringData-MigrationAWS-DatabaseCloud-InfrastructureSenior-Database-AdministratorSenior-Database-Administrator-(SQL-NoSQL)Senior-Database-ConsultantSenior-Database-DeveloperSenior-Database-SpecialistSenior-Database-ArchitectDatabase AdministratorQuery OptimizationtroubleshootingAWSPostgreSQLautomationObservabilityTerraformsecurityAnsibleOracledesignCI/CDCloudjQueryandGoCICDContract

Key highlights

  • 5+ years of Amazon Aurora PostgreSQL administration experience.
  • Hands‑on experience with AWS DMS for Oracle‑to‑PostgreSQL migrations.
  • Remote freelance engagement with L3 escalation responsibilities.
  • Ability to design, configure, and manage highly available Aurora PostgreSQL clusters.
  • Strong expertise in backup, restore, DR planning, and performance tuning.
  • Work within a culture guided by 10 Core Leadership Principles.

Role overview

As our Senior Database Administrator, you'll run the Amazon Aurora PostgreSQL environments in an active Oracle‑to‑PostgreSQL migration program from cluster design through DMS replication through post‑go‑live stabilization. Aedeon handles the repeatable conversion and validation work; you own what agents can't: production judgment. When replication lags, when a workload misbehaves after cutover, or when an incident escalates past L2, you are the person who resolves it and can explain why it happened. This is a freelance, remote engagement where you act as the L3 escalation point on production systems that real businesses run on.

Responsibilities

  • Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters.
  • Configure parameters, maintenance windows, monitoring, and scaling strategies.
  • Keep the environments highly available, fault tolerant, and operationally ready — before go‑live, not after.
  • Map users, roles, and privileges from Oracle to PostgreSQL.
  • Implement least‑privilege access, role hierarchies, and security best practices, and support audit and compliance requirements.
  • Configure, run, monitor, and optimize AWS DMS tasks (Full Load and CDC).
  • Troubleshoot DMS latency, data mismatches, and performance issues, and tune DMS settings for large‑volume, high‑throughput workloads.
  • Tune server and database performance — CPU, memory, I/O, connections — plus PostgreSQL parameters, autovacuum, indexing, and query behavior.
  • Find performance bottlenecks before the customer does, and resolve them.
  • Design and implement backup and restore strategies; define and test DR and failover procedures; support cross‑region replication and recovery drills.
  • Lead post‑go‑live stabilization: monitor production workloads, resolve incidents, and act as the L3 escalation point for database‑related production issues.
  • Deliver operational documentation and handover support, so what you stabilized stays stable after you.

Requirements

  • 5+ years of experience administering Amazon Aurora PostgreSQL.
  • Proven expertise supporting Oracle‑to‑PostgreSQL migrations.
  • Hands‑on experience with AWS DMS.
  • Advanced PostgreSQL performance tuning and troubleshooting skills.
  • Strong knowledge of backup, restore, and DR planning in AWS.
  • Experience with AWS monitoring tools (CloudWatch, Performance Insights).
  • Strong problem‑solving and root‑cause analysis abilities.
  • Experience working in production and post‑go‑live environments.
  • The ability to work independently as an L3 escalation engineer.
  • Clear communication and documentation skills.

Nice to have

  • 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

Benefits

  • Freelance engagement with remote‑work flexibility.
  • Opportunity to serve as the L3 escalation point on production systems for real businesses.
  • Working within a culture that emphasizes 10 Core Leadership Principles.
  • Participation in a structured recruitment process with technical assessments, managerial interview, and HR discussion.
  • Commitment to equal‑opportunity employment practices.
  • Exposure to cutting‑edge AWS modernization using the Aedeon platform.

Additional details

  • 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.
  • Oracle‑to‑PostgreSQL migrations don't fail at conversion. They fail at go‑live DMS latency nobody diagnosed, autovacuum behavior nobody tuned, privilege mappings nobody tested, incidents nobody owns at 2 a.m.
  • This role sits inside our Application & Database Modernization pillar and exists to make sure that doesn't happen.
  • How we work? We refactor legacy databases to cloud‑native AWS on a committed date, with Mactores carrying delivery overage risk for delays we cause.
  • Aedeon absorbs the repetitive majority schema conversion, test generation, regression harnesses.
  • Engineers absorb the judgment: risk tradeoffs, production cutover, post‑cutover optimization.
  • You're the judgment layer for this program's production environments.
  • Life at Mactores: We care about creating a culture that makes a real difference in the lives of every Mactorian.
  • Our 10 Core Leadership Principles: Be one step ahead; Deliver the best; Be bold; Pay attention to the detail; Enjoy the challenge; Be curious and take action; Take leadership; Own it; Deliver value; Be collaborative.
  • The Path to Joining the Mactores Team – recruitment process structured around three stages: Pre‑Employment Assessment, Managerial Interview, HR Discussion.
  • Mactores provides equal opportunities in all employment practices and does not discriminate based on protected categories.
  • Note: Please answer as many questions as possible with this application to accelerate the hiring process.
  • Originally posted on Himalayas.

Similar jobs open now

BlackRock logo
Associate, Reconciliations
BlackRock
Mumbai, India
View details
BlackRock logo
Institutional Accounting, Director
BlackRock
Mumbai, India
View details
BlackRock logo
Vice President, Cash Reconcilliation, Tech & Ops
BlackRock
Mumbai, India
View details
BlackRock logo
Associate - Fund Accounting
BlackRock
Bengaluru, India
View details
Apply now
LocationIndia
TypeContract
Posted10/21/2026
Apply by12/20/2026

Links are checked every day. If this one stops working, tell us and we'll pull it.

More like this

View all
BlackRock logo
Associate, Reconciliations
BlackRock
BlackRock logo
Institutional Accounting, Director
BlackRock
BlackRock logo
Vice President, Cash Reconcilliation, Tech & Ops
BlackRock
Apply now