Click here to login or register
Reference # : 18-00083 Title : Database Architect/Developer
Location : Chicago, IL
Experience Level : Start Date : 10/30/2018  
Description
Needed: Sr. Database Architect/Developer; Part-Time/Telecommute-Remote (20 hrs/week, 1-month trial), $Market Rate; Chicago, IL 60661; skirkwood@htpartners.com

Horizon Technology Partners has an immediate Part-Time/Telecommute-Remote opening (20 hours/week) for a Sr. Database Architect. Your skills are needed to assist a growing digital marketing firm specializing in helping graduate and professional college programs at leading US Universities reach their target markets and increase their enrollment. In this role you will be charged with conducting a database needs assessment and selecting the target cloud-based system (AWS, Azure, Google Cloud, or other). Deliverables will include defining the database architecture and data flow as well as ensuring compliance to data standards and best practices. Tasks will include: database modeling, performance monitoring, data integration, capacity planning, and database performance tuning. Qualified candidates will have an educational and or employment background in Computer Science/Computer Engineering and a career focused on Database Engineering and a demonstrate proficiency in database design, data modeling, SQL programming, Shell scripting, and troubleshooting.

This work is envisioned as a Part-Time/Telecommute (Remote) role at 20/hr per week. We would prefer someone based in the Chicago land area that can be available for occasional meetings (not required).

Activities will include:
- Scope Definition, Database Assessment to recommend cloud-based storage for data that will assist in leveraging data analytics capabilities
- Work collaboratively with Business Stakeholders to develop the database models and data structures
- Define the collection of data attributes/storage
- Database design (Logical/Physical)
- Partitioning/Indexing
- Develop and implement new database and data loading patterns - structure ETL process for disparate data feeds
- Assist in the defining: KPI/ Dashboarding / Reporting / Visualization Environment

Required Skills:
- 7-10+ years of experience in the design and development of enterprise relational database management systems
- Advanced data modeling/architecture (relational, dimensional data modeling and database design)
- Experience with data warehousing / business intelligence environments and platforms
- Familiarity with data loading technologies
- Proficiency with SQL (Must be able to write and implement complex SQL from scratch, understands sub selects, nested joins, coercion, and the functions in SQL and can author complex SQL in addition to adapting and modifying existing code)
- Experience with developing Cloud based (AWS, Azure, Google Cloud, or other) databases and migrating on-premise data to Cloud based databases
- Knowledge of distributed databases and partitioning
- Knowledge of scalable data architectures
- Experience with identifying and addressing performance bottlenecks
- Excellent communication and interpersonal relationship skills, working in a distributed, remote team environment

Interested candidates should forward their resumes to: skirkwood@htpartners.com