Applications Systems Analyst

Full-Time Benefits: Health, vision, dental, and life insurance; annual and sick leave; paid holidays; pension and tax-deferred compensation (457) plans; and more.

An employee in this class is responsible for performing a variety of assignments pertinent to analysis of data systems and manual systems for data processing application. Tasks are of more than average difficulty and include developing functional specifications, analyzing operational procedures and production systems, and preparing test data. Although under general supervision, these employees might engage in independent research and prepare and present reports of findings. The exercise of reasonable initiative and independent judgment is required in completing assigned tasks and meeting time constraints. Considerable tact and courtesy are required of these employees when serving as user liaison for development and maintenance projects. An employee in this class may be subject to on-call status on a rotating basis to provide 24 hour/7 day service. Work is performed on project teams and is reviewed while in progress and upon completion through documentation prepared and participation in project team meetings.

Examples of  Duties:

• Manage execution of scheduled database backups and maintenance across the enterprise
• Recommend system changes improving overall customer service
• Develop, and implement database schema changes including reviewing SQL scripts provided by developers Install and configure SQL Server database software
• Develop and implement database backup and recovery strategies
• Maintain organization wide security standards including user rights and data integrity
• Support the development life cycle and change control process as defined by organization wide standards
• Perform other duties as assigned

Working knowledge of: database infrastructure planning, implementation, and maintenance with special emphasis on change control, version upgrades, storage maintenance, and performance tuning; relational database design; various other technical disciplines including one or more of the following; client/server application development, web application development, third party application installation and configuration, OS configuration and troubleshooting, hardware configuration and troubleshooting; information security practices.  Knowledge of C# or Visual Basic .NET a plus        

Ability to: troubleshoot, diagnose, and resolve current and potential operational and system deficiencies and provide continued service availability;Demonstrate a customer centric work ethic while maintaining an effective working relationship with technical and non-technical staff; conduct independent research and prepare reports; analyze information and document procedures and processes; prepare detailed procedures manuals; perform project staff and librarian duties; express oneself clearly and concisely, both orally and in writing; establish and maintain effective working relationships with others.

Technical Skills: Automate tasks using job scheduling software, T-SQL, python, power shell and other scripting languages as required; Develop SQL Server T-SQL code when performing data changes, schema changes, and stored procedures; Develop ETL processes using SQL data tools or other software; Query, and SQL object creation using SQL Management Studio; Develop reports using SQL Server Report Builder or other software; deploying Visual Studio application solutions using Team Foundation Server; migrating data from MS Access to SQL Server.

Graduation from an accredited college or university with a Bachelor’s Degree in Computer Science, Management Information Systems or a related field computing field and one (1) year of experience in business systems (analyzing data and manual systems for data processing application); or an equivalent combination of training and experience.

 

Preferred Qualifications:

Graduation from an accredited college or university with a Bachelor’s degree or higher with a major in Computer Science, Management Information Systems, or a closely-related computing field, and (4) four years in information technology, including (2) two years of experience in relational database administration.

Possession of a valid drivers license may be required.

Evaluation of education and experience. Drug testing is included in all pre-employment processing.

HELPFUL HINTS FOR COMPLETING YOUR APPLICATION: Please register before you begin the application process. This will enable you to view and re-use information from previously submitted applications to complete and submit any future applications. Please make certain your application is complete and the information you provide clearly demonstrates that you possess the minimum job qualifications as stated in the job announcement. Resumes can be submitted in support of an application, but not in lieu of an application. Resumes and copies of certifications or other required documents may be attached to your online application.