Back to jobs

Senior Database Administrator (Freelancer)

Pay
Pay not listed
Work setting
Not stated
Employment
Contract — employment source
Employment type in the employer’s posting: Freelancer (Remote)
From the employer’s posting

What you’ll work on

Full posting
  • Design, configure and manage Amazon Aurora PostgreSQL clusters

  • Configure, run and tune AWS DMS tasks for Full Load and CDC

  • Map Oracle users, roles and privileges to PostgreSQL with least-privilege access

  • Tune server, PostgreSQL parameters, autovacuum, indexing and queries

  • Design backup, restore, DR and failover procedures and run recovery drills

From the employer’s posting
Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters.
Configure, run, monitor, and optimize AWS DMS tasks (Full Load and CDC).
Map users, roles, and privileges from Oracle to PostgreSQL.
Tune server and database performance — CPU, memory, I/O, connections — plus PostgreSQL parameters, autovacuum, indexing, and query behavior.
Design and implement backup and restore strategies; define and test DR and failover procedures; support cross-region replication and recovery drills.
Apply at Mactores

Posting record

Report an error

Open 7 monthsWe first saw this posting 220 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Apr 15, 2026220 days ago
Recorded sightings
157
Last seen by us
Nov 21, 2026
Employer says posted
Jan 19, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 220

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,770 similar postings that came down. Coming down is not always a hire.

Mactores is hiring

3 open jobs

  • No new data jobs since July
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • AWS
  • Oracle
  • PostgreSQL
  • Terraform
Where the posting names them
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.
- 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.
- Proven expertise supporting Oracle-to-PostgreSQL migrations. - Hands-on experience with AWS DMS. - Advanced PostgreSQL performance tuning and troubleshooting skills.
- 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 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.
- Familiarity with CI/CD implementation tools like Liquibase/Flyway - AWS Certified Database – Specialty - AWS Certified Solutions Architect
- AWS Certified Database – Specialty - AWS Certified Solutions Architect How we work?
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. When we tell a customer their database will be stable on a date, your work is what makes that sentence true. Life at Mactores
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. 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, when an incident escalates past L2, you're the person who resolves it and can explain why it happened. This is a freelance engagement, remote, working as the L3 escalation point on production systems that real businesses run on.
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. 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, when an incident escalates past L2, you're the person who resolves it and can explain why it happened.
What you will do? - 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.
- 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.
What are we looking for? - 5+ years of experience administering Amazon Aurora PostgreSQL. - Proven expertise supporting Oracle-to-PostgreSQL migrations.
- 5+ years of experience administering Amazon Aurora PostgreSQL. - Proven expertise supporting Oracle-to-PostgreSQL migrations. - Hands-on experience with AWS DMS.
- Hands-on experience with AWS DMS. - Advanced PostgreSQL performance tuning and troubleshooting skills. - Strong knowledge of backup, restore, and DR planning in AWS.
- 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

Your next step

Complete your application on jobs.lever.co. The employer’s form will show what is required.

Applying through Lever

  • No account needed: one form, and Lever reads your resume into the profile recruiters search.

Already applied? Track this application

Job description

View original posting ↗

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.

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, when an incident escalates past L2, you're the person who resolves it and can explain why it happened.

This is a freelance engagement, remote, working as the L3 escalation point on production systems that real businesses run on.

 

What you will do?

  • 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.

What are we looking for?

  • 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.

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

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. When we tell a customer their database will be stable on a date, your work is what makes that sentence true. 
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 that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.
 
1. Be one step ahead
2. Deliver the best
3. Be bold
4. Pay attention to the detail
5. Enjoy the challenge
6. Be curious and take action
7. Take leadership
8. Own it
9. Deliver value
10. Be collaborative
 
We would like you to read more details about the work culture on https://mactores.com/careers 
 
 
The Path to Joining the Mactores Team
At Mactores, our recruitment process is structured around three distinct stages:
 
Pre-Employment Assessment: 
A series of evaluations of your technical proficiency and suitability for the role.
 
Managerial Interview: The hiring manager engages with you in multiple discussions, 30 minutes to an hour each, covering technical skills, hands-on experience, leadership potential, and communication. 
 
HR Discussion: During this 30-minute session, you'll have the opportunity to discuss the offer and next steps with a member of the HR team.
 
Mactores provides equal opportunities in all employment practices. We don't discriminate based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other category protected by federal, state, and local laws. This applies to every part of the employment relationship, recruitment, compensation, promotions, transfers, disciplinary action, layoff, training, and social and recreational programs.
 
 
Note: Please answer as many questions as possible with this application to accelerate the hiring process.

Employment type

Freelancer (Remote)

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Mumbai, MH

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, when an incident escalates past L2, you're the person who resolves it and can explain why it happened. This is a freelance engagement, remote, working as the L3 escalation point on production systems that real businesses run on. What you will do?
More source context
Employment type Freelancer (Remote)
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.