Arty Martynas Kancleris

Sr. MS SQL Server DBA, MCSE, MCSA, MCITP, MCTS

USE [Curriculum Vitae]
Nationality: Lithuanian
DOB: 1980 March 26
Mobile: +370.686.60.477 LT
Email: m.kancleris@gmail.com
Skype: martynas.kancleris
LinkedIn: http://www.linkedin.com/in/kancleris
CV (pdf) CV (docx) Recommendations (Linkedin)
Updated: 2015 September 20

 
Intro
SET NOCOUNT ON

Senior Microsoft SQL Server DBA - Available immediately for permanent opportunities, long or short term contracts, back fills

Pursuing an engineering opportunity to write T-SQL code for the next big ERP solution

 

   
Profile
dbo.View

I am highly skilled Microsoft SQL Server expert. I have 15+ years' experience in the IT services industry where I have held positions from developer to executive management. I have worked extensively with Microsoft SQL Server since '02 with versions 2000 through to 2012 in both production and development environments where technology has to be resilient, recoverable and flexible. In various leadership and individual contributor roles, my responsibilities included designing, developing and configuring enterprise applications, hiring professionals and delivering results.

Clear understanding of today's business needs | desire for new challenges

 

I have been involved with various types of Microsoft SQL Server based applications, such as high-performance, mission-critical, real-time transaction-processing systems, large-scale data archives, data warehousing applications. The databases were ranging from gigabytes to terabytes.

12 years' experience developing ERP systems | Enterprise Resource Planning

 

I am particularly interested in designing and configuring relational database using Microsoft SQL Server 2008R2/2012. I would like to lead in the management, design, backup and control of production/development databases infrastructures, performance tuning, distribution and replication. I can provide technical support in the areas of database administration, data integrity, data repository administration, data replication, database backup and restore processes and reporting engines.

Microsoft SQL Server 2012, C#, ASP.NET

 

I have strong communication and self-management skills and have worked in complex and challenging environments. I have demonstrated the ability to work well under pressure to tight deadlines whilst maintaining strong relationships with management and colleagues. I have a strong grounding in support of production system and success in delivering projects in high pressured business atmospheres.

 

I am a self-learner who is willing and able to acquire new skills quickly.

Specialties: Market research, Finances, ERP

 

I am looking for Microsoft SQL Server challenges and work that can force to deliver best out of me.

Strong interest: Microsoft Technology stack with a heavy emphasis on Microsoft SQL Server.

 

link RAISERROR('image',10,16) WITH NOWAIT

   
Skills
dbo.Table
  • SQL Server setup, installation and configuration of SQL 2000/2005/2008/2008R2/2012
  • SQL Server infrastructure and capacity planning
  • Logical and physical data modeling (tables, DML triggers, indexes, references, constraints, file groups)
  • Development a complex DB objects (stored procedures, functions, triggers and views)
  • Development of business applications logic using DB objects that serving screens and reports
  • Defining and maintaining best practices for database architecture and operations (DDL triggers)
  • Supporting developer staging area (testing) before production
  • Server security management - logins, users, roles, schemas
  • Designing database security policies
  • Disaster recovery planning
  • Configure SQL Server jobs monitoring, alerts, scripting and operators etc.
  • Planning for high availability
  • Planning and implementation of failover clustering for SQL Server
  • Implement database mirroring and HTTP End points
  • Implement database log shipping and replication
  • Trouble shooting (DBCC) and performance tuning, monitoring and maintenance (SQL profiler, execution plans, policy manager, resource governor, database engine tuning advisor and DMV)
  • Consolidation of SQL Server instances, databases and schemas
  • Import and export utilities (BCP, BULK inserts, SSIS etc.), ETL
  • Knowledge of Service Broker, SQL Mail
  • Solid experience developing reports with SQL Server Reporting Services (SSRS)
  • Knowledge of SQL Server Integration Services
  • Automation scripting, Visual Basic for Applications, C# and .NET technologies
  • Provide technical and functional support to desktop users
  • Administer and update Exchange server
  • Update Active Directory with new users, computers and security changes
  • Administration of DNS and DHCP with reservations for computers and hardware
  • Update Windows Servers 2003/2008 with OS patches, upgrades and software updates
  • Monitor Windows Servers for warnings and errors to prevent issues
  • Replace hardware in desktop and servers as needed
  • Providing 2nd level support to helpdesk
  • Studying and understanding of business needs, study of data sources/systems and understanding/preparing requirement documents and mapping to architecture
  • Strong command over team management and leadership
  • Oracle database migration to SQL Server database
   
