Technology Systems Developer (DIT) - Services- Applications Division

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

Respect. Equity. Accountability. Diversity…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


• Tuition Assistance Program

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

• 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

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.

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

• None required

• 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
  1. Oracle APEX
  2. Oracle E-business suite
  3. Oracle ERP applications
  4. 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, Talent Acquisition Partner, Senior at (804) 646-4705 or by email at Jessica.McKenzie@RVA.GOV.

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.