Oracle Database/Forms and Reports Developer - Allied Consultants : Job Details

Overview

Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Oracle Database/Forms and Reports Developer to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.

**Location: Hybrid**

Responsibilities

The client is seeking an Oracle Database/Forms and Reports Developer (hereafter “the Developer”) who satisfies both the general qualifications of an Oracle Database/Forms and Reports Developer and the specific requirements detailed herein for the client.

The Developer will assume senior-level responsibilities that include analyzing requirements, developing both server and client software throughout its lifecycle, performing unit testing, and producing relevant documentation. In addition, the Developer will devise innovative methods for handling data securely across various schemas and servers.

The Developer will interpret project requirements and implement or maintain corresponding database components in accordance with client specifications. Responsibilities also include reverse engineering and troubleshooting complex legacy applications using available documentation and baseline requirements, providing support in reading, interpreting, and maintaining code in Oracle Forms, Oracle Reports, and related technologies, as well as advising both the team and management on technical decisions.

The position further involves contributing to complex database design, optimizing queries, and working with additional databases such as SQL Server and PostgreSQL. The Developer must demonstrate proficiency in writing scripts to migrate objects and data across various databases, as well as in developing functions, procedures, Web PL/SQL, and other packages in Oracle Database.

Expert knowledge of the Oracle Fusion Middleware Product Suite is required, alongside extensive experience in developing and supporting applications using Oracle Forms and Reports. The Developer will assist in migrating solutions to alternative technologies, including modifying queries and delivering new functionalities in Oracle Reports, as well as guiding and assisting in the conversion of Oracle Reports to other platforms.

The Developer must be adept at collaborating within a large project team, existing database developers as well as working independently, demonstrating thorough knowledge of security, version control, and other software development best practices. The role also includes project management activities, providing after-hours support for application and assists in database upgrades or maintenance, and offering emergency support as needed. The Developer works under limited supervision with considerable latitude for initiative and independent judgment. Additional duties may be assigned as required. Compliance with all applicable Agency, Division, and Branch rules, regulations, and procedures is mandatory.

Qualifications

• 7 years experience designing and developing Oracle database for applications including Pl/SQL,SSL, entity relationship diagramming and review, table normalization, performance tuning on relational databases.
• 5 yeas of Oracle Forms and Reports development and support experience
• 5 years working in a project team environment, Agile Methodology
• 5 years testing to ensure accessibility and other existing standards are met
• 5 years maintaining effective working relationships
• 3 years experience with other DB technologies (SQL Server, MySQL, PostgreSQL, MongoDB, etc)
• 3 years skilled writing SQL in industry standard relational databases.

Preferred:

• 5 years managing multiple task priorities
• 3 years leading Database team
• 3 years of PowerBI experience