Database Applications Specialist I

Position summary

Duties and responsibilities

• Design and develop database systems using the County technical environment, including MS-SQL, .NET, and SAP.
• Implement application security and manage access; architect reliable, high-performance systems and monitor metrics.
• Manage test and production code-promotion processes; develop SQL, stored procedures, SQL scripts, and web technologies.
• Design application logic, data structures, queries, calculations, workflows, and integrations.
• Plan and monitor pilot testing; create reports with SQL Reporting Services, SharePoint, MS Access, and MS Excel.
• Support transaction logs, backup and recovery; administer access rights and passwords.
• Troubleshoot operational failures, processing errors, and performance issues; work with vendors on resolution.
• Analyze new application needs with clients, model systems, evaluate requirements, and assess alternative solutions.
• Document systems, train users, provide ongoing end-user support, and prepare reports and presentations.
• Participate in committees, perform other assigned duties, and comply with occupational safety and confidentiality requirements.

Education and experience

• Three-year college diploma in Information Technology or Computer Programmer Analyst, or educational equivalency under County policy.
• Four years of IT experience developing and maintaining complex corporate databases, server platforms, and web applications in a large corporate setting.
• Knowledge of at least two of MS-SQL, SAP NetWeaver, Service Oriented Architecture, and Business Intelligence.
• Knowledge of HTML, XML, .NET, and JavaScript.

Other qualifications

• Problem-solving and critical-thinking skills; clear communication with users of differing technical knowledge.
• Ability to manage interruptions and multiple independent projects and prioritize work.
• Technical writing skills for procedures and reports.
• Valid G class driver’s licence and access to a reliable vehicle.
• Criminal records check less than six months old at time of hire.

Effort

• The provided description states that no physical effort of note is associated with the position.

Employment

• Permanent, full-time position.