Sql Server Developer
Resume:
Evgueny Vassiliev
Phone: 905-***-****
Cell: 289-***-****
email: *************@*****.**
Objectives
Position of Senior Production DBA/Database Developer/Database Analyst in an organization where my knowledge of MSSQL Server 2005/2008/2012/2014, Windows 2000/XP/2003/2008/ Windows Server 2012 R2, SSAS (Analysis Services), SSRS (Reporting Services), Windows shell scripting, .Net, C#, XML, my 17 years of experience in administering and developing relational databases, troubleshooting front-end applications and ability to work in high volume will be utilized.
Summary
I am a Senior Database Administrator/Architect/Developer with experience in extended relational database environment. I offer an extensive background in MS SQL SERVER, MS .Net Framework, POSTGRESQL, MySQL and Microsoft Windows server products.
Relational database assessment, design and implementation;
Design and implementation of ETL processes with DTS/SSIS ;
SQL SERVER database and application performance tuning;
Conversion to and from databases and applications in SQL SERVER, POSTGRESQL, MySQL and MS Access;
SQL SERVER system administration, upgrades, installation and support (SQL 2005/2008 R2/2012/2014);
SQL database administration and query optimization;
Analysis and implementation of applications in ASP .Net and SQL SERVER;
Customer Relationship Management (CRM) and Point Of Sale (POS) system implementation;
Training of programmers, administrators and users.
Work Experience
July 2015 - December 2015: sub-contract -Senior Database Administrator/Database Developer at INCOMM (Miami, Florida, US, http://www.qpaynet.com)
-Created ETL procedures for the load of data from legacy systems into Financial management system – “Microsoft Dynamics GP” (formerly Great Plains);
-Created ETL processes for load of the data from third-party vendors into customer’s database;
-Created database objects – stored procedures, UDFs, triggers, tables and views per customer’s request;
-Generated reports per customers request;
-Managed SQL servers(SQL server 2008 R2, 2012) ;
-Managed transactional replication between servers.
-Worked in Agile environment.
2004 –July 2015: Senior Database Administrator/Database Developer/Database Architect at “The Marketing Store” (Toronto, Ontario, http://www.tmsw.com); Leading Database Administrator in the project “Nissan CRM”
-Designed and implemented ETL solution between OLTP, Reporting and Data Warehouse databases.
-Created database objects using T-SQL: stored procedures, UDFs, triggers, tables and views per customer’s request
-Managed large databases in complex environment: SQL SERVER 2005/2008/2012/2014 running Windows 2003/2008/Windows Server 2012 R2 operating system, virtual and physical servers, MySQL on Linux in Amazon AWS.
-Monitoring the health of the database servers using SQL Server native tools (DMVs, Performance Monitor, system views and stored procedures, SQL Server profiler, Data Collector, SQL Server
-Migrated servers and databases between environments
-Upgraded SQL Servers from SQL 2000 and SQL 2005 to SQL Server 2008 R2 and SQL Server 2012
-Utility) and third-party tools (Quest Software Spotlight on SQL Server Enterprise, RedGate SQL Monitor)
-Enforce all security policies associated with the project and the corporation.
-Designed and implemented solutions for data synchronization between servers using Replication, Log Shipping, SSIS packages.
-Designed and implemented High Availability database environments using Log Shipping, Database Mirroring, Failover Cluster and Always ON
-Planned, prepared and implemented the migration of SQL servers and WEB applications between different hosting environments
-Gained Extensive experience with debugging of SQL procedures.
-Analyzed the execution plans of stored procedures and SQL statements in order to identify performance bottlenecks.
-Analyzed SQL SERVER applications and database design to optimize query and data access performance.
-Implemented upgrades from SQL SERVER 2000 to SQL SERVER 2005 and from SQL SERVER 2005 to SQL SERVER 2008/ SQL Server 2012
-Reviewed and Deployed database change scripts provided by development team
-Optimized stored procedures in order to improve performance
-Educated colleagues with respect to database design and implementation practices.
- Documented company’s database environments
-Created maintenance plans, designed and implemented data archiving process
-Resolved DB performance and consistency problems
2000 - 2004: NESS-ISI (www.NESS.COM)
- Designed and developed project Data Stock” for the world’s second largest Health Insurance Company “Clalit”: managed dataflow process from fifteen hospitals across the country and integration of data into central database. Used SQL Server 2000 as database server and TSQL for stored procedures and functions.
- Performed logical and physical Database Design including complex store procedures, triggers, functions, cursors, constraints and indexes.
- Administered and developed Data Warehousing and Data Mining systems.
- Created and maintained SOE (Standard Operating Environment): Installed hardware, Installed and configured Windows NT/2000 Servers and Windows 95/98/NT/2000/XP workstations.
- Administered Database servers in 15 hospitals (db size 200-400 GB): planned and performed server installations, configured SQL server settings, analyzed and optimized SQL queries and stored procedures, tuned indexes using SQL Server Profiler, developed and implemented backup\restore strategy, managed security, distributed database patches.
- Developed DTS packages for data conversion from Ingress, dBase, Btrieve, Oracle, DB2, MS Access, ASCII and other data providers to MS SQL Server 2000.
- Administered SSAS Servers: archived and restored SSAS databases, optimized and automated cubes’ processes, managed security.
- Administered databases and supported customers.
- Created installation packages using Install Shield (versions 5, 7, 8).
- Optimized performance of databases and front-end applications.
- Supported end-users and IT staff in hospitals.
- Consulted software developers and database administrators from other projects and other company branches.
- Developed client/server applications for internal use using VB, C#,XML
1998-2000: IPEX -ISI DBA\Customer Support
- Installed and configured Windows NT servers and Windows 98/NT workstations, installed hardware and software, created disk images using GHOST utility, installed new workstations using previously prepared disk images.
- Created deployment packages for applications using InstallShield 5.0 and Package for the WEB.
- Provided technical telephone support to end-users in Germany and Switzerland
- Installed, administered and optimized SQL Server 7.0 databases.
- Tested front-end applications of Retail Merchandising System “Paragon” for “InterSport” Corporation, Germany.
- Consulted Helpdesk team in Germany and Switzerland by phone.
Education
1991-1996 Bachelor’s Degree. Khabarovsk State University, Russia.
Courses
2014 Designing Database Solutions for Microsoft SQL Server 2012
2000 Implementing a Database Design on Microsoft SQL Server
2000 Administering Microsoft SQL server
1998-99 Administering computer networks
1998 Professional course for computer technicians
Microsoft Certification Exams
- Developing Windows-based applications with Microsoft Visual C# and Microsoft Visual Studio .Net
- Installing, Configuring and Administering Microsoft Windows 2003 Server
- Administering Microsoft SQL Server
- Implementing Databases using Microsoft SQL Server
- Microsoft Certified Database Administrator (MCDBA)
Personal Skills
- Able to work as a team player in high volume with minimal supervision
- Good communicator
- Self-motivated
Languages
French, German, Russian
Contact this candidate