Senior Database Developer, Monta Group — October 2017-Present

Working part time as a senior SQL Server developer, I have to monitor the system and apply query optimizations on slow-running queries; besides, I have to teach other junior and newly-joint members how to write ell-performing queries and review their w orks. Here is a list of tasks I am doing in this company.

•          Implementing database administration policies;

•          Implementing data access rules and security;

•          Designing and implementing data models;

•          Writing database scripts, stored procedures, views, and so on;

•          Documenting codes, and system design;

•          Maintaining disaster recovery strategies;

•          Tuning system performance and optimizing queries.

Technologies, frameworks, libraries:Microsoft SQL Server

Tools: SSMS, SQL Server Profiler, Jira

Senior Software Developer, Iranian National Tax Administration, Tehran — June 2015-Present

On a daily basis, we are developing variety of software to fulfill the requirements of the organization. In order for other developers to be able to develop and maintain the system, I have to design strategies to address the challenges; moreover, I have to write C# and Java codes to satisfy system’s requirements as well. Some of my main tasks are as follows:

•          Maintaining software that facilitate development process in DevOps            

•          Counseling other developers on designing their developing strategies, web or database

•          Developing software based on the use case to satisfy organization’s requirements

Technologies, frameworks, libraries:SQL Server, Oracle, ASP.NET Core, Micro Services, Docker, RabbitMQ (RawRabbit), SignalR, Git, Libgit2sharp

Tools: Microsoft Visual Studio, SQL Server Management Studio, VS Code, Git Kraken, GitLab, Jira, IntelliJ IDEA, eclipse, Oracle SQL Developer, Postman, Fiddler

Computer Science Instructor, Amirkabir University, Tehran — May 2010-July 2015

I have always been enthusiastic to impart my knowledge to the younger generation, which is why I had five fabulous years teaching Web and Database Development there.

•          Teaching SQL Server, 10 quarters

•          Installation and maintenance

•          Scripting: writing procedures, functions, views, triggers, etc.

•          Recovery strategies: backup and restore

•          Introducing high availability technologies: Mirroring, Replication, Log Shipping

•          Teaching Web Programming, 5 quarters

•          JavaScript, HTML, CSS, and KnockoutJS framework

•          ASP.NET MVC: MVC, SignalR, Restful APIs

.NET and SQL Server Consultant, Iran Code, Tehran — March 2016, August 2016

As a part-time job we had to tackle the problems the development team was facing, from database design to low-level programming.

•          Counseling on database design

•          Creating libraries to facilitate how high level code communicates with industrial printers and barcode readers

Technologies, frameworks, libraries:Microsoft SQL Server, ASP.NET MVC, .NET Framework

Tools: SSMS, Visual Studio
 

Senior .NET and SQL Server Developer, Tax Organization of Tehran Province, Tehran — August 2014, June 2015

There were several problems to tackle; the most significant one was the way authentication and authorization system was developed; we needed to make an overhaul, thus, we developed a Single-Sign-On (SSO) system to handle the process.

•          Designing databases for various systems, such as Taxpayer Identification system, SSO, and etc.

•          Implementing an admin panel for SSO

•          Creating a JavaScript framework over KnockoutJS to uniform the way client-side apps are written, called “freshAirJS” similar to “DrundalJS”

•          Implementing Mirroring and Database encryptions to achieve better high availability and security level

Technologies, frameworks, libraries:Microsoft SQL Server, .Net Framework, ASP.NET MVC, Entity framework, Dapper

Tools: Visual Studio, Team Foundation Server (TFS), SSMS

SQL Server Developer, Monta Group, Tehran — March 2012, October 2014

Most of my responsibilities were database-related, from designing data models to writing scripts and documenting the processes and scripts. All of the major tasks have been described earlier, since I worked here for two different periods.

.NET and SQL Server Developer, OGHAB Afshan Industrial & Manufacturing Company, Tehran — October 2008, September 2012

We switched from Windows forms to WPF, a cutting-edge technology at that period.We were developing an automation system to handle various processes within the company from warehousing to production line controls.

•          Designing and implementing database architecture

•          Writing scripts, procedures, functions, and etc.

•          Performing performance tuning operations, such as indexing.

•          C# team member, coordinating programmers with testers and business analysts

•          Implementing data access layer using LINQ to SQL

•          Analyzing business requirements and documentation

•          Programming WPF forms

Technologies, frameworks, libraries:Microsoft SQL Server 2005, .NET Framework 3.5, WPF, LINQ to SQL

Tools: SSMS, Visual Studio, TFS

C# programmer & SQL Server Developer, Razi Medicine Distribution Company, Tehran — September 2005, October 2008

The early years of being in the industry was so charming and challenging, I learnt a wealth of patterns in programming from team members and they were not reluctant to assign me challenging tasks.At first I was a member of C# team and later on I joined the database team to implement Merge Replication amongst 23 branches nation-wide, a wonderful experience.

•          C# team member, writing Windows forms applications to handle the business requirements

•          Database team member, writing stored procedures and implementing Merge Replication.

•          Technologies, frameworks, libraries: Microsoft SQL Server 2000& 2005, .NET Framework 1.1, WPF, ADO.NET

•          Tools: SSMS, Visual Studio, TFS

Personal Projects

Aurelia Toolbelt

I am one of the creators of aurelia-toolbelt, a bunch of UI components for the Aurelia SPA framework. https://github.com/aurelia-toolbelt/aurelia-toolbelt

Aysuda Web Site

A semi-shopping web site for the Aysuda group to sell their products;the project has been written by employingknockoutJS, bootstrap, and ASP.NET MVC, and also SQL Server as its backend database.

Fardad Jewelry Web Application

The project was built on top of Angular 1.x and ASP.NET MVC 5, using SQL Server 2012 as its backend database. The aim of the project was to automate the sales and customers management in a jewelry production line environment

Education

Associate’s Degree – Software Systems – University of Applied Science and Technology — 2004-2006

Bachelor of Science – Software Engineering – Azad University, Tehran South Branch — 2008-2010

Skills

Working for more than a decade in the industry, I have been working with many technologies and I got interested in some. Here is a brief list of them:

•          Database: Microsoft SQL Server, Entity Framework Core, Dapper, ADO.NET

•          .Net Ecosystem: .NET Core, ASP.NETCore, SignalR, and Micro Services

•          IdentityServer4, Redis, RabbitMQ( used RawRabbit to work with RabbitMQ )

•          Web Client:

•          JavaScript, Typescript, Webpack, Fusebox, Gulp

•          Aurelia, VueJS, KnockoutJS, AngularJS 1.x

•          TDD( Test Driven Development ), Micro Services Architecture

•          Software: Microsoft Visual Studio, VS Code, Microsoft Visual Studio for Mac, SSMS( SQL Server Management Studio ), SQL Server Profiler, GIT, Git Kraken, Source Tree

Also interested in the followings:

•          Docker& Containers

•          Roslyn, F#, Python, Node.js

•          Postgres, PotgREST, RethinkDB, Elastic Search

•          Sass/SCS