System Applications Specialist

City of Las Cruces; Las Cruces (NM); On-site; USD 60,000 - 95,000; Full time

Job summary

City of Las Cruces is seeking an experienced IT professional to install, administer and maintain database-driven applications, ensuring availability, performance and security aligned with city goals, industry best practices, and regulatory requirements.

This full-time, exempt position involves coordinating testing, applying upgrades, and performing enhancements with staff and vendors to sustain high levels of service and data integrity across Microsoft Windows Server environments, MS SQL Server,

Qualifications

• Bachelor’s Degree in computer science, business computer systems, MIS, or related field and two years experience administering and supporting database-driven applications in a Microsoft multi-server network.

Responsibilities

• Administers and maintains database driven application systems, configuration, security, interface, access and performance support to users and vendors to ensure high availability, performance and security.
• Coordinates testing of new or existing applications, upgrades and applies functional changes with staff to enhance application or process efficiency.
• Recommends, schedules and performs software and hardware improvements, upgrades, patches, reconfigurations, and purchases to maintain system integrity and functionality.
• Maintains applications to support delivery of services using multiple platforms.
• Participates in capacity planning and development of long-term strategic goals for systems and applications.
• Monitors work orders for timely resolution and analyzes patterns to identify issues requiring research or changes in software/workflow.
• Performs advanced technical work to solve complex process issues and maintain performance and integrity.

Skills

Database administration

Testing & QA

Capacity planning

Project management

Communication

Education

Bachelor's degree in CS/IS/MS/MIS

Tools

MS SQL Server

Windows Server

ArcGIS SDE

SharePoint

IIS

LaserFiche

Job description

Installs, administers and maintains tiered software applications and functions to ensure availability, performance and security consistent with City goals, industry best practices, and regulatory requirements.

Environmental Factors

Work is performed in a standard office environment.

Physical Factors

Light physical demands. Frequent use of a personal computer.

Work Situation Factors

Position involves competing demands, performing multiple tasks, working to deadlines, occasional work beyond normal business hours, and responding to customer issues. Regular attendance is an essential function of this job to ensure continuity of services. Position is subject to drug testing in accordance with applicable State and Federal regulations and City of Las Cruces policies

Meeting or exceeding the minimum qualifications does not guarantee an invitation to participate in the process.

Full-time, regular, exempt position.

This position is graded RX19.

• Administers and maintains database driven application systems, configuration, security, interface, access and performance support to the user community and/or vendors to ensure high levels of availability, performance, and security.
• Coordinates testing of new or existing applications, upgrades and applies functional changes with applicable staff members to enhance application or process efficiency.
• Recommends, schedules, and performs software and hardware improvements, upgrades, patches, reconfigurations, and/or purchases to maintain system integrity and promote increased functionality.
• Maintains applications to support delivery of services using multiple application platforms.
• Advocates for, participates in, and supports capacity planning and development of long-term strategic goals for systems and applications to meet established objectives.
• Monitors and analyzes work orders for timely resolution to determine if patterns exist to indicate issues requiring research, testing and development or changes in the software and/or workflow processes.
• Performs advanced technical work in coordination with applicable staff to solve complex process issues, enhance and maintain application(s) performance and integrity.

Bachelor’s Degree in computer science, business computer systems, management information systems, or related field AND two years experience administering and supporting database-driven applications in a Microsoft multi-server network. A combination of education, experience, and training may be applied in accordance with City of Las Cruces policy.

Licenses/Certification(s)

Valid driver’s license may be required or preferred. If applicable, position requires an acceptable driving record in accordance with City of Las Cruces policies.

GeneralKnowledge of:

computer hardware and software; deploying and maintaining database driven applications in a Microsoft Windows Server environment using MS SQL server; ArcGIS SDE environment; current versions of MS IIS, Esri ArcGIS, LaserFiche Document Management System and Sharepoint; practices and principles of effective data management; writing and testing code, testing system functionality, and resolving anomalies; researching and implementing new features for systems and applications; systems software protocols and standards in the Microsoft environment; tools and techniques of effective project management; principles of maintaining network operating domains, relational databases, and windows-based software applications; troubleshooting techniques for network hardware, software and peripheral equipment; database systems integration, quality assurance procedures, and documentation of data sets; system access and security guidelines and procedures; City organization, operations, policies and procedures to successfully meet established goals and objectives.

Ability to:

assess and prioritize multiple tasks, projects and demands to meet project schedule requirements; work effectively with users, technical personnel and consultants to achieve stated objectives; establish and maintain effective working relations with co-workers and customers; communicate effectively verbally and in writing; work effectively independently and in a team environment; prepare and present accurate and reliable reports containing findings and recommendations; exercise initiative and independent judgment within established procedural guidelines; respond effectively to customers and perform a variety of duties and responsibilities timely and with accuracy to meet established deadlines.

Skills in:

operating a personal computer with installed generic and specialized software; using required software programming languages; developing computer applications using several programming languages and operating systems; analyzing, identifying and implementing solutions to technical problems; analyzing system malfunctions to determine, recommend and implement effective solutions; interpreting complex technical instructions; conducting research, preparing reports and recommendations.