Sr Applications Programmer

Salary: $37.19 – $52.33 Hourly

Location : City of Las Vegas, NV

Job Type: Full-Time

Job Number: 23OCT79998-O

Department: Department of Innovation and Technology

Division: IT – Municipal Court Operations

Opening Date: 10/03/2023

Closing Date: 10/17/2023 11:59 PM Pacific

Bargaining Unit: LVCEA

About the Position
Career Opportunity:

The City of Las Vegas invites applicants for Sr. Applications Programmer. This position performs advanced level of applications development and programming, system management, training, and a variety of technical tasks related to the assigned areas of responsibility.

Supervision Received and Exercised
Receives direction from higher level supervisory and management staff.
Type of Examination:A civil service examination will be conducted in accordance with the Civil Service Rules of the city of Las Vegas. The supplemental questions are the examination. Falsification of information may result in disqualification from recruitment or removal from a City position. Additional information will not be accepted after the closing date. The supplemental questions are weighted 100% for placement on an eligible list and must be worked on individually by the applicant only. The supplemental questions of all qualified applicants will be reviewed for placement on an eligible list.
EXAMPLE OF DUTIES

Essential Functions:

1. Plans, directs and participates in the evaluation, design, testing and maintenance of software applications.
2. Performs as a team leader in applications development; interviews and works with management, users and other information technology team members as applicable, to identify and document user business rules and processes and data requirements; develops and writes system and program specifications; develops and demonstrates prototypes for approval; conducts project status meetings with managers and users.
3. Designs, develops or modifies large, complex applications to meet user’s business requirements; designs system architecture; develops new applications and application enhancements/modifications; performs coding and debugging of programs, modules, and interfaces, utilizing applicable programming languages.
4. Participates in the peer review of other team members for accuracy, proper work methods and techniques, and compliance with applicable standards and specifications. Assists in the development, maintenance and quality control of programming and documentation standards.
5. Develops, documents and maintains applications design including, but not limited to, screens, reports, interfaces and programs; writes and tests new applications; develops corresponding time lines for assigned projects.
6. Consults with representatives from city departments and external organizations to resolve problems.
7. Monitors and evaluates operations and activities of assigned system responsibilities; recommends improvements and modifications; produces functional and visual design recommendations.
8. Performs database analysis to determine the most effective database designs and configuration; develops and implements new and improved database tables; creates and runs reports.
9. Prepares documentation for new applications and changes to existing applications; in accordance with established standards and procedures.

Marginal Functions:

1. Stays abreast of new computer programs or applications and trends or innovations in the assigned department; researches of new computer software and hardware; searches new web and mobile technologies and analyzes their possible application in the city.
2. Assists other departments with program and operational issues; analyzes causes of issues and recommends solutions or corrective actions.
3. Integrates commercial off the shelf software into the city’s Enterprise Resource Planning (ERP) environment.
4. Assists in the validation of new applications or modifications; assists in the development of validation criteria.
5. Performs related duties and responsibilities as required.

MINIMUM REQUIREMENTS

Experience:
Four years of increasingly responsible experience in advanced application programming. Experience in the hiring department is desirable.

Training:
Bachelor’s degree from an accredited college or university with major in computer sciences, business administration, management information systems or a field related to the essential functions.

A combination of formal education and directly related work experience may substitute for the degree. The city assesses 1.5 years of fulltime experience as equivalent to one year of education.

KNOWLEDGE, SKILLS, AND ABILITIES

Knowledge of:

Programming theory and current programming languages used in City, such as C#, VB.Net, ASP.Net, or Java.
Scripting languages such as VBScript or JavaScript.
Organizational structure, policies and operating procedures of the department and division.
Generally accepted software and system development life cycle processes.
Generally accepted validation and testing processes.
Generally accepted programming and documentation methods.
Principles and techniques of lead supervision.
Principles and techniques of project leadership.
Object and service oriented design concepts.
Database management.
Application user interface, reporting, query and backend development tools.
Structured Query Language (SQL).
Microsoft SQL Server.
XML.
Business rules and object development and support techniques.

Skills in:

Independently, and as a team member, performing the most difficult analysis and design activities assigned.
Analyzing, designing, and implementing complex information technology solutions.
Reading, understanding and applying relevant information from technical publications, manuals and other applicable media.

Ability to:

