Troubleshoot problems that may come up with database environments: performance issues; replication issues; or operational issues. Define, prepare, execute and implement data validation and unit testing methods to ensure data quality.
Numbers & Facts
Location
NV
Description
Job Description:
Work with technical and business team to understand the business requirements, functional and technical specifications
Design, code and maintain new and existing complex SQL stored procedures and functions
Performance tune existing stored procedures, tables and indexes
Work with other engineers to troubleshoot, repair and performance tune databases
Review SQL code written by other developers to ensure compliance to coding standards and best practices as well as maximum performance
Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer
Troubleshoot problems that may come up with database environments: performance issues; replication issues; or operational issues
Perform data analysis and data profiling tasks to provide support and recommendations for development and design decisions
Analyze and define data flow requirements and prepare applicable system documentation and operation manuals as needed
Support production data loads and ongoing refreshes of the database systems
Define, prepare, execute and implement data validation and unit testing methods to ensure data quality
Maintain re-usable development standards that help implement each solution and/or enhancements to existing systems to meet current and future needs