Sr Database Architect/Administrator/Developer

Position: Sr Database Architect/Administrator/Developer

Location: Olympia, WA

Duration: 1 Year

Description:

Senior Database Architect/Administrator/Developer with consulting experience in one or more of the following skill sets and/or technology categories:

• Database Architecture / Data Modeling

Consultant would have expert level data design and architectural skills including:

• Expert consultation and expertise in design of conceptual, logical and physical models, data access, data security and data integration solutions for relational and multidimensional data solutions.
• Expert consultation in the design, development and implementation of databases, data marts and data warehouses.
• Expert knowledge and experience in Embarcadero’s ER Studio using the Enterprise Repository.
• Expert level analytical skills.
• Expert level experience creating and maintaining data dictionaries / glossaries.

• Microsoft SQL Server

Consultant would have expert level development and maintenance skills in Microsoft SQL Server including:

• Expert consultation in the design, development and implementation of databases, data marts and data warehouses.
• Expert consultation in the maintenance and performance tuning of databases, data marts and data warehouses .
• Expert consultation in the installation of Microsoft SQL Server, SSAS, SSIS and SSRS.
• Expert level DBA development skills in T-SQL,SSIS, .Net.

• Hadoop

Consultant would have expert level development and maintenance skills in Hadoop including:

• Expert consultation in the design, development and implementation of data warehouses, data lakes and big data sets.
• Expert consultation in the maintenance and performance tuning of data warehouses, data lakes and big data sets .
• Expert consultation in the installation of Hadoop, Apache Hive and/or Pig software.
• Expert level DBA development skills in Apache Hive and/or Pig.

• NoSQL

Consultant would have expert level development and maintenance skills in NoSQL including:

• Expert consultation in the design, development and implementation of databases, data marts, data warehouses and data lakes.
• Expert consultation in the maintenance and performance tuning of databases, data marts, data warehouses and data lakes.
• Expert consultation in the installation of NoSQL software.
• Expert level DBA development skills in C++, Java, .Net.

• Oracle

Consultant would have expert level development and maintenance skills in Oracle including:

• Expert consultation in the design, development and implementation of databases, data marts and data warehouses.
• Expert consultation in the maintenance and performance tuning of databases, data marts and data warehouses.
• Expert consultation in the installation of Oracle software.
• Expert level DBA development skills in PL/SQL.

• IBM DB2

Consultant would have expert level development and maintenance skills in IBM DB2 including:

• Expert consultation in the design, development and implementation of DB2 databases.
• Expert consultation in the maintenance and performance tuning of DB2 databases.
• Expert consultation in the installation and support of DB2 for IBM z/OS.
• Expert level DBA development skills in CICS and DB2 for IBM z/OS.

• All Technologies
• Proven experience and expertise in enterprise data architecture and database engineering design and development in latest software versions.
• Proven experience with data warehouse design structures such as star and snowflake schemas.
• Mentor and train other Database Architects/Administrator/Developers to ensure successful knowledge transfer.

Job Type: Contract

Required experience:

• IBM DB2: 1 year
• Database Architect: 1 year
• Hadoop: 1 year