Senior Database Administrator (Freelancer)

1 month, 3 weeks 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-250
Founded 2003

Description

  • Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters.
  • Configure parameters, maintenance windows, monitoring, and scaling strategies for Aurora PostgreSQL environments.
  • Ensure high availability, fault tolerance, and operational readiness of database platforms.
  • Map Oracle users, roles, and privileges to PostgreSQL and implement least-privilege access and role hierarchies.
  • Support security, audit, and compliance requirements for database environments.
  • Configure, run, monitor, and optimize AWS DMS tasks for full load and CDC replication.
  • Troubleshoot DMS latency, data mismatches, and performance issues, including high-throughput workloads.
  • Perform server and database performance tuning across CPU, memory, I/O, connections, indexing, autovacuum, and query behavior.
  • Design and implement backup, restore, disaster recovery, failover, cross-region replication, and recovery procedures.
  • Lead post-go-live stabilization, monitor production workloads, resolve incidents, and serve as the L3 escalation point for database issues.

Requirements

  • 5+ years of experience administering Amazon Aurora PostgreSQL.
  • Proven experience supporting Oracle to PostgreSQL migrations.
  • Hands-on experience with AWS DMS.
  • Advanced PostgreSQL performance tuning and troubleshooting skills.
  • Strong knowledge of backup, restore, and disaster recovery planning in AWS.
  • Experience with AWS monitoring tools such as CloudWatch and 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 (preferred).
  • Familiarity with infrastructure as code tools such as Terraform or CloudFormation (preferred).
  • Familiarity with CI/CD implementation tools like Liquibase or Flyway (preferred).
  • AWS Certified Database – Specialty (preferred).
  • AWS Certified Solutions Architect (preferred).

Benefits

  • Remote work arrangement.
  • Freelancer engagement model.
  • Opportunity to work on a major Oracle-to-PostgreSQL migration program.
  • Structured hiring process with pre-employment assessment, managerial interview, and HR discussion.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Clinical Data Manager II/Senior Clinical Data Manager

Precision Medicine Group 251-1K Pharmaceuticals

Precision Medicine Group is hiring a Senior Clinical Data Manager to lead clinical trial data management from study start-up through database lock and oversee database development, testing, and related project coordination.

1 hour, 30 minutes ago

Lakebase Sales Specialist

Databricks 1K-5K IT Services

Databricks is hiring a Lakebase Sales Specialist to drive adoption and revenue for its fully managed Postgres offering for intelligent applications across strategic enterprise accounts.

Apache Spark AWS Azure GCP Microservices MLflow PostgreSQL Serverless
2 hours, 15 minutes ago

Senior Database Site Reliability Engineer

TherapyNotes 51-250 Health Care Providers & Services

TherapyNotes is seeking a Database Site Reliability Engineer to own the reliability and operability of PostgreSQL services supporting a 24x7 SaaS platform for behavioral health software.

Agile Ansible Azure Bash Datadog Grafana HAProxy HIPAA Kubernetes Linux New Relic PostgreSQL PowerShell Prometheus Python Terraform
2 hours, 15 minutes ago

Ssr DevOps Engineer (Brazil-based professionals)

Workana 1K-5K Internet Software & Services

Engenheiro/a DevOps Pleno na Workana para atuar na sustentação de uma infraestrutura Linux e em nuvem de missão crítica para um cliente do setor de segurança eletrônica e monitoramento.

Ansible Apache AWS Docker EC2 Linux MongoDB MQTT MySQL Nginx RabbitMQ Redis Ubuntu Zabbix
2 hours, 30 minutes 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