Technologies
dbo.Table

SQL Server 2012 (2008 R2/2008/2005/2000) | C# .NET4(3.5/3/2), VB.NET, Delphi | ASP.NET(Classic) | HTML, CSS, XML, XSL, JavaScript | Navision 2009(3.7/3.6/3.1/2)

Excellent knowledge of T-SQL. Solid experience using C#, Delphi. Moderate skills building web based solutions. Lots of practice programming Navision.

 

GUI applications, Web applications, Web services, SOAP, TCP/IP sockets (TCP/UDP), COM/ActiveX, Windows NT services, AJAX, Integration solutions

 

Windows Server 2008 R2(2003/2000) | Windows 7(Vista/XP/2000/95) | IIS7.5(6) | Active Directory | Exchange 2010 | Microsoft Office 2010(2007/2003/XP/2000)

 

More than 9 years experience developing automated ERP systems using Microsoft products

 

link FROM ::fn_listextendedproperty('dbo.EXPERTISE',,'Expert',,,,,)

   
Professional Experience
dbo.Table

2011 - 2015: Beit, Vilnius Lithuania | Business management IT solutions

I am consultant, business analyst and architect of IT solutions based on Microsoft technology stack. On daily basis I gather business requirements by working closely with clients' personnel and top management. I suggest efficient solutions to automate business processes by creating sketches and demonstrating their potential. I negotiate contracts and then deliver projects within agreed budget and time specifications from initiation to realization. I am responsible for the whole solution's life cycle. All solutions are developed using Microsoft technologies - C# & SQL Server or/and Navision.

still working | SQL Server 2012/2008R2, C# .NET 3.5, ASP.NET, XML+SOAP, HTML+CSS, JavaScript, Navision 3.10/3.60/2009

 

2004 - 2011: WorldOne Research, London UK, Vilnius Lithuania | Market research

I was ERP solution architect. I created two versions of the solution. I led my team to the development of third version. The solution let company to complete market research projects on time and cut expenses to the minimum. The ERP solutions covered all business processes in multicultural and multilingual environment. Excel and paper sheets used extensively before were replaced with IT technologies. 5 worldwide branches, more than 200 employees were intensively working with the solutions on daily basis. More than 300'000 incentives automatically paid on yearly basis. Millions of emails sent to respondents inviting to participate in market research projects on monthly basis. Company became a leading player in healthcare and pharmaceutical market research industry with revenue more than £40 million by using these solutions.

6.5 years | SQL Server, Delphi, C#, ASP, HTML+CSS, JavaScript, XML+XSL, Navision

 

2004 - 2005: Falck security (G4S), Vilnius Lithuania | Security solutions

I was Navision programmer. I enhanced current business management system by developing custom modules for physical security, cash services and management of ATMs. My responsibilities were to design and implement client's needs.

Less than 1 year, parallel work | Navision, Delphi

 

2002 - 2004: Sonex Sistemos, Vilnius Lithuania | Business management systems

I was Navision consultant and programmer. My responsibilities were to design, code and setup business management modules for the clients. I participated in development of business management solutions for various industries and integrations with third-party systems. I consulted clients on optimizing IT systems and automation of business processes.

2 years | Navision, Delphi, SQL Server

 

