Click here to login or register
Reference # : 19-00031 Title : Sr. Database Engineer (Vertica/Postgres or AWS)
Location : Chicago, IL
Experience Level : Start Date : 05/07/2019  
Description

FYI: Sr. Database Engineer needed (Vertica/Postgres/ or AWS);6-months+; Market Rate - DOE; Chicago, IL 60661; skirkwood@htpartners.com

Hello, this is a heads-up on an opening for a Sr. Database Engineer at a Market Demand Data and Analytics company located in downtown Chicago, IL 60661. In this role you will join a team working on the next generation of their marketing automation and measurement platform. Your responsibilities will include providing expertise with Data, Databases, Data Integration, Data Analytics, and Reporting/BI related applications. We are looking for expertise in database modeling, performance analysis, data integration, capacity planning, and database performance tuning. Overall the person in this position is expected to demonstrate proficiency in database design, SQL programming, Shell scripting, troubleshooting, teamwork, leadership, and customer service. Interested candidates should forward their resumes to: skirkwood@htpartners.com
Thanks - Shaun (ph: 847-202-3242 x106) (See Ad Below)

Needed: Sr. Database Engineer (Vertica/Postgres/ or AWS);6-months+; Market Rate - DOE; Chicago, IL 60661; skirkwood@htpartners.com

Horizon Technology Partners has an immediate opening for a Sr. Database Engineer with a strong Data Warehousing and Business Intelligence background. Your skills are needed to assist a Market Demand Data and Analytics company located in downtown Chicago, IL 60661 with new project development surrounding their marketing automation and measurement platform. In this role you will provide expertise in support of Data Integration, Data Analytics, and Reporting/BI related applications. Tasks will include database modeling, performance analysis/monitoring, data integration, capacity planning, and database performance tuning. You are ultimately responsible for database design and data flow of new projects as well as ensuring compliance to data standards and best practices. 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, SQL programming, Shell scripting, and troubleshooting. The client's environment consists of: Vertica, AWS, Postgres, Tableau, Pentaho, and various scripting languages in a Linux platform. They currently run Vertica in their managed data center with Dev Vertica and some other services in AWS for development needs.

Details from the client: "We have built a marketing automation and marketing measurement platform on Vertica. It supports multiple clients, is data agnostic, and includes sophisticated data analytics. The design of the data relies heavily on reusable data patterns, and most of the data are maintained in deep structures (attribute key pair). This role includes technical database design and detailed implementation of the platform, as well as ongoing extensions and performance improvements. "

Responsibilities/Activities will include:
- Development and implementation of new data base applications as assigned
- Proactively identifying and addressing system performance and capacity issues
- Working collaboratively with Technical Architects, Business/Data Analysts, and Project Managers to implement requirements and technical specifications
- Contributing to system development and deployment activities to ensure that data base systems management concerns are addressed
- Developing and implement new database and data loading patterns
- Working independently and proactively in a rapidly changing team environment
- Developing full life cycle documentation and document activities as assigned
- Taking ownership of assigned responsibilities and follows through to effective solution
- Communicating complex technical information in a timely, concise and coherent manner.

Required Skills/Qualifications:
- 5+ 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 including: Experience with Vertica and Postgres a plus
- Familiarity with data loading technologies such as: Informatica, Pentaho, SPARK, SQOOP
- Proficiency with SQL & PL/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)
- Understands basic underlying systems architecture, infrastructure and administration
- Knowledge of distributed databases, partitioning, scalable data architectures
- Experience with identifying and addressing performance bottlenecks - Tuning
- Experience and familiarity coding with Java
- Experience in Jira a plus
- Excellent communication and interpersonal relationship skills, working in a distributed, remote team environment and supporting multiple, concurrent projects

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