Systems Analyst III

Santa Fe County NM; Santa Fe (NM); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Medical

Dental

Vision

Life Insurance

AD&D Insurance

Voluntary Life and AD&D

FSA

EAP

Gym Membership

Job summary

Santa Fe County NM seeks an experienced IT professional to lead and support system development, testing, and deployment. The role focuses on designing, implementing, and maintaining large-scale software applications and database architectures.

The ideal candidate has strong skills in SQL development, database tuning, and disaster recovery planning, with experience mentoring members of the IT Division. This is an on-site position with competitive county benefits.

Qualifications

• Bachelor’s degree in Computer Science, MIS, IT, or related field; and
• Six (6) years of relevant work experience in software development and support.
• Combination of education and experience may substitute for the degree/experience requirement.
• Experience substitutions: 30 semester hours = 1 year of experience.

Responsibilities

• Participates and leads development and implementation of systems; plans and directs project activities.
• Designs forms, reports, and documentation; completes system design and related documentation.
• Develops, debugs, and modifies existing applications; designs and configures database architecture.
• Oversees application security, validation, and implementation; mentors IT Division members.

Skills

Systems design

Database tuning

SQL development

Disaster recovery

Security administration

Project planning

Technical presentations

Mentoring

Documentation

Education

Bachelor’s degree in Computer Science/IT

10 years related experience or combined substitution

Tools

SQL Server

Oracle

PostgreSQL

Job description

Primary Purpose

Under general direction of the Systems Analyst Supervisor, supports various departments to understand stakeholder requirements that help applications align with the organization’s business process. Ensures effective application development, testing, release deployment, and support.

Essential Job Functions

• Participates and leads the development and implementation of systems by planning, directing project activities, gathering requirements or changes necessary to adapt existing work systems or processes to electronic data processing techniques.
• Designs forms, reports, and documentation.
• Completes system design and all associated documentation prior to systems implementation including narratives, flow charts, decisions table, input/output formats, and database design for management review; supports users in setting up sites, scripting, writing code, developing workflows, and any other system requirements.
• Designs, develops, and installs large scale software applications and configures new systems and hardware.
• Defines and maintains databases and files, logical sequence of information flow, requirements for programming and the systems control parameters.
• Develops, debugs, and modifies existing applications.
• Studies the present or planned systems and helps to formulate specific recommendations on the basis of cost benefits, volume analysis, personnel, etc., for management review.
• Makes formal presentations of systems recommendations to management and department personnel.
• Designs and configures database architecture for affected systems.
• Completes database troubleshooting and optimizing, identifying database corruption, backup/restores, replication, and disaster recovery planning.
• Understands department needs and technical requirements in order to determine and implement solutions.
• Supports databases as administrator, sets up accounts and security for users, and ensures effectiveness of backup databases.
• Mentors other members of the IT Division.
• Completes the setup and maintenance of test environments.
• Conceptualizes, designs, implements, and develops solutions for complex systems and programs independently.
• Defines and maintains databases and files, logical sequence of information flow, requirements for programming and the systems control parameters.
• Develops, administers and manages databases and their applications, performing monitoring and performance tuning as possible and appropriate.
• Completes projects that may span a broad range of applications and/or require expertise in multiple technical environments and business areas.
• Oversees application security, validation, evaluation, and implementation.
• Leads and participates in project planning processes; creates and presents development estimates and operational requirements to enable accurate planning with realistic timelines.
• Reviews technical design specifications developed by other members of the Systems Analysts team.
• Participates in identifying continuity/disaster recovery risks and mitigation plans; assists in developing and testing disaster recovery plans.
• Develops reports and presentations for senior management as needed.
• Assists with long-term strategic planning.

Knowledge/Skills

• Knowledge of form design; systems design and planning; data processing theory and application, logic functions and systems, and application programming languages, virtual memory, remote access item sharing, multi-processing and batch oriented random access systems.
• Knowledge of teleprocessing networks and communications; of software, hardware, capabilities, and systems software; and of file structure, file access methods; and of mathematics and accounting.
• Ability to perform under stress and meet deadlines; to interpret and develop flow charts, specifications, object codes and diagrams; to prepare and present implementation schedules; to formulate long and short range programs; to design and develop user systems; to develop methods for adapting work systems to electronic data processing techniques; to maintain confidentiality; and to communicate and work effectively with technical and non-technical staff.
• Ability to understand the implementation and impact of applications on the overall systems.
• Skilled in database performance management and tuning, fault analysis and remediation, database backups, disaster recovery procedures, database security, auditing, designing database architecture and SQL development, including hardware configuration, logical and physical database layouts, database management and monitoring multiple databases.

Minimum Qualifications

• Bachelor’s degree in Computer Science, Management Information Systems, Information Technology, or other Information Technology related field; and
• Six (6) years of relevant work experience in software development and support.
• Any combination of education from an accredited college or university in a related field and/or direct experience totaling ten (10) years may substitute for the required education and experience.
• Related experience may be substituted for required education at a rate of 30 semester hours equal to one (1) year of experience.

Working Conditions

Work is performed primarily in an office setting. Work schedule may include evening, weekend, emergency call and call-back hours. Some travel may be required. While performing the duties of this job, the employee regularly is required to stand, walk, and sit; reach with hands or arms; climb or balance; stoop, kneel, crouch, or crawl; and talk or hear. Clarity of vision at short distance required. May be required to lift up to 50 pounds on occasion. May be subject to exposure to electrical hazards, CRTs and VDTs.

Conditions Of Employment

Selected candidate must submit to and pass a County paid pre-employment physical and drug/alcohol screening. Additionally, selected candidate must submit to and pass a county paid criminal background screening. Selected candidate must possess and maintain a valid New Mexico Class D Driver’s License as incumbent shall be appointed to drive a County vehicle during the performance of his/her duties.

Santa Fe County is an Equal Opportunity Employer

It is the policy of Santa Fe County to ensure equal employment opportunity to all persons regardless of race, color, age, physical or mental handicap, sex, national origin, ancestry, religion, serious medical condition, sexual orientation, gender identity, genetic information, or political affiliation

Benefits Offered

• Medical
• Dental
• Vision
• Life Insurance
• Accidental Death & Dismemberment (AD&D) Insurance
• Voluntary Life and AD&D
• Short-Term DisabilityLong-Term Disability
• Flexible Spending Account (FSA)
• Employee Assistance Program (EAP)
• Gym Membership

Santa Fe County is proud to offer a comprehensive benefits package to eligible, full-time and part-time employees who work 20 hours per week. You will receive plan booklets, which give you more detailed information about each of these programs.

To learn more details, visit our website:

• Health Benefits
• Leave and Retirement
• Additional Employee Benefits
• Employee Development Program