| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate[pic]Phone: PHONE NUMBER AVAILABLEE-Mail address: EMAIL AVAILABLEAlex 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. ||Certification|70-461 Querying Microsoft SQL Server 2012. Certification number:||s: |F312-1304 ||Publications:|Apress - Author "XML and JSON Recipes for SQL Server" ISBN: || |PHONE NUMBER AVAILABLE || |Apress - Technical Reviewer "Pro SQL Server Administration" || |ISBN: 978-1-484207-11-6 || |Apress - Technical Reviewer "SQL Server AlwaysOn Revealed" ISBN:|| |PHONE NUMBER AVAILABLE || |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 |Windows Server 2012 R2, 2008 ||Systems | ||Software |Team Foundation Server, Visual Studio, MS Office, Red-Gate || |suite, and a number of other tools. |Professional Experience|03/2020 - |HexaArt Inc, Richboro, PA ||Current |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 - |Cox Automotive Atlanta, GA (PA branch in Exton) ||02/2020 |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 - |TMNAS, Greater Philadelphia, PA ||07/2015 | || |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 - |Lincoln Financial Group Radnor, PA ||04/2012 | || |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 - |ePharamaSolutions Conshohocken, PA ||8/2011 | || |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 - |SMART Business Advisory and Consulting, LLC Devon, PA ||11/2009 |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: || |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. || |SQL Script runner - allows applying same SQL scripts to multiple || |databases. || |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. || |Custom Databases management utility - allows receiving fast || |notification responses and correcting certain user || |mistakes/errors. || |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) || | || | | |