Database Systems Specialist I (Remote Work Available)

County of Simcoe; Midhurst; Hybrid; CAD 86,000 - 104,000; Full time

Job summary

County of Simcoe seeks a Database Applications Specialist I to support corporate database systems and web applications. You will liaison with vendors, provide programming support, and handle security, testing, and operational maintenance across MS-SQL, .NET and SAP environments.

You will design robust database architectures, implement access controls, and ensure business continuity while producing reports and training end users. This is a hybrid role with potential remote work as needed.

Qualifications

• Three year college diploma in IT or Programmer Analyst, or educational equivalency.
• Knowledge of two or more core technologies (MS-SQL, SAP NetWeaver, SOA, BI).
• Problem solving and critical thinking to diagnose issues.
• Able to translate technical language for training purposes.
• Able to work on multiple projects with good priorities and judgment.
• Technical writing skills to document procedures and reports.
• Valid G class license and access to reliable vehicle.
• Criminal records check within six months of hire.

Responsibilities

• Provide programming expertise in design and development of database systems (MS-SQL, .NET, SAP).
• Design and implement screen, field, table and process level security.
• Architect high performance, reliable database systems and monitor metrics.
• Ensure integrity of environments via testing and promotion procedures.
• Design application logic including data structures, queries and integration.
• Develop and monitor pilot testing for compliance and user satisfaction.
• Implement reporting using SSRS, SharePoint, MS-Access and MS-Excel.
• Assist in transaction logs and backup/recovery procedures.
• Administer database access rights and passwords.
• Provide troubleshooting for operational failures and performance issues.
• Undertake systems analysis and design for new software applications.
• Liaise with vendors for error resolution.
• Provide end user support and training, plus documentation.
• Prepare reports and presentations; participate in committees.
• Perform other duties including redeployment in emergencies; comply with safety rules.

Skills

Database design

Systems analysis

Troubleshooting

Vendor liaison

MS-SQL

NET/.NET

SAP

Security controls

Business continuity

Education

College diploma in IT or Programmer Analyst

Tools

SharePoint

MS-Access

MS-Excel

SQL Reporting Services

SAP NetWeaver

Job description

County of Simcoe seeks a Database Applications Specialist I to support corporate database systems and web applications. You will liaison with vendors, provide programming support, and handle security, testing, and operational maintenance across MS-SQL, .NET and SAP environments.

You will design robust database architectures, implement access controls, and ensure business continuity while producing reports and training end users. This is a hybrid role with potential remote work as needed.