| Required : Database Engineer : Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: Mohit Saini, Maintec [email protected] Reply to: [email protected] Required : Database Engineer I Remote Experience : 10 + At Envestnet|Tamarac we want to create the ultimate software product for investment professionals that will enable them to transform the precision and efficiency of their back office operations. Our Database Engineering team is committed to development and operational excellence by delivering a world-class customer experience. 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|Tamarac 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 database platform, be a team player with minimal supervision, work cross-functionally and closely with engineering, product management, and quality assurance peers to develop innovative technical tools and solutions. You will continually seek to improve the code and efficiency of our systems. 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" is not going to fly here. We want people who have the mindset that anything is open for questioning and there is always another layer to dig. You do not make money solving easy problems - you make money solving hard problems! We strive to build database systems that are highly reliable and performant. We are 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 and Raleigh, NC. Opportunity to work from remote office may be available depending on the applicant 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 members 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 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 Knowledge of TSQL stored procedures, functions, complex queries, indexing 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 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 2 years experience in a Database Engineer/Administrator role Minimum 1 year experience with database design and architecture Minimum 1 year 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 Thanks & Regards Mohit Saini [email protected] Linkdin Id :https://www.linkedin.com/in/mohit-saini-b21b73230/ (559) 413-4325 |
| [email protected] View all |
| Wed Nov 02 21:34:00 UTC 2022 |