Senior Database Administrator (Freelancer)

16 hours, 7 minutes 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

Database Developer

Skyward 51-200 Internet Software & Services

Skyward is hiring a Database Developer to build and support healthcare data solutions for the CMS Chronic Conditions Data Warehouse, enabling research to improve care quality and costs for Medicare and Medicaid beneficiaries.

HTML JavaScript Machine Learning Oracle Python Snowflake SQL
16 hours, 7 minutes ago

Database Administrator

Accanto Health 1-10 Health Care Providers & Services

Accanto Health is seeking a remote Database Administrator to build, secure, and optimize its Azure data platform supporting enterprise analytics and evidence-based eating-disorder care.

Azure HIPAA Power BI Salesforce SFTP SQL SQL Server
16 hours, 22 minutes ago

Senior Database Administrator

Xsolla 201-500 Internet Software & Services

Xsolla is hiring a Database Administrator to manage and optimize RDBMS and NoSQL platforms that support its global commerce services for video game developers.

AWS Bash Datadog GCP Grafana Linux MySQL PostgreSQL Prometheus Puppet Python SQL Terraform Zabbix
1 day, 16 hours ago

Senior Database Administrator

Xsolla 201-500 Internet Software & Services

Xsolla is seeking a Database Administrator to manage and optimize RDBMS and NoSQL infrastructure supporting its global commerce platform for the video game industry.

AWS Bash Datadog GCP Grafana Linux MySQL PostgreSQL Prometheus Puppet Python SQL Terraform Zabbix
1 day, 16 hours 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