Law

Title: ICE Database Architect

Duration: 6+ months

Location: Washington, DC

Job Description:

Management and the District Council with real time reports of the status of our investigations,

compliance actions and enforcement cases ("ICE") for all data,.

Members of the public/others with non-confidential information regarding concluded enforcement actions and investigations and

Provide varying levels of access for other data depending on the individual. (This is "the Project" or "the ICE Project".)

The project seeks to provide integration of the present and anticipated ICE Systems databases to a common

interface that will allow one-time data entry and report generation, even if data are actually stored in different

program formats. Additional hardware, particularly, storage and processing capacity, may be required.

The interface and access should be through web-based systems, whether the intranet or the agency's public

internet website. While initially the system might be accessible only over wires or through existing wifi clients,

ultimately field staff should be able to use a wireless account. The system should be made ready for future access

through smartphone apps.

This project requires a strong background in Quickbase and the use of MS Suite migration tools for Access, Excel

and good XML experience.

After concluding the assessment for the requirements, the Architect will be responsible for the implementation,

installation, testing, training and documentation of the "ICE Project".

Data Warehouse

• Implement multiple methods of data extraction.

• Write Packages, Procedures and Functions for data transformations.

• High level of expertise in parallel operations and parallel executions.

• Maintenance and support of Materialized views.

• Support for data profiling, meta data analysis, data modeling and relational schema.

• Backup & recovery

• Create data models, develop Data Warehouses and relational databases (MS SQL Server)

Background Check Required, if selected.

Regards

Kevin

Amtex Systems Inc.

50 Broad Street, Suite 801

New York, NY-10004

Cell:       917-463-4086

GTalk id: amtex.kevinb@gmail.com

E-mail: kevinb@amtexsystems.com