Date Posted: May 15, 2017
City/Organization: Washington County, OR
Title: IT - Senior Application Development & Support Analyst
IT - Senior Application Development & Support Analyst - Washington County, OR
Are you passionate about your career and the contributions that you make on a day to day basis providing solutions to complex application development projects? Have you considered continuing your profession in the public sector with a local government agency? If so, your talents will directly contribute to programs that continuously improve the services we provide to the residents of Washington County, Oregon, and we encourage you to apply.
As an advanced level analyst, you will be adding a skill set to assist team members in the support of systems which are growing in complexity, or will be new to the organization. Additionally, you will utilize your Microsoft (MS) SQL Server skills to implement, migrate, upgrade, integrate and enhance application systems; analyze and trouble-shoot problems as well as resolve software issues; and collaborate with the Database Administration staff, Project Management resources and Technical Managers through the life cycle of each major initiative.
We offer a collaborative culture, work-life balance, and a comprehensive benefits package. Working within our local government agency provides daily opportunities to serve, build and sustain communities now and into the future. Washington County is an affirmative active and equal opportunity employer with a commitment to a diverse and inclusive workforce representing the rich diversity in our region. Women, minorities, veterans and people with disabilities are encouraged to apply.
ESSENTIAL JOB DUTIES
This advanced level analyst position will perform the following responsibilities:
Maintains the operational integrity of business applications in the technology areas assigned.
Collaborates with users and departments to analyze current and projected data information, needs and resources required.
Develops detailed requirements documents and design specifications, definitions, flow charts, diagrams, performance criteria, and testing methods, (SQL Server based preferred), for maintaining both new and existing systems.
Writes, develops, and documents operational procedures for data elements and sources.
Assists with the coordination of systems maintenance, testing, and production job runs.
Plans schedules for implementation, monitors progress, and develops and provides training and technical guidance to users and staff in the use of new or modified systems and procedures.
Assists with the migration of current databases into new database structures when required.
Provides professional data analysis and programming, (SQL Server based preferred), in the technology areas assigned.
Installs, configures, and implements new third party vendor databases and applications.
Provides technical assistance and training to support IT analysts and contractors in the development, testing, debugging, and implementation of new or modified systems.
Assists in the monitoring of day-to-day operations, performance, and space requirements of Microsoft SQL-Server database.
Develops and works with MS SQL Server based reporting solutions or SQL Server methodologies, such as SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), stored procedures, and views.
Works in partnership with departmental customers and supports mass print job requests as required.
Collaborates with and supports mobile solutions.
Provides end-user support in technology areas as assigned.
Demonstrates expertise in presentation and management and end-user interactions.
KNOWLEDGE, SKILLS AND ABILITIES
Education and Experience:
A typical way to obtain the minimum required knowledge, skills and abilities would be:
A Bachelor's Degree in computer science, business administration, or related field; AND
Four (4) years of experience providing professional level information technology analysis and support, which will include bulleted criteria below: OR
Any combination of education and experience equivalent to eight (8) years of experience providing professional level information technology analysis and support, which will include the bulleted criteria listed below:
Performing MS SQL Server queries and programming, including writing complex queries, developing stored procedures, using Microsoft SQL Server Management Studio, developing and publishing packages using SQL Services Integration Services (SSIS) for data package transfer between servers using Microsoft Visual Studio, and developing reports using Microsoft SQL Server Reporting Services (SSRS);
Participating in formal presentations, conducting formal meetings, explaining technical and complex information to users and management; and ability to design and analyze and provide documentation on processes and procedures for advanced systems;
Working knowledge of general IT technologies from LAN/WAN, wireless and basic IT infrastructure (servers) and hardware (PC, laptop);
Providing peripheral support as required, but not limited to, Mobile devices, scanners, bar code scanner wands, printers, etc.; and
Establishing and maintaining cooperative working relationships with individuals, the public, or coworkers, representing diverse groups and backgrounds.
Please note: IT - Senior Application Development & Support Analyst is a working title for the classification of Senior Information Systems Analyst. Washington County organizes its positions into classifications. Classification descriptions are typically written broadly. To review the complete classification for this position, please use this link: Senior Information Systems Analyst
Background Investigation Requirement:
Post job offer, this position requires the successful completion of a background investigation.
Department of Motor Vehicles Records Requirement:
Driving a motorized vehicle is an essential function of this position. Successful applicants must possess a valid driver's license and an acceptable driving record. Washington County will review Department of Motor Vehicle (DMV) records on candidates prior to the interviewing phase of the selection process. Please ensure driver's license information is correct and complete on your employment application.
Washington County has the ability to check Oregon DMV records electronically. We do not possess this ability for out-of-state applicants. If you reside outside the State of Oregon, you will need to submit a certified DMV record(s) for the last three year period of time. This would include holding a non-Oregon DMV license in the last three year period of time. Please forward the copies to: email@example.com; or attached an electronic copy to your application packet. To review the Driver's License and Record Policy for Washington County use the following link: DMV Records Policy
Washington County is committed to using a Merit Based System in which recruiting, selecting, and advancing employees is based on their relative knowledge, skills, and abilities.
1. An evaluation of training and experience of submitted applications will be performed by Human Resources as applications are submitted.
2. A Subject Matter Expert (SME) Panel will perform an evaluation of experience and training taken from your employment application materials to include responses to the supplemental questions. This process will begin after May 29, 2017.
3. A DMV records check (covering the last 3 year period) will be performed on candidates that pass the SME evaluation step in the selection process. Out-of-state candidates, or candidates that have possessed a non-Oregon DMV license may wait until the results of the SME evaluations have been posted before submitting their DMV records.
4. Our goal is to schedule oral panel interviews with candidates that successfully passed the SME evaluation step and the DMV records check as soon as possible.
Please note: candidates that are successful in the evaluation process may have their applications referred for additional vacancies in the same classification, or job family.
If you are a veteran and would like to be considered for a veteran's preference for this recruitment, please review instructions by clicking here(Download PDF reader).
Accommodation under the Americans with Disabilities Act:
Reasonable accommodation is available to anyone whose specific disability prevents them from completing this application or participating in the selection process for this recruitment. To obtain confidential assistance please contact Human Resources 503-846-8606, or e-mail at: firstname.lastname@example.org at least 48 hours before any step in the recruitment and selection process for which you feel you need accommodation.
Status of Your Application:
You will be advised by e-mail of your status at each step in the application process, from initial application to final employment disposition.