Thomson Reuters
photo of hand surrounded by flowers

Bring Your Passion

Apply Now    

Lead Database Engineer

Thomson Reuters Technology Operations 2/5/2018 2:50:01 PM Carrollton, TX United States of America
Job Description

Job Duties:

We now have a giant monolithic single tenant SQL Server 2014 database that acts as the data store for several products. The ideal candidate should be able to analyze the current database in detail, code and test the necessary migration scripts, and pave the way to get us to the target state outlined below:

  • Move each product to its own database so multiple products no longer co-exist in the same database.
  • Once we achieve product level database isolation, take it to the next level to achieve service level database isolation. Currently, each product has several services, but they all use the same database. This move to service level database isolation will ensure the data store for each service is self-contained and get us to closer to true micro-service architecture.
  • Currently, every client gets their own database. We want to move to multi-tenant database structure so the same database can house the data for several clients.
  • Finally, move this SQL 2014 database from our internal data center to AWS in a PostgreSQL DB.

Mandatory requirements:

  • Strong hands-on relational Database experience is a must. The ideal candidate should have at least 7+ years of hands-on SQL data modeling, coding, analyzing and troubleshooting skills.
  • Strong experience in analyzing and figuring out the underlying data tables, and the dependencies on views, procs, triggers, functions and constraints.
  • Should be able to write and test data migration scripts with ease.
  • Experience charting ER diagrams
  • The ideal candidate should have spent majority of the last 10-15 years in SQL tools like Profiler, Management Studio, Query Analyzer, etc.
  • Experience with a large scale database (several 1000’s of DBs and 500+tables in each DB)
  • Comfortable working in a fast paced, highly collaborative, dynamic work environment

Optional requirements:

  • Experience with PostgreSQL in AWS is a plus
  • Experience with RESTful micro-services is a plus

At Thomson Reuters, we believe what we do matters. We are passionate about our work, inspired by the impact it has on our business and our customers. As a team, we believe in winning as one - collaborating to reach shared goals, and developing through challenging and meaningful experiences. With more than 45,000 employees in more than 100 countries, we work flexibly across boundaries and realize innovations that help shape industries around the world. Making this happen is a dynamic, evolving process, and we count on each employee to be a catalyst in driving our performance - and their own.

As a global business, we rely on diversity of culture and thought to deliver on our goals. To ensure we can do that, we seek talented, qualified employees in all our operations around the world regardless of race, color, sex/gender, including pregnancy, gender identity and expression, national origin, religion, sexual orientation, disability, age, marital status, citizen status, veteran status, or any other protected classification under country or local law. Thomson Reuters is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.


Intrigued by a challenge as large and fascinating as the world itself? Come join us.

To learn more about what we offer, please visit thomsonreuters.com/careers.

More information about Thomson Reuters can be found on thomsonreuters.com.



Locations
Carrollton-Texas-United States of America
Req #: JREQ097797
Locations: Carrollton-Texas-United States of America
Job Function: Technology Operations
Apply Now    
Link for schema