POSITION SUMMARY
The Database Applications Specialist provides systems analysis and design support for corporate database systems, Business Intelligence (BI) / Analytics environments and web-based applications, including vendor liaison during implementation, programming support, troubleshooting, and operational support for all database and program maintenance functions. Responsible for the overall technical management of large and complex database systems and Business Intelligence (BI) / Analytics environments including systems security, authorized access, and business continuity.
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, MySQL, SAP HANA, Dataverse, PostgreSQL, Data Lake storage, Azure SQL, No-SQL and Database technologies, SAP Sybase .Net, PowerShell, Python, R).
2. Design and implement screen, field, table, and process level security to ensure appropriate user level access to applications.
3. Architect high performance, highly reliable database systems; monitor and adjust to ensure adherence to specified performance metrics.
4. Ensure the integrity of the various environments through the implementation and management of processes and procedures for testing and promoting code to production.
5. Provide programming expertise in the design and deployment of database and web technologies such as SQL, Stored Procedures, SSIS, SSAS, Azure Data Factory, Fabric Pipelines, Azure Data Integration and other Transformation technologies, SAP CPI, Azure Data Storage, SQL Scripting, PowerShell, HTML(5), XML, JavaScript, C#, Python, Java, REST, JSON, UI5, ABAP, oData, APIs etc.
6. Design applications logic including relational and hierarchical data structures, queries, numeric calculations, workflow, and systems integration processes.
7. Develop and monitor application pilot testing to determine functional compliance and user satisfaction.
8. Design and implement database reporting using built-in applications tools such as Power BI, SQL Reporting Services, Analysis Services, SharePoint, Excel, and 3rd party operational build in reporting utilities/platforms.
9. Assist in implementing transaction logs and backup / recovery procedures to ensure the integrity of all corporate applications.
10. Administer access rights and passwords to corporate databases, Business Intelligence (BI) / Analytics environments and applications.
11. Provide technical troubleshooting of operational failures, processing errors, and performance problems.
12. Undertake systems analysis and design for new software applications, including client consultation, modeling of current systems, evaluation of technical and end user requirements, and identification of alternative solutions.
13. Liaise with vendors regarding error descriptions and problem resolution.
14. Provide end user support by preparing program documentation, training on new systems, and ongoing support.
15. Prepare reports and presentations as required.
16. Participate in committees as required.
17. Perform other duties as assigned, including redeployment in emergency situations.
18. Comply with Provincial and County occupational health and safety legislation, regulations, policies and procedures.
19. Maintain confidentiality in accordance with the Municipal Freedom of Information and Protection of Privacy Act.
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
• Understanding of database architecture, applications programming, and network systems, achieved through a three-year College diploma in Information Technology, Computer Programmer Analyst or a related discipline or equivalent combination of education and experience. This job may be considered for educational equivalency in accordance with County Policy.
• Knowledge of two or more of the following core technologies (Microsoft Fabric, MS-SQL, MS-SSIS/Azure Synapse/Azure Data Factory (or equivalent ETL/ELT/Pipeline toolset), Azure or other Cloud Service Provider, .NET, SAP-Netweaver, Service Oriented Architecture, and Python, PowerShell, PySpark, R, XML, JSON, JavaScript, REST, oData, SAP UI5 / Fiori, etc.).
• Knowledge of web technologies (HTML(5), XML, .Net, Python, Java, JavaScript, REST, JSON, APIs, SAP UI5 / Fiori)
• 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.
• Knowledge and experience extracting and transforming data from various operational systems, databases and datastores, such as SAP S/4HANA, SQL, NoSQL, SaaS solutions through the use of APIs
• Relevant experience supporting a production environment, support management and continuous improvement
• Relevant certifications (e.g. Microsoft Azure / BI, DP-900, DP-600, PL-300 or equivalent experience) are highly desirable.
• Knowledge and application of CI/CD processes / Source Code Management Tools (Azure DevOps, GitHub, etc.) and utilizing Deployment Pipelines (CI/CD) to productionize applications, reports, dashboards and source code.
• Technical writing skills required to document systems procedures and prepare reports.
• Valid G class drivers license and access to reliable vehicle.
• Criminal records check that is less than 6 months old at time of hire.
EXPERIENCE
• Four (4) years of experience in the information technology field developing and maintaining complex corporate database systems, BI Environments, Reporting Platforms and associated server platforms, web-enabled applications, in a large corporate setting.
• Two (2) to Three (3) years reporting and database development experience with 1 or more of the following technologies: SQL, MDX, Power BI and MS-SSRS (or equivalent reporting platform), MS-SSIS/Azure Synapse, Azure Data Factor (or equivalent ETL/ELT), MS-SSAS (or equivalent Cube Structures), DAX, PowerShell, HTML5, REST, JSON, Python, Java, JavaScript, .NET, XML, SAP UI5 / Fiori
• Experience working in Microsoft Fabric / Azure Synapse considered an asset
• Experience working in a large, complex technical environment with a wide range of infrastructure
• Experience designing, developing, and supporting/maintaining BI, Reporting Platforms, Databases and/or web applications and Interfaces
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.
• Ability to work remotely if required.
