Mactores

Senior Database Migration Engineer, Oracle, PostgreSQL

Mactores

full-time

Posted on:

Location Type: Remote

Location: India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSOraclePostgresPythonSQL

About the role

  • Design and implement database migration plans from licensed databases like Oracle and MSSQL to open-source databases like Aurora PostgreSQL on AWS
  • Analyze existing database architectures and define optimal migration strategies
  • Convert schemas, stored procedures, functions, packages and database logic (PL/SQL to PL/pgSQL)
  • Optimize database performance through indexing, query tuning, and execution plan analysis
  • Troubleshoot complex database issues and implement robust backup/recovery and HA/DR solutions
  • Develop automation scripts for database operations and monitoring
  • Implement CI/CD best practices for database deployments, including automated schema versioning, testing, and rollout processes
  • Collaborate with cross-functional teams and document migration processes
  • Assess application-level dependencies and ensure compatibility during database migration
  • Implement database security best practices, including access control, auditing, and encryption in AWS

Requirements

  • Bachelor's degree in Computer Science or a related field
  • 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
  • Experience with AWS database migration tools and services such as AWS DMS and SCT/Ora2Pg
  • Proven delivery of 2 or more database migration projects
  • Strong hands-on skills in PL/SQL, PL/pgSQL, schema conversion, and performance tuning
  • Experience with AWS DMS, SCT, RDS, Aurora, and related AWS services
  • Strong SQL, scripting (Shell/Python), troubleshooting, and documentation skills
  • Excellent problem-solving skills with the ability to identify and resolve complex issues
  • Strong communication and collaboration skills
  • Ability to work independently with minimal supervision

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
database migrationOracleMSSQLAurora PostgreSQLPL/SQLPL/pgSQLindexingquery tuningautomation scriptsCI/CD
Soft skills
problem-solvingcommunicationcollaborationindependencedocumentation
Certifications
Bachelor's degree in Computer Science