Senior Oracle Database Architect

About XCIS AI

XCIS AI is a technology and innovation company focused on delivering AI, automation, digital transformation, data, and custom technology solutions that solve complex business challenges. We partner with organizations across high-impact industries, including the nuclear sector, to build scalable, secure, and forward-thinking solutions.

As our work continues to expand, we are seeking a highly experienced Senior Oracle Database Architect / DBA to lead and support a critical Oracle database modernization and migration initiative.

About the Role

We are seeking a highly skilled and hands-on Senior Oracle Database Architect / DBA to lead the architecture, planning, execution, and stabilization of a complex Oracle database migration project.

The successful candidate will be responsible for migrating an existing legacy Oracle database environment to a newer, supported Oracle database platform. This individual will assess the current environment, define the target-state architecture, develop the migration strategy, execute the migration, and ensure database security, reliability, performance, recoverability, and operational readiness.

This is a senior technical role requiring deep Oracle Database expertise, strong architectural judgment, and demonstrated experience successfully delivering complex database upgrades and migrations in enterprise environments.

The ideal candidate is equally comfortable developing the overall database architecture, performing hands-on technical work, resolving complex issues, and collaborating with application, infrastructure, security, business, and project teams.

Key Responsibilities

• Lead the end-to-end architecture, planning, execution, and validation of an Oracle database migration from a legacy environment to a newer Oracle database platform
• Assess the existing database environment, including database versions, schemas, applications, integrations, dependencies, workloads, storage requirements, security configurations, and operational constraints
• Define the target-state database architecture based on performance, scalability, availability, security, disaster recovery, maintainability, and business requirements
• Evaluate migration and upgrade approaches and recommend the most appropriate strategy based on database size, platform compatibility, downtime tolerance, technical risk, and recovery requirements
• Develop a detailed database migration roadmap, technical implementation plan, cutover plan, rollback strategy, validation plan, and post-migration support plan
• Perform Oracle database installations, configurations, upgrades, migrations, patching, cloning, and environment refreshes
• Conduct database compatibility assessments, pre-migration checks, dependency analysis, capacity planning, and technical risk assessments
• Use appropriate Oracle migration and recovery technologies, including Oracle Data Pump, RMAN, AutoUpgrade, Data Guard, GoldenGate, Transportable Tablespaces, or equivalent tools
• Design and implement backup, recovery, replication, high-availability, and disaster-recovery solutions
• Configure and support Oracle RAC, ASM, Data Guard, and related Oracle infrastructure where applicable
• Analyze and optimize database performance using tools and techniques such as AWR, ASH, ADDM, execution plans, indexing, partitioning, statistics management, and SQL tuning
• Identify and remediate obsolete features, unsupported configurations, invalid database objects, compatibility issues, and application dependencies before migration
• Review and optimize SQL and PL/SQL code to support compatibility, performance, and stability in the target environment
• Plan and execute migration rehearsals, performance testing, failover testing, data validation, cutover activities, and production stabilization
• Ensure the completeness, accuracy, integrity, and security of data throughout the migration lifecycle
• Develop automated scripts and utilities for database deployment, migration, validation, monitoring, maintenance, and operational support
• Implement database security controls, including encryption, auditing, access management, privileged account controls, and least-privilege principles
• Troubleshoot and resolve complex database, migration, performance, connectivity, replication, storage, and recovery issues
• Collaborate with application developers, infrastructure teams, cybersecurity teams, business stakeholders, vendors, and project leadership
• Provide technical leadership, recommendations, risk reporting, and status updates throughout the migration project
• Produce and maintain comprehensive architecture diagrams, migration runbooks, configuration documentation, operating procedures, recovery procedures, and knowledge-transfer materials
• Support the transition of the migrated database into production operations and provide post-implementation stabilization support
• Ensure all work complies with organizational security, change-management, documentation, and quality requirements

Required Qualifications

• Eight or more years of progressive professional experience as an Oracle Database Administrator, Oracle Database Architect, or senior database engineering professional
• Demonstrated experience leading complex Oracle database upgrades, migrations, or modernization initiatives in enterprise environments
• Strong hands-on experience administering multiple Oracle Database releases, including both legacy and newer enterprise versions
• Proven ability to assess a legacy Oracle environment and design a secure, scalable, highly available, and supportable target-state architecture
• Strong experience with Oracle migration and upgrade tools and methodologies, including several of the following:
  • Oracle Data Pump
  • Oracle Recovery Manager (RMAN)
  • Oracle AutoUpgrade
  • Oracle Data Guard
  • Oracle GoldenGate
  • Transportable Tablespaces
  • Database Upgrade Assistant
