استخدام SQL Developer
شرح موقعیت شغلی
Alibaba is looking for a talented SQL Developer to help us improve and expand our rapidly-growing product
Job Responsibilities:
- Database Architecture - Design and develop highly efficient, robust, and scalable database architecture on an MS SQL Server platform
- Query Authoring - Construct complex optimized MS SQL stored procedures in support of higher level applications and analysis tools
- Data Intake Process Design - Create and automate reliable processes which handle regular and frequent extracts, transformations, and loads of large volumes of data from a wide variety of external sources
- Standards and Guidance - Develop, contribute to, and improve our standard database development and architecture practices and styles.
- Performance Optimization - Monitor, detect, and correct poor-performing queries and processes. Optimize overall database performance through intelligent indexing, partitioning, normalization, process redesign, and performance tuning.
Skills and Qualifications:
- Over 3 years of experience
- BS or MS in Computer Science, or similar degreeDeep knowledge in Query Execution plan, Query Optimization
- Investigate, debug, and debug data in operational databases.
- Analyze existing queries to optimize performance.
- Monitoring and possible optimization of Query consume server resources.
- Familiar with the concepts presented in the new versions of SQL SERVER.
- Develop procedures and scripts for data migration.
- Review and interpret ongoing business report requirements.
- Provide timely scheduled management reporting.
- Mastery of T-SQL Programming.
- Suggest new queries.
- Build appropriate and useful reporting deliverables.
- Familiarity with application development using technologies like C#, XML, JSON.
مهارتهای مورد نیاز
- Sql Server
- sql query
- T-SQL
حداقل سابقه کار
- سه تا شش سال
جنسیت
- مهم نیست
وضعیت نظام وظیفه
- مهم نیست