Database Applications Specialist II - SAP

Database Applications Specialist II - SAP

Location:

Midhurst, ON L9X 1N6 CA (Primary)

Contract Type:
Permanent - Full Time

Salary Grade: $96,242.00 - $

• Provide comprehensive systems analysis and design support for the County’s SAP landscape including S/4
  
  HANA on‑premise and SAP RISE environments, middleware, custom developments, enterprise systems, and integrations.
• Collaborate with internal teams (Functional Analysts, Infrastructure, Security) and external vendors during project implementation, delivering programming support, troubleshooting, and operational support for SAP integration pipelines, custom ABAP enhancements, SAP configuration, Fiori/UI5 applications, and County applications.
• Manage technical aspects of large and complex SAP integration landscapes, maintaining system security, authorized access, and business continuity.
• Participate in the full development lifecycle, translating functional requirements into technical designs, implementing solutions, executing unit and integration tests, and promoting code through Sandbox, DEV, QA, and Production environments.
• Support BASIS activities including transport management, system monitoring, patching, and collaboration with functional leads to support, configure and validate SAP module configurations (HCM, MM, PM, RE, FI/CO) integrations, and County applications.
• Develop and configure County applications, SAP ABAP solutions, Fiori/UI5 applications, AI/ML, BTP applications, RAP, CAP, OData services, and CDS Views to meet complex business requirements across multiple modules.
• Design, build, and maintain real‑time and batch integrations using SAP BTP/CPI, IDocs, RFCs, SOAP/REST APIs, and middleware tools to connect SAP S/4
  
  HANA with third‑party applications and legacy systems.
• Support and configure Fiori Launchpad roles, catalogs, groups, and tiles; develop intuitive UI5/Fiori applications and custom floor plans that adhere to SAP Fiori design guidelines.
• Support the creation of high-performance, highly reliable applications and database systems; proactively monitor and adjust to ensure adherence to specified performance metrics.
• Lead systems analysis and design initiatives by gathering, refining, analyzing and documenting technical and business requirements from diverse stakeholders.
• Collaborate with business users to define requirements, ensuring effective and user-friendly SAP solutions and workflows.
• Assist with feasibility studies, ensuring optimal alignment between data solutions and strategic objectives, and support the design of user-friendly applications.
• Support and participate in system installation, configuration, patching, upgrades, and transport management for multiple landscapes (Sandbox, DEV, QA, PRD), ensuring optimal performance, stability, and security.
• Support and enforce role‑based access controls, authorization objects, SSO/SAML configurations, and segregation‑of‑duties frameworks in collaboration with Security and Audit teams.
• Implement BTP, CDS Views, ABAP OO, BADI, OData, enhancement point, user‑exit, and enhancement spot to extend SAP standard functionality and meet unique business requirements.
• Provide programming expertise and guidance on best practices in the design and development of SAP systems and interfaces with integrated applications using ABAP, SAP OData Services, CDS Views, AI/ML, Groovy and APIs within the County’s technical environment.
• Perform configuration and testing activities for core SAP modules (HCM, FI/CO, MM, PM, RE) and integrated SAP applications, translating functional requirements into configuration settings and coordinating functional‑to‑technical handoffs.
• Coordinate escalation procedures for high‑severity incidents, perform root‑cause analysis, implement preventive measures, and drive continuous improvement to reduce recurring incidents.
• Manage operational tickets and deliver stable database, application, integration, and SAP environments.
• Investigate and resolve operational issues, data discrepancies, and performance slowdowns.
• Analyze and optimize ABAP code, SQL scripts, CPI, and HANA database models (CDS Views, Calculation Views) to improve transaction throughput, reduce runtime, and manage…