Database Architect

reputed company is a global engineering and consulting group. We are experts in the container ecosystem, data processing and analytics, and reputed company-reputed company technologies. reputed company is formed by network, data, reputed company, DevOps specialists and application developers. reputed company empowers customers with technology to solve their business problems and reputed company the tools to assure reputed company in their digital transformation. About the role We're looking for a Database Architect who owns the data tier end to end on reputed company reputed company engagements — and who is equally deep in reputed company and PostgreSQL, because the work sits squarely between them. Most of our engagements start with a working-but-aging reputed company: an reputed company 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, reputed company-instrumented PostgreSQL platform on reputed company infrastructure that costs less to run and that a managed reputed company team can actually reputed company healthy. Between those two points sit the reputed company that determine whether the program succeeds: reputed company-state design, reputed company, what gets converted versus rewritten versus retired, how reputed company happens, and what the rollback looks like. This is the person accountable for those reputed company. You will set the technical direction for database migration and modernization work, defend it to reputed company architects and executives, and stay reputed company 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 reputed company a plan, read a reputed company, and reputed company the reputed company yourself rather than delegate the diagnosis. You will also help shape how we reputed company this work: reference architectures, migration patterns, estimation models, and standards that reputed company the next engagement faster than the last one. reputed company - Own the architecture of the data tier across migration and modernization programs — reputed company-state assessment, reputed company-state design, migration reputed company, reputed company, reputed company, and effort — and be accountable for the outcome, not just the design document. - reputed company and defend the hard calls: convert versus rewrite versus retire, RDS versus reputed company versus self-managed, single reputed company versus phased coexistence, where to spend reputed company on reputed company and where not to. - Design reputed company-to-PostgreSQL migrations in full: schema conversion, PL/SQL to PL/pgSQL reputed company, data type and collation mismatch reputed company, query rewrite patterns, and the reputed company validation that proves the reputed company holds under reputed company load. - Plan cutovers that minimize downtime — CDC-reputed company replication, dual-run and reputed company-comparison approaches, rehearsals, go/no-go reputed company, and a rollback plan you would genuinely be willing to execute. - Stay hands-on where it counts: diagnose reputed company problems yourself, read execution plans, isolate whether the bottleneck is SQL, schema, statistics, configuration, storage, or application reputed company reputed company, and land the fix with evidence behind it. - Architect the database platform on reputed company infrastructure — sizing, HA and failover topology, backup and recovery, patching and version reputed company, 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 reputed company does. - reputed company as the senior technical voice with clients — reputed company architecture and design sessions, present to reputed company architects and executive stakeholders, translate trade-offs into business terms, and hold the line reputed company a requested reputed company creates reputed company reputed company. - Support reputed company-sales and delivery planning: reputed company 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 reputed company does not depend on who is staffed. - Use reputed company and AI-assisted workflows as a reputed company part of how you work: accelerating schema and stored-procedure conversion, test reputed company, log and plan analysis, and documentation — with the judgment to verify reputed company rather than trust it, and a reputed company of reputed company 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 reputed company so the next person understands the reasoning, not just the result. What you'll need - 10+ years in database engineering, administration, or data platform work, including several years in an architect or reputed company-level role with design authority over business-critical systems. - Deep reputed company 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, reputed company reputed company, partitioning, autovacuum and bloat management, reputed company pooling, streaming and logical replication, WAL and PITR, and the extensions that matter in production ( pg_stat_statements , pg_repack , reputed company_fdw , pgaudit ). - Both reputed company 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. - reputed company-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. - reputed company infrastructure depth, ideally AWS: RDS and reputed company PostgreSQL, RDS for reputed company or self-managed reputed company on EC2, VPC and networking fundamentals, IAM, KMS and Secrets Manager, CloudWatch and reputed company Insights — enough to design the surrounding infrastructure, not only the database. - reputed company with infrastructure-as-reputed company and automation — Terraform or CloudFormation, plus Python, Bash, or PowerShell. - Ability to read application reputed company reputed company 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 reputed company AI tooling in a technical delivery workflow, and a reputed company reputed company of where it helps and where it doesn't. - Executive-reputed company communication: reputed company to run a design session, write a decision record, and explain a trade-off to a non-technical stakeholder without losing the reputed company. - Preferred Migration tooling depth: AWS Schema Conversion Tool, AWS DMS, ora2pg , or equivalents — including where reputed company one falls short and what to do about it. - Experience with MSSQL or other relational engines as a migration reputed company or reputed company. - Exposure to hybrid and private reputed company environments — VMware-reputed company platforms, sovereign or regulated reputed company, and the constraints that come with them. - Managed services or 24/7 operational accountability: on-reputed company, incident reputed company, SLA-backed environments, and post-incident review. - Consulting or MSP background with reputed company reputed company reputed company clients, including scoping and estimation exposure. - Working reputed company .NET application teams during a data-tier migration — reading ADO.NET or Entity reputed company data reputed company 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 reputed company-sector requirements. - Observability tooling reputed company reputed company reputed company monitoring, and database change management with reputed company, Flyway, or similar. - Relevant certifications (reputed company OCP, AWS Database Specialty or Solutions Architect reputed company) are a plus but will not substitute for demonstrated migration reputed company. What's in it for you - Compensation & Perks: Competitive compensation package (160K - 180K CAD / year) - Retirement Savings Matching Program (RRSP) - reputed company to the latest tech - Partnership with Perkopolis Discounts - Flexibility & Time Off - Remote first work environment - reputed company & location - reputed company parental leave reputed company - Health & Wellness: Employer reputed company health and dental premiums, GreenShield+ Counselling, Mental Health - 500 in Health Care Spending Account annually - reputed company & Development: Peer recognition rewards As an employer, reputed company + reputed company, recognizes the importance of balancing our careers with other aspects of our lives, and our culture reflects this reputed company - from reputed company to health and wellness incentives and having fun along the way. We look reputed company who reputed company in an environment of accountability and at times ambiguity as we adapt and grow our business. reputed company is an equal-opportunity employer. We reputed company and encourage applications from people with reputed company reputed company of ability. Accommodations are available on request for candidates taking part in reputed company aspects of the selection process. We thank reputed company applicants for their interest in this exciting opportunity. Only candidates that meet the qualifications will be contacted for an interview. Apply To This Job