Job Description
Job Title: Senior Database Architect
Location: Troy, MI / Hybrid
Vital Tech Solutions is actively seeking a Senior Database Architect who possesses talent, passion and expertise to help design and implement highly scalable and available database solutions to support our growing business needs. 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.
Primary Responsibilities:
- Manage and administer databases, research, architect, and develop innovative multi-tiered solutions using modern tools and methodologies with a goal for technical excellence.
- Design and implement highly scalable and available database solutions.
- Perform database performance tuning and optimization.
- Design and develop ETL processes to integrate data from various sources.
- Collaborate with developers, architects, data scientists, and other stakeholders to understand data requirements and design appropriate data models.
- Develop and maintain backup and disaster recovery strategies.
- Ensure architecture and design of the solution is in alignment with overall enterprise architecture.
- Solve problems and proactively look for ways to improve our products and platform.
Required Experience:
- Bachelor's or Master's degree in Computer Science or related field.
- 8+ years of experience in SQL Server Development
- 2+ years of AWS Experience with AWS lambda functions (Python preferred), AWS databases (Aurora, DynamoDB, or Redshift preferred) and AWS storage services (EC2, S3 preferred).
- Strong ETL experience, with emphasis on complex transformations and large data sets.
- Multiple versions (MS SQL 2000 through MS SQL 2019 preferred).
- Expert backend designer, capable of managing high-level architecture while adding or optimizing components.
- Excellent performance tuning skills regarding data models and SQL code.
- Relentless troubleshooter and investigator, proficient with SQL Profiler, Extended Events, Query Store etc.
- Octopus Deploy, Red Gate SQL Change Automation, Red Gate SQL Toolbelt, or equivalent CI/CD.
- Quick learner: astute and perceptive; keeps up to date on new and emerging technologies
- Technical professional who can educate and mentor other SQL developers with strong automated testing experience.
Preferred Experience:
- Data Lake experience or similar (AWS preferred).
- Experience in designing architecture to support future “Big data” technology solutions (nice to have).
- Graph Data Base and Graph Modeling experience (Neo4j-).
- TFS, Azure DevOps, or Jira project management/requirements management.
Vital Tech Solutions is an Equal Opportunity Affirmative Action employer. We prohibit discrimination in decisions concerning recruitment, hiring, compensation, benefits promotions, training, termination or any other condition of employment or career development. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, marital status, national origin, veteran status, disability status or any other legally protected status.