Database Architect — Oracle & PostgreSQL, Cloud Migration

OpsGuru is a global engineering and consulting group. We are experts in the container ecosystem data processing and analytics and cloud-native technologies. Our team is formed by network data security DevOps specialists and application developers. OpsGuru empowers customers with technology to solve their business problems and provide the tools to assure success in their digital transformation.

About the role

Were looking for a Database Architect who owns the data tier end to end on enterprise cloud engagements and who is equally deep in Oracle and PostgreSQL because the work sits squarely between them.

Most of our engagements start with a working-but-aging system: an Oracle database carrying a decade of business logic in PL/SQL packages nobody has read recently supporting applications that cannot go down. They end with a supportable well-instrumented PostgreSQL platform on cloud infrastructure that costs less to run and that a managed operations team can actually keep healthy. Between those two points sit the decisions that determine whether the program succeeds: target-state design sequencing what gets converted versus rewritten versus retired how cutover happens and what the rollback looks like.

This is the person accountable for those decisions. You will set the technical direction for database migration and modernization work defend it to client architects and executives and stay close enough to the implementation to catch the problems early. It is an architecture role that has not stopped being hands-on you are expected to open a plan read a trace and prove the point yourself rather than delegate the diagnosis.

You will also help shape how we deliver this work: reference architectures migration patterns estimation models and standards that make the next engagement faster than the last one.

What youll do

• Own the architecture of the data tier across migration and modernization programs current-state assessment target-state design migration strategy sequencing risk and effort and be accountable for the outcome not just the design document.
• Make and defend the hard calls: convert versus rewrite versus retire RDS versus Aurora versus self-managed single cutover versus phased coexistence where to spend money on performance and where not to.
• Design Oracle-to-PostgreSQL migrations in full: schema conversion PL/SQL to PL/pgSQL strategy data type and collation mismatch resolution query rewrite patterns and the performance validation that proves the target holds under real load.
• Plan cutovers that minimize downtime CDC-based replication dual-run and output-comparison approaches rehearsals go/no-go criteria and a rollback plan you would genuinely be willing to execute.
• Stay hands-on where it counts: diagnose performance problems yourself read execution plans isolate whether the bottleneck is SQL schema statistics configuration storage or application access pattern and land the fix with evidence behind it.
• Architect the database platform on cloud infrastructure sizing HA and failover topology backup and recovery patching and version strategy encryption and key management observability and cost optimization.
• Define the operational model handed to managed services: runbooks monitoring and alerting standards escalation paths and the health checks that catch problems before the client does.
• Act as the senior technical voice with clients lead architecture and design sessions present to client architects and executive stakeholders translate trade-offs into business terms and hold the line when a requested shortcut creates real risk.
• Support pre-sales and delivery planning: scope database workstreams size effort contribute to proposals and statements of work and flag the assumptions that will break the estimate if they turn out to be wrong.
• Build reusable assets reference architectures migration playbooks conversion patterns assessment tooling so delivery quality does not depend on who is staffed.
• Use agentic and AI-assisted workflows as a core part of how you work: accelerating schema and stored-procedure conversion test generation log and plan analysis and documentation with the judgment to verify output rather than trust it and a point of view on where it belongs in a delivery methodology.
• Set standards and grow the bench: review other engineers database work mentor senior and mid-level engineers and document decisions so the next person understands the reasoning not just the result.
  

What youll need

• 10 years in database engineering administration or data platform work including several years in an architect or principal-level role with design authority over business-critical systems.
• Deep Oracle expertise. PL/SQL inside out packages procedures functions triggers cursors sequences dynamic SQL plus partitioning RMAN backup and recovery Data Guard and the full diagnostic stack (AWR ASH execution plans optimizer statistics SQL tuning).
• Strong PostgreSQL expertise. PL/pgSQL EXPLAIN ANALYZE index strategy partitioning autovacuum and bloat management connection pooling streaming and logical replication WAL and PITR and the extensions that matter in production (pgstatstatements pgrepack postgresfdw pgaudit).
• Both Oracle and PostgreSQL are required not one or the other. This role sits between the two platforms and depth in only one will not be sufficient.
• Oracle-to-PostgreSQL migrations you have architected and seen through to production. You can walk through the design what broke what you got wrong and what you would do differently.
• Cloud infrastructure depth ideally AWS: RDS and Aurora PostgreSQL RDS for Oracle or self-managed Oracle on EC2 VPC and networking fundamentals IAM KMS and Secrets Manager CloudWatch and Performance Insights enough to design the surrounding infrastructure not only the database.
• Fluency with infrastructure-as-code and automation Terraform or CloudFormation plus Python Bash or PowerShell.
• Ability to read application code well enough to understand how it talks to the database and to work as a peer to the developers and architects who own it.
• Practical experience with agentic AI tooling in a technical delivery workflow and a clear view of where it helps and where it doesnt.
• Executive-ready communication: able to run a design session write a decision record and explain a trade-off to a non-technical stakeholder without losing the substance.
  
  

Preferred

• Migration tooling depth: AWS Schema Conversion Tool AWS DMS ora2pg or equivalents including where each one falls short and what to do about it.
• Experience with MSSQL or other relational engines as a migration source or target.
• Exposure to hybrid and private cloud environments VMware-based platforms sovereign or regulated hosting and the constraints that come with them.
• Managed services or 24/7 operational accountability: on-call incident command SLA-backed environments and post-incident review.
• Consulting or MSP background with North American enterprise clients including scoping and estimation exposure.
• Working application teams during a data-tier migration reading or Entity Framework data access to understand behaviour that must be preserved.
• Data protection and compliance exposure: encryption at rest and in transit auditing data residency SOC 2 PCI or public-sector requirements.
• Observability tooling beyond native cloud monitoring and database change management with Liquibase Flyway or similar.
• Relevant certifications (Oracle OCP AWS Database Specialty or Solutions Architect Professional) are a plus but will not substitute for demonstrated migration outcomes

Whats in it for you:

Compensation & Perks

• Competitive compensation package (160K - 180K CAD / year)
• Retirement Savings Matching Program (RRSP)
• Access to the latest tech
• Partnership with Perkopolis Discounts

Flexibility & Time Off

• Remote first work environment
• Flexible work hours & location
• Paid parental leave options

Health & Wellness

• Employer paid health & dental premiums
• GreenShield Counselling Mental Health
• $500 in Health Care Spending Account annually

Growth & Development

• Peer recognition rewards

As an employer OpsGuru Carbon60 recognizes the importance of balancing our careers with other aspects of our lives and our culture reflects this ethos - from flexible work hours to health and wellness incentives and having fun along the way. We look for people who thrive in an environment of accountability and at times ambiguity as we adapt and grow our business.

OpsGuru is an equal-opportunity employer. We welcome and encourage applications from people with all levels of ability. Accommodations are available on request for candidates taking part in all aspects of the selection process. We thank all applicants for their interest in this exciting opportunity.

Only candidates that meet the qualifications will be contacted for an interview.

Required Experience:

Senior IC