PL/SQL Developer

The selected candidate will write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production, and improved transaction editing.

Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, may lead and direct the work of others, a wide degree of creativity and latitude is expected.

Develop database packages, procedures, functions, and queries to maintain production data and address production support tickets and provide development support.

Archive changes to a historical database.

Archive changes for synchronization with external databases.

Procedures will be developed to migrate these changes or notify business users based on type of edit and business rules.

Develop procedures to populate and update a separate de-normalized database for reporting purposes from the transaction database.

Use Microsoft Team Foundation Server for source code management and team collaboration

8 to 10 years of experience in the field or in a related area

Bachelor s Degree in Computer Science, Information Systems with strong development experience or other applicable and/or equivalent development skills, knowledge and work history.

Knowledge of and experience with the following technologies:

Oracle 11g/12c

PL/SQL

Toad

SQL

SQL Developer

SQL Loader

Source Code and Team Management software (TFS preferred)

Special Instructions to Applicants:

This position requires a fingerprint-based background check.

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG’s primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients - including governmental agencies and private companies - throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.