1998 - 2002: Edrana, Vilnius Lithuania | Business management systems

I created and managed fixed asset accounting application - Turtas 2000. I was responsible for the development of this product.

4 years | Delphi, Paradox, Firebird, Interbase, Sybase, HTML, ASP

 

link FETCH NEXT FROM hJOBS INTO @projects

   
Certificates
dbo.Table

2013-09: Programming in HTML5 with JavaScript and CSS3

Microsoft 70-480 | Certification E377-8913 | Programming in HTML5 with JavaScript and CSS3 Specialist

 

2013-08: TS: Windows Applications Development with Microsoft .NET Framework 4

Microsoft 70-511 | Certification E369-3518 | .NET Framework 4, Windows® Applications

 

2013-07: Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

Microsoft 70-459 (based on 70-464 and 70-465) | Certification E344-4861 (Data platform) | Microsoft® Certified Solutions Expert

 

2013-07: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

Microsoft 70-458 (based on 70-462 and 70-463) | Certification E337-7698 | Microsoft® Certified Solutions Associate

 

2013-07: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1

Microsoft 70-457 (based on 70-461 and 70-462)

 

2013-05: Programming in C#

Microsoft 70-483 | Certification E284-9495 | Microsoft Specialist

 

2011-08: TS: Microsoft SQL Server 2008, Implementation and Maintenance

Microsoft 70-432

 

2011-08: TS: Microsoft SQL Server 2008, Database Development

Microsoft 70-433 | Certification Number : D437-8786 | Microsoft® Certified IT Professional (MCITP)

 

2011-07: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

Microsoft 70-450

 

2011-07: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Microsoft 70-451

 

2009-06: TS: Microsoft® SQL Server 2005 - Implementation and Maintenance

Microsoft 70-431 | Certification Number : A990-1543 | Microsoft® Certified Technology Specialist (MCTS)

 

2006-09: Developing and Implementing Windows®-based Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET

Microsoft 70-316

 

2006-04: Designing and Implementing Databases with Microsoft® SQL Server 2000 Enterprise Edition

Microsoft 70-229

 

2004-09: Navision Attain Programming

W1-05-010

 

2004-07: Installing, Configuring, and Administering Microsoft® SQL Server 2000 Enterprise Edition

Microsoft 70-228 | Certification Number : A990-1538 | Microsoft Certified Professional

 

Please visit online transcript: https://mcp.microsoft.com/authenticate/validatemcp.aspx

Login details: Transcript ID - 708575 and Access code - artytran.

 

link OPENROWSET(BULK [Microsoft® Certified Professional Transcript], SINGLE_BLOB)

   
Education
dbo.Table

1998 - 2010: Vilnius University / Mathematics and Computer studies

Vilnius, Lithuania | Bachelor degree

 

1995 - 1998: Vilnius Lyceum of Exact, Natural and Technical Sciences

Vilnius, Lithuania

 

1986 - 1992: Ąžuoliukas music school

Vilnius, Lithuania

 

1986 - 1995: Vilnius J. Basanavičiaus secondary school

Vilnius, Lithuania

link OUTPUT inserted.lvl, deleted.lvl INTO @edu(new_lvl, old_lvl)

   
Personality
dbo.Table

Self-motivated specialist who is reliable, responsible and hard working. Enthusiastic leader capable to unite and motivate a team. Determine and loyal.

Proactive investor who always has a plan how to implement goals and achieve dreams. Never giving up optimist knowing how to make things happen.

Might work as a team member | Prefer a mid-level manager role

 

Languages: English / fluent | Lithuanian / mother tongue | Russian / fluent

European level (Common European Framework of Reference level): C1, C2, C2

 

Hobbies: Chess, Books, Travels, Woodworks

A dream to build traditional wooden boat

 

link CREATE TYPE dbo.style FROM image


DBO: Martynas Kancleris
Hey.lt