lever
Senior Database Administrator (Freelancer)
Mactores
Remote, IND
Full Time, Part Time, Contract, Internship, Temporary, Seasonal, Volunteer
Senior · 5+ years experience
Remote
Discovered 3 weeks ago
Amazon Aurora PostgreSQLOracle to PostgreSQLAWS DMSCloudWatchPerformance InsightsTerraform
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
Amazon Aurora PostgreSQLOracle to PostgreSQLAWS DMS
Key Skills for This Role
Amazon Aurora PostgreSQLOracle to PostgreSQLAWS DMSCloudWatchPerformance InsightsTerraform
Full Job Posting
- 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.
- 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|
- Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet
- Familiarity with IAAC tools such as Terraform, CloudFormation
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Mactores
Business Development Representative
, USA
Discovered 1 weeks agoFull-time
Technical Content Writer
, IND
Discovered 2 weeks agoFull-time
AWS DevOps Engineer (Freelancer)
, USA
Discovered 2 weeks agoContract
Product Manager
, IND
Discovered 2 weeks agoFull-time
Project Manager
, USA
Discovered 2 weeks agoContract
Senior Accountant
, IND
Discovered 2 weeks agoFull-time
Senior Database Developer (Oracle & PostgreSQL)
, IND
Discovered 3 weeks agoFull-time
AWS Data Engineer (Senior)
, IND
Discovered 3 weeks agoFull-time