Database Administrator
Doosheh dairy
Total years of experience :4 years, 5 Months
• Designing and implementing the SQL Server database based on the policies, procedures and standards of database design and documenting the database structure.
• Defining users and managing database access and permissions depending on the specialized role of each end user and to ensure security, privacy and integrity of data, regular tests and evaluations and documentation User access.
• Adjust SQL Server and VMware parameters to provide fast response to queries
• Monitor and managing database performance such as periodic indexing
• Implementing different backup and recovery models scenarios such as Transactional, Differential and Log-shipping by Redgate, managing disk space and checking the security of backup file copies
• Installing and testing new versions and patches of SQL Server and applying changes if necessary (SSMA)
• Communicate regularly with developers to ensure database integrity and security, Writing complex queries, triggers, stored procedures, functions, modifying queries and testing new versions of software
• Creating T-SQL, PowerShell, command prompt or exe files and run them by schedule jobs (SQL Server agent)
• Develop, maintain, and administering complex ETL processes using DTS and SSIS for data load and extraction
• Designing SSIS package with Visual Studio and deploy in SQL Server
• Maintenance and support for a self-service BI
• Develop, troubleshoot and tuning existing or new reports
• Manage and maintain data models including physical and data warehouse
• Establish methods and procedures for tracking data quality, completeness, redundancy and improvement
• Defining users and managing report access and permissions
• Develop programs based on C#, Python, VBA
• up-to-date all documentation regularly
• Training other team members
• Providing 24x7 support