Perform advanced computer programming supported by solid documentation.
Effectively analyze and troubleshoot problems; formulate recommendations and alternatives, and implement solutions.
Utilize business intelligence solutions to improve performance and tuning.
Work independently with minimal supervision while adhering to the direction established by management and established policies, procedures and task assignments.
Communicate clearly and concisely, both orally and in writing.
Establish and maintain effective working relationships with those contacted in the course of work.
Manage multiple assignments and meet critical deadlines.
Demonstrate strong team-oriented interpersonal skills.

Competencies:

Core Workforce Competencies

Professionalism – Demonstrates core values by being honest, respectful and positive.

Effective Communication – Expresses verbal and written thought in a clear and understandable manner.

Customer Focus – Demonstrates genuine concern and satisfies external and/or internal customers based on the CLV core purpose and values.

Adaptability – Able to effectively modify behavior to suit changing workforce demands.

Problem Solving – Solves problems by considering all causes, solutions and outcomes.

Productive Partnerships – Develops, maintains and strengthens partnerships with others.

Technical and Safety Expertise – Possesses a depth of knowledge, skill and ability in a technical (job) area.

WORKING CONDITIONS:

Environmental Conditions:
Location: Office environment.
Hazards: Exposure to computer screens.

Physical Conditions:
Essential and marginal functions require:
Maintaining physical condition appropriate to the performance of assigned duties and responsibilities which include the following:
— Walking, standing, or sitting for extended periods of time; and
— Operating assigned equipment.
Maintaining effective audio-visual discrimination and perception needed for:
— Making observations;
— Communicating with others;
— Reading and writing; and
— Operating assigned equipment.
Maintaining mental capacity which allows the capability of:
— Making sound decisions;
— Effective interaction and communication with others; and
— Demonstrating intellectual capabilities.

CITY OF LAS VEGAS, NEVADA

LVCEA Compensation and Benefits – 2023

COMPENSATION

Annual Base Pay Increases

• Negotiated as part of the collective bargaining process.
• Step (Merit) Increase – typically awarded on the anniversary date of hire, up to range maximum.

BENEFITS

Uniform Allowance

• Available for some classifications.

Tool/Equipment Allowance

• Available for some classifications.

Retirement

• Benefit eligible employees participate in the Public Employees’ Retirement System of Nevada (PERS). PERS, a statewide defined benefit plan, calculates retirement benefits based on 2.25 percent (current percentage for employees hired 7/1/15 and after) for each year of service, applied to the employee’s highest consecutive 36-month average salary. PERS also requires that employees share 50 percent of the PERS contribution, which is implemented by reducing the City’s salary ranges. The highest consecutive 36-month average salary is increased commensurate with the salary range reductions required by PERS.

Deferred Compensation

• The city offers a 457(b) Plan which is a government deferred compensation plan similar to a 401(k) plan. It offers both pre-tax and after-tax savings and investment options.

Medical, Dental and Vision Insurance

• Employees are covered the first of the month following date of employment. Five medical plans, two dental and two vision plans are available. City pays 100% of employee premium + 50% of dependent premium.

Life and AD&D Insurance

• City provides $20,000 policies at no cost.
• Additional voluntary life insurance and AD&D insurance available for purchase.

Disability Insurance

• City provides a long term disability policy:
  • LTD: Employees who normally work at least 30 hours/week are eligible. Benefits begin after 90 days of disability. Payment is up to 60% of earnings, up to $11,000/month, and may not be supplemented with sick or vacation.

Tuition Reimbursement

Employee Assistance Program

ANNUAL PHYSICAL EXAMS

• Employees covered by a City health plan and their covered spouse and dependents over age 18 are eligible for a comprehensive wellness physical exam annually at no cost to them at WellTrac.

VACATION (Hours/Year)

• Year 1-2: 80 hours
• Years 3-7: 120 hours
• Years 8-10: 128 hours
• Years 11-15: 180 hours
• Year 16 and over: 200 hours
• Maximum accrual: 250 hours, if hired after 12/3/2014
• Sell-back: Up to 60 hours each year; must leave a balance of 40 hours in leave bank.

HOLIDAYS

• City provides 12 paid holidays plus a birthday holiday.

SICK LEAVE

• Sick Leave:104 hours per year
• Maximum Accrual: 420 hours, if hired after 12/03/2014
• Sick Leave Bonus:Negotiated sick leave bonus
• Payout at Separation: See contract

RETIREE HEALTH AND LIFE INSURANCE

