Perform database administration, design, and develop databases within an application; tune database and write solutions to improve system performance;
Participate in the analysis and design of County wide solutions like Data Warehouse and Data Marts;
Identify problems and provide resolutions in one or more off the shelf or third-party systems; develop processes and procedures to aid staff using applications;
Receive user requests and assist users in using complicated features of software applications, including queries, report generation, and data extraction;
Monitor system logs/performance data to identify potential problems and remedy identified issues;
Correct program problems by analyzing results of production runs, design and run test scenarios to diagnose problems; resolve data, configuration, and operator errors;
Analyze customer problems and requests; create solutions using advanced features of computer applications or creating detail program specifications for software engineers or vendors;
Prepare complex GIS layers, automate GIS tasks by creating scripts, complete complex analysis and create maps and other work products;
Write and maintain user documentation;
Install software packages and patches including pre-production testing; perform data conversion and package maintenance;
Ensure data is backed up; may perform data recovery or restoration;
Perform database administration, design and develop databases within an application;
May supervise, train, and evaluate performance of staff as assigned; and
Perform related duties as assigned.
Requirements :
Two (2) years experience in software development using SQL Server as a back-end; AND
Two (2) years experience working with the PeopleSoft Application, in particular, developing SQRs (Structured Query Reporter).