Database Engineer

Technology Full-Time ALL US, United States ReqID:4357


Description

Envestnet refers to the family of operating subsidiaries of the public holding company, Envestnet, Inc. (NYSE: ENV). Envestnet is a leading independent provider of technology‐enabled investment and practice management solutions to financial advisors who are independent, as well as those who are associated with small or mid‐sized financial advisory firms and larger financial institutions. Envestnet's technology is focused on addressing financial advisors' front, middle, and back‐office needs. Envestnet is headquartered in Chicago.

Envestnet - Wealth Division is 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
  • 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 

    NOTE:  This is intended to describe the general content of and qualifications for the job. It is not intended as an exhaustive statement of all functions, duties, or desired qualifications.

    Envestnet is an Equal Opportunity Employer



#LI-AQ1


#Remote