• Available for purchase – retiree pays full cost of premiums.

NOTE: Benefits subject to change
Revised 01/2023

01

Applicants must complete this supplemental questionnaire as a part of the application screening and selection process. The information you provide will be reviewed and used to determine your eligibility to move forward in the selection process. Incomplete responses, false statements, omissions, or partial information may result in DISQUALIFICATION from the selection process. Do you agree to answer each supplemental question truthfully and that your responses can be verified from information included within the application?

• Yes
• No

02

When answering “yes” to the below supplemental questions about experience, education, driver’s license, or certification, please be sure the information is reflected in the appropriate section of your application.

• I acknowledge and understand the above statement

03

The city of Las Vegas does not accept resumes in lieu of a completed employment application. Qualifying education and experience, including city of Las Vegas employment must be clearly documented in the Education and Work Experience sections of the employment application. DO NOT substitute a resume for your employment application or write “see attached resume” on your application.

• I understand my resume will not be accepted in lieu of a completed employment application.

04

What is the highest level of education have you completed?

• High School/GED
• Associate’s Degree
• Bachelor’s Degree
• Master’s Degree
• Doctoral Degree
• None

05

A REQUIREMENT of this position is a Bachelor’s degree from an accredited college or university with major in computer sciences, business administration, management information systems or a field related to the essential functions. Do you meet this requirement?

• Yes
• No

06

Please disclose the discipline of your degree. Type “NA” If you do not have a degree.

07

How much increasingly responsible experience do you have in advanced application programming?

• No Experience
• 0-11 Months of Experience
• 1-2 Years of Experience
• 2-3 Years of Experience
• 4 Years of Experience
• 5 or more Years of Experience

08

Do you have programming experience using PL/SQL or TSQL, such as creation of stored procedures, Triggers, Packages, Procedures or Functions in any major DBMS such as Oracle or SQL Server?

• Yes
• No

09

SUPPLEMENTAL EXAMINATION: Questions 10 through 17 below are the examination for this recruitment. Your responses to the following questions will be read and scored by a Subject Matter Expert (SME). While reviewing your responses, the SME will not have access to your application/resume. Although you may have some of this information on your application, you will need to answer the questions completely. In order to give the SME the best opportunity to evaluate your responses, please make sure you read the question carefully and fully answer all the questions asked. This is your only opportunity to provide detailed information. Failure to provide full and complete answers may affect the outcome of your score and placement on the eligibility list. PLEASE DO NOT COPY AND PASTE YOUR RESUME.

• I have read, understand and will comply with the above information.

10

For each programming language in which you are proficient, identify at least one project and your role with sufficient detail to illustrate your contribution to the project.This experience must also be described in the “WORK HISTORY/EXPERIENCE” section of this application. If you don’t have this specific experience, please enter “N/A.” (Do not write “See Resume.”)

11

Describe your progression in computer programming support of enterprise wide applications, to include number of years at any level support. This experience must also be described in the “WORK HISTORY/EXPERIENCE” section of this application. If you don’t have this specific experience, please enter “N/A.” (Do not write “See Resume.”)

12

Please describe your experience with groovy programming language. If you do not have this experience please type N/A.(Do not write “See Resume.”)

13

Please describe your experience with any Web Development frameworks (ex. Angular, Node). if you do not have this experience please type N/A.This experience must also be described in the “WORK HISTORY/EXPERIENCE” section of this application. If you don’t have this specific experience, please enter “N/A.” (Do not write “See Resume.”)

14

Please describe your experience developing for Web content management systems, if you do not have this experience please type N/A. This experience must also be described in the “WORK HISTORY/EXPERIENCE” section of this application. If you don’t have this specific experience, please enter “N/A.” (Do not write “See Resume.”)

15

Describe Software Development Life Cycle.

16

Describe various Software Development models. What is your favorite model and why?

17

Please describe what you find to be most motivating in a workplace.

18

Please describe a program or project where you were the lead computer programmer.This experience must also be described in the “WORK HISTORY/EXPERIENCE” section of this application. If you don’t have this specific experience, please enter “N/A.” (Do not write “See Resume.”)

19

Name each application you have supported at an advanced level and describe the nature of that support.This experience must also be described in the “WORK HISTORY/EXPERIENCE” section of this application. If you don’t have this specific experience, please enter “N/A.” (Do not write “See Resume.”)

20

What has been your favorite work place experience and why?

Required Question