Sql Server .Net Developer

Phone: 215-***-****

E-Mail address: *********@*****.***

Alex Grinberg

Summary:

Senior DBA Architect/Analyst, SQL/T-SQL, SSRS, SSIS, .NET developer, and efficient IT problem solver. Significant experience in implementation and design of complex client/server systems. Enjoy challenging cutting edge business applications. Reliable, disciplined, mature in thinking and work ethic. Good communication skills. Perform with energy, a sense of goal, and stamina.

Board member of Philadelphia SQL Server User Group (PSSUG). Speaker/presenter for professional nationwide events, such as PASS Summit, PASS virtual chapter, SQLSaturday and CodeCamp.

Certifications:

70-461 Querying Microsoft SQL Server 2012. Certification number: F312-1304

Publications:

Apress – Author “XML and JSON Recipes for SQL Server” ISBN: 978-1-4842-3116-6

Apress – Technical Reviewer “Pro SQL Server Administration” ISBN: 978-1-484207-11-6

Apress – Technical Reviewer “SQL Server AlwaysOn Revealed” ISBN: 978-1-484217-62-7

https://www.simple-talk.com/author/alexgrinberg/

https://www.sqlservercentral.com/author/alex-grinberg-230981

RDBMS

MS SQL Server 2016/2017/2019/2022, Sybase, PostgreSQL, MS Access

Cloud Tech

AWS

Languages

Transact-SQL, C#, VB.Net

Scripting

VBScript, JavaScript, HTML, XML, JSON, PowerShell 4.0

ETL/Reporting

MS Integration Services (SSIS), MS SQL Reporting services (SSRS), Seagate Crystal, MS Excel, MS Power Point, MS Access

Data Modeling

S-Designer, ER-Win, ER-Studio (Embarcadero)

Data Access

ODBC, API, ADO/OLEDB

Operating Systems

Windows Server 2012 R2, 2008

Software

Team Foundation Server, Visual Studio, MS Office, Red-Gate suite, and a number of other tools.

Professional Experience

03/2020 - Current

HexaArt Inc, Richboro, PA

Consultant - Senior Database Engineer/DBA

Develop SSIS packages and SQL processes to upload data to SQL Server Datawarehouse. Provide the cleansing and deduping data procuresses.

Develop/Automate upload the data files to AWS S3 buckets.

Develop system to process the medical industry HL7 files in variety of formats, such as JSON, XML, flat text pipe delimited and Excel

Develop and maintain SSIS packages with varying levels of complexity

Participate in corporate business standard enforcement rules for SQL Server objects

Analyze business requirements and create the tables based on corporate standard and best practices

Develop and optimize T-SQL objects such as stored procedures, functions, views, triggers

Lead the implementation of versioning data capture using temporal tables

Review code on a regular basis to enforce the best T-SQL practices

Organized a project to semi-automate/automate manual processes for improving code/project delivery utilizing T-SQL, C#, PowerShell

Provide training sessions for colleagues

07/2015 –

02/2020

Cox Automotive Atlanta, GA (PA branch in Exton)

Senior Database Architect/DBA/Developer

Lead effort in performance tuning, database optimization, data modeling improvements including SQL Server on Cloud (AWS).

Moved the data to AWS S3 in JSON and .csv format.

Improved and automated the servers patching process by implementing PowerShell.

Managing functions of database administrators to ensure that developed solutions meet or exceeded performance requirements for high-volume transaction processing and reporting.

Redesigned inefficient views, stored procedures, triggers, and functions.

Provided re-indexing strategies by eliminating duplicated and inefficient indexes and creating full covering indexes.

Utilizing PowerShell to monitoring system resources and generate the scripts for SQL Server Agent jobs.

To reduce blocking and improve performance, migrating the disk tables into In-Memory Optimized OLTP tables.

Providing help with very large data transactions to reduce load time.

