Senior Database Administrator (Freelancer)

7 months ago
Freelance
Senior
Database Administration
Mactores

Mactores

Mactores provides data analytics solutions and services that empower businesses to enhance their operational efficiency and value through automation and advanced technologies such as AI, Big Data, and cloud computing.

IT Services
51-200
Founded 2003

Description

  • Design, configure, and manage Amazon Aurora PostgreSQL clusters.
  • Set cluster parameters, maintenance windows, monitoring, and scaling strategies.
  • Ensure high availability, fault tolerance, and operational readiness before go-live.
  • Map Oracle users, roles, and privileges to PostgreSQL and implement least-privilege access controls.
  • Configure, monitor, optimize, and troubleshoot AWS DMS Full Load and CDC replication tasks.
  • Resolve DMS latency, data mismatches, and performance issues for high-volume workloads.
  • Tune PostgreSQL and infrastructure performance, including CPU, memory, I/O, connections, autovacuum, indexing, and queries.
  • Design and test backup, restore, disaster recovery, failover, and cross-region recovery procedures.
  • Lead post-go-live stabilization, resolve database incidents, and serve as the L3 escalation point.
  • Deliver operational documentation and handover support.

Requirements

  • 5+ years of experience administering Amazon Aurora PostgreSQL.
  • Proven experience supporting Oracle-to-PostgreSQL migrations.
  • Hands-on experience with AWS DMS, including Full Load and CDC replication.
  • Advanced PostgreSQL performance tuning and troubleshooting expertise.
  • Strong knowledge of AWS backup, restore, and disaster recovery planning.
  • Experience with AWS monitoring tools, including CloudWatch and Performance Insights.
  • Experience supporting production and post-go-live environments.
  • Ability to work independently as an L3 escalation engineer.
  • Strong root-cause analysis, communication, and documentation skills.
  • Familiarity with Ansible, Chef, Puppet, Terraform, CloudFormation, Liquibase, or Flyway is preferred.
  • AWS Certified Database – Specialty or AWS Certified Solutions Architect certification is preferred.

Benefits

  • Remote freelance engagement.
  • Opportunity to work on production AWS modernization and Oracle-to-PostgreSQL migration programs.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Oracle Apex Developer

Latam Engineering Internet Software & Services

Join the company as an Oracle APEX Developer to build, maintain, and optimize business applications across the Oracle front end and database stack.

HTML JavaScript REST API
1 day, 16 hours ago

Desarrollador Backend (Perl / PostgreSQL)

Coderio 201-500 Internet Software & Services

Coderio busca un/a Desarrollador/a Backend Perl para un proyecto de alto impacto en banca/seguros, enfocado en implementar y mantener reglas de cálculo automático de primas y parametrización de productos de salud.

Perl PostgreSQL
2 weeks ago

Principal Data Architect

Massive Rocket 51-200 Media

Massive Rocket is seeking a Principal Data Architect to lead client discovery and design scalable customer-data and MarTech architectures that deliver measurable outcomes for global brands.

Amplitude CI/CD Databricks Git Python Snowflake SQL
3 weeks, 1 day ago

Data Architect

Massive Rocket 51-200 Media

Massive Rocket is seeking a Data Architect to lead discovery and design scalable customer data and MarTech architectures for global client brands.

Amplitude CI/CD CRM Databricks Git Python Snowflake SQL
1 month ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers