Database Engineer at Yodlee, Inc. in Seattle, WA

We are looking for a talented SQL Server database professional with a strong desire to learn complex system, new technologies, broaden database releases with automation, and work closely with our migration to AWS. As part of the Envestnet Database Engineering team, you will be responsible database development in collaboration with our development and architecture teams. You will collaborate with our SRE teams for maintaining the overall health, performance and reliability of our SQL Server databases. You will solve complex database challenges, be a key player in continually improving our databases, work well in a rapidly growing and changing engineering workplace.

The best candidates are able to defend their actions and decisions: "we do it this way because that's the way we've always done it" isn’t going to fly here. We want people who have the mindset that anything is open for questioning and there's always another layer to dig. You don't make money solving easy problems - you make money solving hard problems! We strive to build database systems that are highly reliable and performant. We're in a growth stage and now is the best time to join our team. This position will report directly to VP, Database Engineering. We are located in Seattle, WA. Opportunity to work from remote office may be available depending on the application location.

• 
  
• Responsibilities
• Designing, developing, and optimizing our SQL server databases and environment
• Champion and affect great high-level database systems design, best practices, documentation, high technical standards, tools, platforms, scalability, resiliency, quality and performance
• Work with SRE team to continually improve the performance and availability of OLTP databases. Provide critical review of our production OLTP processes and design. Investigate database tuning settings, query changes needing improved performance
• SQL Server database maintenance, tuning, monitoring, performance analysis, architecture scalability, robustness, and performance; query tuning, index optimization, critical reviews of data models
• Implement database coding optimization standards, including best practices for table design, query writing, use of functions, etc
• Actively monitor production for database performance issues, and analyze and fix them
• Perform in-depth data analysis to understand data from source systems
• Review and provide feedback on other team member’s code and scripts
• Deliver on time with high quality
• Mentor and guide other technical resources
• Identify and performance tune poorly performing queries, sprocs, functions
• Develop key automation and monitoring scripts
• Optimize performance of SQL databases in production and non-production
• Participate in on call rotation as defined by management
• Requirements
• Expert level analytical abilities (problem solving, debugging others/own code, etc.), proven design skills and track record of delivery
• Customer oriented attitude, ability to work with technical and non-technical stakeholders
• Proven ability to work independently or as an integral member of a team with minimal supervision in a results-oriented, fast-paced dynamic environment.
• Be a self-starter and goal-oriented
• Excellent documentation, communication and teamwork skills
• Experience handling large scale database migrations. Advanced experience troubleshooting complex systems
• Strong knowledge of TSQL stored procedures, functions, complex queries, indexing
• Extensive experience with SQL Server
• Experience with database design in both physical and logical
• Working knowledge of SQL tuning and performance considerations in RDBMS and MPP environment
• Familiarity with SSAS, SSRS, and SSIS
• Real-world experience supporting MSSQL in production
• Other document stores/storage mechanism experience is a plus – not everything should be solved with SQL Server
• Minimum 7+ years’ experience in a Database Engineer/Administrator role
• Minimum 4+ years’ experience with database design and architecture
• Minimum 4 years’ experience working with relational databases, preferably MSSQL
• Preferred experience with database technologies in AWS
• Preferred experience with script languages such as Powershell, Python, Bash
• BA/BS Degree in Information Technology or Computer Science or equivalent experience is required.
• Legally eligible to work in the U.S. on an ongoing basis