Demo

Technology Systems Developer - Services - Applications Division

City of Richmond, VA
Richmond, VA Full Time
POSTED ON 3/3/2025
AVAILABLE BEFORE 6/3/2025

Salary : $69,552.00 - $139,021.00 Annually

Location : Richmond, VA

Job Type : Full-Time

Job Number : 20M00000041

Department : Information Technology

Opening Date : 02 / 26 / 2025

Are you Richmond R.E.A.D.Y ?

R espect. E quity. A ccountability. D iversity... YOU !!!

This is an EXCITING time to Join the City of Richmond! We are committed to nurturing talent, fostering growth opportunities, and building strong connections within our workforce. As we continue to make strides to becoming the employer of choice, we are thrilled about the below employee benefit enhancements :

  • Virginia Retirement System (VRS)
  • Language Incentive
  • Referral Bonus
  • T uition Assistance Program

Description

The City of Richmond Department of Information Technology is actively seeking a talented individual to join our team as a Technology Systems Developer - Oracle Apex, within the Applications Division. If you're passionate about cutting-edge technology and thrive in a dynamic environment, this role is for you.

About Us :

The City of Richmond Department of Information Technology is dedicated to leveraging technology to enhance public services and streamline operations. As a Technology Systems Developer, you'll play a crucial role in the development, implementation, and maintenance of our in-house developed Oracle Apex revenue collection management system, contributing to the efficiency and effectiveness of city operations.

Why Join Us :

By joining the City of Richmond Information Technology Team, we offer the opportunity to work on impactful projects that directly benefit the community, within a collaborative and supportive work environment. We understand the importance of having access to professional development opportunities aimed at enhancing your skills and advancing your career. In joining this dynamic team, you'll not only find fulfillment in your work but also a platform to grow and excel professionally.

Position Overview :

As a Technology Systems Developer - Oracle Apex, you will be responsible for enhancing, supporting, and maintaining of our in-house developed Oracle Apex revenue collection management system. We are seeking a skilled Oracle Apex Developer with a strong background in full-stack development and extensive experience in designing, developing, and implementing browser-based applications using Oracle Application Express (APEX) and related web technologies. The successful candidate will have a solid understanding of Oracle databases, data migration, query optimization, and JavaScript. You will be responsible for designing and maintaining custom Oracle applications, and your expertise in JavaScript will be crucial in enhancing user interfaces and overall application functionality

