Mactores
Mactores3mo ago

Senior Database Administrator (Freelancer)

Mumbai · MumbaiRemoteFreelancer (Remote)senior
Database AdministratorData & AI
0 views0 saves0 applied

Quick Summary

Overview

Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008,

Technical Tools
Database AdministratorData & AI
Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.

We are looking for an experienced  Senior Database Administrator to lead and support Amazon Aurora PostgreSQL environments as part of an Oracle to PostgreSQL migration program. The role requires deep hands-on expertise in database administration, AWS DMS, performance tuning, security, and post–go-live stabilization in production environments.
  • Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters.
  • Configure parameters, maintenance windows, monitoring, and scaling strategies.
  • Ensure high availability, fault tolerance, and operational readiness.
  • Perform user, role, and privilege mapping from Oracle to PostgreSQL.
  • Implement least-privilege access, role hierarchies, and security best practices.
  • 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.
  • Tune DMS settings for large-volume and high-throughput workloads.
  • Perform server and database performance tuning (CPU, memory, I/O, connections).
  • Tune PostgreSQL parameters, autovacuum, indexing, and query behavior.
  • Proactively identify and resolve performance bottlenecks.
  • Design and implement backup and restore strategies.
  • Define and test disaster recovery (DR) and failover procedures.
  • Support cross-region replication and recovery drills.
  • Lead post–go-live stabilization activities.
  • Monitor production workloads and resolve incidents.
  • Act as L3 escalation point for database-related production issues.
  • Provide operational documentation and handover support.
  • 5+ years of experience administering Amazon Aurora PostgreSQL
  • Proven expertise in Oracle to PostgreSQL migration support
  • 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
  • Ability to work independently as an L3 escalation engineer
  • Clear communication and documentation skills|
  • 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
  • Listing Details

    Posted
    January 19, 2026
    First seen
    March 26, 2026
    Last seen
    April 24, 2026

    Posting Health

    Days active
    28
    Repost count
    0
    Trust Level
    39%
    Scored at
    April 24, 2026

    Signal breakdown

    freshnesssource trustcontent trustemployer trust
    Mactores

    Mactores is a trusted leader among businesses in providing modern data platform solutions.

    Employees
    125
    Founded
    2008
    View company profile
    Newsletter

    Stay ahead of the market

    Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.

    A
    B
    C
    D
    Join 12,000+ marketers

    No spam. Unsubscribe at any time.

    MactoresSenior Database Administrator (Freelancer)