SQL Developer

Company: TTM Technologies, Inc.
Location: Sterling
Posted on: February 15, 2020

Job Description:

Position: SQL Developer Location: Sterling, VA Job Id: 6424 # of Openings: 1 Scope: We are looking for a business minded individual to join our team. This role requires a strong background in relational databases and SQL. This position will be an integral part of the team working with other SQL developers as well as Application developers to help design and implement new versions of our production software as well as optimize and normalize existing table data structures, stored procedures, triggers and views. The SQL Developer focuses on maximum uptime and operation of Microsoft SQL database as well as developing and optimizing views, functions and complex queries. The position may require after hours or weekend work to maintain maximum uptime. Travel up to 30%. This position can be located in any of these TTM locations: Syracuse, Sterling, Salem, Logan, Denver, San Diego, Santa Clara Duties and Responsibilities: - Design logical and physical database structures using Microsoft SQL Server - Review current database design looking for ways to optimize for better performance and to normalize the data - Designs, creates and maintains SQL code and jobs meeting standards of readability, performance, testability - Maintain/Optimize existing code base - Work with Application developers to help define requirements and functional specifications - Determine the right stored procedures, views, functions and table structures for applications - Analyze, troubleshoot and resolve data issues - Perform duties & responsibilities specific to department functions & activitiesEssential Knowledge and Skills: - Microsoft SQL Server (2005+) - Building complex SQL queries, stored procedures, functions, views and reports. - Understand the business needs effectively and work with developers to design and draft modern and effective database architectures - Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages - Review performance logs to track and analyze production issues and optimize stored procedures for improved database responsiveness. - Analytical skills and a business mind set - Ability to build complex dashboards for planning - Organizational skills and ability to prioritize and multi-task - Highly driven and self-motivated to exceed expectations - Ability to work independently and in a team-based environment - Proficient in both oral and written communicationExport Statement: Must comply with TTM Export Control Policies and Procedures and all applicable laws including ITAR, EAR and OFAC. b) Reinforce to all employees the commitment of TTM management to abide by all US Export laws and regulations. c) Understand and follow authorization procedures for bringing foreign visitors into facilities (VAL). d) Support Export Compliance Officers and others in their efforts to ensure compliance with the Corporate Export policies through implementation and enforcement of these procedures, provide training to all facilities and departments and support periodic audits as required. e) Provide feedback to Corporate Export Compliance Office for continuous improvement of procedures and overall Export Compliance program. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, disability or protected veteran status.

Keywords: TTM Technologies, Inc., Sterling , SQL Developer, IT / Software / Systems , Sterling, Virginia