Database Applications Specialist Ii

4 days ago


Midhurst, Canada County of Simcoe Full time

Requisition Title- Database Applications Specialist II - SAP- Close Date- 18 November 2024- Contract Type- Permanent - Full Time- Location- Midhurst, ON L9X 1N6 CA (Primary)
- Job Description***:
**DUTIES AND RESPONSIBILITIES (not listed in order of priority)**:
1. Provide programming expertise in the design and development of database systems within the County’s technical environment (MS-SQL,.Net, SAP).

3. Manage work with external contractors, and review deliverables to ensure that County standards and development best practices are followed

4. Architect high performance, highly reliable database systems; monitor and adjust to ensure adherence to specified performance metrics.

5. Develop and document systems specifications, including data structures, processes, and integration points for new or re-engineered systems.

6. Ensure the integrity of the various environments through the implementation and management of processes and procedures for testing and promoting code to production.

7. Ensure confidentiality and secure access of corporate data used in assessing / supporting systems including financial, human resources, payroll, social services and health records.

8. Provide programming expertise in the design and deployment of database and web technologies such as SQL, Stored Procedures, SQL Scripting, HTML(5), XML, JavaScript, REST, JSON, UI5, ABAP, APIs, oData, etc.

14. Provide technical troubleshooting of operational failures, processing errors, and performance problems.

16. Liaise with vendors regarding error descriptions and problem resolution.

17. Provide end user support by preparing program documentation, training on new systems, and ongoing support.

18. Prepare reports and presentations as required.

19. Participate in committees as required.

20. Perform other duties as assigned.

21. Comply with Provincial and County occupational health and safety legislation, regulations, policies and procedures.

22. Maintain confidentiality in accordance with the Municipal Freedom of Information and Protection of Privacy Act.

23. Analyze and recommend process re-design to support functional requirements and proposed SAP solutions related to SAP downstream systems

25. Document, assess and identify the impacts to upstream and downstream interfaces processes and provide guidance and recommendations

**CORPORATE COMPETENCIES**:
Has knowledge of and demonstrated ability in our corporate competencies:

- Acts with the Customer in Mind
- Ensures Accountability
- Continuously Seeks to Improve Work Processes
- Collaborates
- Communicates with Impact
- Is Resilient

**EDUCATION, TECHNICAL SKILLS AND CERTIFICATION**:

- Knowledge of two or more of the following core technologies (MS-SQL, SAP-Netweaver, Service Oriented Architecture, and Business Intelligence).
- Knowledge of web technologies (HTML(5), XML.Net, JavaScript, REST, JSON, APIs, SAP UI5 / Fiori, Python, NodeJS, React)
- Problem solving and critical thinking skills to diagnose problems and determine steps necessary to achieve an effective solution.
- Ability to communicate effectively to users with varying levels of computer understanding. Ability to translate complicated technical language into layperson terms for training purposes.
- Ability to work effectively with constant interruptions; ability to work simultaneously on several projects independently and to use good judgment in determining priorities.
- Technical writing skills required to document systems procedures and prepare reports.
- Strong understanding of Secure Software Development principals / methodologies (i.e. OWSAP) would be an asset
- Knowledge and experience developing in SAP HCM module and Scheduling (preferred)
- NetWeaver, S/4 HANA, OData, ABAP Web Dynpro, Fiori Launchpad, JavaScript, SAP Gateway, SAP Web IDE, SAPUI5, Eclipse, ABAP HCM, ABAP Financial/Accounting, ABAP, BAPI, BAdI, IDoc, Dialog Programming (preferred)
- SAP Certification (preferred)
- Relevant experience supporting a production environment, support management and continuous improvement
- ITIL Certification (preferred)

**EXPERIENCE**:

- Experience working in a large, complex technical environment with a wide range of infrastructure
- Five (5) years SAP ABAP experience
- Two (2) to Three (3) years SAP UI5 / Fiori experience

**EFFORT**:

- No physical effort of note is associated with this position.
- Significant mental effort required for systems analysis and design, diagnosing system failures, and managing various tasks on multiple projects simultaneously.

