Welcome to Simply Hired!

Like what you see here? Check out more Computer Occupations, All Other like this one.

Show Me More

Database Architect

Apply Now

Company: Hire IT People

Location: Washington, DC

Date Posted: June, 6 2014

Source: Hire IT People, LLC

This DDOE Project seeks to link together the data from a source of different “databases” into a system that can initially provide (1) DDOE Management and the District Council with real time reports of the status of our Investigations, Compliance actions and Enforcement cases (“ICE”) for all data,.(2) members of the public/others with non-confidential information regarding concluded enforcement actions and investigations and (3) 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 DDOE 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 DDOE intranet or the agency’s public internet website. ...

This DDOE Project seeks to link together the data from a source of different “databases” into a system that can initially provide (1) DDOE Management and the District Council with real time reports of the status of our Investigations, Compliance actions and Enforcement cases (“ICE”) for all data,.(2) members of the public/others with non-confidential information regarding concluded enforcement actions and investigations and (3) 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 DDOE 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 DDOE 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 telecommunication devices through wireless accounts. The system should be made ready for future access through smartphone apps.

This project requires data migration with a background in Quickbase, .Net, Reporting Tools, 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)

1. Development of a relational database, to encompass all the UST Branch needs, e.g. registration, enforcement, LUST records and all types of inspections and reporting. All existing and new UST, LUST and SOC data and reporting fields should be maintained and consolidated into one new database. Historical inspection results and database entries shall be imported in to the new system.

2. Transfer of forms, reports, directives, etc. from paper to electronic and vice versa, for all of the inspections and activities e.g. Site Directives/Corrective Actions, NOVs, etc.

3. Ability to store and associate photographs, correspondence, drawings/diagrams, PDF files, .doc files, and other case specific documents with a case record within the database

4. Calculation of SOC compliance metrics in EPA Reporting formation, translating answers in the various reporting checklist to compliance total and percentages..

5. PDF functionality is necessary, to allow storage of relevant documents in the soft and hard formats being directly accessible from the database.

6. Ability to query information contained within database(s). Queries shall displayed geospatially i.e. find all opened federally Regulated LUST Cases in DC 2010-2012.

7. Ability for tank owners and operators to pay DDOE annual registration fee online, accepting credit cards, veri-sign or pay-pal.

8. Allow inspectors through web link on their mobile apps, tough books and VPN connection to access the system offsite, in the field or at home to make relevant edits.

9. Maintain reporting fields, queries and EPA reporting requirements, matrices/calculations, etc. Should allow for printing automatic EPA reports, SOC Reports compliance metrics, LUST closed cases, confirmed releases, notification forms, etc.

10. Automatically print UST registration certificates and UST technicians and contractors approval certificates.

11. Merge with FOIA and Records Management Databases, including unknown tanks and Fire Department UST Records on the existence and location or certain records.

12. Provide graphical display of data to show graphs, charts, etc. on trends or other comparative statistical analysis across ward or inspectors, regulator, etc.

13. Integration of topic specific interactive help system into the application

Behavior Characteristics:

Works well as a team and independently.

Skills:

SQL Server Database Management Experience

Required 8 Years 3 - Expert

Experience with building and maintaining databases

Required 5 Years 3 - Expert

Experience with data migrations

Required 5 Years 2 - Proficient

Experience with Quickbase

Required 5 Years 2 - Proficient

Experience with GIS Integration

Required 5 Years 2 - Proficient

Show more

Other jobs you might like

  • Database Architect 4(14014300)

    NEW

    Northrop Grumman

    - Vienna, VA

    The National Exploitation System (NEXSYS) will improve operational performance, further the transformation of the National Media Exploitation Center (NMEC) into a continuously...

    3 days ago from Northrop Grumman
  • Senior Storage Engineer / Architect - NetApp

    URS

    - Washington, DC

    URS Federal Services has an immediate opportunity for a Storage Engineer / Architect to join our dynamic team supporting SEC. The position is in Washington, DC (Union Station /...

    30+ days ago from URS Corporation
  • OBIEE Developer- Govt Client

    NEW

    Imetrics Consulting

    - Washington, DC

    Please send you RATE RESUMES to priyankaimetrics-consulting.com. For immediate consideration please fill in all mentioned information Our direct client is looking for OBIEE...

    15 hours ago from Dice
  • Cyber Database Architect 2(14005717)

    NEW

    Northrop Grumman

    - Fort Belvoir, VA

    Designs, models, documents, and guides the logical and conceptual relationship of data and database changes for complex applications. Analyzes needs and requirements of existing...

    2 days ago from Northrop Grumman
  • Data Modeler, Active TS clearance

    NEW

    Deloitte Development

    - Washington, DC

    Deloitte Consulting LLP Deloitte Consulting LLP is one of the world's leading management consulting firms for executable strategy, operations, technology, and human capital...

    3 days ago from Deloitte Development LLC
  • Hadoop developer

    NEW

    Marshwinds International

    - Washington, DC

    Seeking a Hadoop developer for DC for 6 month project with good Pig and Hive skills for Data Management.. Looking for someone who can start asap .... start date is 69. Sr.

    1 day ago from Dice
  • Data Architect

    NEW

    Prism

    - Washington, DC

    Searching for a Data Architect with Oracle 10g+ design experience, to serve as the lead data architect for the redesign of two mission-critical applications. Job located in...

    1 day ago from Dice
  • Hadoop Developer

    Biz4mation

    - Mclean, VA

    The developer is responsible for the various aspects of development required by the Agile Team supporting assigned initiatives within the specific domain. These resources work...

    8 days ago from TheLadders.com
  • Senior Data Architect

    Cameron Craig Group

    - Washington, DC

    Purpose: The Data Architect will support projects under the guidance of the Chief Technical Officer to help define and support long-term, enterprise-level data architecture and...

    30+ days ago from Cameron Craig Group
  • Cyber Architect 3(13008850)

    NEW

    Northrop Grumman

    - Annapolis Junction, MD

    Northrop Grumman Information Systems sector is seeking a Computer Systems Architect with a focus on prototype development to join our team of qualified, diverse individuals. The...

    2 days ago from Northrop Grumman

Show Me More

Were you satisfied with these results? Yes | No
Thank you for your feedback!