Job Description
- Assist software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures.
- Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
- Troubleshoot performance issues (database settings, optimizing queries, altering indexes, ETL development, etc.).
- Monitor and maintain database systems and troubleshoot problems that may arise
- Manage users and assign database roles/permissions.
- Index management to improve data retrieval performance.
- Schedule and monitor daily jobs relating to data transfers, backup, and recovery, transaction log dumps.
- Collaborate with other team members and stakeholders.
Requirements
- At least 3 years of relative experience.
- Deep understanding and experience in Microsoft SQL Server.
- Familiar with In-Memory No-SQL database systems.
- Strong understanding of Database Design and T-SQL.
- Experience in SSRS and MS Report Builder.
- Familiarity with Data Warehouse Design.
- Experience with Performance Tuning and Optimization, using troubleshooting tools.
- Proficient in the implementation of ETL data and SSIS tools.
- Knowledge of High Availability (HA), Replication, and Disaster Recovery (DR) options for SQL Servers.
برای مشاهدهی شغلهایی که ارتباط بیشتری با حرفهی شما دارد، محاسبهکننده حقوق
چقدر حقوق بگیرم؟
برای مشاهدهی شغلهایی که ارتباط بیشتری با حرفهی شما دارد،
