Mactores

Backend Engineer

• Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
• Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
• Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
• Identify, troubleshoot, and fix database-related application bugs.
• Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
• Support and monitor AWS DMS during full load and CDC phases.
• Diagnose and resolve DMS data and performance issues.
• Perform data validation and reconciliation between Oracle and PostgreSQL.
• Collaborate with application teams to align SQL behavior and performance expectations.

Senior Database Developer, Oracle, PostgreSQL

Database Administrator

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

Senior Database Administrator – Freelancer

Technical Recruiter

• Coordinate with hiring managers to define necessary requirements for open roles.
• Design, update job descriptions and post on different portals.
• Browse resume databases and portfolio sites.
• Join social media groups and professional networks and interact with potential candidates.
• Advertise open positions to external networks.
• Ask for referrals from current employees, acquaintances and industry professionals.
• Set up an ATS for organized databases with candidates’ data.
• Screen incoming resumes and update accordingly.
• Use Boolean search to look for qualified candidates for hard-to-fill roles.
• Conduct benchmark research on compensation and benefits for various positions and seniority levels.
• Interview candidates (via phone, video and in-person).
• Advertise job openings on company’s careers page, social media, job boards and internally.
• Provide shortlists of qualified candidates to hiring managers.
• Collaborate with managers to identify future hiring needs.
• Scheduling & set up the interviews accordingly.
• Creating a strong pipeline.
• Measure source of hire and time-to-fill for each role.
• Research and recommend new sourcing tools and techniques.
• Build, motivate, lead a team of professional headhunters, recruiters, interns.

Engineer

• 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

Senior Database Developer, Oracle, PostgreSQL

Senior Database Administrator – Freelancer

Technical Recruiter

Senior Database Migration Engineer, Oracle, PostgreSQL