M

Mactores

Technology consulting for AI, IoT, Cloud

Senior Database Administrator

Database AdministrationConfirmed live in the last 24 hours
ContractMumbai, Maharashtra, IndiaNo salary listedRemote

About the Job

Requirements

  • At least 5 years of experience administering Amazon Aurora PostgreSQL.
  • Proven expertise 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, including 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.

Responsibilities

  • Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters.
  • Configure database parameters, maintenance windows, monitoring, and scaling strategies.
  • Keep environments highly available, fault tolerant, and operationally ready before go-live.
  • Map users, roles, and privileges from Oracle to PostgreSQL.
  • Implement least-privilege access, role hierarchies, and security best practices, and support audit and compliance requirements.
  • Configure, run, monitor, and optimize AWS DMS tasks for Full Load and CDC.
  • Troubleshoot DMS latency, data mismatches, and performance issues, and tune DMS settings for large-volume, high-throughput workloads.
  • Tune server and database performance, including CPU, memory, I/O, connections, PostgreSQL parameters, autovacuum, indexing, and query behavior.
  • Identify and resolve performance bottlenecks.
  • Design and implement backup and restore strategies; define and test disaster recovery and failover procedures; and support cross-region replication and recovery drills.
  • Lead post-go-live stabilization by monitoring production workloads, resolving incidents, and acting as the L3 escalation point for database-related production issues.
  • Deliver operational documentation and handover support.

Desired Qualifications

  • Familiarity with automation and configuration management tools such as Ansible, Chef, or Puppet.
  • Familiarity with infrastructure-as-code tools such as Terraform and CloudFormation.
  • Familiarity with CI/CD implementation tools such as Liquibase and Flyway.
  • AWS Certified Database – Specialty certification.
  • AWS Certified Solutions Architect certification.

About the Company

Mactores

Technology consulting for AI, IoT, Cloud

Mactores helps organizations solve critical business problems by applying expertise in AI, Fast Data, Industrial IoT and Cloud through consulting, engineering and data science. It designs and implements AI-driven analytics, real-time data processing, IoT edge and cloud platforms to turn data into business value. What sets Mactores apart is its customer-centric approach, blending deep technology skills with strong industry knowledge to deliver measurable impact. Its goal is to produce lasting positive effects on businesses and communities while becoming a leading technology consulting and product firm through consistent value delivery.

Company size
51-200
Company stage
Not listed
Total funding
Not listed
Headquarters
Seattle, WA
Founded
2008

Recently Posted Jobs

Explore more opportunities at Mactores

See more jobs