System Applications Specialist

City-of-Las-Cruces; Las Cruces (NM); In loco; USD 75.000 - 100.000; Tempo pieno

Descrizione del lavoro

City of Las Cruces is seeking a database/system administrator to install, administer and maintain database-driven applications, ensuring availability, performance and security. The role involves testing, upgrades, capacity planning, and coordinating with staff and vendors to improve efficiency.

The position requires a Bachelor’s degree in computer science or MIS and at least two years of related experience in a Microsoft multi-server network, with preference for strong security and data

Competenze

• Bachelor’s Degree in computer science, MIS, or related field with two years experience administering and supporting database-driven applications in a Microsoft multi-server network.
• Experience with Microsoft Windows Server environments, MS SQL Server, and security best practices.
• Ability to coordinate testing, upgrades, and apply changes with staff and vendors.

Mansioni

• 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.

Conoscenze

Database administration

MS SQL Server

Windows Server

Security best practices

System integration

Formazione

Bachelor’s Degree in Computer Science or MIS

Strumenti

ArcGIS SDE

SharePoint

LaserFiche

MS IIS

Descrizione del lavoro

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.