استخدام SQL Server Database Developer
شرح موقعیت شغلی
Responsibility:
-Publish a high variety of online and operational databases
-Check and adapt all designs and naming with software development’s standards and guidelines
-Index and tune SP and Queries
-Monitor, evaluate and manage database reports
-Advise and consulate for database designs
-Recommend for a distributed database solution
-Recommend solution for maintaining and manage high volume data
Requirements
- At least seven years of experience in the same position
- Expertise in T-SQL programming and database design concepts and standards
- Proficient in Query Performance Tuning
- Ability to present a solution based on SQL Server
- Ability to develop and optimize complicated queries
- Ability to check and evaluate potential blocking, deadlock and recommend a solution for avoiding blockages
- Familiar with Database administration concepts
- Familiar with Data Warehouse and BI concepts
Qualification
- Good knowledge in SSIS (ETL)
- Good T-SQL Programming Knowledge
- Create complex query definitions that allow data to be extracted
- Admin of database: installation, Backup Strategy
- Performance tuning in SQL Server
- Manage users and groups
- Monitor performance counter
- Work with HA/DR solution in SQL server(Failover Cluster, Always on)
- Good knowledge about lock & latch in SQL server
Benefits:
- Flexible working hours
- Appropriate and on-time payment
- Interesting work environment
مهارتهای مورد نیاز
- Database Development
- Sql Server
- T-SQL
حداقل سابقه کار
- بیش از شش سال
جنسیت
- مهم نیست
وضعیت نظام وظیفه
- مهم نیست