Senior Oracle Database Consultant

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 an experienced Senior Oracle Database Consultant to support enterprise Oracle database environments, particularly Oracle workloads hosted in Azure and accessed by business-critical applications from on-premises environments.

About the Role

We are seeking a highly experienced Senior Oracle Database Consultant for a part-time contract engagement to assess, validate, and recommend best practices for Oracle databases running in Azure, while supporting multiple business-critical thick-client applications connecting from on-premises environments.

The successful candidate will provide senior-level advisory and managed-services support across Oracle database architecture, Azure networking, client connectivity, database performance tuning, backup and recovery, disaster recovery, storage optimization, and operational best practices.

This role requires deep Oracle expertise, strong understanding of Azure hybrid environments, and the ability to advise on complex enterprise database environments where multiple applications and users connect simultaneously from corporate endpoints.

The ideal candidate is a senior Oracle subject-matter expert with strong architecture, troubleshooting, performance, and advisory experience in regulated or mission-critical environments.

Employment Type: Part-Time Contract

Key Responsibilities

Assess existing Oracle database architecture and provide recommendations for enterprise deployment best practices.
Review Oracle databases hosted in Azure and advise on architecture, performance, scalability, availability, and operational reliability.
Evaluate Oracle memory configuration, instance optimization, SGA/PGA management, indexing strategies, and non-functional design considerations.
Provide best-practice guidance for Oracle client connectivity from enterprise and thick-client applications.
Assess and recommend Oracle connectivity configurations involving ODP.NET Managed Driver, ODP.NET Unmanaged Driver, OCI Client, JDBC Drivers, and ODBC Drivers.
Advise on best practices for connecting on-premises applications to Oracle databases hosted behind Azure firewalls.
Review and recommend Azure networking architecture for Oracle workloads, including Azure Firewall, hybrid networking, secure connectivity patterns, and network performance optimization.
Support troubleshooting and optimization of hybrid connectivity between on-premises environments and Azure-hosted Oracle databases.
Provide guidance on TCP Keep-Alive configuration, persistent database connections, network timeout tuning, firewall-induced connection drops, and the database impact of connection-management settings.
Recommend strategies to prevent application firewalls from terminating database connections unnecessarily.
Review and recommend Oracle backup and recovery strategies using RMAN, archive-log management, recovery planning, and recovery testing.
Provide guidance on Oracle Data Guard, high availability, disaster recovery architecture, failover design, replication strategies, and DR testing.
Assess storage configuration and performance for Oracle workloads, including SSD sizing, IOPS optimization, throughput design, database file layout, and Azure storage performance.
Support enterprise Oracle environments used by multiple applications and user groups.
Provide recommendations for operational excellence, monitoring, maintainability, documentation, and long-term support.
Collaborate with technical teams, business stakeholders, infrastructure teams, application teams, and project leadership.
Produce clear technical recommendations, findings, documentation, and implementation guidance.

Required Qualifications

10+ years of Oracle Database consulting, architecture, administration, or senior database engineering experience.
Strong background as a Senior Oracle DBA, Oracle Database Consultant, Oracle Database Architect, or equivalent senior Oracle specialist.
Deep knowledge of Oracle Database architecture and enterprise deployment patterns.
Strong experience with Oracle database administration, architecture, memory configuration, instance optimization, and performance tuning.
Strong knowledge of SGA/PGA memory management, indexing strategies, query optimization, and enterprise database design considerations.
Experience supporting Oracle databases in mission-critical or enterprise environments.
Experience with Oracle client connectivity and configuration for enterprise applications.
Hands-on or advisory experience with ODP.NET Managed Driver, ODP.NET Unmanaged Driver, OCI Client, JDBC Drivers, and ODBC Drivers.
Experience supporting thick-client applications connecting to Oracle databases.
Strong understanding of Oracle deployments in Azure or comparable cloud-hosted enterprise environments.
Strong knowledge of Azure networking architecture, Azure Firewall, hybrid connectivity, secure connectivity patterns, firewall rules, and network troubleshooting.
Experience advising on connectivity between on-premises systems and cloud-hosted Oracle databases.
Strong understanding of TCP Keep-Alive, persistent database connections, timeout configuration, and firewall-related connection issues.
Strong experience with Oracle RMAN, backup strategies, recovery planning, archive-log management, and recovery testing.
Strong experience with Oracle Data Guard, high availability, disaster recovery architecture, replication strategies, failover design, and DR testing.
Experience with Oracle storage and performance engineering, including SSD sizing, IOPS optimization, storage throughput design, database file layout, and performance tuning.
Strong troubleshooting, analytical, and root-cause analysis skills.
Strong communication skills, with the ability to explain complex technical issues, risks, and recommendations to both technical and non-technical stakeholders.
Ability to work independently and provide senior-level technical guidance in a regulated, security-sensitive, or enterprise environment.

Preferred Qualifications

Oracle Certified Professional certification.
Oracle Certified Master certification, highly desirable.
Microsoft Azure Solutions Architect Expert certification.
Microsoft Azure Administrator Associate certification.
Experience supporting Primavera P6, RES, RDS, STEM, engineering systems, asset-management platforms, ERP-style applications, or other enterprise applications using Oracle databases.
Experience in utilities, nuclear, energy, engineering, government, financial services, or other highly regulated industries.
Experience providing advisory or managed-services support for large Oracle environments.
Experience supporting environments where multiple business-critical applications and users connect simultaneously from corporate endpoints.
Existing security clearance considered an asset.

Key Technical Skills

Oracle Database Architecture
Senior-Level Oracle DBA / Oracle Consulting
Oracle Data Guard
Oracle RMAN
Oracle Backup and Recovery
Archive Log Management
Azure Networking and Firewall
Hybrid Connectivity — On-Premises to Azure
ODP.NET, OCI, JDBC, and ODBC
Oracle Performance Tuning
SGA/PGA Optimization
TCP Keep-Alive and Connection Management
Storage, SSD, IOPS, and Throughput Optimization
Enterprise Availability and Disaster Recovery
Regulated Enterprise Environments

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, Engineering, or a related technical discipline is preferred.

Equivalent combinations of Oracle certifications, Azure 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.
Contribute to complex, business-critical Oracle and Azure initiatives.
Work on high-impact enterprise technology environments involving performance, connectivity, reliability, and operational excellence.
Collaborate with experienced professionals across database, infrastructure, cybersecurity, application, and business teams.
Apply your expertise in a fast-paced, entrepreneurial, and technically challenging environment.
Contribute directly to secure, reliable, and scalable technology solutions for high-impact industries.

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.