Senior Oracle Database Consultant
XCIS
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
XCIS AI seeks a Senior Oracle Database Consultant for a part-time contract to optimize Oracle databases in Azure and support on-premises endpoints. You will guide architecture, performance tuning, backup strategies, and DR planning across hybrid environments, ensuring high availability and secure connectivity for critical applications.
The role requires deep Oracle knowledge, strong advisory skills, and experience in regulated enterprise settings, with the ability to work independently and
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.
- Experience with Oracle RMAN, backup and recovery strategies.
- Experience with Oracle Data Guard and DR testing.
- Strong understanding of Azure networking and hybrid connectivity.
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 applications.
- Advise on connectivity configurations involving ODP.NET, OCI Client, JDBC Drivers, and ODBC Drivers.
- Review Azure networking architecture for Oracle workloads and security patterns.
Skills
Education
Tools
Job description
Job Identification senior-oracle-database-consultant Job Category Data Transformation Posting Date 14/07/2026, 17:50 Job Schedule Contract Location Canada (Remote)
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.
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.
Part-Time Contract
- 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.
- 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.
- Oracle Certified Professional certification.
- Oracle Certified Master certification, highly desirable.
- Microsoft Azure Solutions Architect Expert 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.
- Senior‑Level Oracle DBA / Oracle Consulting
- Oracle Data Guard
- Oracle RMAN
- Oracle Backup and Recovery
- Azure Networking and Firewall
- Hybrid Connectivity - On-Premises to Azure
- TCP Keep-Alive and Connection Management
- Storage, SSD, IOPS, and Throughput Optimization
- Enterprise Availability and Disaster Recovery
- Regulated Enterprise Environments
- 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.
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.
- 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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
