شرح جایگاه شغلی
• Understand concepts of data models and data layer of enterprise services
• Have experience with build and deploy online data processing database systems
• Knowledge about database administration routines and best practices in working with data
• Expertise in MS SQL server administration and server management in mission critical environments
• Knowledge of SQL server features and internal tasks and processes
• investigate bottlenecks and problems in a live OLTP database service
• write T-SQL code effortlessly and fluently and design objects needed in every use case
• Have experience with systems sizing, capacity assessment and server resource management
• Fluent in server performance tuning, execution plans, query optimization and related solutions
• Resolve and troubleshoot complex data and operation issues
• Write complex on-demand and periodic and pre-planned reports
• Know how to automate and manage maintenance and business procedures
• Have understanding of root cause of regular issues with SQL server engine and other services
• Have knowledge about windows server features, networking, and enterprise storage systems
• Ensure compliance of standards and conventions in development playground
• Maintain and manage all versions of data for production, testing and development databases
• Design, develop and implement and work on integration systems like data warehouses/marts
• Be motivate about finding solution, think about problems faced and use every possible solution
• Perform and execute ETL operations using SSIS and other third party tools
• Know how to prevent potential blocking issues in the manner of design, code writing
• understand existing business cases deployed at the company and extend them if needed
• Participate in discussion involving the service development and translate comments and requirements to features and code/design accordingly
• Be familiar with data mining and BI concepts