Database Administrator

Pardakht Electronic Sadad Tehran

Posted a year ago

Job

Company

Salary

Applicant Insights

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. ● Create users and assign database permissions. ● Index management to improve data retrieval performance. ● Schedule and monitor daily jobs relating to data transfers, backup, and recovery, transaction log dumps.

Requirements

● Bachelor's degree in Computer Science, or Computer Engineering. ● Deep understanding of Microsoft SQL Server. ● More than two years of MS SQL Server Administration experience. ● Strong understanding of Database Design and T-SQL. ● Familiarity with Data Warehouse Design. ● Experience with Performance Tuning and Optimization, using troubleshooting tools. ● Familiarity with In-Memory OLTP. ● Proficient in the implementation of ETL data and SSIS tools. ● Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Servers.

Employment Type