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

Information Technology

51-250 (90)

Founded 2003

3 open positions

Links

View All Jobs

Senior Database Administrator (Freelancer)

5 months, 1 week ago

India

Freelance

Senior

Database Administrator

Database Administration

Ansible AWS Chef CI/CD CloudFormation Oracle PostgreSQL Puppet Terraform

Apply Now

Mactores

IT Services

51-250

Founded 2003

View All Jobs 3

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

Freelance Senior FLEXCUBE System Analyst (B2B Contract)

HITCONTRACT 11-50 Professional Services

Senior FLEXCUBE System Analysts will support a large banking client’s Core Banking team by developing, improving, and transforming the Oracle FLEXCUBE platform across technical and business domains.

Europe Freelance Senior Database Administrator Software Engineer

$86k-$106k

Linux REST API SOAP SQL Unix XML

2 days, 14 hours ago

Apply

2 days, 14 hours ago

Information Management and GIS Officer

The HALO Trust 5K-10K Capital Markets

HALO is seeking an Information Management and GIS Officer in Gaza to manage operational data and deliver mapping and analysis that support mine action operations, decision-making, and donor reporting.

Palestine Contract Mid Level Data Analyst Database Administrator

PostgreSQL SQL SQL Server

3 days, 14 hours ago

Apply

3 days, 14 hours ago

Database Administrator - SAP HANA / SAP Basis

TWO95 International 51-250 Internet Software & Services

Remote Database Administrator on a 1+ year contract supporting enterprise SAP HANA, SAP S/4HANA, SAP Basis, and cloud-connected SAP environments to maintain availability, security, integrations, and operational reliability.