• Strong experience with Oracle database installation, configuration, patching, upgrades, backup, recovery, cloning, and environment refreshes
• Strong knowledge of Oracle database architecture, memory management, storage structures, tablespaces, indexing, partitioning, statistics, and query optimization
• Experience designing and supporting high-availability and disaster-recovery database environments
• Hands-on experience with Oracle RAC, ASM, Data Guard, or comparable enterprise database technologies
• Advanced SQL and PL/SQL knowledge, including performance analysis and troubleshooting
• Strong experience with database performance tuning using AWR, ASH, ADDM, execution plans, and related diagnostic tools
• Strong understanding of backup, recovery, failover, rollback, and business-continuity requirements
• Experience performing database capacity planning, workload analysis, storage forecasting, and performance benchmarking
• Strong knowledge of database security, encryption, auditing, access controls, privileged account management, and data-protection practices
• Experience working with Linux or UNIX operating systems and shell scripting
• Experience integrating Oracle databases with enterprise applications, middleware, APIs, reporting platforms, and third-party systems
• Experience developing migration plans, architecture documents, technical runbooks, cutover procedures, validation plans, and operational documentation
• Strong troubleshooting, analytical, and root-cause analysis abilities
• Strong communication skills, with the ability to explain complex technical issues, options, risks, and recommendations to both technical and non-technical stakeholders
• Ability to work independently, take ownership of critical deliverables, and provide technical leadership within a cross-functional project team
• Ability to work effectively within regulated, security-sensitive, and change-controlled environments

Preferred Qualifications

• Oracle Database certification, such as Oracle Certified Professional, Oracle Certified Master, or a comparable certification
• Experience migrating Oracle databases from older releases to Oracle Database 19c or a later supported release
• Experience with Oracle Exadata or engineered database systems
• Experience with Oracle Enterprise Manager
• Experience with Oracle Zero Downtime Migration
• Experience with Oracle Cloud Infrastructure or Oracle Database Cloud services
• Experience migrating Oracle workloads to cloud, hybrid-cloud, or modernized on-premises environments
• Familiarity with Microsoft Azure or Amazon Web Services infrastructure
• Experience with infrastructure automation or configuration-management tools such as Ansible, Terraform, or similar technologies
• Experience with CI/CD pipelines, DevOps practices, version control, and automated database deployment processes
• Familiarity with database monitoring and observability platforms
• Experience supporting large, high-volume, business-critical, or highly available database environments
• Experience working within nuclear, energy, utilities, government, financial services, healthcare, or other highly regulated industries
• Existing Level 1 Security Clearance considered a strong asset

Eligibility and Security — Mandatory

• Must be legally authorized to work in Canada.
• Must be eligible and willing to complete and maintain all required background screening and security clearance.
• Security-clearance processing may take approximately three to five months, and work cannot begin until clearance is obtained.
• Any offer is conditional upon successful completion of the required screening and clearance process.
• Please apply only if this timeline aligns with your availability.

Education

Bachelor’s Degree in Computer Science, Information Technology, Computer Engineering, Software Engineering, or a related technical discipline is preferred.

Equivalent combinations of advanced Oracle certifications, specialized technical training, and substantial relevant professional experience will also be considered.

Why Join XCIS AI?

• Join a growing and innovative organization focused on AI, automation, digital transformation, data, and enterprise technology solutions
• Lead and contribute to a significant Oracle database modernization initiative
• Work on complex, technically challenging, and operationally important projects
• Collaborate with experienced professionals across technology, infrastructure, cybersecurity, and business functions
• Apply your technical expertise within an entrepreneurial and fast-paced environment
• Contribute directly to secure, reliable, and high-impact technology solutions

Recruitment Notice

Apply only through XCIS AI’s official Careers page or authorized postings on LinkedIn and Indeed. XCIS AI does not charge candidates any fees during the recruitment process and does not authorize third parties to offer employment, immigration assistance, visa sponsorship, or permanent residency on our behalf.