Database Administrator

Mapna O&M 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 ● 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.

Employment Type