Job Description

Design, code and maintain new and existing complex SQL stored procedures and functions.

Responsibilities:

• Design, code and maintain new and existing complex SQL stored procedures and functions. Review SQL code written by other developers to ensure compliance to coding standards and best practices as well as maximum performance.
• Work with other engineers to troubleshoot, repair and performance tune databases. Perform data analysis and data profiling tasks to provide support and recommendations for development and design decisions.
• Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer. Define, prepare, execute and implement data validation and unit testing methods to ensure data quality.
• Troubleshoot problems that may come up with database environments: performance issues; replication issues; or ...