Senior Database Administrator – Freelancer

Job not on LinkedIn

🕒 January 19

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Mactores

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2008

🏢 Enterprise

Enterprise • Data

Mactores is a company that provides end-to-end data platform solutions aimed at accelerating business value through automation. Since 2008, Mactores has been helping businesses with digital transformation, offering services like Enterprise Data Lakes, Scalable Databases, Modern Data Warehouses, Automated DataOps, MLOps, and Generative AI solutions. They focus on enabling faster and cost-effective migrations and modernizations in data analytics, partnering with leading platforms to drive innovation and success. Mactores works alongside tech teams to strategize and implement the right data solutions timely and efficiently.

📋 Description

• 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.

🎯 Requirements

• 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|