Job Description
DBA/Data Engineer MUST RESIDE in Michigan Troy (2/3) / Remote (3/2) - Local candidates preferred Actively seeking a DBA/Data Engineer who possesses talent, passion and expertise to help design and implement highly scalable and available database solutions to support growing business needs. As a DBA/Data Engineer, we expect this role to be critical in ensuring that our data solutions and architecture are designed to be scalable, reliable, and high-performance. This position offers excellent career growth and promotional opportunities, stellar compensation, and an opportunity which could very well be your best and last position in a rewarding and fulfilling career! 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 (Must Have) * Expert SQL Server Development experience (Minimum 8 years experience). * Strong AWS Experience (Minimum 2+ years 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 * Adept at optimizing and refactoring and upgrading legacy systems * Excellent performance tuning skills regarding data models and SQL code * Proven experience in designing and implementing highly scalable and available database solutions * 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 evangelist who can educate and mentor other SQL developers and strong automated testing experience * Excellent communicator -- articulate, persuasive, professional Preferred Experience (Nice to Have) * Bachelor's or Master's degree in Computer Science or related field * 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- nice to have) * TFS, Azure DevOps, or Jira project management/requirements management A minimum requirement for this position is the ability to work legally in the United States. No visa sponsorship/support is available for this position. In addition, NO C2C or 3rd parties please.