Duties include but are not limited to

  • Gather and analyze user requirements to design effective solutions using Oracle APEX.
  • Develop and implement browser-based applications using Oracle APEX 18 or higher.
  • Design, develop, and maintain custom Oracle applications leveraging Oracle APEX.
  • Write SQL and PL / SQL scripts for data conversion and migration processes.
  • Develop External Tables, Joins, Indexes, and sequences to optimize database performance.
  • Utilize JavaScript to enhance user interfaces and application functionality.
  • Create dynamic reports within the Oracle APEX environment using APEX reporting tools.
  • Support workflow and process automation for revenue functions.
  • Lead requirement gathering sessions and define solution sets to meet project objectives.
  • Debug complex applications and address defects within a fast-paced environment.
  • Collaborate with cross-functional teams to ensure the successful delivery of projects.
  • Provide expertise in query optimization, performance tuning, and PL / SQL development.
  • Utilize tools such as SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, and Bulk Collect.
  • Demonstrate effective communication skills to convey technical concepts to non-technical stakeholders.
  • Ensuring compliance with City standards and protocols
  • Serving as an essential employee, available for on-call support 24 / 7 during emergencies
  • Incumbents serves as an Essential employee, which means that the incumbent is required to work when the City is closed due to public emergencies, critical or hazardous conditions, or inclement weather The incumbent in this position is required to serve on-call 24 hours / 7 days a week to provide leadership for the support and resolution of problems for critical systems and applications within the assigned City of Richmond portfolio.

    Qualifications, Special Certifications and Licenses

    KNOWLEDGE, SKILLS AND ABILITIES :

  • Proficiency in SQL and PL / SQL scripting for data conversion and migration.
  • Strong expertise in developing External Tables, Joins, Indexes, and sequences.
  • Ability to write ad-hoc SQL queries and develop shell scripts as needed.
  • Proficiency with protocols such as web services and application program interfaces.
  • Experience with mobile application development.
  • Proficiency in JavaScript for enhancing user interfaces and application functionality.
  • Experience with query optimization, performance tuning, and PL / SQL development.
  • Proven ability to debug complex applications and remediate defects in a fast-paced environment.
  • Effective creation of dynamic reports using APEX reporting tools.
  • Demonstrated leadership skills with the ability to lead groups and gather requirements.
  • Strong problem-solving skills and attention to detail.
  • Excellent communication skills for interacting with technical and non-technical stakeholders.
  • MINIMUM TRAINING AND EXPERIENCE :

  • Bachelor's degree in computer science, systems development, or database management.
  • Minimum of 10 years of experience as an Oracle APEX full-stack developer.
  • Extensive experience in designing and maintaining custom Oracle applications using APEX.
  • Technical fluency in relational databases, including solid SQL and PL / SQL skills.
  • Familiarity with Oracle APEX 18 or higher.
  • Experience with global temporary tables and table partitioning.
  • Knowledge of web technologies and frameworks.
  • Familiarity with agile development methodologies.
  • LICENSING, CERTIFICATIONS, and / or OTHER SPECIAL REQUIREMENTS :

  • None required
  • PREFERRED TRAINING AND EXPERIENCE :

  • At least ten (10) years direct experience as developer working with Oracle applications
  • Technical fluency in relational databases. This includes solid SQL and PL / SQL skills
  • At least (10) years of experience with large-scale Oracle databases
  • Preferred experience in the areas below
  • Oracle APEX

  • Oracle E-business suite
  • Oracle ERP applications
  • Oracle 11i / 12r.
  • Equal Employment Opportunity Statement

    The City of Richmond provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

    The City of Richmond is committed to the full inclusion of all qualified individuals. As part of this commitment, the City of Richmond will ensure that persons with disabilities are provided with reasonable accommodations. If you require reasonable accommodations under the Americans with Disabilities Act (ADA) to participate in the job application and / or the interview process, please contact Jessica McKenzie, Human Resources Manager by email at

    This policy applies to all terms and conditions of employment, including recruitment, hiring, placement, promotion, termination, layoff, transfer, leaves of absence, compensation and training.

    The City of Richmond Values Veterans. We are an official V3 Certified Company .

    The City of Richmond is a proud partner with the US Army Partnership for Your Success PaYS Program.

    With over 4,000 employees, the City of Richmond is an "Employer of Choice" among cities throughout the nation. The City strives to hire and retain employees who bring dedication and talent to the workforce. Offering a competitive, cost effective, and quality benefits package is one element of an "Employer of Choice".

    The City offers a full range of benefit programs from initial hire through retirement. Please visit our Web site for details.

    10-point compensable veteran. You must have an existing compensable service-connected disability of 10 percent or more. Other 10-point veteran include disabled veteran or a veteran who was awarded the Purple Heart for wound or injuries received in action, veteran's widow or widower who has not remarried, wife or husband of a veteran who has a service-connected disability, widowed, divorced or separated mother of an ex-service son or daughter who died in action, or who is totally and permanently disabled. Do any of these apply?

    5-point veteran's must have been discharged under honorable conditions and had one of the following : Active duty in the Armed Forces of the United States, in a war, or during the period 4 / 28 / 52-7 / 1 / 55 or active duty for more than 180 consecutive days other than for training, any part of which occurred during the period beginning 2 / 1 / 55 and 10 / 14 / 76 or active duty during the Gulf War sometime between 8 / 2 / 90 - 1 / 2 / 92 or active duty in a campaign or expedition for which a campaign badge has been authorized or active duty for which more than 180 consecutive days other than for training, any part of which occurred during the period beginning 9 / 11 / 2001 and ending on the date prescribed by the Presidential proclamation or by the law as the last date of operation Iraqi Freedom. Do any of these apply?

    Employees in this job classification are designated ESSENTIAL PERSONNEL and must be available to report to work during disasters, inclement weather, and other declared emergencies. Are you available and willing to work under these conditions?

    Are you available and willing to work on call work hours to include evenings, weekends, and holidays?

    Which answer best describes your highest level of education?

  • High School Diploma / GED
  • Some college
  • Associate's Degree
  • Bachelor's Degree
  • Master's / Advanced Degree
  • None of the above
  • Which best describes your experience performing duties in the Information Technology industry?

  • Less than one year of experience
  • One to four years of experience
  • More than four years of experience
  • Which best describes your years of experience with gathering and documenting requirements from a client?

  • Less than one year of experience
  • One to four years of experience
  • More than four years of experience
  • Which best describes your years of experience working in different phases of the Systems Development Life Cycle? (SDLC)

  • Less than one year of experience
  • One to four years of experience
  • More than four years of experience
  • Which describes your experience writing PL / SQL?

  • Less than one year of experience
  • One to four years of experience
  • More than four years of experience
  • How has your education, training and experience prepared you for this opportunity?

    Required Question

    Salary : $69,552 - $139,021

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Technology Systems Developer - Services - Applications Division?

    Sign up to receive alerts about other jobs on the Technology Systems Developer - Services - Applications Division career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $72,538 - $87,299
    Income Estimation: 
    $88,790 - $110,816
    Income Estimation: 
    $88,790 - $110,816
    Income Estimation: 
    $107,385 - $134,565
    Income Estimation: 
    $107,385 - $134,565
    Income Estimation: 
    $128,473 - $158,030
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at City of Richmond, VA

    City of Richmond, VA
    Hired Organization Address Richmond, VA Full Time
    Are you Richmond R.E.A.D.Y ? R espect. E quity. A ccountability. D iversity… YOU !!! This is an EXCITING time to Join th...
    City of Richmond, VA
    Hired Organization Address Richmond, VA Full Time
    Are you Richmond R.E.A.D.Y ? R espect. E quity. A ccountability. D iversity… YOU !!! This is an EXCITING time to Join th...
    City of Richmond, VA
    Hired Organization Address Richmond, VA Full Time
    The City of Richmond, Department of Public Utilities - Gas Distribution Division, is seeking qualified individuals to fi...
    City of Richmond, VA
    Hired Organization Address Richmond, VA Full Time
    Salary : $70,122.00 - $109,963.00 Annually Location : Richmond, VA Job Type : Full-Time Permanent Job Number : 08M000000...

    Not the job you're looking for? Here are some other Technology Systems Developer - Services - Applications Division jobs in the Richmond, VA area that may be a better fit.

    Applications Developer - 00152

    Department of General Services, Richmond, VA

    Technology Systems Developer - ERP

    City of Richmond, VA, Richmond, VA

    AI Assistant is available now!

    Feel free to start your new journey!