Database Administrator Architect
| Posted: |
11/21/11
|
| Job Req ID: |
777
|
| Locations: |
San Diego,CA
|
| |
| Summary: |
Demonstrate expert skills in the design of databases, data warehouses and datamarts used to create analytics for reports, dashboards and decision making interfaces.
Responsibilties:
a.Data normalization and complex entity relationships
b.Data dimensions
c.Referential integrity
d.Database replication
e.Service Oriented Architecture and open standards: e.g. SOAP, WSDL, XML/XSLT, SAML, WS*, etc.
f.T-SQL coding and ANSI standards
g.Data abstraction and access layers
h.Database and query analysis and tuning
i.Reporting tools such as Crystal Reports, SQL Reporting Services, et al.
j.Indexes, Triggers, Stored Procedures, and Views
k.Experience with DOD technical governance (e.g. DOD Architectural Framework) is preferred.
- Design and maintain logical and physical data models of master data domains - Capture and maintain meta-data pertaining to data definitions, lineage, rules, and taxonomy
- ETL Processes and implementation(DTS, SSIS and third party tools, e.g., IBM DataStage)
- Database Change Management
InnovaSystems International is an EEO/AA employer M/F/D/V.
|
| |
| Requirements: |
BS in CS or Engineering plus 6 years experience OR Bachelors Degree plus 8 years of experience OR 12 years direct data architect experice AND positive recomendation from supervisor/Technical Lead.
Special considerations: Lead or expert.
Dimensional Modeling Experience (OLAP,OLTP,Kimball)
DESIRED TECHNICAL EXPERIENCE: - Proven record of delivering scalable enterprise data warehousing and business intelligence solutions. - Experience with BI tools (COGNOS, SSRS, SSAS, Performance Point) - Experience with Military Readiness Systems - Distributed SOA Architecture (Data, WCF, REST, Enterprise Messaging, Service Bus) Experience with Share Point 2010.
2+ years Experience implementing a meta-data repository is a plus
3+ years Understanding of XML data structures is a plus
6+ years related to data analysis and data modeling
4+ years demonstrated experience working with Database Technolgies (SQL Server, Oracle or DB2)
SPECIAL SKILLS OR TRAINING:
SQL Modeling tools, i.e., ERWIN or ER Studio SQL Server 2005+ (SSRS, SSAS, SSIS)Enterprise Data Integration Systems
Aviation Training / Military Readiness Functional Knowledge Preferred
|
| Additional Requirements: |
US Citizenship is required. Applicants selected may be subject to a security clearance investigation and must meet eligibility requirements for access to classified information. |
|
|