SQL Server Developer / DBA

Mohsen Memarian

ac10k0@r.postjobfree.com

Irvine, CA U.S.A - +1-949-***-****

Objective

To join a team as a senior SQL Server administrator or senior SQL Server developer to design, administer and tuning large databases.

Summary

Self-motivated database design and administration with over one decade of experience with Microsoft SQL Server. Expert on large-scale database design, administration, and especially performance tuning of SQL Server databases. Professional in writing complicated queries using TSQL. Skilled in managing multiple tasks, in scheduling people and resources, and in prioritizing competing responsibilities. I am green card holder and moved in to US recently.

Experience

Lead SQL Server Developer /DBA

Knowledge Technology Era (KTE) co. Tehran, Iran

2003 –July 2017

KTE is one of the main software companies in IRAN who provide excellent Business Intelligence product and solutions. I have done many jobs in KTE including:

Design and implement database for a Business Intelligence (BI) system and extends it during 13 years. This software sold to more than 300 customers.

Design more than 40 ETL packages using Microsoft SSIS.

Install and administer SQL Server for company customers, especially for one bank ( Tourism Bank )

Write hundreds of stored procedure and functions and triggers for BI database.

Using Microsoft Performance profile, execution plan and monitor activity to find bottleneck of system and tune them with some tools like indices, rewrite queries, etc.

Design and implement database for more than 10 customized software systems.

Manage a database team that has five member.

I also had following programming experience in KTE:

Developed .Net(C#) desktop application for Khuzestan Water Organization (KWPA) for data entry over their network and created report using crystal report for them

Designed and Implemented a database for totally new BI tool with hundreds of stored procedures and user defined functions

Created a 5-Tier web based application using ASP.NET (C#) for KTE BI tool with more than 300 hundreds customers.

Implemented a .NET(C#) desktop application for installation KTE software products

Developed web based cross-tab reports using HTML, Ajax, DHTML, CSS and JavaScript

Performed business and system analysis, requirement gathering and leading developer team with agile methodologies

Implemented Web-Service for KTE BI tool to communicate with other software using .Net(C#)

Technologies: Microsoft SQL Server (Database Engine, SSIS, SSAS), Visual Studio .Net(C#), Microsoft Team Foundation Server (TFS), HTML, CSS, Ajax

Faculty Member

Azad University, Semnan, Iran

2003 –July 2017

I was a faculty member of computer science department of Azad University for 14 years.

I taught computer science courses specially Relational Database Design, Software Engineering, Automata Theory.

I conducted 50 final projects of computer science students.

Software Developer

Parna, Tehran, Iran

2001 – 2003

Net Developed web based application using Asp and HTML for Water Utility Company in Ahvaz (KWPA).

Developed application using Delphi language for a company in Canada (outsourcing)

Create and manage database objects like tables, views, triggers, etc.

Technologies used: ASP classic, HTML, Delphi, Pascal, SQL Server

IT Expert

Plan and Budget Organization of Iran, High Council of Informatics (HCI) Department, Tehran, Iran

1998 – 2001

Designed HCI site using HTML, CSS and Perl language

Supervision and maintenance user’s computer and solve their problems

Network Troubleshooting

Technologies used: HTML, CSS, Delphi, Pascal, CGI Programming: Perl scripting

Education

M.Sc. in Software Engineering

SBU, Tehran, Iran

2002

B.Sc. in Software Engineering

SBU, Tehran, Iran

2000

References

References are available on request.

Mohsen Memarian

ac10k0@r.postjobfree.com

Contact this candidate