Database Architect

» Database Architect
Information Technology
in Miami Gardens
, FL
Reference: 19-01816

Job Description:

The Database Architect will be extracting, transforming, and loading data from various sources (external and internal) into the data warehouse and developing, documenting, implementing, maintaining, and enforcing the comprehensive data strategy, standards, and processes. Design, construct, and test data structures and solutions.

Responsibilities:

  • Develop data mappings in SSIS, reports in SSRS for dashboard
  • Leveraging SQL analysis services to develop advanced analytics components and services to be used in dashboard
  • You will be writing various components in SSIS for advanced data formatting and rules injection
  • You will be developing the Enterprise Relational Datastore for several applications
  • Corresponding data access adapters (Stored Procedures, SQL Views)
  • Develop and design database objects, tables, views, indexes, constraints, etc.
  • Analyze query execution plans and optimize database code
  • Define and implement data validation processes to ensure data accuracy
  • Produce a detailed functional design and architectural document to match customer requirements
    • Create stored procedures and functions to incorporate complex database algorithms
    • Write and understand complex SQL queries for MS SQL, MYSQL, and NoSQL databases
    • Designing and maintain schema and databases for MySQL, MS SQL, and NoSQL
    • Other duties as assigned and modified at manager’s discretion
  • Define, document, and develop new or maintain existing interfaces between applications, databases, and third party systems to meet business requirements
  • Perform ad hoc analysis of production data where necessary to develop solutions to reported incidents
  • Effectively communicate with the appropriate internal and external business and technical customers for information gathering and follow up

Desired Skills and Experience:

  • Fluency with relational databases, including structure design, ad-hoc SQL queries, and stored procedures
  • Experience in relational database design, optimization and performance with commercial-grade databases such as MySQL
  • Experience with data dictionaries, data analysis and relational databases
  • Familiarity with ERD tools (Erwin, data modelers)
  • Ability to create conceptual, logical, physical data designs
  • Ability to effectively query various database platforms to extract required information
  • Proven understanding of SQL optimization (proper indexing and ability to interpret execution plans)
  • Ability to understand business requirements and convert them into database designs
  • Proven ETL development skills (SSIS, Informatica, or equivalent ETL tool)
  • SSIS and/or Informatica development skill a definite plus
  • Proven data modeling skills
  • Fluent in English

Education Requirements:

  • Bachelor of Science in Computer Science, MIS, or Bachelor’s degree in Mathematics
  • 5+ years ETL (Extract, Transform, Load) coding experience in SQL
  • 2+ years of experience analyzing and develop Star Schema Designs
  • 3+ years of experience with MySQL, SQL Server