Database Architect – Oracle, PostgreSQL, Cloud Migration

This is a fully remote position, open to applicants in Canada.

📋 Description

• Take ownership of the architecture for the data tier during migration and modernization initiatives.

• Evaluate the current state and formulate the desired target state, including migration strategies, sequencing, risk assessment, and effort estimation.

• Make informed decisions regarding conversion, rewriting, or retiring solutions, as well as selecting cloud platforms.

• Design migrations from Oracle to PostgreSQL, which encompasses schema conversion, strategies for PL/SQL to PL/pgSQL, resolution of mismatches, query rewrites, and performance validation.

• Strategize low-downtime cutovers employing CDC replication, dual-run scenarios, output comparisons, rehearsals, go/no-go criteria, and rollback plans.

• Identify and resolve database performance issues through evidence-based solutions.

• Design cloud database infrastructure, addressing aspects such as sizing, high availability/failover, backup and recovery, patching, encryption, observability, and cost optimization.

• Establish operational models for managed services, including runbooks, monitoring protocols, alerting systems, escalation paths, and health checks.

• Facilitate architecture and design sessions with clients and effectively communicate trade-offs to executive stakeholders.

• Aid in pre-sales and delivery planning by scoping, estimating, preparing proposals, and generating statements of work.

• Develop reusable reference architectures, migration playbooks, conversion patterns, and assessment tools.

• Utilize agentic and AI-assisted workflows for conversion tasks, test generation, analysis, and documentation, while ensuring output validation.

• Review the database work of engineers, mentor them, and document architectural decisions.

⛳️ Requirements

• Over 10 years of experience in database engineering, administration, or working with data platforms.

• Several years in an architectural or principal-level position with design authority over mission-critical systems.

• Extensive expertise in Oracle, covering PL/SQL, partitioning, RMAN, Data Guard, AWR, ASH, execution plans, optimizer statistics, and SQL tuning.

• Strong proficiency in PostgreSQL, including PL/pgSQL, EXPLAIN ANALYZE, index strategies, partitioning, autovacuum, bloat management, connection pooling, replication, WAL, PITR, and production extensions.

• Proficiency in both Oracle and PostgreSQL is essential.

• Experience in architecting and executing Oracle-to-PostgreSQL migrations to production environments.

• Depth of knowledge in cloud infrastructure, ideally within AWS settings, including RDS, Aurora PostgreSQL, RDS for Oracle or Oracle on EC2, VPC, IAM, KMS, Secrets Manager, CloudWatch, and Performance Insights.

• Familiarity with infrastructure-as-code and automation using Terraform or CloudFormation, as well as expertise in Python, Bash, or PowerShell.

• Capability to comprehend application code and its interaction with databases.

• Practical experience utilizing agentic AI tools in technical delivery processes.

• Strong communication skills suitable for executive-level interactions.

• Preferred experience with migration tools such as AWS Schema Conversion Tool, AWS DMS, ora2pg, or similar alternatives.

• Experience with MSSQL or other relational database engines is advantageous.

• Exposure to hybrid and private cloud environments is a plus.

• Preferred experience in managed services or having 24/7 operational responsibilities.

• Consulting or managed service provider background with North American enterprise clients is preferred.

• Familiarity with .NET application teams is a plus.

• Exposure to data protection and compliance matters is preferred.

• Experience with observability tools and database change management is advantageous.

• Relevant certifications are beneficial but not a substitute for proven migration success.

🏝️ Benefits

• Competitive compensation package (160K - 180K CAD / year).

• Retirement Savings Matching Program (RRSP).

• Access to the latest technology.

• Partnership with Perkopolis Discounts.

• Remote-first work environment.

• Flexible work hours and locations.

• Paid parental leave options.

• Employer-covered health and dental premiums.

• GreenShield+ Counseling for Mental Health support.

• Annual $500 Health Care Spending Account.

• Peer recognition rewards.