Wrote series of .NET (C#) applications to reduce manual processes and improve monitoring for about 800 servers.

Provided operational DBA support for client's servers 24X7.

Providing in-house training sessions to improve developers coding skills.

04/2012 - 07/2015

TMNAS, Greater Philadelphia, PA

Database Architect/DBA/Developer

Led project to upgrade SQL Server versions 2000 and 2005 to SQL Server 2012.

Led effort in performance tuning, database optimization, data modeling improvements.

Managed functions of database administrators to ensure that developed solutions meet or exceeded performance requirements for high-volume transaction processing and reporting.

Redesigned inefficient views, stored procedures, triggers, and functions.

Provided re-indexing strategies by eliminating duplicated and inefficient indexes and creating full covering indexes. Applied table partitioning technology for very large databases.

Utilized PowerShell to monitoring system resources and generate the scripts for SQL Server Agent jobs.

Provided help with very large data transactions to reduce load time.

Wrote series of .NET (C#) applications to reduce manual processes and improve monitoring for about 250 servers.

Provided operational DBA support for client's servers 24X7.

Played a key role in the design, development, and implementation for database monitoring tool (automation process, which creates a report about server health).

Provided help with SSIS packages for Actuarial team.

Created number of reports (SSRS), automated email notifications, and desktop applications for top management to reduce corporation cost of operations.

Awarded “Best Innovation Employee” in year 2013.

Trained clients and co-workers in advanced T-SQL techniques and XQuery language.

09/2011 - 04/2012

Lincoln Financial Group Radnor, PA

Credit Risk Developer

Simplified process to upload Bloomberg data from Excel into SQL Server (VB.NET).

Created custom designed tool for the Credit Risk group to retrieve all necessary daily and monthly portfolio data using C# 2010.

Created SSIS packages and T-SQL scripts to upload data into SQL Server tables.

Improved and simplified cross tab financial reports to analyze company’s investment efficiency.

11/2009 – 8/2011

ePharamaSolutions Conshohocken, PA

Senior Database Architect/DBA/Developer

Designed, developed, tested and deployed Help Desk Search utility to cut response time to the clients (FDLS, ASP.NET 3.5/C# 2008).

Improved a client data load process (from 1000 rows per day to 1000 per hour).

Improved, simplified, automated XML files data load process using XQuery language.

Designed, developed, created and tested all SQL Server objects (tables, views, triggers, functions, stored procedures, indexes, etc).

Designed, developed, tested, deployed and support multiple ePS ETL processes.

Automated SSIS packages to load data from Excel and flat files to SQL Server.

Enhanced T-SQL code and re-designed the indexes to optimize performance of the data retrieving processes.

Designed, created complex clinical research reports using SSRS.

Designed and implemented CLR objects (functions, triggers, stored procedures) utilizing C#, to improve ETL processes and enforce business rules.

Setup and maintain database backup and recovery solutions. Analyzed and proactively resolved database performance issues, database capacity issues.

Assisted and consulted coworkers in a variety of T-SQL, SSIS, SSRS, C# questions and challenges, and helped to resolve problems of varying complexity.

Led internal SQL Server classes for IT professionals to improve the quality of the development process.

1/2009 – 11/2009

SMART Business Advisory and Consulting, LLC Devon, PA

Senior Consultant - DBA/Programmer/Analyst

Wrote and optimized XML based reports using XQuery language.

Created SSIS packages to load data from Excel and flat files to SQL Server.

Migrated data form IRMS into Siebel system (client CSL Behring).

Created complex Accounting and Banking reports using SSRS based on both OLTP and OLAP (SSAS) technologies (client American Realty Advisors).

Wrote MDX queries and T-SQL procedures to provide data for the reports.

Analyzed, documented then converted Access database to SQL Server 2005.

Enhanced T-SQL code and re-designed the indexes to optimize performance of the data retrieving processes.

Assisted and consulted coworkers in a variety of T-SQL, SSRS and C# questions and challenges, and helped to resolve problems of varying complexity.

Provided in-house training sessions to share experience and coding techniques with colleagues.

Designed and implemented a .Net utility as an efficient wrapper and GUI for Rs.EXE server-side software created for batch-uploading of SSRS reports to web server.

Involved in managing projects, project time estimation and mentoring other developers.

2007 – 2008

Law School Admission Council (LSAC) Newtown, PA

Consultant - Senior DBA/Programmer/Analyst

Optimized database objects (stored procedures, functions, views, triggers) performance up to 90% in efficiency using new features like CTE, XML data type, Ranking functions and other.

Designed, implemented, and supported the Applicant centralized database system.

Created number of utilities using VB.NET to improve and/or simplify workflow process:

1.QueryRunner ETL –allows composing and running complex SQL statements across databases (more than 200 client databases), transfer result into a table, Excel worksheet, and flat file.

2.SQL Script runner – allows applying same SQL scripts to multiple databases.

3.Database disaster recovery system utility – Backup, restore, detach, and attach databases within minutes (more then 200 client databases). Prior manual process for same operations used to take over 5 hours.

4.Custom Databases management utility – allows receiving fast notification responses and correcting certain user mistakes/errors.

5.SQL Script viewer – allows retrieving single stored procedure from global file, then saving it as single file.

Created a number of generic SQL script utilities to speed up development process.

Assisted and consulted coworkers in a variety of SQL/VB.NET questions and challenges, and helped to resolve problems of varying complexity.

Created SSIS packages to exchange data between Excel and SQL Server and Oracle

2001 - 2007

IDP Inc. Wyncote, PA

Senior Programmer/Analyst/DBA/Team Lead

Analyzed and created number of indexes to improve database performers.

Created complex fully automated DTS solution, which exchanges backup files

with an offshore company.

Playing main role for R&D SQL Server 2005 (XML Data types, SSIS, DDL triggers, Error Handling, CLR, etc.) then covert SQL Server 2000 to SQL Server 2005.

Participating in redesign Policy save/retrieve structure.

Participating in design Data warehouse. Created DTS packages to populate Data warehouse tables.

Wrote numbers T-SQL generic scripts to speed up development process.

Wrote BuildRunner program, which simplifies and speed up loading hundred SQL scripts (C#)

Wrote generic DTSRunner program, which allows running or installing DTS on any server and database.

Coded and enhance a number of SQL Server stored procedures, triggers, and DTS Packages (VBScript) targeted at efficient data extraction, loading, and transformation according to customized application requirements as per client's business process definitions.

Wrote documentation on the system administration, troubleshooting, and up keeping.

As a part of an extended team, converted business logic to logical and then physical design of database systems for various applications. OOP: Designed and coded a generic business object (C#) handling cross-server data migration for reporting purposes.

Applied knowledge of Object Oriented programming as well as all prior business application programming, incorporating expertise in VS.NET/VB.NET,ASP.NET, XSL, VBScript, and JavaScript. Involved at a varied complexity level in all stages of application development, including Q/A and customer technical support. Designed repurchase block to enhance existing system.

Taking active part in design and development of the Insurance Data Processing information system. Part of the application was converted from the mainframe environment, with a number of additions, modifications, and enhancements. System is created in Windows 2000 environment using C#/VB.NET, MS SQL server 2000, and reporting tools, including Seagate Crystal Reports.

Implemented DB standards for name conventions and supported 4 production,2 dev and 1 QA SQL Servers

Monitored on 24/7bases jobs and SQL Server performance.

2000 - 2001

VerticalNet Horsham, PA

Senior Web Developer/Database Analyst

1996 - 2000

Compu Source Corporation Southampton, PA

SQL Server DBA/Programmer Analyst

1993 – 1996

Stratum Consulting Philadelphia, PA

Programmer

1990 – 1992

Aircraft Manufacturing Plant Kiev, Ukraine

Programmer

Education/Professional Training

1986 - 1990

Master of Mechanical Engineering.

Minor in Mathematics. State University, Kiev (Ukraine)

Contact this candidate