Thermo Fisher Scientific SQL Developer in Pittsburgh, Pennsylvania

Job Description

When you’re part of the team at Thermo Fisher Scientific, you’ll do important work, like helping customers in finding cures for cancer, protecting the environment or making sure our food is safe. Your work will have real-world impact, and you’ll be supported in achieving your career goals.

We are looking for a SQL who will be responsible for designing databases and ensuring their stability, reliability, and performance, creating stored procedures holding the business logic for dynamic applications. You will also work other developers optimizing and/or developing application SQL statements along with following best practices established by the group. You will help solve database issues and come up with ideas and advice that can help avoid such problems in the future. SQL Developer duties will also include creating/maintaining databases for applications, designing, coding and testing queries and stored procedures, and creating SSIS processes to and from various data sources.

Responsibilities:

  • Help write and optimize in-application SQL statements and stored procedures

  • Ensure performance and availability of databases

  • Design and create database structures,

  • Prepare documentations and specifications

  • Collaborate with other team members and stakeholders

Skills and Qualifications:

  • Proficiency with SQL and its variation among popular databases

  • Experience with relational databases

  • Skilled at optimizing large complicated SQL statements

  • Knowledge of best practices when dealing with relational databases

  • Capable of troubleshooting common database issues

  • Perform ad hoc analyses and prepare reports of findings as needed.

  • Provide subject matter expertise to internal teams on the structure and content of relational databases that contain product, customer, pricing and transactions stores.

  • Must understand the different types of joins,

  • Perform other duties as assigned.

Minimum Requirements/Qualifications:

  • Bachelor's degree in Computer Science, Information Science, or a related work experience

  • 1-3 years of experience developing T-SQL Stored Procedures and functions

  • 1-3 years of experience in database design including referential integrity, with strong understanding of key data elements and table indexing

  • Experience with SSIS utilizing MS SQL Server Management Studio and MS SQL Data Tools

  • Ability to solve complex problems, strong analytical skills and the ability to trace issues to the root source

  • Highly motivated and self-directed; independent worker, self starter, ability to work without direct supervision

  • Strong problem-solving skills

  • Ability to develop and execute on detailed design documents and work plans from high-level requirements and specifications

  • Able to work nights and/or weekends as required

Non-Negotiable Hiring Criteria:

  • Bachelor's degree in Computer Science, Information Science, or a related work experience

  • Experience in database design including referential integrity, with strong understanding of key data elements, table indexing and database tuning

  • Experience developing T-SQL Stored Procedures and functions

  • Able to work nights and/or weekends as required

At Thermo Fisher Scientific, each one of our 65,000 extraordinary minds has a unique story to tell. Join us and contribute to our singular mission—enabling our customers to make the world healthier, cleaner and safer. Apply today http://jobs.thermofisher.com

Thermo Fisher Scientific is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.

Thermo Fisher Scientific is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.