Database Architect

Location: Miami Gardens, FL
Date Posted: 09-20-2017

Responsibilities- Extracting, transforming and loading data from various sources (external and internal) into the data 
warehouse. The incumbent in this role develops, documents, implements, maintains and enforces the comprehensive data strategy, standards, 
and processes. He/she designs, constructs and tests data structures and solutions. 

Develops data mappings in SSIS, reports in SSRS for Dashboard. 
Leverages SQL analysis services to develop advanced analytics components and services to be used in Dashboard. 
Writes various components in SSIS for advanced data formatting and rules injection. 
Develops the Enterprise Relational Data store for several applications. 
Corresponds Data Access Adapters (Stored Procedures, SQL Views). 
Develops and designs database objects, tables, views, indexes, constraints, etc. 
Analyzes query execution plans and optimizes database code. 
Defines and implements data validation processes to ensure data accuracy. 
Produces a detailed functional design and architectural document to match customer requirements. 
Creates stored procedures and functions to incorporate complex database algorithms. 
Writes and understands complex SQL queries for MS SQL, MYSQL and NoSQL databases. 
Defines, documents, and develops new or maintains existing interfaces between applications, databases and third party systems to meet 
business requirements. 
Performs ad-hoc analysis of production data where necessary to develop solutions to reported incidents. 
Communicates with the appropriate internal and external business and technical customers for information gathering and follow up. 
Designs and maintains schema and databases for MySQL, MS SQL, and NoSQL 
Performs other duties as assigned and modified at manager’s discretion. 

Bachelor's degree in Computer Science, MIS or Mathematics required. 

At least five (5) years ETL (Extract, Transform, Load) coding experience in SQL. 
At least two (2) years’ experience analyzing and developing Star Schema Designs. 
At least three (3) years’ experience with MySQL, SQL Server. 
Experience in relational database design, optimization and performance with commercial-grade databases such as MySQL. 
Experience with data dictionaries, data analysis and relational databases. 
Proven ETL development skills (SSIS, Informatica or equivalent ETL tool). 
SSIS and/or Informatica development skill a definite plus. 

Relational database design, optimization and performance tuning. 
ETL (Extract, Transform, Load) coding experience in SQL. 
SSIS and/or Informatica development. 
MySQL Architectural Design and Implementation. 
PowerBI Development.
Laurie Roth
President/Sr. Consultant
this job portal is powered by CATS