**WORKING CONDITIONS**:

- Typical office environment.
- May be required to attend the workplace or log in from outside the workplace during evenings, nights, or weekends for problem resolution.
- Salary Grade- $89,107.00 - $108,417.00- Union- Non UnionPersonal information provided is collected under the authority of the Municipal Act (2001) and will be used to determine eligibility for employment.



  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative support...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative support...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative support...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative support...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services Division, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative support...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services Division, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative support...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services Division team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIJob Summary:The Administrative Assistant II is a key member of the Social & Community Services Division team, providing administrative support to senior and middle managers. This role requires a high level of organization, attention to detail, and excellent communication skills.Key Responsibilities:Provide administrative...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job SummaryThe Social & Community Services Division of Simcoe County is seeking an experienced Administrative Assistant II to provide administrative support to senior and middle managers. The successful candidate will be responsible for performing a variety of administrative tasks, including data entry, filing, and calendar management.Key...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIAt Simcoe County, we are seeking an experienced Administrative Assistant II to join our team. As a key member of our Social & Community Services Division, you will provide administrative support to senior and middle managers, ensuring the smooth operation of our office.Key Responsibilities:Provide clerical and...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIAt Simcoe County, we are seeking a highly skilled and organized Administrative Assistant II to join our team. As a key member of our Social & Community Services Division, you will provide administrative support to senior and middle managers, ensuring the smooth operation of our office.Key Responsibilities:Provide...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIAt Simcoe County, we are seeking an experienced Administrative Assistant II to join our team. As a key member of our Social & Community Services Division, you will provide administrative support to senior and middle managers, ensuring the smooth operation of our office.Key Responsibilities:Provide clerical and...


  • Midhurst, Ontario, Canada Simcoe County Full time

    Job Title: Administrative Assistant IIAt Simcoe County, we are seeking a highly skilled and organized Administrative Assistant II to join our team. As a key member of our Social & Community Services Division, you will provide administrative support to senior and middle managers, ensuring the smooth operation of our office.Key Responsibilities:Provide...

  • Planner Ii

    4 weeks ago


    Midhurst, Canada County of Simcoe Full time

    Requisition Title- Planner II- Close Date- 25 October 2024- Contract Type- Permanent - Full Time- Location- Midhurst, ON L9X 1N6 CA (Primary) - Job Description**DUTIES AND RESPONSIBILITIES (not listed in order of priority)**: - Review of mapped and written information related to physical and land use characteristics and other planning matters. - Providing...

  • Urban Planner II

    2 months ago


    Midhurst, Ontario, Canada Simcoe County Full time

    Job SummaryWe are seeking a highly skilled Urban Planner II to join our team at Simcoe County. As a key member of our planning department, you will be responsible for assembling and analyzing information to prepare recommendations regarding planning and development applications.Key ResponsibilitiesPrepare reports and provide comments on...

  • Urban Planner II

    1 month ago


    Midhurst, Ontario, Canada Simcoe County Full time

    Job SummaryWe are seeking a highly skilled Urban Planner II to join our team at Simcoe County. As a key member of our planning department, you will be responsible for assembling and analyzing information to prepare recommendations regarding planning and development applications.Key ResponsibilitiesPrepare reports and provide comments on...

  • Planner II Position

    4 weeks ago


    Midhurst, Ontario, Canada Simcoe County Full time

    Job SummaryWe are seeking a highly skilled Planner II to join our team at Simcoe County. As a key member of our planning department, you will be responsible for assembling and analyzing information to prepare recommendations regarding planning and development applications.Key ResponsibilitiesReport preparation and provision of comments on...

  • Planner II Position

    4 weeks ago


    Midhurst, Ontario, Canada Simcoe County Full time

    Job SummaryWe are seeking a highly skilled Planner II to join our team at Simcoe County. As a key member of our planning department, you will be responsible for assembling and analyzing information to prepare recommendations regarding planning and development applications.Key ResponsibilitiesReport preparation and provision of comments on...