Senior Database Administrator (Freelancer) job opportunity at Mactores.

Home Jobs In India Tag: Engineering – Data Engineering and Data Science Senior Database Administrator (Freelancer) position at Mactores


bot
Mactores Senior Database Administrator (Freelancer)
Experience: 5 Years
Pattern: Remote
Country:
apply Apply Now
Salary:
Status:

Engineering,Data Engineering and Data Science

Copy Link Report
degreeBachelor's (B.Sc.)
loacation Mumbai, MH, India
loacation Mumbai, MH....India

Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.We are looking for an experienced  Senior Database Administrator to lead and support Amazon Aurora PostgreSQL environments as part of an Oracle to PostgreSQL migration program. The role requires deep hands-on expertise in database administration, AWS DMS, performance tuning, security, and post–go-live stabilization in production environments.\nWhat you will do?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.What are we looking for?5+ years of experience administering Amazon Aurora PostgreSQLProven expertise in Oracle to PostgreSQL migration supportHands-on experience with AWS DMSAdvanced PostgreSQL performance tuning and troubleshooting skillsStrong knowledge of backup, restore, and DR planning in AWSExperience with AWS monitoring tools (CloudWatch, Performance Insights)Strong problem-solving and root-cause analysis abilitiesExperience working in production and post–go-live environmentsAbility to work independently as an L3 escalation engineerClear communication and documentation skills|You will be preferred if Familiarity with automation and configuration management tools, such as Ansible, Chef, or PuppetFamiliarity with IAAC tools such as Terraform, CloudFormationFamiliarity with CI/CD implementation tools like Liquibase/FlywayAWS Certified Database – SpecialtyAWS Certified Solutions Architect\nLife at MactoresWe care about creating a culture that makes a real difference in the lives of every Mactorian. Our 10 Core Leadership Principles that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.1. Be one step ahead2. Deliver the best3. Be bold4. Pay attention to the detail5. Enjoy the challenge6. Be curious and take action7. Take leadership8. Own it9. Deliver value10. Be collaborativeWe would like you to read more details about the work culture on https://mactores.com/careers The Path to Joining the Mactores TeamAt Mactores, our recruitment process is structured around three distinct stages:Pre-Employment Assessment: You will be invited to participate in a series of pre-employment evaluations to assess your technical proficiency and suitability for the role.Managerial Interview: The hiring manager will engage with you in multiple discussions, lasting anywhere from 30 minutes to an hour, to assess your technical skills, hands-on experience, leadership potential, and communication abilities.HR Discussion: During this 30-minute session, you'll have the opportunity to discuss the offer and next steps with a member of the HR team.At Mactores, we are committed to providing equal opportunities in all of our employment practices, and we do not discriminate based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other category protected by federal, state, and local laws. This policy extends to all aspects of the employment relationship, including recruitment, compensation, promotions, transfers, disciplinary action, layoff, training, and social and recreational programs. All employment decisions will be made in compliance with these principles.Note: Please answer as many questions as possible with this application to accelerate the hiring process.

Other Ai Matches

remote-jobserver Remote
Java Engineer – Application / Database Modernization (Freelancer) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
Java Engineer – Application / Database Modernization Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
AWS Data Engineer (Senior) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
Sales Operations Specialist Applicants are expected to have a solid experience in handling Business – Sales related tasks
remote-jobserver Remote
AWS DevOps Engineer (Senior) Applicants are expected to have a solid experience in handling Engineering – DevOps and Cloud Engineering related tasks
Technical Content Writer Applicants are expected to have a solid experience in handling Marketing related tasks
remote-jobserver Remote
AWS DevOps Engineer (Associate) Applicants are expected to have a solid experience in handling Engineering – DevOps and Cloud Engineering related tasks
remote-jobserver Remote
AWS Data Engineer (Senior) (Freelancer) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
Cloud Engineer (Intern) Applicants are expected to have a solid experience in handling Engineering – DevOps and Cloud Engineering related tasks
remote-jobserver Remote
Graphic Designer Applicants are expected to have a solid experience in handling Business – Marketing related tasks
remote-jobserver Remote
Senior Database Developer (Oracle & PostgreSQL) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
Senior Database Administrator (Freelancer) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
Sales Operations (Intern) Applicants are expected to have a solid experience in handling Business – Sales related tasks
remote-jobserver Remote
AWS DevOps Engineer (Freelancer) Applicants are expected to have a solid experience in handling Engineering – DevOps and Cloud Engineering related tasks
remote-jobserver Remote
Project Manager (Data Center Migration & Modernization) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
Data Engineer (Intern) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
DevOps Engineer (Intern) Applicants are expected to have a solid experience in handling Engineering – DevOps and Cloud Engineering related tasks
remote-jobserver Remote
AWS DevOps Engineer (Senior) Applicants are expected to have a solid experience in handling Engineering – DevOps and Cloud Engineering related tasks
remote-jobserver Remote
AWS Data Engineer (Senior) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
AWS Data Engineer (Associate) Applicants are expected to have a solid experience in handling Engineering – Data Engineering and Data Science related tasks
remote-jobserver Remote
AWS DevOps Engineer (Senior) - Migration Project (VMware to AWS) Applicants are expected to have a solid experience in handling Engineering – DevOps and Cloud Engineering related tasks