Senior Oracle Database Administrator Jobs in Minnesota

Job Summary:
Stantec is a company with a diverse team of professionals dedicated to optimizing business processes. They are seeking a Senior Application Architect to design and oversee the architecture of software systems, ensuring scalability and security while integrating with existing platforms such as Oracle EBS.
Responsibilities:
• Design and document the overall application architecture for projects, spanning on-premises systems and cloud platforms.
• Ensure architectures are scalable, reliable, and meet business requirements.
• Provide expertise in cloud services (such as Oracle and/or Azure) and architect cloud-based applications or migrations.
• Serve as the subject matter expert on Oracle E-Business Suite(EBS) within the architecture.
• Provide technical leadership to software development teams throughout the software development lifecycle.
• Incorporate security requirements and performance considerations into all application architecture designs from the outset.
• Collaborate with stakeholders across the organization – including business Subject Matter Experts (SMEs), business analysts, project managers, and IT leadership – to understand requirements and translate business requirements into technical architecture designs.
• Take part in planning and executing IT projects as the architecture owner.
• Stay updated with emerging technologies, tools, and best practices in the industry.
Qualifications:
Required:
• Degree or diploma in Computer Science, Software Engineering, Information Technology or a related field (or equivalent professional experience).
• A strong foundational understanding of software development principles and SDLC is expected.
• Extensive experience in software development and architecture.
• Typically, 8+ years in software engineering/architecture covering the full software development lifecycle, with at least a couple of years in a senior application design/architecture capacity.
• Experience should include designing complex systems and making complex technical decisions.
• Proven experience working with Oracle E-Business Suite (EBS) in an architectural or senior development role.
• Candidates should have participated in full lifecycle implementations or major upgrades of Oracle EBS and have a deep understanding of EBS modules (e.g., Financials, Project Billing and Costing, HCM etc.).
• Knowledge of the Oracle EBS technical stack is required – e.g. Oracle Database and PL/SQL, Oracle Forms/Reports, Workflow, and interface tools.
• Ability to design or review customizations, data migrations, and integrations involving EBS is essential.
• Strong expertise in cloud computing platforms and services.
• Hands-on experience in designing and deploying applications on Oracle Cloud and/or Microsoft Azure is required.
• This includes familiarity with cloud services such as compute, storage, databases, networking, and cloud-native design patterns.
• The architect should be comfortable with various multi-tier, microservices and event driven architecture patterns and understand how to leverage cloud offerings (like serverless functions, messaging services, etc.) in solution designs.
• Embraces a DevSecOps culture for quicker and more reliable deployments – including continuous integration, continuous delivery/deployment (CI/CD), and automated testing.
• Also, following Agile methodologies (e.g., Scrum or Kanban) to iteratively deliver architecture components and adapt to changes.
• In-depth knowledge of DevSecOps principles and tools.
• Ability to build and/or maintain CI/CD pipelines using tools such as Terraform, Azure DevOps, or GitLab CI/CD.
• Experience with configuration management and automation (e.g., Ansible, Puppet, or Chef) and with containerization technologies (Docker, Kubernetes) is expected.
• The candidate should have a track record of implementing automated build, test, and deployment processes that improve software delivery speed and quality.
• Familiarity with IaC (Infrastructure-As-Code (e.g. Terraform)) is also highly valued.
• Strong integration skills – ability to design and implement APIs and middleware for connecting heterogeneous systems.
• Experience with web services (RESTful APIs, SOAP) and enterprise application integration patterns is required.
• Given the Oracle EBS focus, knowledge of integration tools or middleware (such as Oracle Integration Cloud, Oracle SOA Suite, or other ESB tools) is advantageous for orchestrating data flows between EBS and other applications.
• Proficiency in programming and scripting languages relevant to the enterprise stack.
• This may include Python/Django, Java or C# for application development.
• Solid skills in SQL and working with relational databases (particularly Oracle Database and PL/SQL) are required.
• Comfortable working in a Linux environment.
• Familiarity with version control systems and build tools is also expected as part of the development toolkit.
• Experience with RESTful web services and frameworks to build APIs is important.
• Use of modelling tools to create architecture diagrams and documentation – e.g. Microsoft Visio, Draw.io, Lucidchart or UML design tools.
• Strong grasp of software architecture principles and design patterns.
• Ability to create models/diagrams (using UML or similar) to communicate system structure.
• Knowledge of established architecture frameworks (such as TOGAF or Zachman) and design methodologies is optional but beneficial.
• Experience with Agile/Scrum development processes and understanding of the DevSecOps culture of collaboration between development and operations.
• The candidate should be comfortable working in an iterative, fast-paced project environment and ideally have been part of agile teams.
• They should also be versed in continuous improvement practices and possibly have experience with other methodologies like ITIL for service management or PRINCE2/PMP for project management.
• Knowledge of automated testing frameworks (for unit testing, functional testing, systems integration testing, non-functional testing, security testing etc.) and performance testing tools would be helpful.
• Utilizing Software Design Patterns (e.g. creational, structural and behavioral) appropriately to create robust, scalable and maintainable designs.
• Implementing security best practices at every layer of architecture.
• This means following principles like least privilege, defense in depth, and secure coding practices.
• Incorporating security reviews in the design phase, using threat modelling for new systems, and ensuring compliance with relevant standards (such as ISO 27001and other internal security policies).
• For cloud deployments, adhering to the cloud provider’s well-architected security guidelines is crucial.
• Designing with performance in mind – e.g., following best practices for database indexing, caching frequently used data, and using content delivery networks (CDNs) for static content in web applications.
• Additionally, designing for reliability by including failover capabilities, backups, and considering Disaster Recovery (DR) plans.
• Maintaining clear architectural documentation and diagrams as living artifacts.
• The architect ensures that as systems evolve, the documentation and repository of decisions are updated, aiding future development and knowledge transfer.
• Encouraging a culture of learning within the technical team – for example, holding knowledge-sharing sessions on new technologies or post-mortems after major projects to capture lessons learned.
• Excellent communication skills are essential.
• The Senior Application Architect must be able to communicate complex technical concepts to both technical teams and non-technical stakeholders in clear, understandable terms.
• Strong analytical and problem-solving skills are required to assess requirements and troubleshoot architectural issues.
• Leadership and interpersonal skills are critical – the Senior Application Architect should be able to lead and mentor technical teams, facilitate discussions, and drive consensus on technical decisions.
• They should be self-motivated and proactive in driving solutions, with a high degree of initiative.
Company:
Stantec is a professional services company that provides engineering, architecture, design, and consulting services. Founded in 1954, the company is headquartered in Edmonton, CAN, with a team of 10001+ employees. The company is currently Late Stage.