Programmer Analyst 4

Ampcus, Inc; Richmond (VA); On-site; USD 85,000 - 115,000; Full time

Job summary

A certified technology and consulting firm is searching for a highly motivated Programmer Analyst 4 to join their team in Richmond, VA. The role involves developing and maintaining Oracle Apex applications, optimizing complex SQL queries, and performing debugging in a fast-paced environment. The ideal candidate has over 10 years of relevant experience, including strong skills in SQL, PL/SQL, and effective requirements gathering. This is a full-time position offering a chance to significantly contribute to financial application systems.

Qualifications

• 10+ years developing and maintaining custom Oracle applications using Oracle Apex.
• 10+ years in SQL, PL/SQL for data conversion and migration.
• 10+ years optimizing queries and performance in PL/SQL.

Responsibilities

• Develop and support Oracle Apex full stack applications.
• Design complex Oracle SQL logic for financial applications.

Skills

Oracle Apex design

SQL scripting

PL/SQL development

Query optimization

Application debugging

Dynamic report creation

Requirements gathering

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Programmer Analyst 4. Location: Richmond, VA.

Complete Description

• The City seeks a full-time Oracle Apex full stack developer to support a robust financial application supporting key revenue streams for the City.
• Candidates must be experienced with designing and executing complex Oracle SQL logic in the integration of data to support its Oracle Enterprise Resource Planning system.

Required / Desired Skills and Experience

• Experience designing and maintaining custom Oracle applications using Oracle Apex - Required 10 Years.
• Experience in developing scripts in SQL, PLSQL for data conversion, data migration - Required 10 Years.
• Experience in developing External Tables, Joins, Indexes, and sequences. Ability to write ad-hoc SQL queries and code shell scripts as needed - Required 10 Years.
• Query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect - Required 10 Years.
• Experience debugging complex applications and remediating defects in a fast-paced environment - Required 10 Years.
• Effective creation of dynamic reports within the Oracle APEX environment, using APEX reporting tools - Required 10 Years.
• Ability to lead groups, gather requirements, define solution sets, and remediate defects - Required 10 Years.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.