Responsibilities
Responsible for tuning complex SQL queries, procedures and indexing strategies for better performance.
Identify missing indexes on the databases and implement them for better performance.
Analyze long-running execution plans and provide recommendations to improve performance.
Should have experience in transaction replication in replicating large size tables from large databases.
Analyze, design, develop, test, maintain and implement database solutions within Thomson Reuters suite of applications.
Work with other disciplines, such as software, product, architecture, dev/ops, and performance, to design the best product solutions.
Provide technical leadership for an application development team.
Perform full life cycle SQL/NoSQL code and model development, including researching technical options for features, providing guidance and feedback on the findings, and building proof of concepts to confirm the best approach.
Create solutions utilizing the best data storage technology for the use case (i.e., RDBMS, NoSQL, Data Lake, etc.).
Work with performance engineers to monitor system health and performance, ensuring high levels of performance and availability.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
Assist developers with complex query tuning, schema refinement, and determining differences between releases/environments.
Perform database code/script/package reviews.
Minimum Requirements
Bachelor's degree in a CS, Engineering, or related field.
7+ years of developing for MS SQL Server or performing Database Engineering duties.
Experience with relational databases reaching over 10TB.
Heavy performance tuning experience and SQL optimization.
Experience with non-traditional methods of performance tuning.
Mentorship abilities required.
Ability to work shoulder to shoulder with development teams.
#J-18808-Ljbffr