Oracle / PL/SQL Specialist

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.

Forensics Tracking System (FORTS)

Sexual Offender Management System (SOMS)

Patient Cash Application (PCA)

Forensic Tracking System (FORTS) & the Sexual Offender Management System (SOMS) are used to track patients incarcerated by the state judicial system. The Patient Cash Application (PCA) tracks the cash of patients in the OMH facilities.

Daily Tasks will include but not limited to the following:

1. Write complex queries in PL/SQL for multiple applications. 

2. Participate in daily Scrum meetings to support Agile methodology used for system development on multiple systems. 

3. Write migration scripts for QA and Production for multiple applications.

4. Develop scripts for automating support and maintenance for multiple applications.

5. Interact with business users to translate requirements into technical models.

1. Good comm skills are a big priority
2. Duration: 24 months