Sr. Database Architect

Troy, MI 48098

Posted: 02/28/2022 Category: Information Technology Job Number: 99245

Job Description


SENIOR DATABASE ARCHITECT 

We are actively seeking a Senior Database Architect who possesses a strong passion for designing, optimizing, refactoring, and upgrading complex data solutions. Our primary product is Automotive Content, and we need someone who can help us acquire, ingest, store, organize, transform, map, relate, process, extract, and package this data using efficient, optimized, state-of-industry tools and methods to help us deliver this content to our  customers.
Our data team is undergoing a growth phase – both in terms of technology and personnel, and we are looking for someone to share our mission that will transform our company’s future. With this position, you will have a rare opportunity to use your talents, passions, and expertise to help drive this massive change in how we build and organize and optimize our backend systems and processes across all our product lines.
This position offers excellent career growth and promotional opportunities, stellar compensation, and an opportunity to work with the world's premier provider of aftermarket automotive data. 


Required Experience (must have)
• Expert SQL Server Development experience (Minimum 8 years’ experience)
o Expert data modeler
o Multiple versions – MS SQL 2000 through MS SQL 2019 preferred
o Adept at optimizing and refactoring and upgrading legacy systems
• Strong ETL experience, with emphasis on complex transformations and large data sets
o SSIS, Kettle, or Talend preferred
• Technical evangelist who can educate and mentor other SQL developers
• Expert data analytic skills
• Relentless troubleshooter and investigator
• Strong automated testing experience
• Strong AWS Experience (Minimum one to two years’ experience)
o Lambda Functions - Python Preferred.
o AWS Glue and Scala
o Step Functions / State Machines and Control Flow
o ECS/ECR AWS Containerization
• Proficient in developing solutions targeting Amazon Web Services (AWS) and EC2
• Linux and container experience
Helpful Experience (nice to have)
• Scrum and DevOps Experience
• Proficient with Git, TFS/Azure DevOps
• Experience in one or more of the following: Octopus Deploy and Cloud Formation
• Red Gate SQL Toolbelt or equivalent, Red Gate SQL Change Automation or similar database CI/CD
• Experience in rapid solution prototyping
• Experience with Data Lakes in AWS
• Graph Data Base Experience (Neo4j preferred)
o Graph Modeling Experience
Primary Responsibilities
• Research, architect, and develop innovative multi-tiered solutions using modern tools and methodologies with a goal for technical excellence
• Work closely with other developers, architects, and stakeholders to provide project estimates based on customer experience, features, and envisioned solutions
• Ensure architecture and design of the solution is in alignment with overall enterprise architecture
• Solve problems and pro-actively look for ways to improve our products and platform
• Mentor junior software architects and developers

This is an Onsite role in the suburbs north of Detroit, MI
Not eligible for C2C or C2H but sponsorship is a possibility

If Interested in this role, please reach out to:

Ryan Partlan
IT Recruiter
A-Line Staffing
rpartlan@alinestaffing.com
(586) 960-3870 Direct/text        
 
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.