Sr. SQL Developer

English: Advanced. Working Hours: PSTSalary: $2,500.00 USD

Primary Skills:

• 5- 7 yrs. of proven experience as SQL developer

• Expertise in SQL server design and development

• Strong experience & knowledge of SSIS and SSRS

• Technical expertise in the areas of data profiling, data mining, and data analytics

• Technical expertise in building reliable data ETL/ELT processes, query optimization, and dynamic SQL

We would need candidates having – strong SQL Development knowledge, SSIS Development / implementation, Performance Tuning of the DB’s, Query optimization skills etc.

ResponsabilidadesResponsibilities

• 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 o 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

• Perform enhancements and bug fixes as required

• Perform any additional duties as assigned

Key Skills

• SQL