City of Richmond, VA
Technology Systems Developer (DIT) - Services- Applications Division
City of Richmond, VA, Richmond, Virginia, United States, 23214
Salary :
$69,552.00 - $139,021.00 Annually
Location :
Richmond, VA
Job Type:
Full-Time
Job Number:
20M00000041
Department:
Information Technology
Opening Date:
11/15/2024
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 IncentiveReferral BonusT
uition Assistance ProgramDescription
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 functionalityDuties 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 protocolsServing as an essential employee, available for on-call support 24/7 during emergenciesIncumbents 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 requiredPREFERRED TRAINING AND EXPERIENCE:At least ten (10) years direct experience as developer working with Oracle applicationsTechnical fluency in relational databases. This includes solid SQL and PL/SQL skillsAt least (10) years of experience with large-scale Oracle databasesPreferred experience in the areas below
Oracle APEXOracle E-business suiteOracle ERP applicationsOracle 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, Talent Acquisition Partner, Senior at (804) 646-4705 or 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.
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.
01
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?
YesNo
02
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?
YesNo
03
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?
YesNo
04
Are you available and willing to work on call work hours to include evenings, weekends, and holidays?
YesNo
05
Which answer best describes your highest level of education?
High School Diploma/GEDSome collegeAssociate's DegreeBachelor's DegreeMaster's/Advanced DegreeNone of the above
06
Which best describes your experience performing duties in the Information Technology industry?
Less than one year of experienceOne to four years of experienceMore than four years of experience
07
Which best describes your years of experience with gathering and documenting requirements from a client?
Less than one year of experienceOne to four years of experienceMore than four years of experience
08
Which best describes your years of experience working in different phases of the Systems Development Life Cycle? (SDLC)
Less than one year of experienceOne to four years of experienceMore than four years of experience
09
Which describes your experience writing PL/SQL?
Less than one year of experienceOne to four years of experienceMore than four years of experience
10
How has your education, training and experience prepared you for this opportunity?
Required Question
$69,552.00 - $139,021.00 Annually
Location :
Richmond, VA
Job Type:
Full-Time
Job Number:
20M00000041
Department:
Information Technology
Opening Date:
11/15/2024
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 IncentiveReferral BonusT
uition Assistance ProgramDescription
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 functionalityDuties 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 protocolsServing as an essential employee, available for on-call support 24/7 during emergenciesIncumbents 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 requiredPREFERRED TRAINING AND EXPERIENCE:At least ten (10) years direct experience as developer working with Oracle applicationsTechnical fluency in relational databases. This includes solid SQL and PL/SQL skillsAt least (10) years of experience with large-scale Oracle databasesPreferred experience in the areas below
Oracle APEXOracle E-business suiteOracle ERP applicationsOracle 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, Talent Acquisition Partner, Senior at (804) 646-4705 or 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.
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.
01
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?
YesNo
02
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?
YesNo
03
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?
YesNo
04
Are you available and willing to work on call work hours to include evenings, weekends, and holidays?
YesNo
05
Which answer best describes your highest level of education?
High School Diploma/GEDSome collegeAssociate's DegreeBachelor's DegreeMaster's/Advanced DegreeNone of the above
06
Which best describes your experience performing duties in the Information Technology industry?
Less than one year of experienceOne to four years of experienceMore than four years of experience
07
Which best describes your years of experience with gathering and documenting requirements from a client?
Less than one year of experienceOne to four years of experienceMore than four years of experience
08
Which best describes your years of experience working in different phases of the Systems Development Life Cycle? (SDLC)
Less than one year of experienceOne to four years of experienceMore than four years of experience
09
Which describes your experience writing PL/SQL?
Less than one year of experienceOne to four years of experienceMore than four years of experience
10
How has your education, training and experience prepared you for this opportunity?
Required Question