System Administrator

• Administration of local IT systems (workstations, servers, render farm) 
• Provide 1st & 2nd level support to end-users 
• Documentation (updating network diagram and information) 
• Setup of new workstations and systems 
• User management with Active Directory 
• Operation and maintenance of backup and archival procedures 
• Evaluation of new systems for purchase recommendations 
• Scripting and automation 
• Office 365

• Network Design & Implementation of Central Building & the entire Branch in Country 
• Enterprise Servers Administrator (Windows Server and Linux) 
• Design and Implementation of many activities. For instance: ESX, Active Directory, Mail Server, VPN Servers, 
• Design Firewall Rules with Sophos 
• Monitoring Servers with Solarwins 
• Design and implementation mail server with Microsoft Exchange Server 
• Wrote Job Queries scripts for daily maintenance activities such as backup databases, including indexes and tables analyses 
• Installing software for the clients 
• Operate master consoles to monitor the performance of computer systems 
• Information Design & Documentation 
• Database Administration (DBA)

• Using SQL Profiler to conduct Performance tuning 
• Developing Online reports using SSRS 
• Maintenance plans creation and scheduling including database logs, backups and cleanups), 
• Developing security issue scripting of database roles for Stored Procedure rights. 
• Programing in DB2 and SQL Server environment and producing software using Server-Side technique Cooperation to designers, analyzers for creating the facilities required for using related systems; 
• Preparing technical reports on system performance; 
• Aforementioned holds ability to understand problems and providing solutions as well as teamwork capabilities; 
• Programming using Delphi 
• Creating new sub_ systems and integration them with existing systems and sub_ systems; 
• Producing Online reports with Stimulsoft Report & Active Report for monitoring the soft wares. 
• Testing third party software for ensuring the accuracy of their function and usage in the system; 
• Optimizing the codes produced in programing team; 
• Programing using Delphi programming language and cooperation in production of Banking Centralized Credits software process. 
• Developing and producing the software of automatic run of night Jobs of credits system of Bank Mellat to synchronize the data in different systems 
• Working with complex queries, Designing and implementing Tasks using SSIS

• Network Design & Implementation of Central Building & the entire Branch in Country. 
• Enterprise Servers Administrator 
• Design and Implementation of many activities. For instance: Active Directory, Mail Server, VPN Servers,

• Programming of Credit System of Mellat Bank. 
• This bank is one of the biggest private banks in Iran. 
• Platform is .NET Framework. 
• Database is SQL Server. 
• Assisting with the programming and development of Mellat Bank's finance and loan software 
• Assisting with the application of Microsoft tools for programming and development, tools including Visual Studio. Net, Reporting Service, Microsoft Visual SourceSafe 2005, SQL SERVER 2005, 2008 
• Querying XML for huge amount of records retrieved from all branches. 
• SQL CLR Programming to utilize .Net Framework facilities and class library. 
• Writing, implementing and running Stored Procedures, Triggers, Views and queries based on Design and analyzing team's documentations. 
• Designing and implementing queries required for the reports of accountants, auditors 
• Creating User Defined functions (Scalar and table value functions) for being utilized in reporting scripts. 
• Combine user-defined functions with views and procedures (Mostly used in Report Scripts) 
• Database changes management on Daily bases (Including Tables, Procedures, Triggers, Views alteration) for setup and version changing. 
• Transaction defining and setting Isolation levels (Almost all the scripts and processes were executed in transactions) 
• Modifying Data using Insert, Update and Delete Statements in Transactions 
• Cursor Usage for querying or Updating data 
• Raise error and try catch using for trouble shooting and error handling issues 
• Configuring Linked Servers to execute various T-SQL to retrieve different reports among Bank branches 
• Working with complex queries, Designing and implementing reports using SSRS 
• Installing, implementing and updating software on branch servers by creating the scripts in setup files and executing them 0n branch databases 
• SSRS Trouble shooting, Using SQL Server reporting service configuration manager 
• Documenting and report preparation to keep the records of failures and faults

• Developing forms and programing parts of credits facility system of Bank Mellat 
• Programing in SQL Server environment in producing software and components using SQL CLR technology 
• Investigating issues, commercial logic and algorithms presented through analysis and developing teams using C# & VB.NET programing language 
• Developing and implementing Queries related to WebService and creating XML files related to that 
• Programing and producing system reports and reducing codes' run time through optimizing codes 
• Research and collaboration in consulting production and method of coding of system and programs in order to develop and produce and recognize limitations and potentials of project to exploit the produced software 
• Developing and preparing models based on UML and preparing documents using Rational Rose tools 
• Producing, programing, and final testing of software in order to operationalize them 
• Developing and producing sub_ systems and integrating them with existing systems 
• Changing in existing software and troubleshooting and fixing errors and optimizing produced software 
• Reporting Service, Microsoft Visual SourceSafe 2005, SQL Server 2005, 2008 
• Using SQL Profiler to conduct Performance tuning 
• Documenting and report preparation to keep the records of failures and faults 
• Index rebuilding and Performing Used Index tuning wizard for a better performance 
• Maintenance plans creation and scheduling including database logs, backups and cleanups) 
• Security issue scripting of database roles for Stored Procedure rights. 
• Securing the Data Storage 
• Administering and Managing Database Mirroring