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: August 8, 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 ...

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

  • Senior Data Architect TS/SCI

    McKenna Principals

    - Herndon, VA

    The McKenna Principals is looking for a Senior Data Architect with an active TS/SCI to join our dynamic team! The Data Architect/XML Schema Developer will be working in a...

    5 days ago from TheLadders.com
  • System Architect (Data Network Architect)

    AT&T

    - Woodlawn, MD

    Responsibilities: Life cycle management of a complex data network supporting a multi-site Cisco UCCE call center deployment with secure integration to client back-end applications...

    30+ days ago from AT&T
  • Data Modeler

    NEW

    Canopyone Solutions

    - Washington, DC

    Role: Data Modeler Location: Washington, DC Duration: 6 months+ Requirements: * College Degree with a minimum of 4 years of data architecture experience, or equivalent total...

    1 day ago from Tech Fetch
  • 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...

    17 days ago from ZipRecruiter
  • NoSQL Data Architect - Big Data Manager

    IMG Systems

    - Washington, DC

    NoSQL Data Architect - Big Data Manager Our client is seeking candidates with Big Data background working with NoSQL This is a hands-on technical role. The Basics: 1+ year of...

    26 days ago from TheLadders.com
  • Senior Business Architect - Largo

    Computer Sciences Corporation (CSC)

    - Upper Marlboro, MD

    .label color:#005172; font-size: 1.2em; font-weight: bold; display:inline; .value color:black; font-size: 1.2em; font-weight: normal; display:inline; Job Description Job Title:...

    14 days ago from The Washington Post
  • Sr. SQL Database Engineer

    Randstad Professionals

    - Columbia, MD

    Built on 30 years of expertise, Randstad Professionals provides specialized recruiting services to a diverse portfolio of clients ranging from Fortune 500 companies to small and...

    5 days ago from Dice
  • Hadoop Big Data Train and Hire

    NEW

    Dexter Systems

    - Herndon, VA

    Hadoop Big Data Train and Hire Dexter Systems Inc is ITSM and Technology Solution provider based out of Herndon, VA USA is looking for Recent Stem Graduate / F1 /OPT Graduate/...

    1 day ago from Get Java Jobs
  • Business Architect

    Digital Infuzion

    - Gaithersburg, MD

    Requirements: This position will support the Lead Enterprise Architect to create Current-State artifacts, End-State artifacts, Information Management Roadmap and Master Schedule,...

    19 days ago from TheLadders.com
  • Senior Database Architect (MS SQL certification)- Highly Compensated

    Fwg Solutions

    - Washington, DC

    FWG Solutions is seeking a seasoned Senior Database Architect for our program within DC government. The Senior Database Architect must have a minimum of 6 years of database...

    11 days ago from ZipRecruiter

Show Me More

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